We have finished our five-week adventure into the land of SQL (WS17SQL1007). Thank you for joining us.

By the way, try to figure out what the following prints. You might not need to go to http: //ascii.cl/.

DECLARE @yourNAME VARCHAR(50),
        @yourCRSE VARCHAR(11);

SET @yourNAME = '#space_holder_for_your_name#';
                                -- your name in this param
SET @yourCRSE = 'WS17SQL1007';  -- this class ending today

PRINT   CHAR(84) +CHAR(104)+CHAR(97) +CHAR(110)+CHAR(107)+
        CHAR(32) +CHAR(121)+CHAR(111)+CHAR(117)+CHAR(44) +
        CHAR(32) +@yourNAME+CHAR(44) +CHAR(32) +CHAR(102)+
        CHAR(111)+CHAR(114)+CHAR(32) +CHAR(116)+CHAR(97) +
        CHAR(107)+CHAR(105)+CHAR(110)+CHAR(103)+CHAR(32) +
        CHAR(99) +CHAR(108)+CHAR(97) +CHAR(115)+CHAR(115)+
        CHAR(32) +@yourCRSE+CHAR(46) +CHAR(13) +CHAR(83) +
        CHAR(101)+CHAR(101)+CHAR(32) +CHAR(121)+CHAR(111)+
        CHAR(117)+CHAR(32) +CHAR(105)+CHAR(110)+CHAR(32) +
        CHAR(116)+CHAR(104)+CHAR(101)+CHAR(32) +CHAR(105)+
        CHAR(110)+CHAR(116)+CHAR(101)+CHAR(114)+CHAR(109)+
        CHAR(101)+CHAR(100)+CHAR(105)+CHAR(97) +CHAR(116)+
        CHAR(101)+CHAR(32) +CHAR(99) +CHAR(108)+CHAR(97) +
        CHAR(115)+CHAR(115)+CHAR(46) +CHAR(13) +CHAR(13) +
        CHAR(70) +CHAR(46) +CHAR(79) +CHAR(108)+CHAR(118)+
        CHAR(101)+CHAR(114)+CHAR(97) +CHAR(13) +CHAR(102)+
        CHAR(111)+CHAR(108)+CHAR(118)+CHAR(101)+CHAR(114)+
        CHAR(97) +CHAR(64) +CHAR(98) +CHAR(109)+CHAR(99) +
        CHAR(99) +CHAR(46) +CHAR(99) +CHAR(117)+CHAR(110)+
        CHAR(121)+CHAR(46) +CHAR(101)+CHAR(100)+CHAR(117)+
        CHAR(13) +CHAR(104)+CHAR(116)+CHAR(116)+CHAR(112)+
        CHAR(58) +CHAR(47) +CHAR(47) +CHAR(102)+CHAR(111)+
        CHAR(108)+CHAR(118)+CHAR(101)+CHAR(114)+CHAR(97) +
        CHAR(46) +CHAR(99) +CHAR(111)+CHAR(109)+CHAR(109)+
        CHAR(111)+CHAR(110)+CHAR(115)+CHAR(46) +CHAR(103)+
        CHAR(99) +CHAR(46) +CHAR(99) +CHAR(117)+CHAR(110)+
        CHAR(121)+CHAR(46) +CHAR(101)+CHAR(100)+CHAR(117)+
        CHAR(47) ;          -- calling characters in ASCII

Download the class notes for day 10.

We are almost done — just one more class to go. We will have a quiz (another lab).

If you have any questions regarding the material, don’t hesitate to contact me via email or Slack (https://sqlhq.slack.com/).

Download the class notes for day 9.

We have two more classes to go.

• Next Monday we will review all the material that we have covered so far.
• Next Wednesday we will have a quiz.

Download the class notes for day 8.

We have started to CREATE database objects using the following base syntax.

CREATE database_object object_name
AS some_code_to_create_structure

Download the class notes for day 7.

• On a silly note, this is post 486 as in i486.

I have emailed all students a one-time invitation to my Slack channel (https://sqlhq.slack.com/) where you can post any question/comment and get answers/response by your fellow students.

Last night we worked on a long lab covering all material that we have covered so far. Next week we will start to CREATE data objects, INSERT data into tables and DROP data objects.

Download the class notes for day 6.

We are half-way done (fifth class of ten). We will stop covering new material in order to review all the material we have covered so far. You need to understand and know the syntax well as this is the foundation of SQL. We will then continue and cover how to CREATE and ALTER database objects.

Download the class notes for day 5.