0:00 / 3:08
Getting Started with SSMS
0:00 - 0:30
Introduction to the SQL Server Management Studio environment, connecting to the database engine, and setting the script context.
Basic Table Operations
0:30 - 1:02
A walkthrough of the basic T-SQL table operations: Create, Insert, Select, Update, Delete, and Drop.
Building the Course Schema
1:02 - 1:37
Building a multi-table academic schema with appropriate data types for names, dates, and numeric values.
Modifying Table Structure
1:37 - 2:07
Modifying existing tables using ALTER TABLE and system procedures to add columns or constraints.
Safe Object Removal
2:07 - 2:39
Understanding table dependencies, the correct order for dropping objects, and using TRUNCATE vs. DROP.
Master Script and Deliverables
2:39 - 3:08
Synthesizing tasks into an automated master rebuild script and reviewing final lab deliverables.