We have finished the course and had a final covering all material we have covered.

For fun run the following.

    DECLARE @yourName VARCHAR(50) = 'your_name_here',
            @CourseCd VARCHAR(15) = 'SF19SQL1002';
    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));

Download the class notes for day 5.

As a quick review, SQL is the language to interact with a relational database.

• to request data (SELECT) from database objects (databases, schemas, tables and views)
• to create (CREATE) where to store data, database objects (databases, schemas, tables including columns, etc.)
• to modify (ALTER) database objects
• to delete (DROP) database objects, automatic COMMIT in SQL Server hence no ROLLBACK (no way to rescue the data or objects)
• to manipulate data either affecting the data or not (showing data only)
  • CREATE database_object object_name [other_code]
  • DROP database_object object_name [other_code]
  • ALTER database_object object_name ALTER|ADD|DROP [other_code]
  • DELETE rows from a table
  • INSERT INTO table (rows/records)
  • TRUNCATE table (erasing all data in table)
  • UPDATE table

We use SQL to return data to any person or program that needs data.

• • Your boss or end user requests data as a report (RPT), graphic (GIF, JPEG, PNG, .BMP, etc.), an office file (XLS, DOC, etc. or other data types as PDF. The end user does not need to know where the data is or how to get it.
  • You (the middle person handling errands) get the data from the database using SQL. Normally you would not take care of visualization, analysis and/or interpretation. You also do not need to understand the data, but you need to know your data (row ID of tables, keys or other constraints, etc.) and make sure the data is clean (no garbage data).
  • The database holds the data that the end user needs and all SQL requests (SELECT, DROP, ALTER, etc.) if written currently (no syntax errors) return the data to you or directly to the end user. The database does not have AI and hence only returns what you ask. As such if you make the wrong request, the database would return the wrong data (your bad logic, not a syntax error).

Download the class notes for day 4(a) and day 4(b).

We have started creating, dropping and altering objects.

  CREATE  db_object  obj_name   [code_structure];

  DROP    db_object  obj_name;

  ALTER   db_object  obj_name   ADD|DROP|ALTER  db_object  data_type;

Download the class notes for day 3(a) and day 3(b).

So far, we have covered functions that affect strings, numeric values and even formatted numeric values (converting them to strings) and how to retrieve data from one or more tables using `INNER JOIN`.

Download the class notes for day 2(a) and day 2(b).

We have started a new course on Saturday mornings — getting ready for long days having fun with SQL.

Download the class notes for day 1(a) and day 1(b).