Training agenda
  1.  Introduction to Microsoft SQL Server

    • The Basic Architecture of SQL Server
    • SQL Server Editions and Versions
    • Getting Started with SQL Server Management Studio
  2.  Introduction to T-SQL Querying

    • Introducing T-SQL
    • Understanding Sets
    • Understanding Predicate Logic
    • Understanding the Logical Order of Operations in SELECT statements
  3.  Writing SELECT Queries

    • Writing Simple SELECT Statements
    • Eliminating Duplicates with DISTINCT
    • Using Column and Table Aliases
    • Writing Simple CASE Expressions
  4.  Querying Multiple Tables

    • Understanding Joins
    • Querying with Inner Joins
    • Querying with Outer Joins
    • Querying with Cross Joins and Self Joins
  5. Sorting and Filtering Data

    • Sorting Data
    • Filtering Data with Predicates
    • Filtering Data with TOP and OFFSET-FETCH
    • Working with Unknown Values
  6.  Working with SQL Server Data Types

    • Introducing SQL Server Data Types
    • Working with Character Data
    • Working with Date and Time Data
  7.  Using DML to Modify Data

    • Adding Data to Tables
    • Modifying and Removing Data
    • Generating automatic column values
  8.  Using Built-In Functions

    • Writing Queries with Built-In Functions
    • Using Conversion Functions
    • Using Logical Functions
    • Using Functions to Work with NULL
  9.  Grouping and Aggregating Data

    • Using Aggregate Functions
    • Using the GROUP BY Clause
    • Filtering Groups with HAVING
  10.  Using Subqueries

    • Writing Self-Contained Subqueries
    • Writing Correlated Subqueries
    • Using the EXISTS Predicate with Subqueries
  11. Using Table Expressions

    • Using Views
    • Using Inline Table-Valued Functions
    • Using Derived Tables
    • Using Common Table Expressions
  12. Using Set Operators

    • Writing Queries with the UNION operator
    • Using EXCEPT and INTERSECT
    • Using APPLY
  13.  Using Windows Ranking, Offset, and Aggregate Functions

    • Creating Windows with OVER
    • Exploring Window Functions
  14.  Pivoting and Grouping Sets

    • Writing Queries with PIVOT and UNPIVOT
    • Working with Grouping Sets
  15.  Executing Stored Procedures

    • Querying Data with Stored Procedures
    • Passing Parameters to Stored procedures
    • Creating Simple Stored Procedures
    • Working with Dynamic SQL
  16. Programming with T-SQL

    • T-SQL Programming Elements
    • Controlling Program Flow
  17. Implementing Error Handling

    • Implementing T-SQL error handling
    • Implementing structured exception handling
  18.  Implementing Transactions

    • Transactions and the database engines
    • Controlling transactions