- Download and install SQLite
- Watch videos (about 60 min) and answer questions of initial WSPDBC DB5 SQL modules (https://class.stanford.edu/courses/DB/SQL/SelfPaced/courseware/ch-sql/)
- Introduction to SQL (4:31),
- Basic SELECT statement (9:57)
- Table Variables and Set Operators (10:33)
- Subqueries in WHERE clause (20:14)
- Subqueries in FROM and SELECT (8:02)
- NULL values (6:25) Not in order
- Optionally, read Sections 5.1, 6.1 – 6.3 of U/W.
- Complete
- SQL Movie-Rating Query Exercises Q1 – Q6 at https://class.stanford.edu/courses/DB/SQL/SelfPaced/courseware/ch-sql/seq-exercise-sql_movie_query_core/ ,
- SQL Movie-Rating Extras Exercises Q1-Q6 at https://lagunita.stanford.edu/courses/DB/SQL/SelfPaced/courseware/ch-sql/seq-exercise-sql_movie_query_extra/ ,
- SQL Social-Network Query Exercises Q1 – Q7 at https://class.stanford.edu/courses/DB/SQL/SelfPaced/courseware/ch-sql/seq-exercise-sql_social_query_core/), and
- SQL Social Networking exercises Q1-Q2 at https://lagunita.stanford.edu/courses/DB/SQL/SelfPaced/courseware/ch-sql/seq-exercise-sql_social_query_extra/.