Day 1: SQL Basics & Advanced SQL Queries
[X] Complete the SQL Basics course
[X] Complete the Advanced SQL queries course
Day 2: Relational Queries
Complete the Relational Queries course Complete the Modifying databases with SQL course Day 3: Install Postgres and Complete Tutorials with psql
[X] Install Homebrew by following instructions listed here [X] Install Postgres by following instructions listed here [X] Learn the psql command line tool by working through the following tutorials
[X] complete the tutorial for createdb here
[X] complete the tutorial for selecting the database here
[X] complete the tutorial for dropping the database here
[X] complete the tutorial for create table here
[X] complete the tutorial for drop table here
[X] complete the tutorial for schema here
[X] complete the tutorial for insert here
[X] complete the tutorial for select here
[X] complete the tutorial for expressions here
[X] complete the tutorial for where clause here
[X] complete the tutorial for and and or operators here
[X] complete the tutorial for update queries here
[X] complete the tutorial for delete queries here
[X] complete the tutorial for the like clause here
[X] complete the tutorial for the limit clause here
[X] complete the tutorial for the order by clause here
[X] complete the tutorial for the group by clause here
Day 4: Mini Project & Exercises
Exercises 1-13 in the sql-exercises repo are complete and written to the appropriate file:
[X] sql/01-create-table-student.sql
[X] sql/02-create-table-friend.sql
[X] sql/03-create-table-like.sql
[X] sql/04-load-table-learner.sql
[X] sql/05-load-table-friend.sql
[X] sql/06-load-table-like.sql
[X] sql/07-query-friends-gabriel.sql
sql/08-query-likes-grade-two-or-more.sql
sql/09-mutual-likes.sql
sql/10-not-liked.sql
sql/11-liked-but-does-not-like.sql
sql/12-find-friends-in-common.sql
sql/13-popular-students.sql
Day 5: Exercises on SQL Bolt
Complete the SQL Bolt tutorial
Stretch
Complete the Codeacademy course on SQL
Complete the SQL Zoo quizzes