Microsoft SQL Server Developer Training

Filtering with the TOP and OFFSET-FETCH Options Working with Unknown and Missing Values

Filtering Data with a WHERE Clause

Sorting Data ASC, DESC

Querying with Outer Joins(Left, Right and Full Joins)

Querying with Cross Joins and Self Joins

Understanding Joins Querying with Inner Joins

Data Removal with the DELETE Statement Data Modification with the UPDATE Statement Working with the MERGE Statement Synchronizing Two Tables with MERGE

Understanding INSERT and SELECT Subquery INSERT and EXECUTE Statement

INSERT INTO Statement with VALUES Clause

Using Aggregate Functions Using the GROUP BY Clause Filtering Groups with HAVING

Using the EXISTS Predicate with Subqueries

Writing Correlated Subqueries

Writing Self-Contained Subqueries

Using Inline Table-Valued Functions

Using Views

Using Common Table Expressions (CTE) Deleting Duplicate Rows with CTE

Using Derived Tables

Using EXCEPT to find nonmatching rows Identifying matching rows with INTERSECT Using APPLY

Writing Queries with the UNION Operator Stacking results with UNION ALL

Removing constraints with ALTER TABLE

Guaranteeing uniqueness with primary key constraints Enforcing integrity with foreign key constraints Imposing business rules with check constraints Enabling and disabling constraints

TCL (Transaction Control Language)

DCL (Data Control Language)

DDL ( Data Defination Language)

DML (Data Manipulation Language)

Exploring Window Functions

Creating Windows with OVER

Writing Queries with PIVOT and UNPIVOT Working with Grouping Sets

Designing & Creating Views - Modifying Data Table-Valued, Scalar-Valued & Inline Functions Temporary Tables, Table Variables & tempdb Spatial Data Types: Geography & Geometry Applying Manual Debugging Tech niques

Trigger Examples with DELETED & INSERTED Tables Discovering INSTEAD OF Triggers & AFTER Triggers DDL - Data Definition Language Triggers

DML - Data Manipulation Language Triggers

Stored Procedure Design and Programming Passing Parameters to Stored Procedures Creating Simple Stored Procedures

Programing Statements in Transact-SQL User Defined and System Stored Procedures INTERSECT and EXCEPT Set Operators FILESTREAM Data and SPARSE Columns

BEGIN, COMMIT, ROLLBACK TRANSACTION

Using TRY…CATCH Blocks for Exception HandlingLocks, Isolation Levels and Deadlocks Snapshot Isolation for OLTP Concurrency

TRANSACT-SQL, Batch, and Scripts

Debugging with the Transact-SQL Debugger

Factors in Query Performance

Displaying Query Performance Data

Optimizing with Database Engine Tuning Advisor