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.

This entry is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International license.