We are almost done with this course. We have covered how to SELECT data from tables throughout several sessions. We have also just started to CREATE and DROP objects.

Download the class notes for day 7.

We are almost ready to start working with database objects. In the meantime, we reviewed all the material so far.

Download the class notes for day 6.

We continue covering built-in functions and slightly covered the CASE clause.

    CASE
      WHEN some_condition_1 THEN some_action_1  -- if this condition fails,
                                                -- need to go to the next one
      WHEN some_condition_2 THEN some_action_2  -- if this condition fails,
                                                -- need to go to the next one
      WHEN some_condition_3 THEN some_action_3  -- if this condition fails,
                                                -- need to go to the next one
      ...
      ELSE escape_action                        -- if all prior conditions fail,
                                                -- need to perform this action
    END

Download the class notes for day 5.

We have continue retrieving data from one or more tables and using built-in functions — this time, aggregate functions. Just remember to use GROUP BY.

Download the class notes for day 4.

We have reviewed all functions prior to creating objects.

Download the class notes for day 5.

We have started retrieving data from one or more tables and using built-in functions. It is time for fun!

Download the class notes for day 3.

We are finally looking at code and now you can retrieve data.

    SELECT field1,
      field2...
    FROM table1
    INNER|LEFT|RIGHT JOIN table2
      ON table1.shared_value = table2.shared_value;

Download the class notes for day 2.