SQL Server FAST TRACK for Novices – Tables

Course Curriculum

Chapter 1: The Basics

Lecture 1: * * * * COURSE INTRODUCTION * * * *

Lecture 2: * * SECTION DESCRIPTION * *

Lecture 3: Table Types

Chapter 2: Table Design and Management

Lecture 1: * * SECTION DESCRIPTION * *

Lecture 2: Table Design and Naming Convention

Lecture 3: How to Create Setup Tables – SSMS

Lecture 4: How to Alter Table Schema – SSMS

Lecture 5: How to Alter Table Schema – Command Line TSQL

Chapter 3: INSERT Records

Lecture 1: * * SECTION DESCRIPTION * *

Lecture 2: INSERT RECORDS – SSMS

Lecture 3: INSERT RECORDS – SSMS – NOT NULL Fields

Lecture 4: INSERT RECORDS – SSMS – Handling NOT NULL Fields with Default Va

Lecture 5: INSERT RECORDS – TSQL

Lecture 6: INSERT RECORDS – TSQL – Default Values

Lecture 7: INSERT RECORDS – STORED PROCEDURE

Lecture 8: INSERT RECORDS – STORED PROCEDURE AND DEFAULT VALUES

Chapter 4: UPDATE Records

Lecture 1: * * SECTION DESCRIPTION * *

Lecture 2: UPDATE RECORDS – SSMS GUI

Lecture 3: UPDATE RECORDS – VIA TSQL

Lecture 4: UPDATE RECORDS – TSQL SCRIPT

Lecture 5: UPDATE RECORDS – STORED PROCEDURE

Chapter 5: DELETE Records

Lecture 1: * * SECTION DESCRIPTION * *

Lecture 2: DELETE RECORDS – SSMS GUI

Lecture 3: DELETE RECORDS – VIA TSQL

Lecture 4: DELETE RECORDS – TSQL SCRIPT

Lecture 5: DELETE RECORDS – STORED PROCEDURE

Chapter 6: INSERT & DELETE Advanced

Lecture 1: * * SECTION DESCRIPTION * *

Lecture 2: INSERT and DELETE – Part 1 of 5 – SSMS

Lecture 3: INSERT and DELETE – Part 2 of 5 – TSQL

Lecture 4: INSERT and DELETE – Part 3 of 5 – IDENTITY INSERT

Lecture 5: INSERT and DELETE – Part 4 of 5 – SELECT INTO

Lecture 6: INSERT and DELETE – Part 5 of 5 – DBCC CheckIdent

Chapter 7: Scripting

Lecture 1: * * SECTION DESCRIPTION * *

Lecture 2: Scripting – Part 1 of 4 – Table Creation Script – SSMS

Lecture 3: Scripting – Part 2 of 4 – Data Insertion Script

Lecture 4: Scripting – Part 3 of 4 – Using a Script as a Template

Lecture 5: Scripting – Part 4 of 4 – Specialty Stored Procedure