It is time to celebrate. You have finished the Introduction to SQL course.

Download the class notes for day 10 (final).

We have finished all material, done 10 labs and are ready for the final.

Download the class notes for day 9.

We have finished covering the material for this course. We only have one day to review and another for the final.

Download the class notes for day 8.

We have two more classes to go before the final.

Download the class notes for day 7.

We have started creating (CREATE), destroying (DROP) and modifying (ALTER) data objects like databases, schemata and tables.

Download the class notes for day 6.

We have covered how to join tables (INNER, LEFT and RIGHT) and the WHERE clause, operators (=, <>, !=, <, >, <=, >=, !> and !<) as well as NOT, LIKE, IN and BETWEEN.

Download the class notes for day 5.

We are almost half-way done with the course. We have covered

1. the basics of a `SELECT` statement using `INNER JOIN` to retrieve the values shared between two tables,
2. logic using `CASE` clauses
3. and built-in functions including `FORMAT()`.

Download the class notes for day 4.

So far, we have covered the two ways you can concatenate strings (using function `CONCAT()` or using the `+` sign). We understand that using the `+` sign has limitations. When adding a string to a NULL, your result is a NULL. To avoid the latter, we can use a `CASE` clause.

  CASE
    WHEN   condition1
      THEN action1
    WHEN   condition2
      THEN action2
    ELSE   escape_action
  END

Download the class notes for day 3.

We have started joining tables and working with built-in functions.

Download the class notes for day 2.

We have started a new course. Download the class notes for day 1.