We have been working with WHERE to limit our output.

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

We have also seen the differences between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN.

Download the class notes for day 5.

We are almost half way done with the course. We have covered how to retrieve data (SELECT), filtering data (WHERE), organizing data (ORDER BY), grouping data (GROUP BY) when using aggregate functions and formatting numeric values (FORMAT()).

SELECT table1.field1, table1.field2...
  table2.field1, table2.field2...
  table3.field1, table3.field2...
FROM table1
INNER|LEFT|RIGHT JOIN table2
  ON table1.shared_field1 = table2.shared_field1
    AND table1.shared_field2 = table2.shared_field2
INNER|LEFT|RIGHT JOIN table3
  ON table1.shared_field1 = table3.shared_field1
    AND table1.shared_field2 = table3.shared_field2...
WHERE condition1
  AND|OR condition2
  ...

Download the class notes for day 4.

We continue covering built-in functions that affect strings or numeric values including FORMAT() as well as clauses like GROUP BY and ORDER BY.

Download the class notes for day 3.

It is only day 2, but we have already covered how to retrieve fields from multiple tables

SELECT field1, field2 ...
FROM table1
INNER|LEFT|RIGHT JOIN table2
  ON table1.shared_field1 = table2.shared_field1
  AND table1.shared_field2 = table2.shared_field2
  ...
INNER|LEFT|RIGHT JOIN table3
  ON table1.shared_field1 = table3.shared_field1
  AND table1.shared_field2 = table3.shared_field2
  ...

and built-in functions both for strings and numeric values (aggregate).

Download the class notes for day 2.

Let me welcome to the world of SQL. There is no time to waste. It is time to get your hands wet.

Download the class notes for day 1.

Download the class notes for day 10 (the final). Thank you for taking this course.

We have covered how to CREATE, DROP and ALTER data objects — especially tables adding constraints like PK, FK and CPK.

Download the notes for day 9.

Get ready for the final!

We are finally in the fun section of the course — stored procedures (UDP) and user-defined functions (UDF). We can finally write code once and recycle it.

Download the notes for day 8.

We have only three (3) more days. We have covered how to CREATE, DROP and ALTER data objects (databases, schemas, tables and views) with the correct data types.

Download the notes for day 7.