06: Primary Keys and Indexing
I start the process of "linking" tables together by explaining the concept of primary keys and how they serve to connect two tables. The "connections" in SQL are sort of bolted on to the syntax, but all (most?) databases can be configured to enforce the connections if you need. I also cover indexing since many times you'll need to index additional columns, or these indexes are done for you on primary keys and that has certain implications.
Register today for the Beginner Basics course and get the new releases by just paying the difference. There's also special discounts for existing customers when new courses are released.
Still Not Sure? Check out more curriculum!