We have reached the end of SF16SQL10002. Download the class notes for day 10. As I have mentioned before, you are welcome to contact (email) me at any time with any questions regarding SQL or related technologies.

---

DECLARE @yourName VARCHAR(50),
        @myCourse VARCHAR(11);

SET @yourName = '#space_holder_for_your_name#';
SET @myCourse = 'SF16SQL1001';

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) +@myCourse+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) ;

Since some students were taking the day before Thanksgiving (day 10) off, we took the final quiz/practice early.

Download the class notes for day 9 and compare your code.

Download the class notes for day 8.

We’re almost done with this course (SF16SQL10002). We have two more classes before we “celebrate” with one more quiz/practice covering all the material we have covered.

Download the class notes for day 7.

We have covered views finishing most of section two.

In a database management system, a view is a way of portraying information in the database. This can be done by arranging the data items in a specific order, by highlighting certain items, or by showing only certain items. For any database, there are a number of possible views that may be specified. Databases with many items tend to have more possible views than databases with few items. Often thought of as a virtual table, the view doesn’t actually store information itself, but just pulls it out of one or more existing tables. Although impermanent, a view may be accessed repeatedly by storing its criteria in a query.
http://searchsqlserver.techtarget.com/definition/view

Download the class notes for day 6.

So far, we have covered how to CREATE, ALTER and DROP database objects (databases, schemas and tables), SELECT and FORMAT data FROM tables, JOIN tables, ALTER tables and INSERT and UPDATE data types.

Download the class notes for day 5.

You survived the first quiz (practice). Most of you did very well.

Next week we will cover to create tables and views with the proper data types (https://msdn.microsoft.com/en-us/library/ms187752.aspx) for Transact-SQL (also referred to as T-SQL; https://msdn.microsoft.com/en-us/library/ms365303.aspx).

Download the class notes for day 4.

We have finished the first section of the course and we are having the first quiz (practice) on Wednesday.

If you have any questions about anything that we have covered so far, do not hesitate to contact me or posting your question on Slack (https://sqlhq.slack.com/). Other students might be able to answer or also have the same inquiry.

In the meantime, download the class notes for day 3.

In the past two classes, we have covered how to query a table (SELECT field1, field2... FROM table) using functions for both strings and numeric values with WHERE, GROUP BY and ORDER BY clauses.

Download the class notes for day 2.