Week 7: SQL

week7
sql
databases
tables
queries
joins
aggregates

Hello and welcome to CS50!

We’re onto the seventh week of CS50! This week we will be learning about SQL, a powerful language used to manage and query databases. SQL stands for Structured Query Language and is used to communicate with databases to perform tasks such as creating tables, inserting data, and querying data.

This week we will be learning about the basics of SQL, including creating databases, tables, and queries. We will also cover more advanced topics such as joins and aggregates. By the end of the week, you will have a good understanding of how to use SQL to interact with databases and perform complex operations.

Resources:

Section-Specific:

Course-wide:

Office Hours:

  • My Office Hours: Friday 10:30AM-11:30AM in HSA Building 4th Floor
  • All-Staff Office Hours: Sunday 3-5PM in Widener Library
  • Office Hours Schedule
  • If you have any questions at all, email me!