CS50's Introduction to Databases with SQL

About this course

Harvard's CS50 SQL teaches you to create, query and design relational databases with SQL, starting with SQLite and moving on to MySQL and PostgreSQL. Who it's for: beginners, analysts and developers who want a solid foundation in SQL. These are the free, official videos of the "CS50's Introduction to Databases with SQL" playlist from the CS50 YouTube channel (youtube.com/@cs50). All videos belong to Harvard University's CS50; Sikhami is not affiliated with Harvard University's CS50 and simply arranges the public playlist into a course, so you can learn one lesson at a time and keep track of your progress.

What you will learn

• Querying data with SELECT, conditions, sorting and aggregate functions • Relating tables with keys, joins, subqueries and sets • Designing a schema: data types, constraints and normalisation • Writing data: inserting, updating, deleting and triggers • Views, common table expressions and partitioning • Optimising with indexes, transactions and concurrency • Scaling with MySQL and PostgreSQL

Course content

1 section · 8 lectures · 11h 8m

1. 1. CS50's Introduction to Databases with SQL

   • CS50 SQL - Introduction1m
   • CS50 SQL - Lecture 0 - Querying1h 19m
   • CS50 SQL - Lecture 1 - Relating1h 41m
   • CS50 SQL - Lecture 2 - Designing1h 21m
   • CS50 SQL - Lecture 3 - Writing1h 43m
   • CS50 SQL - Lecture 4 - Viewing1h 22m
   • CS50 SQL - Lecture 5 - Optimizing1h 28m
   • CS50 SQL - Lecture 6 - Scaling2h 9m