Thank you for taking class SF21SQL1001. See you in the intermediate class.

Download the class notes for day 10.

We have finished covering all the material for this course.

Download the class notes for day 9.

We are two sessions away to finish the course and we have covered all the material for this course.

Download the class notes for day 8.

We are almost done with the course. We have covered how to SELECT (retrieve data), various built-in functions including FORMAT() and how to CREATE, ALTER and DROP various data objects.

Download the class notes for day 7.

We started creating data objects.

    CREATE  obj_type   obj_name [some_code]

    DROP    obj_type   obj_name

    ALTER   obj_type   obj_name
      ALTER obj_type   obj_name   data_type

Download the class notes for day 6.

We continue manipulating data (without making changes in the database). We have covered functions that affect strings and numeric values — especially `CONVERT()` to change data types.

Download the class notes for day 4.

We continue manipulating data (without making changes in the database). We have covered functions that affect strings and numeric values — including `FORMAT()` to change currency and date values.

  FORMAT(numeric_value, format_needed, culture)
  FORMAT(numeric_value_money, 'c', 'en-us')
  FORMAT(numeric_value_date,  'd', 'en-us')
  FORMAT(numeric_value_date,  'D', 'en-us')

Download the class notes for day 3.

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 2.

We have started a new class. We covered what SQL can do like getting the correct cookies when going to The Corner Shop for a boss who does not give up complete details of what you need to buy.

Download the class notes for day 1.