We have started a new course. We first talked about cookies and tomorrow we will start coding.

Download the class notes for day 9.

It has been great experience teaching this class and I hope you had fun — aside from learning SQL, of course.

    CREATE PROCEDURE final.message_sp
    AS
    BEGIN
      DECLARE @yourName VARCHAR(50) = 'your_name',   -- param to hold your name
              @CourseCd VARCHAR(15) = 'WS23SQL1001'; -- code for the SQL course
      PRINT CONCAT ( CHAR(084), CHAR(104), CHAR(097), CHAR(110), CHAR(107),
          CHAR(032), CHAR(121), CHAR(111), CHAR(117), CHAR(044), CHAR(032),
          @yourName, CHAR(044), CHAR(032), CHAR(102), CHAR(111), CHAR(114),
          CHAR(032), CHAR(116), CHAR(097), CHAR(107), CHAR(105), CHAR(110),
          CHAR(103), CHAR(032), CHAR(099), CHAR(108), CHAR(097), CHAR(115),
          CHAR(115), CHAR(032), @CourseCd, CHAR(046), CHAR(013), CHAR(083),
          CHAR(101), CHAR(101), CHAR(032), CHAR(121), CHAR(111), CHAR(117),
          CHAR(032), CHAR(105), CHAR(110), CHAR(032), CHAR(116), CHAR(104),
          CHAR(101), CHAR(032), CHAR(105), CHAR(110), CHAR(116), CHAR(101),
          CHAR(114), CHAR(109), CHAR(101), CHAR(100), CHAR(105), CHAR(097),
          CHAR(116), CHAR(101), CHAR(032), CHAR(099), CHAR(108), CHAR(097),
          CHAR(115), CHAR(115), CHAR(046), CHAR(013), CHAR(013), CHAR(070),
          CHAR(046), CHAR(079), CHAR(108), CHAR(118), CHAR(101), CHAR(114),
          CHAR(097), CHAR(032), CHAR(040), CHAR(102), CHAR(111), CHAR(108),
          CHAR(118), CHAR(101), CHAR(114), CHAR(097), CHAR(064), CHAR(098),
          CHAR(109), CHAR(099), CHAR(099), CHAR(046), CHAR(099), CHAR(117),
          CHAR(110), CHAR(121), CHAR(046), CHAR(101), CHAR(100), CHAR(117),
          CHAR(041), CHAR(013), CHAR(104), CHAR(116), CHAR(116), CHAR(112),
          CHAR(058), CHAR(047), CHAR(047), CHAR(102), CHAR(111), CHAR(108),
          CHAR(118), CHAR(101), CHAR(114), CHAR(097), CHAR(046), CHAR(099),
          CHAR(111), CHAR(109), CHAR(109), CHAR(111), CHAR(110), CHAR(115),
          CHAR(046), CHAR(103), CHAR(099), CHAR(046), CHAR(099), CHAR(117),
          CHAR(110), CHAR(121), CHAR(046), CHAR(101), CHAR(100), CHAR(117),
          CHAR(047) );
    END;

    EXECUTE final.message_sp;

Download the class notes for day 10.

We have finished all new material and we are getting ready for the final.

Download the class notes for day 9.

We are two sessions away from finishing the course.

Download the class notes for day 8.

We continue creating, dropping and altering objects as well as inserting, deleting and truncating tables.

Download the class notes for day 7.

We are now seeing how to CREATE, ALTER and DROP data objects. This is the really fun part of the course.

Download the class notes for day 6.

We continue retrieving data from different tables, using functions and now CASE clauses.

Download the class notes for day 5.

We have started working with functions — currently playing with aggregate functions and the need to use GROUP BY when calling fields that are not subject to any aggregate function.

Download the class notes for day 4.

We have started working with functions — currently playing with strings and making numbers (dates and currency) into strings.

Download the class notes for day 3.

We are finally writing code to query data from tables.

    SELECT field1, field2...
    FROM table1 AS t1
    INNER|LEFT|RIGHT JOIN table2 AS t2
    ON t1.common_data = t2.common_data;

Download the class notes for day 2.