Module 14 – Wrap Up Video
Module 14 – Wrap Up Video
Beginning SQL Server TSQL Programming
Module 1 - Introduction
Module 1 - Introduction
Module 2 – Navigating SSMS
Module 2 – Navigating SSMS
Module 3 – DML, the Data Manipulation Language
Module 3 – DML, the Data Manipulation Language
Module 4 – DDL, the Data Declaration Language
Module 4 – DDL, the Data Declaration Language
Module 5 – DCL, the Data Control Language
Module 5 – DCL, the Data Control Language
Module 6 – Using JOINS in Queries
Module 6 – Using JOINS in Queries
Module 7 – The ORDER BY clause
Module 7 – The ORDER BY clause
Module 8 – The GROUP BY clause
Module 8 – The GROUP BY clause
Module 9 – Aggregate Functions
Module 9 – Aggregate Functions
Module 10 – UNION and UNION ALL
Module 10 – UNION and UNION ALL
Module 11 – String Functions
Module 11 – String Functions
Module 12 – Date Functions
Module 12 – Date Functions
Module 13 – TSQL Deep Dive
Module 13 – TSQL Deep Dive
Module 14 – Wrap Up
Module 14 – Wrap Up
Lesson Homework Assignments
Lesson Homework Assignments
Lesson Homework Templates
Lesson Homework Templates
Lesson Homework Solutions
Lesson Homework Solutions
Create Databases DDL
Create Databases DDL
Create Database Tables
Create Database Tables
This module serves as a summary of the course. We embarked on a journey through SQL Server programming, including ten lessons, examples, demos, and homework. This course had everything from mastering the basics of SQL Server Management Studio to delving deep into T-SQL programming with data manipulation, data declaration, and data control language. We explored essential topics such as table joins, aggregate functions, UNION clause, string manipulation, date manipulation, batch processing, and advanced techniques like conditional logic, loops, stored procedures, functions, and common table expressions (CTEs). Each lesson was packed with hands-on examples, interactive demos, and practical exercises to reinforce your learning. Whether new to SQL or looking to sharpen your skills, this course, when completed, will equip you with the knowledge and tools to excel in SQL Server programming.