SQL Server 2014 with Exam Preparation

SQL Server 2014 with Exam Preparation

This SQL Server training teaches developers all the Transact-SQL skills they need to create database objects like Tables, Views, Stored procedures & Functions and triggers in SQL Server.

course at a glance

  • Date : 16 Sep - 23 Dec 2017
  • No. of Classes/ Sessions : 26
  • Total Hours : 75
  • Last Date of Registration : 14 Sep 2017
  • Class Schedule :
    • Saturday - 3.00PM - 6.00PM
    • Tuesday - 6.30PM - 9.30PM
  • venue : LEADS Training & Consulting Ltd. Rupayan Trade Center 16th, 114, Kazi Nazrul Islam Avenue, Banglamotors, Dhaka 1000.

Price: TK. 15,000

This training is jointly organized by BITM & Leads Training & Consulting Ltd

Training will be held in Leads Training & Consulting Ltd


Giving idea about writing Queries & Sub-queries, working with Joins, etc. As well as database management skills like backup, restore, etc.

Course Outline

70-461 Querying Microsoft SQL Server

1 - Introduction to Microsoft SQL Server 2014

2 - Introduction to T-SQL Querying

3 - Writing SELECT Queries

4 - Querying Multiple Tables

5 - Sorting and Filtering Data

6 - Working with SQL Server 2014 Data Types

7 - Using DML to Modify Data

8 - Using Built-In Functions

9 - Grouping and Aggregating Data

10 - Using Subqueries

11 - Using Table Expressions

12 - Using Set Operators

13 - Using Window Ranking, Offset, and Aggregate Functions

14 - Pivoting and Grouping Sets

15 - Executing Stored Procedures

16 - Programming with T-SQL

17 - Implementing Error Handling

18 - Implementing Transactions

70-462 Administering Microsoft® SQL Server® Databases

1 - Introduction to SQL Server 2014 Database Administration

2 - Installing and Configuring SQL Server 2014

3 - Working with Databases and Storage

4 - Planning and Implementing a Backup Strategy

5 - Restoring SQL Server 2014 Databases

6 - Importing and Exporting Data

7 - Monitoring SQL Server 2014

8 - Tracing SQL Server Activity

9 - Managing SQL Server Security

10 - Auditing Data Access and Encrypting Data

11 - Performing Ongoing Database Maintenance

12 - Automating SQL Server 2014 Management

13 - Monitoring SQL Server 2014 by Using Alerts and Notifications

70-463 Implementing a Data Warehouse with Microsoft® SQL Server

1 - Introduction to Data Warehousing

2 - Planning Data Warehouse Infrastructure

3 - Designing and Implementing a Data Warehouse

4 - Creating an ETL Solution with SSIS

5 - Implementing Control Flow in an SSIS Package

6 - Debugging and Troubleshooting SSIS Packages

7 - Implementing a Data Extraction Solution

8 - Loading Data into a Data Warehouse

9 - Enforcing Data Quality

10 - Master Data Services

11 - Extending SQL Server Integration Services

12 - Deploying and Configuring SSIS Packages

13 - Consuming Data in a Data Warehouse

Curriculum

SQL Server 2014 with Exam Preparation SQL Server 2014 with Exam Preparation 75 Hrs