CS50 SQL - Lecture 0 - Querying

***

This is CS50, Harvard University's introduction to the intellectual enterprises of computer science and the art of programming.

***

TABLE OF CONTENTS

00:00:00 - Introduction
00:00:17 - Tables
00:03:37 - Spreadsheets
00:04:26 - Databases
00:12:28 - SQLite
00:13:56 - SELECT
00:19:36 - LIMIT
00:21:34 - WHERE
00:31:45 - NULL
00:34:23 - LIKE
00:45:58 - Range Conditions
00:53:10 - ORDER BY
01:02:00 - Aggregate Functions
01:17:21 - Conclusion

***

HOW TO SUBSCRIBE

HOW TO TAKE CS50

HOW TO JOIN CS50 COMMUNITIES

HOW TO FOLLOW DAVID J. MALAN

***

CS50 SHOP

***

LICENSE

CC BY-NC-SA 4.0
Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International Public License

David J. Malan

[the-tankeur]

CS50's teacher never fail to amaze me. Thank you for your brilliant and passionate explainations

[andybecker]

Love cs50 courses. Always learn something new. I’ve used sql for years and never knew about ordering by more than one condition

[pavlinggeorgiev]

Just finished CS50x and starting this to advance my DB knowledge. You guys are awesome Thank you !

[bidoofmania]

I am thrilled to be a part of this course! So happy to apply this in my career

[batuhanbatuhan]

dude made his daily workout walked 10km back and forth between his laptop and the board.

[taasinbinhossainalvi]

Carter Zenke is one of my favourite Teachers of all time. Excited to learn with him.

[qrtvchj]

I have just complete CS50x now u am here i just love CS50 we always learn new things

[elbarzwalid]

amazing course, amazing professors, this is what teaching should be like

[thapaharis]

What a timing. I am trying to learn about SQL. Thanks ❤ ❤

[GenZ__]

You’re great.
Thank you for the high quality intro🙏🏽

[danielset]

CS50 Thank you!
The teaching level of the courses is superior!

[moverecursus]

Amazing! Gonna watch the all the episodes!

[kasiajakubowska]

Amazing lecture on SQL! Highly recommend.

[batuhanbatuhan]

I can only focus about 15 minutes. I wish I had the attention span that allowed me two watch three entire lectures. This guy is very well prepared I appreciate him and CS50.

[CaptainCoder]

Thank you so much for such beautiful, video which was fully packed with basic sql commands. I don't think that i could have ever understand so many things anywhere in just barley quater and one hour.❤❤❤❤❤❤❤❤❤❤❤

[janetkalu]

SQL has never been fun. Thank you for this great intro to SQL

[sarwechimdad]

Thank you, carter, for great efforts, that really amazing.

[OIP_]

never thought i would be excited to click on an SQL video but here we are

[debanjansaha]

Absolutely thrilled to start this course🥺

[gloriaedeh]

This is super amazing...I love your teaching methodology, so clearly presented that I believe anyone could understand the lesson. Thanks