Down the syllabus for SF16SQL10002.
SQL
SQL Questions & Answers at Slack
I just created a Slack room for SQL. If you have any SQL questions, you can post them at https://sqlhq.slack.com/. Email me for an invitation to join.
A one-time invitation was sent to former students. New students will also get a one-time invitation.
You can download Slack applications for various operating systems.
Database Administration Fundamentals (SF16SQL1001) – Day 10
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.
Database Administration Fundamentals (SF16SQL1001) – Day 9
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.
Database Administration Fundamentals (SF16SQL1001) – Day 8
We survived quiz #2 and I must congratulate all students who did great. Download the class notes for day 8.
Database Administration Fundamentals (SF16SQL1001) – Day 7
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.
Database Administration Fundamentals (SF16SQL1001) – Day 6
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.
Lunch & Learn – Data Analytics in the 21st Century
I was asked to do Lunch & Learn presentation on Data Analytics in the 21st Century. If you attended the presentation, I truly appreciate your support and I hope you enjoyed the presentation.
Database Administration Fundamentals (SF16SQL1001) – Day 5
We have covered how to CREATE, ALTER and DROP database objects.
Download the class notes for day 5.
Database Administration Fundamentals (SF16SQL1001) – Day 4
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.