We have finished the Introduction to SQL course. I hope you join us for the Intermediate SQL course.

Download the class notes for day 10.

We have finished the material, reviewed the material and are ready for the final.

Download the class notes for day 9.

Download the class notes for day 8.

We have finished covering new material. We only have a full review (day 9) and the final (day 10).

We are almost done. We only have one topic to cover — functions and procedures.

Download the class notes for day 7.

We continue creating, dropping and altering data objects including data types. We have three (3) more days before the final.

Download the class notes for day 6.

We have started working with data types (VARCHAR(n), INT, FLOAT, etc.) and data objects (DATABASE, SCHEMA, TABLE, etc.).

Download the class notes for day 5.

By the way, have a good π Day.

So far, we have covered how JOIN tables, built-in functions to manipulate strings, numbers and even convert numbers (currencies and dates) to strings, GROUP BY and ORDER BY clauses and the structure of a SELECT statement.

  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
    AND|OR condition3
  ...

  GROUP BY table1.field1,
    table1.field2,
    ...
    table2.field1,
    table2.field2,
    ...
    table3.field1,
    table3.field2,
    ...

  ORDER BY
    table1.field1 ASC|DESC,
    table1.field2 ASC|DESC,
    ...
    table2.field1 ASC|DESC,
    table2.field2 ASC|DESC,
    ...
    table3.field1 ASC|DESC,
    table3.field2 ASC|DESC,
    ...

Download the class notes for day 4.

We have covered so far how to query data from one or multiple tables as well as how to manipulate data using built-in functions and adding logic using `CASE`.

Download the class notes for day 3.

We have started working with built-in functions to manipulate strings and numbers.

Download the class notes for day 2.

We have started a new course. You will learn the basics of SQL, which will prepare you for the Intermediate SQL course. It is time to have fun.

Download the class notes for day 1.