Microsoft SQL Server Developer Training

• Getting Started with SQL Server Management Studio (SSMS)
• Installing SQL Server Sample Databases

• Primary Key and Foreign Key; RDBMS Basics 1NF, 2NF & 3NF Normal Forms
• Introducing T-SQL

• Type Database Diagram Design in Object Explorer
• Double, Float, Decimal, FileStream and Geographical CREATE TABLE by Script & Using Object Explorer Primary Key and Foreign Key Constraints and
• New; DATE, TIME, Datetime, DATETIMEOFFSET & DATETIME2, Char, Varchar, Int, Tinyint, Small int, BigInt, Money
• Understanding Logical Data Modeling, Working with Table Column Data Types

• Basic SQL SELECT and SELECT INTO Statements The GROUP BY Clause & Aggregate Functions Sorting SELECT Query Results with ORDER BY TOP, ROW_NUMBER, RANK, DENSE_RANK and NTILE
• Writing Simple SELECT Statements Eliminating Duplicates with DISTINCT Using Column and Table Aliases Writing Simple CASE Expressions

• 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

• 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

• Debugging with the Transact-SQL Debugger
• Factors in Query Performance
• Displaying Query Performance Data
• Optimizing with Database Engine Tuning Advisor