Thank you for taking class SF21JOB#2.

Download the class notes for day 10.

We have finished all new material for this course.

Download the class notes for day 9.

We have finished all new material for this course.

Download the class notes for day 8.

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.