Intro to SQL: Querying and managing data
SAT Score Range
•
4 sessions
•
sk
NJ
AA
+11
Home
About
This series ended on August 22, 2023. All 1:1 and group chats related to this series are disabled 7 days after the last session.
About
This is an experimental series that will run once weekly. No programming experience required!
We will be using a "flipped classroom" style, where you will watch the lectures before coming to class and then we will work on the challenges together during class.
We will be following the Khan Academy curriculum. Here is the link to the course:
https://www.khanacademy.org/computing/computer-programming/sql
Note that you will need a Khan Academy account!
Schedule
✋ ATTENDANCE POLICY
You will be withdrawn from the series if you miss any session without giving the tutor prior notice.
SESSION 1
1
Aug
SESSION 1
Orientation
Orientation
Tue 10:00 PM - 11:00 PM UTCAug 1, 10:00 PM - 11:00 PM UTC
Before this session, watch the videos in "SQL basics." You don't need to attempt the challenges before class, but you are welcome to!
https://www.khanacademy.org/computing/computer-programming/sql/sql-basics/v/welcome-to-sql
SESSION 2
8
Aug
SESSION 2
Computer Science
Computer Science
Tue 10:00 PM - 11:00 PM UTCAug 8, 10:00 PM - 11:00 PM UTC
Before this session, watch the videos in "More advanced SQL queries."
https://www.khanacademy.org/computing/computer-programming/sql/more-advanced-sql-queries/pt/more-complex-queries-with-andor
SESSION 3
15
Aug
SESSION 3
Computer Science
Computer Science
Tue 10:00 PM - 11:00 PM UTCAug 15, 10:00 PM - 11:00 PM UTC
Before this session, watch the videos in "Rational queries in SQL."
https://www.khanacademy.org/computing/computer-programming/sql/relational-queries-in-sql/a/splitting-data-into-related-tables
SESSION 4
22
Aug
SESSION 4
Computer Science
Computer Science
Tue 10:00 PM - 11:00 PM UTCAug 22, 10:00 PM - 11:00 PM UTC
Before this session, watch the videos in "Modifying databases with SQL" and read "What to learn next."
https://www.khanacademy.org/computing/computer-programming/sql/modifying-databases-with-sql/a/using-sql-to-update-a-database