We are two sessions away from finishing the course.

Download the class notes for day 8.

We continue creating, dropping and altering objects as well as inserting, deleting and truncating tables.

Download the class notes for day 7.

We are now seeing how to CREATE, ALTER and DROP data objects. This is the really fun part of the course.

Download the class notes for day 6.

We continue retrieving data from different tables, using functions and now CASE clauses.

Download the class notes for day 5.

We have started working with functions — currently playing with aggregate functions and the need to use GROUP BY when calling fields that are not subject to any aggregate function.

Download the class notes for day 4.

We have started working with functions — currently playing with strings and making numbers (dates and currency) into strings.

Download the class notes for day 3.

We are finally writing code to query data from tables.

    SELECT field1, field2...
    FROM table1 AS t1
    INNER|LEFT|RIGHT JOIN table2 AS t2
    ON t1.common_data = t2.common_data;

Download the class notes for day 2.

We have started a new course. We will cover the basics of SQL from querying to creating and altering data objects. It will be a fun ride.

Download the class notes for day 1.