Database Administration Fundamentals (SF16SQL10002) – Day 10

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) ;

Database Administration Fundamentals (SF16SQL10002) – Day 6

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.

Database Administration Fundamentals (SF16SQL10002) – Day 4

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.

Database Administration Fundamentals (SF16SQL10002) – Day 3

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.

Database Administration Fundamentals (SF16SQL10002) – Day 1

We have started a new Introduction to SQL course. We will have fun for the next five (5) weeks.

You will receive a one-time invitation to Slack (https://sqlhq.slack.com/) where you can post any questions and where other classmates can respond. Of course, you can also email me directly any questions you have.

Download the class notes for day 1.