We have finished another course. Remember that programming is a fun experience as we can tell a machine and tell it what to do. I hope you had fun in this course and continue learning SQL and related technologies like Python.

Download the class notes for day 10.

We are one more session away from finishing this course. I hope you have had fun.

Download the class notes for day 9.

We have finished all new material for this class and have started the review for the final next week.

Download the class notes for day 8.

We continued taking a look at LOGINs, USERs, ROLEs, AUTHENTICATION and other data objects. We also looked at how to BACKUP and RESTORE databases.

Download the class notes for day 7.

We have covered how to CREATE, DROP and ALTER several objects including user-defined functions, stored procedures, triggers and sequences. We have also covered normalization as well as learning how to CREATE, DROP and ALTER logins and users.

Download the class notes for day 6.

After learning the hard way that SQL Server authentication is not enabled by default, we were finally able to CREATE LOGINS and USERS.

    CREATE LOGIN foo WITH PASSWORD = 'p@$$W0rd';
    CREATE USER FOR LOGIN foo;

We also learned that dropping the LOGIN before the USER will leave the USER orphan and we will not be able to drop the USER especially if the USER owns any object.

Download the class notes for day 5.

We continued working on normalization replacing values of cities/counties with FIPS (Federal Information Processing Standards) values for these cities/counties. We had to import data into our working database WS231. We ran into errors along the way and had to make the proper changes to normalize our data. In any case, the main part of the whole process was having fun!

Download the class notes for day 4.

We continue working with constraints — primary and foreign keys including composites. We have covered the need to normalize and clean our data as well as having fun with it — just make sure that you have backups.

Download the class notes for day 3.

We have reviewed user-defined functions and store procedures. We have also started working with constraints — primary and foreign keys.

Download the class notes for day 2.