Download the class notes for day 10 (quiz3 & quiz3b).

  -- Just for fun, read and run or run and read.

  DECLARE @yourName VARCHAR(50) = 'your_name';
  DECLARE @CourseCd VARCHAR(15) = 'WS18SQL1002';

  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(013),
     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(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));      -- characters in ASCII

Here’s a little more.

We have finished the course and we only have one more day for the final.

Download the class notes for day 9.

We are two classes away from the end of this course. I hope you have been having fun with creating, altering and dropping objects including stored procedures and user-defined functions.

Download the class notes for day 8.

We are almost done with the course — two more days before the final. We are having lots of fun as we get ready to write functions and procedures.

Download the class notes for day 7.

We have started to CREATE database objects.

  CREATE object_type object_name
  [AS structure]

So far we are making (CREATE),

  CREATE TABLE table_name
  (
    field1 datatype [null|not null] [unique] [primary key],
    field2 datatype [null|not null],
    ...
  )

modifying (ALTER)

  ALTER TABLE table_name
  ADD|DROP|ALTER COLUMN field_name datatype

and destroying (DROP) tables.

  DROP TABLE table_name

Download the class notes for day 6.