In this course, we will cover SQL Server implementation and programming essentials, including the fundamentals of Data Manipulation Language (DML), Data Declaration Language (DDL), and Data Control Language (DCL).

This free introductory module will show you what you can expect to learn and what each module contains.

By taking this course, you'll gain a solid foundation in the basics of database management, be able to navigate SQL Server Management Studio (SSMS), learn to execute queries, and create and manage databases, tables, views, and more.

Please check out this course to see what you can learn to become an expert SQL Server developer. Together, we'll unlock the power of SQL Server!

Each lesson includes several examples, demos, and a homework assignment to reinforce your learning. All example code is available at the end of the course outline so you can practice the concepts learned.

Welcome to module 2, SSMS.

This module discusses SSMS and the skills required to master SSMS.

By the end of this module, you will be able to understand and navigate the SSMS menu bar, execute queries, create databases, manage security credentials and user roles, and much more.

If you are unfamiliar with SQL Server Management Studio, we'll guide you through the essential tools in SSMS to help you get started.

As is the case for all the modules in this course, each lesson includes several examples, demos, and a homework assignment to reinforce your learning. All example code is available at the end of the course outline so you can practice the concepts learned.

In this module, you'll learn how to write efficient queries using the DML sub-language of TSQL. Hands-on exercises and real-world examples are included.

You will also learn to insert, modify, and delete data from database tables. After all, you need data to learn how to write queries!

As is the case for all the modules in this course, each lesson includes several examples, demos, and a homework assignment to reinforce your learning. All example code is available at the end of the course outline so you can practice the concepts learned.

Welcome to module 4, DDL. In this module, you'll learn how to create and manage database objects, including tables, indexes, views, and many more programming components.

We'll cover the essentials of DDL syntax, best practices for designing database schemas, and basic strategies for optimizing performance. As with the other modules, hands-on tutorials and practical examples will give you the skills to build and maintain databases using T-SQL confidently.

Join us and take your first steps toward becoming a proficient SQL Server developer. You may also learn some basic DBA skills.

As usual, each module lesson includes several examples and demos, plus a homework assignment to reinforce learning.

All example code is available at the end of the course outline.

Welcome to module 5, DCL.

In this module, we will examine security management within SQL Server, mastering the tools and techniques for controlling access to your database environment.

From creating and managing server logins, database logins, and passwords to assigning database roles and permissions, you'll learn how to protect your data and ensure regulatory compliance.

You'll gain hands-on experience securing SQL Server using DCL T-SQL commands through practical tutorials and real-world scenarios.

As usual, each module lesson includes several examples and demos, plus a homework assignment to reinforce learning.

All example code is available at the end of the course outline.

Welcome to module 6, JOINS.

In this module, you'll learn how to apply a series of operators to establish table relations.

We'll explore all the types of joins available in T-SQL, including inner joins, outer joins (left, right, and full outer, cross joins, and self-joins. Through comprehensive tutorials and hands-on exercises, you'll master the art of combining data from multiple tables to extract valuable insights.

Whether you are new to TSQL or looking to strengthen - your technical skills, this module will enhance the knowledge you need to write efficient and powerful T-SQL queries.

As usual, each module lesson includes several examples and demos, plus a homework assignment to reinforce learning.

All example code is available at the end of the course outline.

Welcome to module 7, The ORDER BY clause.

In this module, you'll learn how to use the ORDER BY clause to sort the output of your queries in ascending or descending order and specify which row to start sorting the data and how many rows to include.

Through examples and hands-on demonstrations, we'll cover various scenarios and best practices for effectively leveraging the ORDER BY clause by learning how to effectively use it in your reports, queries, and scripts.

Each lesson includes several examples and demos, plus a homework assignment to reinforce your learning.

All example code is available at the end of the course outline.

Welcome to module 8.

In this module, we explore how to apply the GROUP BY clause, a fundamental feature of SQL queries that groups rows based on specified columns. This clause is also used for queries that include one or more aggregate functions like sum() or average (). You will learn about these in the next module.

You'll learn how to use GROUP BY to aggregate data and perform operations like counting, summing, averaging, and more across groups.

We will demonstrate different use cases and scenarios that require the GROUP BY clause through a series of illustrative examples and interactive demos.

