Microsoft SQL Server 2016 with Exam Preparation

Microsoft SQL Server 2016 with Exam Preparation

SQL 2016 Database Development certification validates your skills in building and implementing databases across organizations, and will qualify you for a position as a database developer.

course at a glance

  • Date : 2 Aug - 4 Oct 2019
  • No. of Classes/ Sessions : 20
  • Total Hours : 60
  • Last Date of Registration : 2 Aug 2019
  • Class Schedule :
    • Friday - 4.00 PM - 6.00 PM
  • venue : New Horizons Software Development Center, Momtaz Plaza, 3rd. Flr., House #7, Road #4, Dhanmondi, Dhaka, Bangladesh

Price: TK. 20,000
(Excluding VAT & TAX)

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

Module Microsoft SQL Server 2016 with exam Preparation 60 Hrs

Tentative Class Start

2nd August, 2019

Available Seat

10 / 15

who can join

Any one who can change their life with passion.

Meet the Instructor