We had our first quiz and most of you did great!
Download the class notes for day 3 (quiz 1). As I have mentioned, there is no single right answer. Use my answers to the quiz as a guide.
Just another CUNY Academic Commons site
We had our first quiz and most of you did great!
Download the class notes for day 3 (quiz 1). As I have mentioned, there is no single right answer. Use my answers to the quiz as a guide.
We have started getting creative displaying data returned from our queries using functions.
Download the class notes for day 2.
Since Monday 05/30/2016 is Memorial Day, we are not meeting till Wednesday. Therefore review all your notes and get ready for your first quiz.
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.