As usual, each lesson includes several examples and demos, plus a homework assignment to reinforce your learning.

All example code is available at the end of the course outline.

Welcome to module 9, aggregate functions.

This module explores the built-in aggregate functions for summarizing and analyzing data in SQL queries.

You'll learn how to use aggregate functions such as SUM, AVG, COUNT, MIN, and MAX to perform calculations on groups of rows, extract valuable nuggets, and generate quality reports that your users will love.

Through hands-on examples and interactive demos, we'll explore various scenarios where aggregate functions lead, from simple calculations to complex data analysis tasks.

Each lesson includes a homework assignment to reinforce your learning, and you'll have access to all example code in the Grumpy Old IT Guy GitHub repository. Join us to master aggregate functions and level up your SQL skills!

We will demonstrate different use cases and scenarios requiring aggregate functions through illustrative examples and interactive demos.

As usual, each lesson includes several examples and demos, plus a homework assignment to reinforce your learning.

All example code is available at the end of the course outline.

Welcome to module 10, the UNION clause, an essential operator for combining the results of multiple SELECT queries into a single result set.

You'll learn to use UNION to merge data from different tables or queries, remove duplicates, and manipulate complex data.

Through hands-on examples and interactive demos, we'll explore scenarios where the UNION clause solves critical programming requirements, from integrating data sources to generating comprehensive reports.

As usual, each lesson includes several examples and demos, plus a homework assignment to reinforce your learning.

Welcome to module 11, string functions.

We explore potent functions like CONCAT, SUBSTRING, CHARINDEX, and more, allowing you to manipulate and transform strings quickly. Through a series of hands-on examples and interactive demos, you'll learn how to extract substrings, concatenate strings, search for specific characters, and perform various string operations to meet your query requirements.

As usual, each lesson includes several examples and demos, plus a homework assignment to reinforce your learning.

Welcome to module 12, date functions.

In this module, we explore essential functions like DATEADD, DATEDIFF, DATEPART, and more, which enable you to manipulate and analyze dates quickly.

Through a series of hands-on examples and interactive demos, you'll learn to calculate date differences, extract date parts, perform date arithmetic, and handle various date-related tasks efficiently.

As usual, each lesson includes several examples and demos, plus a homework assignment to reinforce your learning.

Welcome to module 13, TSQL deep dive!

This module explores batch processing, conditional logic, iterative loops, and advanced query techniques, such as case statements, cursors, stored procedures, functions, and common table expressions (CTEs).

You'll learn how to write efficient T-SQL code to manipulate data, implement business logic, and solve complex business requirements through short lessons, hands-on examples, and demos.

Each lesson includes practical exercises to reinforce your understanding.

As usual, each lesson includes several examples and demos, plus a homework assignment to reinforce your learning.

This module serves as a summary of the course. We embarked on a journey through SQL Server programming, including twelve 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,

We even covered the use of common table expressions (CTEs).

Each lesson included hands-on examples, demos, and practical exercises to reinforce your learning. Whether you are new to SQL or looking to sharpen your good coding standards skills, this course, when completed, will equip you with the skills and tools to master SQL Server TSQL programming.

For your convenience this section contains pdf versions of the homework clips for each lesson.

Here are the templates to get you started with a possible solution to the homework. You can try to solve the homework without the templates, but if you need some help starting, you can use these. The critical goal is to learn the material, so if you need help or cheat, use these templates. A good approach is to load the template in one query window and load the solution to the homework assignment in another query pane so if you get stuck; you can check out the solution.

In this section you will find the SQL Server TSQL files that contain the homework solutions for each module lesson. Compare your results with these and see if you can improve on my solutions.

The files in this section you enable you to create the databases used in the course. Make sure you change any references to file folders to match the file and drive setup on your particular machine. Suggested file folder set ups are provided for setting up the PRIMARY, DATA and LOG folders for each database.

This section contains the files required to create the tables, views, stored procedures and functions for each database.

This section contains all the zipped data files for each of the tables in each database. It also contains the BEGINNING_TSQL_DATABASES zip file, which can be used to set up a complete environment. The individual database zip files are available in case you want to refresh a single database.

Here you will see bug fixes to any lesson code or the scripts used to create the databases, tables and to load them.

