Querying Data with Transact-SQL

Introduction to Microsoft SQL Server

• The Basic Architecture of SQL Server

• SQL Server Editions and Versions

• Getting Started with SQL Server Management Studio

Introduction to T-SQL Querying

• Introducing T-SQL

• Understanding Sets

• Understanding Predicate Logic

• Understanding the Logical Order of Operations in SELECT statements

Writing SELECT Queries

• Writing Simple SELECT Statements

• Eliminating Duplicates with DISTINCT

• Using Column and Table Aliases

• Writing Simple CASE Expressions

Querying Multiple Tables

• Understanding Joins

• Querying with Inner Joins

• Querying with Outer Joins

• Querying with Cross Joins and Self Joins

Sorting and Filtering Data

• Sorting Data

• Filtering Data with Predicates

• Filtering Data with TOP and OFFSET-FETCH

• Working with Unknown Values

Working with SQL Server Data Types

• Introducing SQL Server Data Types

• Working with Character Data

• Working with Date and Time Data

Using DML to Modify Data

• Inserting Data

• Modifying and Deleting Data

Using Built-In Functions

• Writing Queries with Built-In Functions

• Using Conversion Functions

• Using Logical Functions

• Using Functions to Work with NULL

Grouping and Aggregating Data

• Using Aggregate Functions

• Using the GROUP BY Clause

• Filtering Groups with HAVING

Using Subqueries

• Writing Self-Contained Subqueries

• Writing Correlated Subqueries

• Using the EXISTS Predicate with Subqueries

Using Table Expressions

• Using Views

• Using Inline Table-Valued Functions

• Using Derived Tables

• Using Common Table Expressions

Using Set Operators

• Writing Queries with the UNION operator

• Using EXCEPT and INTERSECT

• Using APPLY

Using Windows Ranking, Offset, and Aggregate Functions

• Creating Windows with OVER

• Exploring Window Functions

Pivoting and Grouping Sets

• Writing Queries with PIVOT and UNPIVOT

• Working with Grouping Sets

Implementing Transactions

• Transactions and the database engines

• Controlling transactions

Integrating Generative AI with MS SQL

• Introduction to Generative AI

• Importance of AI in the SQL Domain

• Enhance and simplify SQL query

• Integrating Generative AI with MS SQL for Data Analytics