Lesson 1 - Introduction Video
Lesson 1 - Introduction 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 free introductory lesson introduces the topics covered in the remaining module lessons. If you are auditing the course, view this lesson to get an idea of the content.
This lesson introduces the topics that will be discussed in the module lessons.
This lesson will cover the fundamental aspects of the data manipulation language used to create TSQL queries. This is a sub-language of TSQL and is affectionately called DML! It is taught by our esteemed virtual professor, Professor Grumpy, and his assistant, Virtual Assistant Professor Nigel. In this lesson, you will embark on an exciting journey, learning everything you need about programming with TSQL, from its basic syntax to its advanced features, such as using aggregate functions, date functions, case statements, and much more. Whether you're a beginner or an experienced SQL user, this lesson will equip you with the skills to create powerful queries and reports for your business users and managers. So, let's set sail on this adventure to master one of the most powerful tools in the SQL Server ecosystem!