This training is jointly organized by  BITM & New Horizons Software Development Center. Training will be held in  New Horizons Software Development Center.

Course Outline:

PART ONE:

Introduction to Microsoft SQL Server 2016

Introduction to T-SQL Querying

Writing SELECT Queries

Querying Multiple Tables 

Sorting and Filtering Data

Working with SQL Server 2016 Data Types

Using DML to Modify Data

Using Built-In Functions

Grouping and Aggregating Data

Using Subqueries

Using Table Expressions

Using Set Operators

Using Windows Ranking, Offset, and Aggregate Functions

Pivoting and Grouping Sets

Executing Stored Procedures

Programming with T-SQL

Implementing Error Handling

Implementing Transactions

PART TWO:

Introduction to Database Development

Designing and Implementing Tables

Advanced Table Designs

Ensuring Data Integrity through Constraints

Introduction to Indexes

Designing Optimized Index Strategies

Columnstore Indexes

Designing and Implementing Views

Designing and Implementing Stored Procedures

Designing and Implementing User-Defined Functions

Responding to Data Manipulation via Triggers

Using In-Memory Tables

Implementing Managed Code in SQL Server

Storing and Querying XML Data in SQL Server

Storing and Querying Spatial Data in SQL Server

Storing and Querying BLOBs and Text Documents in SQL Server

SQL Server Concurrency

Performance and Monitoring

Curriculum