Curriculum
Section 1: The Basics | |||
---|---|---|---|
Lecture 1 |
* * * * COURSE INTRODUCTION * * * *
| 03:11 | |
Lecture 2 |
* * SECTION DESCRIPTION * *
| 00:32 | |
Lecture 3 |
Table Types
| 03:03 | |
Quiz 1 |
SECTION 1 - REVIEW QUIZ
| 4 questions | |
Section 2: Table Design and Management | |||
Lecture 4 |
* * SECTION DESCRIPTION * *
| 02:17 | |
Lecture 5 |
Table Design and Naming Convention
| 04:58 | |
Lecture 6 |
How to Create Setup Tables - SSMS
| 05:52 | |
Lecture 7 |
How to Alter Table Schema - SSMS
| 03:55 | |
Lecture 8 |
How to Alter Table Schema - Command Line TSQL
| 03:58 | |
Quiz 2 |
SECTION 2 - REVIEW QUIZ
| 6 questions | |
Section 3: INSERT Records | |||
Lecture 9 |
* * SECTION DESCRIPTION * *
| 03:02 | |
Lecture 10 |
INSERT RECORDS - SSMS
| 01:13 | |
Lecture 11 |
INSERT RECORDS - SSMS - NOT NULL Fields
| 01:46 | |
Lecture 12 |
INSERT RECORDS - SSMS - Handling NOT NULL Fields with Default Va
| 03:13 | |
Lecture 13 |
INSERT RECORDS - TSQL
| 02:56 | |
Lecture 14 |
INSERT RECORDS - TSQL - Default Values
| 04:30 | |
Lecture 15 |
INSERT RECORDS - STORED PROCEDURE
| 02:29 | |
Lecture 16 |
INSERT RECORDS - STORED PROCEDURE AND DEFAULT VALUES
| 06:42 | |
Quiz 3 |
SECTION 3 - REVIEW QUIZ
| 8 questions | |
Section 4: UPDATE Records | |||
Lecture 17 |
* * SECTION DESCRIPTION * *
| 03:03 | |
Lecture 18 |
UPDATE RECORDS - SSMS GUI
| 01:17 | |
Lecture 19 |
UPDATE RECORDS - VIA TSQL
| 02:48 | |
Lecture 20 |
UPDATE RECORDS - TSQL SCRIPT
| 02:51 | |
Lecture 21 |
UPDATE RECORDS - STORED PROCEDURE
| 04:14 | |
Quiz 4 |
SECTION 4 - REVIEW QUIZ
| 6 questions | |
Section 5: DELETE Records | |||
Lecture 22 |
* * SECTION DESCRIPTION * *
| 03:01 | |
Lecture 23 |
DELETE RECORDS - SSMS GUI
| 00:43 | |
Lecture 24 |
DELETE RECORDS - VIA TSQL
| 01:54 | |
Lecture 25 |
DELETE RECORDS - TSQL SCRIPT
| 02:18 | |
Lecture 26 |
DELETE RECORDS - STORED PROCEDURE
| 03:12 | |
Quiz 5 |
SECTION 5 - REVIEW QUIZ
| 4 questions | |
Section 6: INSERT & DELETE Advanced | |||
Lecture 27 |
* * SECTION DESCRIPTION * *
| 03:09 | |
Lecture 28 |
INSERT and DELETE - Part 1 of 5 - SSMS
| 01:23 | |
Lecture 29 |
INSERT and DELETE - Part 2 of 5 - TSQL
| 04:16 | |
Lecture 30 |
INSERT and DELETE - Part 3 of 5 - IDENTITY INSERT
| 05:48 | |
Lecture 31 |
INSERT and DELETE - Part 4 of 5 - SELECT INTO
| 05:47 | |
Lecture 32 |
INSERT and DELETE - Part 5 of 5 - DBCC CheckIdent
| 04:12 | |
Quiz 6 |
SECTION 6 - REVIEW QUIZ
| 5 questions | |
Section 7: Scripting | |||
Lecture 33 |
* * SECTION DESCRIPTION * *
| 03:49 | |
Lecture 34 |
Scripting - Part 1 of 4 - Table Creation Script - SSMS
| 03:25 | |
Lecture 35 |
Scripting - Part 2 of 4 - Data Insertion Script
| 03:05 | |
Lecture 36 |
Scripting - Part 3 of 4 - Using a Script as a Template
| 03:11 | |
Lecture 37 |
Scripting - Part 4 of 4 - Specialty Stored Procedure
| 03:48 | |
Quiz 7 |
SECTION 7 - REVIEW QUIZ
| 4 questions |
Instructor Biography
Download :
http://adf.ly/1Rp2Ra