Microsoft SQL Server Developer Training

Understanding Joins Querying with Inner Joins

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

Querying with Cross Joins and Self Joins

Sorting Data ASC, DESC

Filtering Data with a WHERE Clause

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

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

INSERT INTO Statement with VALUES Clause

Understanding INSERT and SELECT Subquery INSERT and EXECUTE Statement

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

Writing Self-Contained Subqueries

Writing Correlated Subqueries

Using the EXISTS Predicate with Subqueries

Using Derived Tables

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

Using Views

Using Inline Table-Valued Functions

Writing Queries with the UNION Operator Stacking results with UNION ALL

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

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

Removing constraints with ALTER TABLE

DML (Data Manipulation Language)

DDL ( Data Defination Language)

DCL (Data Control Language)

TCL (Transaction Control Language)

Creating Windows with OVER

Exploring Window Functions

Writing Queries with PIVOT and UNPIVOT Working with Grouping Sets

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

DML - Data Manipulation Language Triggers

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

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

TRANSACT-SQL, Batch, and Scripts

BEGIN, COMMIT, ROLLBACK TRANSACTION

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

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

Optimizing with Database Engine Tuning Advisor

Debugging with the Transact-SQL Debugger

Factors in Query Performance

Displaying Query Performance Data