Formation SQL Server - Fundamentals of Transact-SQL Language

Module 1: Introduction to Microsoft SQL Server

Understanding the basic architecture of SQL Server

Overview of SQL Server editions and versions

Getting started with SQL Server Management Studio

Module 2: Introduction to T-SQL Queries

Introduction to Transact-SQL (T-SQL)

Understanding sets in T-SQL

Exploring logical predicates

Understanding the logical order of operations in SELECT statements

Module 3: Writing SELECT Queries

Writing simple SELECT statements

Eliminating duplicates with DISTINCT

Using column and table aliases

Writing simple CASE expressions

Module 4: Writing Queries with Multiple Tables

Understanding joins in SQL

Writing queries with inner joins

Writing queries with outer joins

Writing queries with cross joins and self-joins

Module 5: Sorting and Filtering Data

Sorting data using ORDER BY

Filtering data with predicates

Using the TOP and OFFSET-FETCH options for pagination

Handling unknown values

Module 6: Working with SQL Server Data Types

Overview of SQL Server data types

Working with string data types

Working with date and time data types

Module 7: Using DML to Modify Data

Inserting data into tables

Modifying and deleting data from tables

Module 8: Utilizing Built-In Functions

Writing queries with built-in functions

Using conversion functions

Using logical functions

Working with NULL-related functions

Module 9: Grouping and Aggregating Data

Using aggregate functions

Using the GROUP BY clause

Filtering groups with the HAVING clause

Module 10: Using Subqueries

Writing subqueries

Writing correlated subqueries

Using the EXISTS predicate with subqueries