Autoplay
Autocomplete
Previous Lesson
Complete and Continue
SQL Server Fast Track for Novices: Tables
The Basics
* * * * COURSE INTRODUCTION * * * * (3:12)
* * SECTION DESCRIPTION * * (0:33)
Table Types (3:04)
Table Design and Management
* * SECTION DESCRIPTION * * (2:18)
Table Design and Naming Convention (5:00)
How to Create Setup Tables - SSMS (5:54)
How to Alter Table Schema - SSMS (3:55)
How to Alter Table Schema - Command Line TSQL (3:59)
INSERT Records
* * SECTION DESCRIPTION * * (3:03)
INSERT RECORDS - SSMS (1:13)
INSERT RECORDS - SSMS - NOT NULL Fields (1:46)
INSERT RECORDS - SSMS - Handling NOT NULL Fields with Default Va (3:13)
INSERT RECORDS - TSQL (2:57)
INSERT RECORDS - TSQL - Default Values (4:32)
INSERT RECORDS - STORED PROCEDURE (2:29)
INSERT RECORDS - STORED PROCEDURE AND DEFAULT VALUES (6:44)
UPDATE Records
* * SECTION DESCRIPTION * * (3:04)
UPDATE RECORDS - SSMS GUI (1:17)
UPDATE RECORDS - VIA TSQL (2:48)
UPDATE RECORDS - TSQL SCRIPT (2:52)
UPDATE RECORDS - STORED PROCEDURE (4:14)
DELETE Records
* * SECTION DESCRIPTION * * (3:02)
DELETE RECORDS - SSMS GUI (0:43)
DELETE RECORDS - VIA TSQL (1:55)
DELETE RECORDS - TSQL SCRIPT (2:19)
DELETE RECORDS - STORED PROCEDURE (3:13)
INSERT & DELETE Advanced
* * SECTION DESCRIPTION * * (3:10)
INSERT and DELETE - Part 1 of 5 - SSMS (1:24)
INSERT and DELETE - Part 2 of 5 - TSQL (4:17)
INSERT and DELETE - Part 3 of 5 - IDENTITY INSERT (5:50)
INSERT and DELETE - Part 4 of 5 - SELECT INTO (5:49)
INSERT and DELETE - Part 5 of 5 - DBCC CheckIdent (4:13)
Scripting
* * SECTION DESCRIPTION * * (3:50)
Scripting - Part 1 of 4 - Table Creation Script - SSMS (3:26)
Scripting - Part 2 of 4 - Data Insertion Script (3:06)
Scripting - Part 3 of 4 - Using a Script as a Template (3:11)
Scripting - Part 4 of 4 - Specialty Stored Procedure (3:49)
SECTION 7 - REVIEW QUIZ
UPDATE RECORDS - TSQL SCRIPT
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock