Just another CUNY Academic Commons site
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.
We have started a new Intermediate SQL class. We have reviewed the basics and we will start programmability right away.
Download the class notes for day 1.
We have arrived to the end of SF22SQL1001.
CREATE SCHEMA lab15; GO CREATE PROCEDURE lab15.thanks_sp AS BEGIN PRINT 'Thank you for being part of SF22SQL1001!' END; EXEC lab15.thanks_sp;
Download the class notes for day 10.
One more session to go before you hand me the final.
Download the class notes for day 9.
We are two (2) more sessions away from the SF22SQL1001 final.
We have covered lots of material —
I hope you have been having lots of fun.
Download the class notes for day 8 — 22 pages’ worth of material.
We are three (3) more sessions to go.
We have started using variables (DECLARE @parameter) in order to avoid re-writing code every time the values in the WHERE clause change. Parameters will also help us create our own functions.
Download the class notes for day 7 — 29 pages’ worth of material.
We have finally started making (CREATE), deleting (DROP) and changing (ALTER) data objects. We can now use all the material we have covered when getting data (SELECT) from tables and views in a database.
Download the class notes for day 6.
