Lesson 5 – Group By Clause with CUBE

Lesson 5 – Group By Clause with CUBE

Preview unavailable

You must log in or sign up to view this lesson.

LoginSign up

Beginning SQL Server TSQL Programming

Buy nowLearn 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
  • ORGANIZATION.zip
  • PLANT.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