Down the syllabus for SF16SQL10002.

We’ve reached the end of the Intro to SQL course — CONGRATULATIONS! I hope I see you in the second SQL course for certification exam 98-364. Download the class notes for day 10.

As I have mentioned several times, you can contact (email) me at any time if you need help with SQL and/or related technologies.

We are almost done with the course. We have covered sections 1 to 3 from the Exam 98-364 MTA Database Administration Fundamentals (ISBN 9780470889169) book. We will take quiz #3 on the last day (08/10/2016). Download the class notes for day 9.

We survived quiz #2 and I must congratulate all students who did great. Download the class notes for day 8.

We have covered most of the material of this course except for referential integrity.

Referential integrity is a relational database concept, which states that table relationships must always be consistent. In other words, any foreign key field must agree with the primary key that is referenced by the foreign key. Thus, any primary key field changes must be applied to all foreign keys, or not at all. The same restriction also applies to foreign keys in that any updates (but not necessarily deletions) must be propagated to the primary parent key.
https://www.techopedia.com/definition/1233/referential-integrity-ri

Download the class notes for day 7.

We are half-way into the course. We have covered most of section two (2) including parameters (variables). We can finally start having fun writing procedures and functions — data objects that can be reused by anyone with the proper privileges.

Download the class notes for day 6.

We have covered how to CREATE, ALTER and DROP database objects.

Download the class notes for day 5.

We took care of quiz #1. Download the class notes for day 4. As I mentioned, compare your code to my notes. If you have any questions, let me know.