We continue working with built-in functions — those that affect strings and those that affect numeric values.

Download the class notes for day 3.

So far, we have covered built-in functions that affect strings and how to retrieve data from one or multiple tables.

Download the class notes for day 2.

We have started a new course. You will learn the basics of SQL.

Download the class notes for day 1.

It is time to celebrate. You have finished the Introduction to SQL course.

Download the class notes for day 10 (final).

We have finished all material, done 10 labs and are ready for the final.

Download the class notes for day 9.

We have finished covering the material for this course. We only have one day to review and another for the final.

Download the class notes for day 8.

We have two more classes to go before the final.

Download the class notes for day 7.

We have started creating (CREATE), destroying (DROP) and modifying (ALTER) data objects like databases, schemata and tables.

Download the class notes for day 6.

We have covered how to join tables (INNER, LEFT and RIGHT) and the WHERE clause, operators (=, <>, !=, <, >, <=, >=, !> and !<) as well as NOT, LIKE, IN and BETWEEN.

Download the class notes for day 5.

We are almost half-way done with the course. We have covered

1. the basics of a `SELECT` statement using `INNER JOIN` to retrieve the values shared between two tables,
2. logic using `CASE` clauses
3. and built-in functions including `FORMAT()`.

Download the class notes for day 4.