In this course, we will cover SQL Server implementation and programming essentials, including the fundamentals of Data Manipulation Language (DML), Data Declaration Language (DDL), and Data Control Language (DCL).

This free introductory module will show you what you can expect to learn and what each module contains.

By taking this course, you'll gain a solid foundation in the basics of database management, be able to navigate SQL Server Management Studio (SSMS), learn to execute queries, and create and manage databases, tables, views, and more.

Please check out this course to see what you can learn to become an expert SQL Server developer. Together, we'll unlock the power of SQL Server!

Each lesson includes several examples, demos, and a homework assignment to reinforce your learning. All example code is available at the end of the course outline so you can practice the concepts learned.

Welcome to module 2, SSMS.

This module discusses SSMS and the skills required to master SSMS.

By the end of this module, you will be able to understand and navigate the SSMS menu bar, execute queries, create databases, manage security credentials and user roles, and much more.

If you are unfamiliar with SQL Server Management Studio, we'll guide you through the essential tools in SSMS to help you get started.

As is the case for all the modules in this course, each lesson includes several examples, demos, and a homework assignment to reinforce your learning. All example code is available at the end of the course outline so you can practice the concepts learned.

In this module, you'll learn how to write efficient queries using the DML sub-language of TSQL. Hands-on exercises and real-world examples are included.

You will also learn to insert, modify, and delete data from database tables. After all, you need data to learn how to write queries!

As is the case for all the modules in this course, each lesson includes several examples, demos, and a homework assignment to reinforce your learning. All example code is available at the end of the course outline so you can practice the concepts learned.

Welcome to module 4, DDL. In this module, you'll learn how to create and manage database objects, including tables, indexes, views, and many more programming components.

We'll cover the essentials of DDL syntax, best practices for designing database schemas, and basic strategies for optimizing performance. As with the other modules, hands-on tutorials and practical examples will give you the skills to build and maintain databases using T-SQL confidently.

Join us and take your first steps toward becoming a proficient SQL Server developer. You may also learn some basic DBA skills.

As usual, each module lesson includes several examples and demos, plus a homework assignment to reinforce learning.

All example code is available at the end of the course outline.

Welcome to module 5, DCL.

In this module, we will examine security management within SQL Server, mastering the tools and techniques for controlling access to your database environment.

From creating and managing server logins, database logins, and passwords to assigning database roles and permissions, you'll learn how to protect your data and ensure regulatory compliance.

You'll gain hands-on experience securing SQL Server using DCL T-SQL commands through practical tutorials and real-world scenarios.

As usual, each module lesson includes several examples and demos, plus a homework assignment to reinforce learning.

All example code is available at the end of the course outline.

Welcome to module 6, JOINS.

In this module, you'll learn how to apply a series of operators to establish table relations.

We'll explore all the types of joins available in T-SQL, including inner joins, outer joins (left, right, and full outer, cross joins, and self-joins. Through comprehensive tutorials and hands-on exercises, you'll master the art of combining data from multiple tables to extract valuable insights.

Whether you are new to TSQL or looking to strengthen - your technical skills, this module will enhance the knowledge you need to write efficient and powerful T-SQL queries.

As usual, each module lesson includes several examples and demos, plus a homework assignment to reinforce learning.

All example code is available at the end of the course outline.

Welcome to module 7, The ORDER BY clause.

In this module, you'll learn how to use the ORDER BY clause to sort the output of your queries in ascending or descending order and specify which row to start sorting the data and how many rows to include.

Through examples and hands-on demonstrations, we'll cover various scenarios and best practices for effectively leveraging the ORDER BY clause by learning how to effectively use it in your reports, queries, and scripts.

Each lesson includes several examples and demos, plus a homework assignment to reinforce your learning.

All example code is available at the end of the course outline.

Welcome to module 8.

In this module, we explore how to apply the GROUP BY clause, a fundamental feature of SQL queries that groups rows based on specified columns. This clause is also used for queries that include one or more aggregate functions like sum() or average (). You will learn about these in the next module.

You'll learn how to use GROUP BY to aggregate data and perform operations like counting, summing, averaging, and more across groups.

We will demonstrate different use cases and scenarios that require the GROUP BY clause through a series of illustrative examples and interactive demos.

