View the updated syllabus for this course.
Download the class notes for day 1.
Just another CUNY Academic Commons site
View the updated syllabus for this course.
Download the class notes for day 1.
Class Notes for 2016/04/04
Class Notes for 2016/04/06
Class Notes for 2016/04/11
Class Notes for 2016/04/13
Class Notes for 2016/04/18
Class Notes for 2016/04/20
Class Notes for 2016/04/25
Class Notes for 2016/04/27 (Pop Quiz #1)
Class Notes for 2016/05/02
Class Notes for 2016/05/02 (Pop Quiz #2)
Class Notes for 2016/05/04 (Pop Quiz #3)
We have finished the course. It has been a pleasure working with you. As a reminder, if you have any SQL questions, send me an email.
Download the notes for day ten (last day).
We have reached to the end of the course. We will review all we have covered on the last day of this course.
Download the notes for day nine.
These are the notes for day nine on database administration (22-page PDF, theory only). You need to know the theory before the last week of class.
These are the answers for quiz #2.
At this point, we have finished sections one to four. Tomorrow (day 8) we will review quiz #2.
Next week we will cover database administration.
Download the notes for day seven.
We are almost at the end of this course. Review all your notes for quiz 2, which you will taking in the comfort of your home or office.
Download the notes for day six.
This week we are covering parameters (http://whatis.techtarget.com/definition/parameter), procedures (http://www.techonthenet.com/sql_server/procedures.php) and functions (http://www.techonthenet.com/sql_server/functions.php).
Download the notes for day five.
We took our first pop quiz with seven steps to create one view. In other words, it is only one question.
We have one more pop quiz, in which you will create a database and manage its rights.
Download the notes for day four (answer to the pop quiz).