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.

We have finished section one (retrieving data) and have started section two (creating, destroying and modifying data objects).

CREATE object_type object_name
AS (
  some_structure
);

DROP object_type object_name;

ALTER object_type object_name
ADD|DROP|ALTER object_type data_type;

Download the notes for day 6.

We are half-way done with the course. We have covered how to retrieve data from table(s) and how to present that data in comprehensible manner.

SELECT [DISTINCT] table1.field1,
  table1.field2,
  ...
  table2.field1,
  table2.field2,
  ..
FROM table1
INNER|LEFT JOIN table2
  ON table1.sharedfile1 = table2.sharedfile1
    AND|OR table1.sharedfile2 = table2.sharedfile3
    ...
INNER|LEFT JOIN table3
  ON table1.sharedfile1 = table3.sharedfile1
    AND|OR table1.sharedfile2 = table3.sharedfile3
    ...
WHERE condition1
  AND|OR condition2
  ...
GROUP BY fields_not_in_aggregate_function
ORDER BY field1,
  field2
  ...;

Download the notes for day 5.