As usual, each lesson includes several examples and demos, plus a homework assignment to reinforce your learning.

All example code is available at the end of the course outline.

Welcome to module 9, aggregate functions.

This module explores the built-in aggregate functions for summarizing and analyzing data in SQL queries.

You'll learn how to use aggregate functions such as SUM, AVG, COUNT, MIN, and MAX to perform calculations on groups of rows, extract valuable nuggets, and generate quality reports that your users will love.

Through hands-on examples and interactive demos, we'll explore various scenarios where aggregate functions lead, from simple calculations to complex data analysis tasks.

Each lesson includes a homework assignment to reinforce your learning, and you'll have access to all example code in the Grumpy Old IT Guy GitHub repository. Join us to master aggregate functions and level up your SQL skills!

We will demonstrate different use cases and scenarios requiring aggregate functions through illustrative examples and interactive demos.

As usual, each lesson includes several examples and demos, plus a homework assignment to reinforce your learning.

All example code is available at the end of the course outline.

Welcome to module 10, the UNION clause, an essential operator for combining the results of multiple SELECT queries into a single result set.

You'll learn to use UNION to merge data from different tables or queries, remove duplicates, and manipulate complex data.

Through hands-on examples and interactive demos, we'll explore scenarios where the UNION clause solves critical programming requirements, from integrating data sources to generating comprehensive reports.

As usual, each lesson includes several examples and demos, plus a homework assignment to reinforce your learning.

Welcome to module 11, string functions.

We explore potent functions like CONCAT, SUBSTRING, CHARINDEX, and more, allowing you to manipulate and transform strings quickly. Through a series of hands-on examples and interactive demos, you'll learn how to extract substrings, concatenate strings, search for specific characters, and perform various string operations to meet your query requirements.

As usual, each lesson includes several examples and demos, plus a homework assignment to reinforce your learning.

Welcome to module 12, date functions.

In this module, we explore essential functions like DATEADD, DATEDIFF, DATEPART, and more, which enable you to manipulate and analyze dates quickly.

Through a series of hands-on examples and interactive demos, you'll learn to calculate date differences, extract date parts, perform date arithmetic, and handle various date-related tasks efficiently.

As usual, each lesson includes several examples and demos, plus a homework assignment to reinforce your learning.

Welcome to module 13, TSQL deep dive!

This module explores batch processing, conditional logic, iterative loops, and advanced query techniques, such as case statements, cursors, stored procedures, functions, and common table expressions (CTEs).

You'll learn how to write efficient T-SQL code to manipulate data, implement business logic, and solve complex business requirements through short lessons, hands-on examples, and demos.

Each lesson includes practical exercises to reinforce your understanding.

As usual, each lesson includes several examples and demos, plus a homework assignment to reinforce your learning.

This module serves as a summary of the course. We embarked on a journey through SQL Server programming, including twelve 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,

We even covered the use of common table expressions (CTEs).

Each lesson included hands-on examples, demos, and practical exercises to reinforce your learning. Whether you are new to SQL or looking to sharpen your good coding standards skills, this course, when completed, will equip you with the skills and tools to master SQL Server TSQL programming.

For your convenience this section contains pdf versions of the homework clips for each lesson.

Here are the templates to get you started with a possible solution to the homework. You can try to solve the homework without the templates, but if you need some help starting, you can use these. The critical goal is to learn the material, so if you need help or cheat, use these templates. A good approach is to load the template in one query window and load the solution to the homework assignment in another query pane so if you get stuck; you can check out the solution.

In this section you will find the SQL Server TSQL files that contain the homework solutions for each module lesson. Compare your results with these and see if you can improve on my solutions.

The files in this section you enable you to create the databases used in the course. Make sure you change any references to file folders to match the file and drive setup on your particular machine. Suggested file folder set ups are provided for setting up the PRIMARY, DATA and LOG folders for each database.

This section contains the files required to create the tables, views, stored procedures and functions for each database.

This section contains all the zipped data files for each of the tables in each database. It also contains the BEGINNING_TSQL_DATABASES zip file, which can be used to set up a complete environment. The individual database zip files are available in case you want to refresh a single database.

Here you will see bug fixes to any lesson code or the scripts used to create the databases, tables and to load them.