We have arrived to the end of SF22SQL1001.

  CREATE SCHEMA lab15;
  GO

  CREATE PROCEDURE lab15.thanks_sp
  AS
  BEGIN
    PRINT 'Thank you for being part of SF22SQL1001!'
  END;

  EXEC lab15.thanks_sp;

Download the class notes for day 10.

One more session to go before you hand me the final.

Download the class notes for day 9.

We are two (2) more sessions away from the SF22SQL1001 final.

We have covered lots of material —

1. getting data from tables/views (SELECT... FROM...),
2. joining tables/views (INNER|LEFT|RIGHT JOIN) to make larger datasets,
3. filtering the output of queries (WHERE),
4. ordering the output of queries (ORDER BY),
5. grouping the output of queries when using aggregate functions (GROUP BY),
6. adding logic to queries (CASE... WHEN... THEN... END),
7. pushing new values into tables (INSERT INTO),
8. deleting selected rows (DELETE FROM) from a table,
9. deleting all rows (TRUNCATE) from a table,
10. making data objects (CREATE),
11. deleting objects (DROP)
12. modifying objects (ALTER)
13. and much more.

I hope you have been having lots of fun.

Download the class notes for day 8 — 22 pages’ worth of material.

We are three (3) more sessions to go.

We have started using variables (DECLARE @parameter) in order to avoid re-writing code every time the values in the WHERE clause change. Parameters will also help us create our own functions.

Download the class notes for day 7 — 29 pages’ worth of material.

We have finally started making (CREATE), deleting (DROP) and changing (ALTER) data objects. We can now use all the material we have covered when getting data (SELECT) from tables and views in a database.

Download the class notes for day 6.

We are half-way done with the course. Can you handle having so much fun?

Download the class notes for day 5.

We continue working with functions. Some affect strings (RIGHT, LEFT, SUBSTRING, etc.) while others affect numbers (TIME, DATE, FORMAT, etc.) as well as aggregate functions, which need the GROUP BY clause.

    SELECT field1,
      aggregate_function(field2),
      field3
       -- other fields if any
    FROM table1
    INNER|LEFT|RIGHT JOIN table2
      ON table1.shared_data1 = table2.shared_data2
        AND table1.shared_data2 = table2.shared_data2
       -- other tables if any
    WHERE condition1
      AND|OR condition2
      -- other conditions if any
    GROUP BY field1
    ORDER BY field1 ASC|DESC,
      field2 ASC|DESC,
      field3 ASC|DESC,
      ...; -- other fields if any

Download the class notes for day 4.