Beginning SQL Server TSQL Programming
Buy now
Learn more
Module 1 - Introduction
Lesson 1 - Introduction
Lesson 1 – Introduction Video
Topic 1 – Introduction
Topic 2 – Who is the Grumpy Old IT Guy?
Topic 3 – Objectives
Topic 4 – Course Overview
Topic 5 – SSMS
Topic 6 – TSQL DML
Topic 7 – DML Query Structure
Topic 8 – DDL
Topic 9 – DCL
Topic 10 – JOINS
Topic 11 – The ORDER BY Clause
Topic 12 – The GROUP BY Clause
Topic 13 – Aggregate Functions
Topic 14 – UNION
Topic 15 – String Functions
Topic 16 – Date Functions
Topic 17 – TSQL Programming
Topic 18 – Review
Introduction to TSQL script
Intro Quiz
Setup - Installing SQL Server and SSMS
GRUMPY PODCAST - INSTALLING SQL SERVER 2019
GRUMPY PODCAST - INSTALLING SSMS 2019
BEGINNING TSQL - SETUP ENVIRONMENT - START HERE
DISCLAIMER
Module 2 – Navigating SSMS
Introduction
Introduction Video – Navigating SSMS
MODULE 02 - INTRO SSMS SCRIPT
Lesson 2 - Connection Management Description
Lesson 2 - Connection Management Video
Lesson 3 - Creating Databases Description
Lesson 3 - Creating Databases Video
Lesson 4 - Exploring Databases Description
Lesson 4 - Exploring Databases Video
Lesson 5 - Managing Tables Description
Lesson 5 – Managing SQL Server Database Tables Video
Lesson 6 – SQL Server Database View Management Description
Lesson 6 – SQL Server Database View Management View
Lesson 7 – SQL Server Programmability with TSQL Description
Lesson 7 – SQL Server Programmability with TSQL Video
Lesson 8 – Database Object Security Management Description
Lesson 8 – Database Object Security Management Video
Lesson 9 – Job Management and Scheduling with SQL Agent Description
Lesson 9 – Job Management and Scheduling with SQL Agent Video
Lesson 10 – Review Description
Lesson 10 – Review Video
Module 3 – DML, the Data Manipulation Language
Lesson 1 – Introduction Description
Lesson 1 - Introduction Video
Lesson 1 - Demo TSQL Script
Lesson 1 - Quiz
Lesson 2 – The SELECT Clause Description
Lesson 2 – The SELECT Clause Video
Lesson 2 - Demo TSQL Script
Lesson 2 - Quiz
Lesson 3 – The FROM Clause Description
Lesson 3 - The FROM Clause Video
Lesson 3 - Demo TSQL Script
Lesson 3 - Quiz
Lesson 4 – The WHERE Clause Description
Lesson 4 – The WHERE Clause Video
Lesson 4 - Demo TSQL Script
Lesson 4 - Quiz
Lesson 5 – The JOIN Clause Description
Lesson 5 - The JOIN Clause Video
Lesson 5 - Demo TSQL Script
Lesson 5 - Quiz
Lesson 6 – The GROUP BY Clause Description
Lesson 6 – The GROUP BY Clause Video
Lesson 6 - Demo TSQL Script
Lesson 6 - Quiz
Lesson 7 – Aggregate Functions Description
Lesson 7 – Aggregate Functions Video
Lesson 7 - Demo TSQL Script
Lesson 7 - Quiz
Lesson 8 – The HAVING Clause Description
Lesson 8 – The HAVING Clause Video
Lesson 8 - Demo TSQL Script
Lesson 8 - Quiz
Lesson 9 – The ORDER BY Clause Description
Lesson 9 – The ORDER BY Clause Video
Lesson 9 - Demo TSQL Script
Lesson 9 - Quiz
Lesson 10 – Managing Database Tables Description
Lesson 10 – Managing Database Tables Video
Lesson 10 - Demo TSQL Script
Lesson 10 - Quiz
Lesson 11 – The INSERT Command Description
Lesson 11 – INSERT Command Video
Lesson 11 - Demo TSQL Script
Lesson 11 - Bulk Insert CSV Data Example
Lesson 11 - Quiz
Lesson 12 – Quick Review Description
Lesson 12 – Quick Review Video
Lesson 12 - Demo TSQL Script
Lesson 12 - Quiz
Lesson 13 – More DML Commands Description
Lesson 13 – More DML Commands Video
Lesson 13 - Demo TSQL Script
Lesson 13 - Quiz
Lesson 14 – BACKUP Utility Description
Lesson 14 – BACKUP Utility Video
Lesson 14 - Demo TSQL Script
Lesson 14 - Quiz
Lesson 15 – RESTORE Utility Description
Lesson 15 – RESTORE Utility Video
Lesson 15 - Demo TSQL Script
Lesson 15 - Quiz
Lesson 16 – Module Review Description
Lesson 16 – Review Video
Module 4 – DDL, the Data Declaration Language
Lesson 1 – Introduction
Lesson 1 – Introduction Video
Lesson 1 - Demo TSQL Script
Lesson 2 – The CREATE DATABASE Command
Lesson 2 – The CREATE DATABASE Command Video
Lesson 2 - Demo TSQL Script
Lesson 2 - Quiz
Lesson 3 – The CREATE TABLE Command
Lesson 3 – The CREATE TABLE Command Video
Lesson 3 - Demo TSQL Script
Lesson 3 - Quiz
Lesson 4 – The CREATE VIEW Command
Lesson 4 – The CREATE VIEW Command Video
Lesson 4 - Demo TSQL Script
Lesson 4 - Quiz
Lesson 5 – The CREATE INDEX Command
Lesson 5 – The CREATE INDEX Command Video
Lesson 5 - Demo TSQL Script
Lesson 5 - Quiz
Lesson 6 – Introduction to Query Plans
Lesson 6 – Introduction to Query Plans Video
Lesson 6 - Demo TSQL Script
Lesson 6 - Quiz
Lesson 7 – Review
Lesson 7 – Review Video
Module 5 – DCL, the Data Control Language
Lesson 1 – Introduction
Lesson 1 – Introduction Video
Lesson 1 - Demo TSQL Script
Lesson 1 - Quiz
Lesson 2 – DCL – Data Control Language
Lesson 2 – DCL – Data Control Language Video
Lesson 2 - Demo TSQL Script
Lesson 2 - Quiz
Lesson 3 – Server Level LOGINS
Lesson 3 – Server Level LOGINS Video
Lesson 3 - Demo TSQL Script
Lesson 3 - Quiz
Lesson 4 – Database Level USERS
Lesson 4 – Database Level USERS Video
Lesson 4 - Demo TSQL Script
Lesson 4 - Quiz
Lesson 5 – Server Roles
Lesson 5 – Server Roles Video
Lesson 5 - Demo TSQL Script
Lesson 5 - Quiz
Lesson 6 – Database Roles
Lesson 6 – Database Roles Video
Lesson 6 - Demo TSQL Script
Lesson 6 - Quiz
Lesson 7 – Application Roles
Lesson 7 – Application Roles Video
Lesson 7 - Demo TSQL Script
Lesson 7 - Quiz
Lesson 8 – Review
Lesson 8 – Review Video
Module 6 – Using JOINS in Queries
Lesson 1 – Introduction
Lesson 1 – Introduction Video
Lesson 2 – Inner Join
Lesson 2 – Inner Join Video
Lesson 2 - Demo TSQL Script
Lesson 2 - Quiz
Lesson 3 – Left Outer Join
Lesson 3 – Left Outer Join Video
Lesson 3 - Demo TSQL Script
Lesson 3 - Quiz
Lesson 4 – Right Outer Join
Lesson 4 – Right Outer Join Video
Lesson 4 - Demo TSQL Script
Lesson 4 - Quiz
Lesson 5 – Cross Join
Lesson 5 – Cross Join Video
Lesson 5 - Demo TSQL Script
Lesson 5 - Quiz
Lesson 6 – Join Predicates and Operators
Lesson 6 – Join Predicates and Operators Video
Lesson 6 - Demo TSQL Script
Lesson 6 - Quiz
Lesson 7 – Using Multiple Join Operators
Lesson 7 – Using Multiple Join Operators Video
Lesson 7 - Demo TSQL Script
Lesson 7 - Quiz
Lesson 8 – Using a Join with a Function
Lesson 8 – Using a Join with a Function Video
Lesson 8 - Demo TSQL Script
Lesson 8 - Quiz
Lesson 9 – Review
Lesson 9 – Review Video
Module 7 – The ORDER BY clause
Lesson 1 – Introduction
Lesson 1 – Introduction Video
Lesson 1 - Demo TSQL Script
Lesson 2 – The ORDER BY clause
Lesson 2 – The ORDER BY clause - Video
Lesson 2 - Demo TSQL Script
Lesson 2 - Quiz
Lesson 3 – More ORDER BY
Lesson 3 – More ORDER BY Video
Lesson 3 - Demo TSQL Script
Lesson 3 - Quiz
Lesson 4 – ORDER BY clause with CASE Blocks
Lesson 4 – ORDER BY clause with CASE Blocks Video
Lesson 4 - Demo TSQL Script
Lesson 4 - Quiz
Lesson 5 – Data Conversion Traps
Lesson 5 – Data Conversion Traps Video
Lesson 5 - Demo TSQL Script
Lesson 5 - Quiz
Lesson 6 – ORDER BY with ROW
Lesson 6 – ORDER BY with ROW Video
Lesson 6 - Demo TSQL Script
Lesson 7 – ORDER BY with Parameters
Lesson 7 – ORDER BY with Parameters Video
Lesson 7 - Demo TSQL Script
Lesson 7 - Quiz
Lesson 8 – Review
Lesson 8 – Review Video
Module 8 – The GROUP BY clause
Lesson 1 – Introduction
Lesson 1 – Introduction Video
Lesson 2 – Introducing the Group By Clause
Lesson 2 – Introducing the Group By Clause Video
Lesson 2 - Demo TSQL Script
Lesson 2 - Quiz
Lesson 3 – Group By and Having Clauses
Lesson 3 – Group By and Having Clauses Video
Lesson 3 - Demo TSQL Script
Lesson 4 – The Group By clause with ROLLUP
Lesson 4 – The Group By clause with ROLLUP Video
Lesson 4 - Demo TSQL Script
Lesson 4 - Quiz
Lesson 5 – Group By Clause with CUBE
Lesson 5 – Group By Clause with CUBE Video
Lesson 5 - Demo TSQL Script
Lesson 5 - Quiz
Lesson 6 – Group By with Grouping Sets
Lesson 6 – GROUP BY with GROUPING SETS Video
Lesson 6 - Demo TSQL Script
Lesson 6 - Quiz
Lesson 7 – Grouping Sets with Empty Groups
Lesson 7 – Grouping Sets with Empty Groups Video
Lesson 7 - Demo TSQL Script
Lesson 7 - Quiz
Lesson 8 – Review
Lesson 8 – Review Video
Module 9 – Aggregate Functions
Lesson 1 – Introduction
Lesson 1 – Introduction Video
Lesson 1 - Demo TSQL Script
Lesson 2 – The COUNT() Function
Lesson 2 – The COUNT() Function Video
Lesson 2 - Demo TSQL Script
Lesson 2 - Quiz
Lesson 3 – The SUM() Function
Lesson 3 – The SUM() Function Video
Lesson 3 - Demo TSQL Script
Lesson 3 - Quiz
Lesson 4 – The MAX() Function
Lesson 4 – The MAX() Function Video
Lesson 4 - Demo TSQL Script
Lesson 4 - Quiz
Lesson 5 – The MIN() Function
Lesson 5 – The MIN() Function Video
Lesson 5 - Demo TSQL Script
Lesson 5 - Quiz
Lesson 6 – The AVG() Function
Lesson 6 – The AVG() Function Video
Lesson 6 - Demo TSQL Script
Lesson 6 - Quiz
Lesson 7 – The STDEV() & STDEVP Function
Lesson 7 – The STDEV() & STDEVP Function Video
Lesson 7 - Demo TSQL Script
Lesson 7 - Quiz
Lesson 8 – The VAR() & VARP Function
Lesson 8 – The VAR() & VARP Function Video
Lesson 8 - Demo TSQL Script
Lesson 9 – MATH 101
Lesson 8 - Quiz
Lesson 9 – MATH 101 Video
Lesson 9 - Demo TSQL Script
Lesson 9 - Quiz
Lesson 10 – Loading the Failure Tables
Lesson 10 – Loading the Failure Tables
Lesson 10a - Demo TSQL Script - loading Plant & Hobby Shop Tables
Lesson 10b - Demo TSQL Script - loading Hobby Shop transactions
Lesson 10 - Quiz
Lesson 11 – THE OVER() Clause
Lesson 11 – THE OVER() Clause Video
Lesson 11 - Demo TSQL Script
Lesson 11 - Quiz
Lesson 12 – Review
Lesson 12 – Review Video
Lesson 13 - Extra TSQL Files for loading tables
Lesson 13 - Demo TSQL Script - generate plant failure test data
Lesson 13 - Demo TSQL Script - Plant database, adding failure tables
Module 10 – UNION and UNION ALL
Lesson 1 – Introduction
Lesson 1 – Introduction Video
Lesson 2 – The PLANT database
Lesson 2 – The PLANT database Video
Lesson 2 - Demo TSQL Script
Lesson 2 - Quiz
Lesson 3 – The UNION Operator
Lesson 3 – The UNION Operator Video
Lesson 3 - Demo TSQL Script
Lesson 3 - Quiz
Lesson 4 – UNION ALL
Lesson 4 – UNION ALL Video
Lesson 4 - Demo TSQL Script
Lesson 5 – UNION (without ALL)
Lesson 5 – UNION (without ALL) Video
Lesson 5 - Demo TSQL Script
Lesson 5 - Quiz
Lesson 6 – Review
Lesson 6 – Review Video
Module 11 – String Functions
Lesson 1 – Introduction
Lesson 1 – Introduction Video
Lesson 1 - Demo TSQL Script
Lesson 2 – The LEN() Function
Lesson 2 – The LEN() Function Video
Lesson 2 - Demo TSQL Script
Lesson 2 - Quiz
Lesson 3 – The LEFT() Function
Lesson 3 – The LEFT() Function Video
Lesson 3 - Demo TSQL Script
LESSON 3 - Quiz
Lesson 4 – The RIGHT() Function
Lesson 4 – The RIGHT() Function Video
Lesson 4 - Demo TSQL Script
Lesson 4 - Quiz
Lesson 5 – The LTRIM() Function
Lesson 5 – The LTRIM() Function Video
Lesson 5 - Demo TSQL Script
Lesson 5 - Quiz
Lesson 6 – The RTRIM() Function
Lesson 6 – The RTRIM() Function Video
Lesson 6 - Demo TSQL Script
Lesson 6 - Quiz
Lesson 7 – The REPLACE() Function
Lesson 7 – The REPLACE() Function Video
Lesson 7 - Demo TSQL Script
Lesson 7 - Quiz
Lesson 8 – The CHARINDEX() Function
Lesson 8 – The CHARINDEX() Function Video
Lesson 8 - Demo TSQL Script
Lesson 8 - Quiz
Lesson 9 – The SUBSTRING() Function
Lesson 9 – The SUBSTRING() Function Video
Lesson 9 - Demo TSQL Script
Lesson 9 - Quiz
Lesson 10 – The REVERSE() Function
Lesson 10 – The REVERSE() Function Video
Lesson 10 - Demo TSQL Script
Lesson 10 - Quiz
Lesson 11 – The CONCAT() Function
Lesson 11 – The CONCAT() Function Video
Lesson 11 - Demo TSQL Script
Lesson 11 - Quiz
Lesson 12 – The LOWER() Function
Lesson 12 – The LOWER() Function Video
Lesson 12 - Demo TSQL Script
Lesson 12 - Quiz
Lesson 13 – The UPPER() Function
Lesson 13 – The UPPER() Function Video
Lesson 13 - Demo TSQL Script
Lesson 13 - Quiz
Lesson 14 – The DIFFERENCE() Function
Lesson 14 – The DIFFERENCE() Function Video
Lesson 14- Demo TSQL Script
Lesson 14 - Quiz
Lesson 15 – The SOUNDEX() Function
Lesson 15 – The SOUNDEX() Function Video
Lesson 15 - Demo TSQL Script
Lesson 15 - Quiz
Lesson 16 – The STRING_SPLIT() Function
Lesson 16 – The STRING_SPLIT() Function Video
Lesson 16 - Demo TSQL Script
Lesson 16 - Quiz
Lesson 17 – Review Video
Lesson 17 – Review
Module 12 – Date Functions
Lesson 1 – Introduction
Lesson 1 – Introduction Video
Lesson 1 - Demo TSQL Script
Lesson 2 – The GETDATE() Function
Lesson 2 – The GETDATE() Function Video
Lesson 2 - Demo TSQL Script
Lesson 2 - Quiz
Lesson 3 – The ISDATE() Function
Lesson 3 – The ISDATE() Function Video
Lesson 3 - Demo TSQL Script
Lesson 3 - Quiz
Lesson 4 – The DATEADD() Function
Lesson 4 – The DATEADD() Function Video
Lesson 4 - Demo TSQL Script
Lesson 4 - Quiz
Lesson 5 – The DATEDIFF() Function
Lesson 5 – The DATEDIFF() Function Video
Lesson 5 - Demo TSQL Script
Lesson 5 - Quiz
Lesson 6 – The DATEPART() Function
Lesson 6 – The DATEPART() Function Video
Lesson 6 - Demo TSQL Script
Lesson 6 - Quiz
Lesson 7 – The DAY() Function
Lesson 7 – The DAY() Function Video
Lesson 7 - Demo TSQL Script
Lesson 7 - Quiz
Lesson 8 – The MONTH() Function
Lesson 8 – The MONTH() Function Video
Lesson 8 - Demo TSQL Script
Lesson 8 - Quiz
Lesson 9 – The YEAR() Function
Lesson 9 – The YEAR() Function Video
Lesson 9 - Demo TSQL Script
Lesson 9 - Quiz
Lesson 10 – The EOMONTH() Function
Lesson 10 – The EOMONTH() Function Video
Lesson 10 - Demo TSQL Script
Lesson 10 - Quiz
Lesson 11 – Review
Lesson 11 – Review Video
Module 13 – TSQL Deep Dive
Lesson 1 – Introduction
Lesson 1 – Introduction Video
Lesson 2 – Batch Concepts
Lesson 2 – Batch Concepts Video
Lesson 2 - Demo TSQL Script
Lesson 2 - Quiz
Lesson 3 – Conditional Programming with IF-ELSE Blocks
Lesson 3 – Conditional Programming with IF-ELSE Blocks Video
Lesson 3 - Demo TSQL Script
Lesson 3 - Quiz
Lesson 4 – WHILE Loops
Lesson 4 – WHILE Loops Video
Lesson 4 - Demo TSQL Script
Lesson 4 - Quiz
Lesson 5 – Using CASE Blocks
Lesson 5 – Using CASE Blocks Video
Lesson 5 - Demo TSQL Script
Lesson 5 - Quiz
Lesson 6 – Using CURSOR Blocks
Lesson 6 – Using CURSOR Blocks Video
Lesson 6 - Demo TSQL Script
Lesson 6 - Quiz
Lesson 7 – Stored Procedures
Lesson 7 – Stored Procedures Video
Lesson 7 - Demo TSQL Script
Lesson 7 - Quiz
Lesson 8 – Functions
Lesson 8 – Functions Video
Lesson 8 - Demo TSQL Script
Lesson 8 - Quiz
Lesson 9 – CTE – Common Table Expressions
Lesson 9 – CTE – Common Table Expressions Video
Lesson 9 - Demo TSQL Script
Lesson 9 - Quiz
Lesson 10 – Review
Lesson 10 – Review Video
Module 14 – Wrap Up
Module 14 – Wrap Up Video
Lesson Homework Assignments
BEGINNING TSQL - MODULE 2 - HOMEWORK PDF.pdf
BEGINNING TSQL - MODULE 3 - DML - HOMEWORK PDF.pdf
BEGINNING TSQL - MODULE 4 - DDL - HOMEWORK PDF.pdf
BEGINNING TSQL - MODULE 5 - DCL - HOMEWORK PDF.pdf
BEGINNING TSQL - MODULE 6 - JOINS - HOMEWORK PDF.pdf
BEGINNING TSQL - MODULE 7 - ORDER BY - HOMEWORK PDF.pdf
BEGINNING TSQL - MODULE 8 - GROUP BY - HOMEWORK PDF.pdf
BEGINNING TSQL - MODULE 9 - AGGREGATE FUNCTIONS - HOMEWORK PDF.pdf
BEGINNING TSQL - MODULE 10 - UNION - HOMEWORK PDF.pdf
BEGINNING TSQL - MODULE 11 - STRING FUNCTIONS - HOMEWORK PDF.pdf
BEGINNING TSQL - MODULE 12 - DATE FUNCTIONS - HOMEWORK PDF.pdf
BEGINNING TSQL - MODULE 13 - TSQL DEEP DIVE - HOMEWORK PDF.pdf
Lesson Homework Templates
MODULE 02 - SSMS HOMEWORK TEMPLATE_FINAL.sql
MODULE 03 - DML HOMEWORK TEMPLATE_FINAL.sql
MODULE 04 - DDL HOMEWORK TEMPLATE_FINAL.sql
MODULE 05 - DCL HOMEWORK TEMPLATE_FINAL.sql
MODULE 06 - JOINS HOMEWORK TEMPLATE_FINAL.sql
MODULE 07 - ORDER BY HOMEWORK TEMPLATE_FINAL.sql
MODULE 08 - GROUP BY HOMEWORK TEMPLATE_FINAL.sql
MODULE 09 - AGGREGATE HOMEWORK TEMPLATE_FINAL.sql
MODULE 10 - UNION HOMEWORK TEMPLATE - FINAL.sql
MODULE 11 - STRING HOMEWORK TEMPLATE - FINAL.sql
MODULE 12 - DATE HOMEWORK SOLUTION TEMPLATE - FINAL.sql
MODULE 13 - TSQL DEEP DIVEHOMEWORK TEMPLATE - FINAL.sql
Lesson Homework Solutions
MODULE 02 - SSMS HOMEWORK SOLUTIONS.sql
MODULE 03 -DML HOMEWORK SOLUTIONS.sql
MODULE 04 -DDL HOMEWORK SOLUTIONS.sql
MODULE 05 -DCL HOMEWORK SOLUTIONS.sql
MODULE 06 -JOINS HOMEWORK SOLUTIONS.sql
MODULE 07 - ORDER BY HOMEWORK SOLUTIONS.sql
MODULE 08 - GROUP BY HOMEWORK SOLUTIONS.sql
MODULE 09 - AGGREGATE HOMEWORK SOLUTIONS.sql
MODULE 10 - UNION HOMEWORK SOLUTIONS.sql
MODULE 12 - DATE HOMEWORK SOLUTIONS.sql
MODULE 11 - STRING HOMEWORK SOLUTIONS.sql
MODULE 13 - TSQL DEEP DIVE HOMEWORK SOLUTIONS.sql
Create Databases DDL
CREATE BANK DATABASE.sql
CREATE CUSTOMER DATABASE.sql
CREATE CUSTOMER_MASTER DATABASE.sql
CREATE CUSTOMER_SALES DATABASE.sql
CREATE HOBBY_SHOP DATABASE.sql
CREATE HUMAN_RESOURCES DATABASE.sql
CREATE INVENTORY DATABASE.sql
CREATE LOGISTICS DATABASE.sql
CREATE ORGANIZATION DATABASE.sql
CREATE PLANT 10 HW DATABASE.sql
CREATE PLANT DATABASE
CREATE PLANT M10 DATABASE.sql
CREATE SALES DATABASE.sql
CREATE SALES DW DATABASE.sql
Create Database Tables
CREATE BANK DATABASE TABLES.sql
CREATE CUSTOMER DATABASE TABLES.sql
CREATE CUSTOMER SALES DATABASE TABLES.sql
CREATE HOBBY SHOP DATABASE TABLES.sql
CREATE HUMAN RESOURCES SALES DATABASE TABLES.sql
CREATE INVENTORY DATABASE TABLES.sql
CREATE ORGANIZATION SALES DATABASE TABLES.sql
CREATE PLANT DATABASE TABLES.sql
CREATE PLANT M10 DATABASE TABLES.sql
CREATE PLANT M10 HW DATABASE TABLES.sql
CREATE SALES DW DATABASE TABLES.sql
CREATE SALES DATABASE TABLES.sql
Database Tables BCP files
BANK.zip
CUSTOMER.zip
HOBBY_SHOP.zip
CUSTOMER_SALES.zip
HUMAN_RESOURCES.zip
INVENTORY.zip
PLANT.zip
ORGANIZATION.zip
PLANT_M10.zip
PLANT_10_HW.zip
SALES.zip
SALES_DW.zip
BEGINNING_TSQL_DATABASES
BUG Fixes
BUG 01 - Existing databases on the students server cause load script to fail - 11/3/2025 - RESOLVED
Products
Course
Section
Lesson
Lesson 3 – Server Level LOGINS
Lesson 3 – Server Level LOGINS
Beginning SQL Server TSQL Programming
Buy now
Learn more
Module 1 - Introduction
Lesson 1 - Introduction
Lesson 1 – Introduction Video
Topic 1 – Introduction
Topic 2 – Who is the Grumpy Old IT Guy?
Topic 3 – Objectives
Topic 4 – Course Overview
Topic 5 – SSMS
Topic 6 – TSQL DML
Topic 7 – DML Query Structure
Topic 8 – DDL
Topic 9 – DCL
Topic 10 – JOINS
Topic 11 – The ORDER BY Clause
Topic 12 – The GROUP BY Clause
Topic 13 – Aggregate Functions
Topic 14 – UNION
Topic 15 – String Functions
Topic 16 – Date Functions
Topic 17 – TSQL Programming
Topic 18 – Review
Introduction to TSQL script
Intro Quiz
Setup - Installing SQL Server and SSMS
GRUMPY PODCAST - INSTALLING SQL SERVER 2019
GRUMPY PODCAST - INSTALLING SSMS 2019
BEGINNING TSQL - SETUP ENVIRONMENT - START HERE
DISCLAIMER
Module 2 – Navigating SSMS
Introduction
Introduction Video – Navigating SSMS
MODULE 02 - INTRO SSMS SCRIPT
Lesson 2 - Connection Management Description
Lesson 2 - Connection Management Video
Lesson 3 - Creating Databases Description
Lesson 3 - Creating Databases Video
Lesson 4 - Exploring Databases Description
Lesson 4 - Exploring Databases Video
Lesson 5 - Managing Tables Description
Lesson 5 – Managing SQL Server Database Tables Video
Lesson 6 – SQL Server Database View Management Description
Lesson 6 – SQL Server Database View Management View
Lesson 7 – SQL Server Programmability with TSQL Description
Lesson 7 – SQL Server Programmability with TSQL Video
Lesson 8 – Database Object Security Management Description
Lesson 8 – Database Object Security Management Video
Lesson 9 – Job Management and Scheduling with SQL Agent Description
Lesson 9 – Job Management and Scheduling with SQL Agent Video
Lesson 10 – Review Description
Lesson 10 – Review Video
Module 3 – DML, the Data Manipulation Language
Lesson 1 – Introduction Description
Lesson 1 - Introduction Video
Lesson 1 - Demo TSQL Script
Lesson 1 - Quiz
Lesson 2 – The SELECT Clause Description
Lesson 2 – The SELECT Clause Video
Lesson 2 - Demo TSQL Script
Lesson 2 - Quiz
Lesson 3 – The FROM Clause Description
Lesson 3 - The FROM Clause Video
Lesson 3 - Demo TSQL Script
Lesson 3 - Quiz
Lesson 4 – The WHERE Clause Description
Lesson 4 – The WHERE Clause Video
Lesson 4 - Demo TSQL Script
Lesson 4 - Quiz
Lesson 5 – The JOIN Clause Description
Lesson 5 - The JOIN Clause Video
Lesson 5 - Demo TSQL Script
Lesson 5 - Quiz
Lesson 6 – The GROUP BY Clause Description
Lesson 6 – The GROUP BY Clause Video
Lesson 6 - Demo TSQL Script
Lesson 6 - Quiz
Lesson 7 – Aggregate Functions Description
Lesson 7 – Aggregate Functions Video
Lesson 7 - Demo TSQL Script
Lesson 7 - Quiz
Lesson 8 – The HAVING Clause Description
Lesson 8 – The HAVING Clause Video
Lesson 8 - Demo TSQL Script
Lesson 8 - Quiz
Lesson 9 – The ORDER BY Clause Description
Lesson 9 – The ORDER BY Clause Video
Lesson 9 - Demo TSQL Script
Lesson 9 - Quiz
Lesson 10 – Managing Database Tables Description
Lesson 10 – Managing Database Tables Video
Lesson 10 - Demo TSQL Script
Lesson 10 - Quiz
Lesson 11 – The INSERT Command Description
Lesson 11 – INSERT Command Video
Lesson 11 - Demo TSQL Script
Lesson 11 - Bulk Insert CSV Data Example
Lesson 11 - Quiz
Lesson 12 – Quick Review Description
Lesson 12 – Quick Review Video
Lesson 12 - Demo TSQL Script
Lesson 12 - Quiz
Lesson 13 – More DML Commands Description
Lesson 13 – More DML Commands Video
Lesson 13 - Demo TSQL Script
Lesson 13 - Quiz
Lesson 14 – BACKUP Utility Description
Lesson 14 – BACKUP Utility Video
Lesson 14 - Demo TSQL Script
Lesson 14 - Quiz
Lesson 15 – RESTORE Utility Description
Lesson 15 – RESTORE Utility Video
Lesson 15 - Demo TSQL Script
Lesson 15 - Quiz
Lesson 16 – Module Review Description
Lesson 16 – Review Video
Module 4 – DDL, the Data Declaration Language
Lesson 1 – Introduction
Lesson 1 – Introduction Video
Lesson 1 - Demo TSQL Script
Lesson 2 – The CREATE DATABASE Command
Lesson 2 – The CREATE DATABASE Command Video
Lesson 2 - Demo TSQL Script
Lesson 2 - Quiz
Lesson 3 – The CREATE TABLE Command
Lesson 3 – The CREATE TABLE Command Video
Lesson 3 - Demo TSQL Script
Lesson 3 - Quiz
Lesson 4 – The CREATE VIEW Command
Lesson 4 – The CREATE VIEW Command Video
Lesson 4 - Demo TSQL Script
Lesson 4 - Quiz
Lesson 5 – The CREATE INDEX Command
Lesson 5 – The CREATE INDEX Command Video
Lesson 5 - Demo TSQL Script
Lesson 5 - Quiz
Lesson 6 – Introduction to Query Plans
Lesson 6 – Introduction to Query Plans Video
Lesson 6 - Demo TSQL Script
Lesson 6 - Quiz
Lesson 7 – Review
Lesson 7 – Review Video
Module 5 – DCL, the Data Control Language
Lesson 1 – Introduction
Lesson 1 – Introduction Video
Lesson 1 - Demo TSQL Script
Lesson 1 - Quiz
Lesson 2 – DCL – Data Control Language
Lesson 2 – DCL – Data Control Language Video
Lesson 2 - Demo TSQL Script
Lesson 2 - Quiz
Lesson 3 – Server Level LOGINS
Lesson 3 – Server Level LOGINS Video
Lesson 3 - Demo TSQL Script
Lesson 3 - Quiz
Lesson 4 – Database Level USERS
Lesson 4 – Database Level USERS Video
Lesson 4 - Demo TSQL Script
Lesson 4 - Quiz
Lesson 5 – Server Roles
Lesson 5 – Server Roles Video
Lesson 5 - Demo TSQL Script
Lesson 5 - Quiz
Lesson 6 – Database Roles
Lesson 6 – Database Roles Video
Lesson 6 - Demo TSQL Script
Lesson 6 - Quiz
Lesson 7 – Application Roles
Lesson 7 – Application Roles Video
Lesson 7 - Demo TSQL Script
Lesson 7 - Quiz
Lesson 8 – Review
Lesson 8 – Review Video
Module 6 – Using JOINS in Queries
Lesson 1 – Introduction
Lesson 1 – Introduction Video
Lesson 2 – Inner Join
Lesson 2 – Inner Join Video
Lesson 2 - Demo TSQL Script
Lesson 2 - Quiz
Lesson 3 – Left Outer Join
Lesson 3 – Left Outer Join Video
Lesson 3 - Demo TSQL Script
Lesson 3 - Quiz
Lesson 4 – Right Outer Join
Lesson 4 – Right Outer Join Video
Lesson 4 - Demo TSQL Script
Lesson 4 - Quiz
Lesson 5 – Cross Join
Lesson 5 – Cross Join Video
Lesson 5 - Demo TSQL Script
Lesson 5 - Quiz
Lesson 6 – Join Predicates and Operators
Lesson 6 – Join Predicates and Operators Video
Lesson 6 - Demo TSQL Script
Lesson 6 - Quiz
Lesson 7 – Using Multiple Join Operators
Lesson 7 – Using Multiple Join Operators Video
Lesson 7 - Demo TSQL Script
Lesson 7 - Quiz
Lesson 8 – Using a Join with a Function
Lesson 8 – Using a Join with a Function Video
Lesson 8 - Demo TSQL Script
Lesson 8 - Quiz
Lesson 9 – Review
Lesson 9 – Review Video
Module 7 – The ORDER BY clause
Lesson 1 – Introduction
Lesson 1 – Introduction Video
Lesson 1 - Demo TSQL Script
Lesson 2 – The ORDER BY clause
Lesson 2 – The ORDER BY clause - Video
Lesson 2 - Demo TSQL Script
Lesson 2 - Quiz
Lesson 3 – More ORDER BY
Lesson 3 – More ORDER BY Video
Lesson 3 - Demo TSQL Script
Lesson 3 - Quiz
Lesson 4 – ORDER BY clause with CASE Blocks
Lesson 4 – ORDER BY clause with CASE Blocks Video
Lesson 4 - Demo TSQL Script
Lesson 4 - Quiz
Lesson 5 – Data Conversion Traps
Lesson 5 – Data Conversion Traps Video
Lesson 5 - Demo TSQL Script
Lesson 5 - Quiz
Lesson 6 – ORDER BY with ROW
Lesson 6 – ORDER BY with ROW Video
Lesson 6 - Demo TSQL Script
Lesson 7 – ORDER BY with Parameters
Lesson 7 – ORDER BY with Parameters Video
Lesson 7 - Demo TSQL Script
Lesson 7 - Quiz
Lesson 8 – Review
Lesson 8 – Review Video
Module 8 – The GROUP BY clause
Lesson 1 – Introduction
Lesson 1 – Introduction Video
Lesson 2 – Introducing the Group By Clause
Lesson 2 – Introducing the Group By Clause Video
Lesson 2 - Demo TSQL Script
Lesson 2 - Quiz
Lesson 3 – Group By and Having Clauses
Lesson 3 – Group By and Having Clauses Video
Lesson 3 - Demo TSQL Script
Lesson 4 – The Group By clause with ROLLUP
Lesson 4 – The Group By clause with ROLLUP Video
Lesson 4 - Demo TSQL Script
Lesson 4 - Quiz
Lesson 5 – Group By Clause with CUBE
Lesson 5 – Group By Clause with CUBE Video
Lesson 5 - Demo TSQL Script
Lesson 5 - Quiz
Lesson 6 – Group By with Grouping Sets
Lesson 6 – GROUP BY with GROUPING SETS Video
Lesson 6 - Demo TSQL Script
Lesson 6 - Quiz
Lesson 7 – Grouping Sets with Empty Groups
Lesson 7 – Grouping Sets with Empty Groups Video
Lesson 7 - Demo TSQL Script
Lesson 7 - Quiz
Lesson 8 – Review
Lesson 8 – Review Video
Module 9 – Aggregate Functions
Lesson 1 – Introduction
Lesson 1 – Introduction Video
Lesson 1 - Demo TSQL Script
Lesson 2 – The COUNT() Function
Lesson 2 – The COUNT() Function Video
Lesson 2 - Demo TSQL Script
Lesson 2 - Quiz
Lesson 3 – The SUM() Function
Lesson 3 – The SUM() Function Video
Lesson 3 - Demo TSQL Script
Lesson 3 - Quiz
Lesson 4 – The MAX() Function
Lesson 4 – The MAX() Function Video
Lesson 4 - Demo TSQL Script
Lesson 4 - Quiz
Lesson 5 – The MIN() Function
Lesson 5 – The MIN() Function Video
Lesson 5 - Demo TSQL Script
Lesson 5 - Quiz
Lesson 6 – The AVG() Function
Lesson 6 – The AVG() Function Video
Lesson 6 - Demo TSQL Script
Lesson 6 - Quiz
Lesson 7 – The STDEV() & STDEVP Function
Lesson 7 – The STDEV() & STDEVP Function Video
Lesson 7 - Demo TSQL Script
Lesson 7 - Quiz
Lesson 8 – The VAR() & VARP Function
Lesson 8 – The VAR() & VARP Function Video
Lesson 8 - Demo TSQL Script
Lesson 9 – MATH 101
Lesson 8 - Quiz
Lesson 9 – MATH 101 Video
Lesson 9 - Demo TSQL Script
Lesson 9 - Quiz
Lesson 10 – Loading the Failure Tables
Lesson 10 – Loading the Failure Tables
Lesson 10a - Demo TSQL Script - loading Plant & Hobby Shop Tables
Lesson 10b - Demo TSQL Script - loading Hobby Shop transactions
Lesson 10 - Quiz
Lesson 11 – THE OVER() Clause
Lesson 11 – THE OVER() Clause Video
Lesson 11 - Demo TSQL Script
Lesson 11 - Quiz
Lesson 12 – Review
Lesson 12 – Review Video
Lesson 13 - Extra TSQL Files for loading tables
Lesson 13 - Demo TSQL Script - generate plant failure test data
Lesson 13 - Demo TSQL Script - Plant database, adding failure tables
Module 10 – UNION and UNION ALL
Lesson 1 – Introduction
Lesson 1 – Introduction Video
Lesson 2 – The PLANT database
Lesson 2 – The PLANT database Video
Lesson 2 - Demo TSQL Script
Lesson 2 - Quiz
Lesson 3 – The UNION Operator
Lesson 3 – The UNION Operator Video
Lesson 3 - Demo TSQL Script
Lesson 3 - Quiz
Lesson 4 – UNION ALL
Lesson 4 – UNION ALL Video
Lesson 4 - Demo TSQL Script
Lesson 5 – UNION (without ALL)
Lesson 5 – UNION (without ALL) Video
Lesson 5 - Demo TSQL Script
Lesson 5 - Quiz
Lesson 6 – Review
Lesson 6 – Review Video
Module 11 – String Functions
Lesson 1 – Introduction
Lesson 1 – Introduction Video
Lesson 1 - Demo TSQL Script
Lesson 2 – The LEN() Function
Lesson 2 – The LEN() Function Video
Lesson 2 - Demo TSQL Script
Lesson 2 - Quiz
Lesson 3 – The LEFT() Function
Lesson 3 – The LEFT() Function Video
Lesson 3 - Demo TSQL Script
LESSON 3 - Quiz
Lesson 4 – The RIGHT() Function
Lesson 4 – The RIGHT() Function Video
Lesson 4 - Demo TSQL Script
Lesson 4 - Quiz
Lesson 5 – The LTRIM() Function
Lesson 5 – The LTRIM() Function Video
Lesson 5 - Demo TSQL Script
Lesson 5 - Quiz
Lesson 6 – The RTRIM() Function
Lesson 6 – The RTRIM() Function Video
Lesson 6 - Demo TSQL Script
Lesson 6 - Quiz
Lesson 7 – The REPLACE() Function
Lesson 7 – The REPLACE() Function Video
Lesson 7 - Demo TSQL Script
Lesson 7 - Quiz
Lesson 8 – The CHARINDEX() Function
Lesson 8 – The CHARINDEX() Function Video
Lesson 8 - Demo TSQL Script
Lesson 8 - Quiz
Lesson 9 – The SUBSTRING() Function
Lesson 9 – The SUBSTRING() Function Video
Lesson 9 - Demo TSQL Script
Lesson 9 - Quiz
Lesson 10 – The REVERSE() Function
Lesson 10 – The REVERSE() Function Video
Lesson 10 - Demo TSQL Script
Lesson 10 - Quiz
Lesson 11 – The CONCAT() Function
Lesson 11 – The CONCAT() Function Video
Lesson 11 - Demo TSQL Script
Lesson 11 - Quiz
Lesson 12 – The LOWER() Function
Lesson 12 – The LOWER() Function Video
Lesson 12 - Demo TSQL Script
Lesson 12 - Quiz
Lesson 13 – The UPPER() Function
Lesson 13 – The UPPER() Function Video
Lesson 13 - Demo TSQL Script
Lesson 13 - Quiz
Lesson 14 – The DIFFERENCE() Function
Lesson 14 – The DIFFERENCE() Function Video
Lesson 14- Demo TSQL Script
Lesson 14 - Quiz
Lesson 15 – The SOUNDEX() Function
Lesson 15 – The SOUNDEX() Function Video
Lesson 15 - Demo TSQL Script
Lesson 15 - Quiz
Lesson 16 – The STRING_SPLIT() Function
Lesson 16 – The STRING_SPLIT() Function Video
Lesson 16 - Demo TSQL Script
Lesson 16 - Quiz
Lesson 17 – Review Video
Lesson 17 – Review
Module 12 – Date Functions
Lesson 1 – Introduction
Lesson 1 – Introduction Video
Lesson 1 - Demo TSQL Script
Lesson 2 – The GETDATE() Function
Lesson 2 – The GETDATE() Function Video
Lesson 2 - Demo TSQL Script
Lesson 2 - Quiz
Lesson 3 – The ISDATE() Function
Lesson 3 – The ISDATE() Function Video
Lesson 3 - Demo TSQL Script
Lesson 3 - Quiz
Lesson 4 – The DATEADD() Function
Lesson 4 – The DATEADD() Function Video
Lesson 4 - Demo TSQL Script
Lesson 4 - Quiz
Lesson 5 – The DATEDIFF() Function
Lesson 5 – The DATEDIFF() Function Video
Lesson 5 - Demo TSQL Script
Lesson 5 - Quiz
Lesson 6 – The DATEPART() Function
Lesson 6 – The DATEPART() Function Video
Lesson 6 - Demo TSQL Script
Lesson 6 - Quiz
Lesson 7 – The DAY() Function
Lesson 7 – The DAY() Function Video
Lesson 7 - Demo TSQL Script
Lesson 7 - Quiz
Lesson 8 – The MONTH() Function
Lesson 8 – The MONTH() Function Video
Lesson 8 - Demo TSQL Script
Lesson 8 - Quiz
Lesson 9 – The YEAR() Function
Lesson 9 – The YEAR() Function Video
Lesson 9 - Demo TSQL Script
Lesson 9 - Quiz
Lesson 10 – The EOMONTH() Function
Lesson 10 – The EOMONTH() Function Video
Lesson 10 - Demo TSQL Script
Lesson 10 - Quiz
Lesson 11 – Review
Lesson 11 – Review Video
Module 13 – TSQL Deep Dive
Lesson 1 – Introduction
Lesson 1 – Introduction Video
Lesson 2 – Batch Concepts
Lesson 2 – Batch Concepts Video
Lesson 2 - Demo TSQL Script
Lesson 2 - Quiz
Lesson 3 – Conditional Programming with IF-ELSE Blocks
Lesson 3 – Conditional Programming with IF-ELSE Blocks Video
Lesson 3 - Demo TSQL Script
Lesson 3 - Quiz
Lesson 4 – WHILE Loops
Lesson 4 – WHILE Loops Video
Lesson 4 - Demo TSQL Script
Lesson 4 - Quiz
Lesson 5 – Using CASE Blocks
Lesson 5 – Using CASE Blocks Video
Lesson 5 - Demo TSQL Script
Lesson 5 - Quiz
Lesson 6 – Using CURSOR Blocks
Lesson 6 – Using CURSOR Blocks Video
Lesson 6 - Demo TSQL Script
Lesson 6 - Quiz
Lesson 7 – Stored Procedures
Lesson 7 – Stored Procedures Video
Lesson 7 - Demo TSQL Script
Lesson 7 - Quiz
Lesson 8 – Functions
Lesson 8 – Functions Video
Lesson 8 - Demo TSQL Script
Lesson 8 - Quiz
Lesson 9 – CTE – Common Table Expressions
Lesson 9 – CTE – Common Table Expressions Video
Lesson 9 - Demo TSQL Script
Lesson 9 - Quiz
Lesson 10 – Review
Lesson 10 – Review Video
Module 14 – Wrap Up
Module 14 – Wrap Up Video
Lesson Homework Assignments
BEGINNING TSQL - MODULE 2 - HOMEWORK PDF.pdf
BEGINNING TSQL - MODULE 3 - DML - HOMEWORK PDF.pdf
BEGINNING TSQL - MODULE 4 - DDL - HOMEWORK PDF.pdf
BEGINNING TSQL - MODULE 5 - DCL - HOMEWORK PDF.pdf
BEGINNING TSQL - MODULE 6 - JOINS - HOMEWORK PDF.pdf
BEGINNING TSQL - MODULE 7 - ORDER BY - HOMEWORK PDF.pdf
BEGINNING TSQL - MODULE 8 - GROUP BY - HOMEWORK PDF.pdf
BEGINNING TSQL - MODULE 9 - AGGREGATE FUNCTIONS - HOMEWORK PDF.pdf
BEGINNING TSQL - MODULE 10 - UNION - HOMEWORK PDF.pdf
BEGINNING TSQL - MODULE 11 - STRING FUNCTIONS - HOMEWORK PDF.pdf
BEGINNING TSQL - MODULE 12 - DATE FUNCTIONS - HOMEWORK PDF.pdf
BEGINNING TSQL - MODULE 13 - TSQL DEEP DIVE - HOMEWORK PDF.pdf
Lesson Homework Templates
MODULE 02 - SSMS HOMEWORK TEMPLATE_FINAL.sql
MODULE 03 - DML HOMEWORK TEMPLATE_FINAL.sql
MODULE 04 - DDL HOMEWORK TEMPLATE_FINAL.sql
MODULE 05 - DCL HOMEWORK TEMPLATE_FINAL.sql
MODULE 06 - JOINS HOMEWORK TEMPLATE_FINAL.sql
MODULE 07 - ORDER BY HOMEWORK TEMPLATE_FINAL.sql
MODULE 08 - GROUP BY HOMEWORK TEMPLATE_FINAL.sql
MODULE 09 - AGGREGATE HOMEWORK TEMPLATE_FINAL.sql
MODULE 10 - UNION HOMEWORK TEMPLATE - FINAL.sql
MODULE 11 - STRING HOMEWORK TEMPLATE - FINAL.sql
MODULE 12 - DATE HOMEWORK SOLUTION TEMPLATE - FINAL.sql
MODULE 13 - TSQL DEEP DIVEHOMEWORK TEMPLATE - FINAL.sql
Lesson Homework Solutions
MODULE 02 - SSMS HOMEWORK SOLUTIONS.sql
MODULE 03 -DML HOMEWORK SOLUTIONS.sql
MODULE 04 -DDL HOMEWORK SOLUTIONS.sql
MODULE 05 -DCL HOMEWORK SOLUTIONS.sql
MODULE 06 -JOINS HOMEWORK SOLUTIONS.sql
MODULE 07 - ORDER BY HOMEWORK SOLUTIONS.sql
MODULE 08 - GROUP BY HOMEWORK SOLUTIONS.sql
MODULE 09 - AGGREGATE HOMEWORK SOLUTIONS.sql
MODULE 10 - UNION HOMEWORK SOLUTIONS.sql
MODULE 12 - DATE HOMEWORK SOLUTIONS.sql
MODULE 11 - STRING HOMEWORK SOLUTIONS.sql
MODULE 13 - TSQL DEEP DIVE HOMEWORK SOLUTIONS.sql
Create Databases DDL
CREATE BANK DATABASE.sql
CREATE CUSTOMER DATABASE.sql
CREATE CUSTOMER_MASTER DATABASE.sql
CREATE CUSTOMER_SALES DATABASE.sql
CREATE HOBBY_SHOP DATABASE.sql
CREATE HUMAN_RESOURCES DATABASE.sql
CREATE INVENTORY DATABASE.sql
CREATE LOGISTICS DATABASE.sql
CREATE ORGANIZATION DATABASE.sql
CREATE PLANT 10 HW DATABASE.sql
CREATE PLANT DATABASE
CREATE PLANT M10 DATABASE.sql
CREATE SALES DATABASE.sql
CREATE SALES DW DATABASE.sql
Create Database Tables
CREATE BANK DATABASE TABLES.sql
CREATE CUSTOMER DATABASE TABLES.sql
CREATE CUSTOMER SALES DATABASE TABLES.sql
CREATE HOBBY SHOP DATABASE TABLES.sql
CREATE HUMAN RESOURCES SALES DATABASE TABLES.sql
CREATE INVENTORY DATABASE TABLES.sql
CREATE ORGANIZATION SALES DATABASE TABLES.sql
CREATE PLANT DATABASE TABLES.sql
CREATE PLANT M10 DATABASE TABLES.sql
CREATE PLANT M10 HW DATABASE TABLES.sql
CREATE SALES DW DATABASE TABLES.sql
CREATE SALES DATABASE TABLES.sql
Database Tables BCP files
BANK.zip
CUSTOMER.zip
HOBBY_SHOP.zip
CUSTOMER_SALES.zip
HUMAN_RESOURCES.zip
INVENTORY.zip
PLANT.zip
ORGANIZATION.zip
PLANT_M10.zip
PLANT_10_HW.zip
SALES.zip
SALES_DW.zip
BEGINNING_TSQL_DATABASES
BUG Fixes
BUG 01 - Existing databases on the students server cause load script to fail - 11/3/2025 - RESOLVED
Lesson unavailable
Please
login to your account
or
buy the course
.