Microsoft SQL Server - Introduction

· SQL Server Architecture

· SQL Server Editions and Versions

· SQL Server Management Studio

· Transact-SQL

· Objects- Tables, Stored Procedures, Function, Triggers etc.

· Logical Order of Operations in SELECT Statements

Write Simple SELECT Statements

· Eliminate Duplicates with DISTINCT

· Column and Table Aliases

· Write Simple CASE Expressions

· Joins

· Query with Inner Joins and Outer Joins

· Query with Cross Joins and Self Joins

Working with Data

· Sort Data

· Filter Data with a WHERE Clause

· Filter with the TOP and OFFSET-FETCH Options

· Work with Unknown and Missing Values

· Write Queries with Built-In Functions

· Conversion Functions

· Logical Functions

· Use Functions to Work with NULL

Sub-Queries and Aggregation

· Write Self-Contained Sub-queries

· Write Correlated Sub-queries

· Use the EXISTS Predicate with Sub-queries

· Use Aggregate Functions

· Use the GROUP BY Clause

· Filter Groups with HAVING

Query Data with Stored Procedures

· Query Data with Stored Procedures

· Pass Parameters to Store Procedures

· Create Simple Stored Procedures

· Work with Dynamic SQL

· Use TRY/CATCH Blocks

· Work with Error Information

· Control transactions with BEGIN, COMMIT and ROLLBACK

SQL Performance Tools

· Resource Governor

· Activity Monitor

· Live Query Statistics

· Monitoring SQL with Transact-SQL

· DMOs and Performance Tuning

· Tuning Process

· Performance Monitor Tool

· SQL Query Processing Steps

· Understanding Execution Plans

· Set Statistics Time and Set Statistics IO