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 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.