SQL: DDL and DML Part 2 of 4: ALTER TABLE, and CONSTRAINTs: Check, Unique, and Foreign Key
This video is part two of a four-part series on SQL Data Definition and Data Manipulation commands. In this video we focus on the ALTER TABLE statement, using it to and remove columns, and various table-based constraints like CHECK, UNIQUE and the tricky FOREIGN KEY. We continue to build out our SQL database for our fictitious company, Spiffy Lube.
The SQL code is available here: https://github.com/mafudge/learn-data...
If you need to setup your own database environment, check out learn-databases! The easy way to get going and follow along with these videos. https://mafudge.github.io/learn-datab... The Database Client I am using it azure data studio: https://docs.microsoft.com/en-us/sql/...
This video is part of the textbook Applied Database Management https://applieddb.com
Here's the entire playlist: • Applied Database Management with SQL
