SQL: DDL and DML Part 4 of 4: INFORMATION SCHEMA
This video is the fourth and final part of our four-part series on SQL Data Definition and Data Manipulation commands. In this video we focus on INFORMATION SCHEMA views that we can use to query the metadata within the database such as the tables, keys constraints and columns. We will finalize out Up/Down SQL script 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/...
To learn more about INFORMATION SCHEMA on SQL Server, visit: 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
