off original price!

The coupon code was not applied because it has already been redeemed or expired. Please click on "My Courses" to see if the course is already on your account.

off original price!

The coupon code was not applied because it has already been redeemed or expired. Please click on "My Courses" to see if the course is already on your account.

SQL Server Fast Track for Novices: Tables

The All-in-One Primer for Getting Up To Speed on SQL Server Database Tables

What's Inside

So you have a basic understanding of SQL, but you’re ready to take your skills to the next level? This in-depth course is the perfect place to start. Get up to speed on proper table design, creation, scripting, and management, and start executing simple TSQL statements. With real world examples of Stored Procedures, you’ll understand the importance of production database development in your industry and beyond.

Take your SQL skills to the next level w/ over 37 lectures & 2 hours of content
Design, build, manage & maintain a wide variety of database tables
Learn to streamline functions like INSERT, UPDATE & DELETE
Access real world examples
Download included Stored Procedures
View several code examples of simultaneous techniques in action
Learn how mastering SQL Server can boost your career

Course Curriculum

The Basics

* * * * COURSE INTRODUCTION * * * * - 3:12
Start
* * SECTION DESCRIPTION * * - 0:33
Start
Table Types - 3:04
Start

Table Design and Management

* * SECTION DESCRIPTION * * - 2:18
Start
Table Design and Naming Convention - 5:00
Start
How to Create Setup Tables - SSMS - 5:54
Start
How to Alter Table Schema - SSMS - 3:55
Start
How to Alter Table Schema - Command Line TSQL - 3:59
Start

INSERT Records

* * SECTION DESCRIPTION * * - 3:03
Start
INSERT RECORDS - SSMS - 1:13
Start
INSERT RECORDS - SSMS - NOT NULL Fields - 1:46
Start
INSERT RECORDS - SSMS - Handling NOT NULL Fields with Default Va - 3:13
Start
INSERT RECORDS - TSQL - 2:57
Start
INSERT RECORDS - TSQL - Default Values - 4:32
Start
INSERT RECORDS - STORED PROCEDURE - 2:29
Start
INSERT RECORDS - STORED PROCEDURE AND DEFAULT VALUES - 6:44
Start

UPDATE Records

* * SECTION DESCRIPTION * * - 3:04
Start
UPDATE RECORDS - SSMS GUI - 1:17
Start
UPDATE RECORDS - VIA TSQL - 2:48
Start
UPDATE RECORDS - TSQL SCRIPT - 2:52
Start
UPDATE RECORDS - STORED PROCEDURE - 4:14
Start

DELETE Records

* * SECTION DESCRIPTION * * - 3:02
Start
DELETE RECORDS - SSMS GUI - 0:43
Start
DELETE RECORDS - VIA TSQL - 1:55
Start
DELETE RECORDS - TSQL SCRIPT - 2:19
Start
DELETE RECORDS - STORED PROCEDURE - 3:13
Start

INSERT & DELETE Advanced

* * SECTION DESCRIPTION * * - 3:10
Start
INSERT and DELETE - Part 1 of 5 - SSMS - 1:24
Start
INSERT and DELETE - Part 2 of 5 - TSQL - 4:17
Start
INSERT and DELETE - Part 3 of 5 - IDENTITY INSERT - 5:50
Start
INSERT and DELETE - Part 4 of 5 - SELECT INTO - 5:49
Start
INSERT and DELETE - Part 5 of 5 - DBCC CheckIdent - 4:13
Start

Scripting

* * SECTION DESCRIPTION * * - 3:50
Start
Scripting - Part 1 of 4 - Table Creation Script - SSMS - 3:26
Start
Scripting - Part 2 of 4 - Data Insertion Script - 3:06
Start
Scripting - Part 3 of 4 - Using a Script as a Template - 3:11
Start
Scripting - Part 4 of 4 - Specialty Stored Procedure - 3:49
Start
SECTION 7 - REVIEW QUIZ
Start

off original price!

The coupon code was not applied because it has already been redeemed or expired. Please click on "My Courses" to see if the course is already on your account.

Get started now!