SQL: DDL and DML Part 1 of 4: CREATE TABLE, Primary Keys and INSERT
This video is part one of a four-part series on SQL Data Definition and Data Manipulation commands. In this video we focus on CREATE TABLE and INSERT, and use of surrogate primary keys while walking you through the process of building a database in SQL for a company, Spiffy Lube.
The SQL code I create in this 4 part series 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
