It's all to do with the training: you can do a lot if you're properly trained.
An Institution That Can Change The Way of Your Life
It's all to do with the training: you can do a lot if you're properly trained.
An Institution That Can Change The Way of Your Life
It's all to do with the training: you can do a lot if you're properly trained.
An Institution That Can Change The Way of Your Life
It's all to do with the training: you can do a lot if you're properly trained.
An Institution That Can Change The Way of Your Life
It's all to do with the training: you can do a lot if you're properly trained.
An Institution That Can Change The Way of Your Life
It's all to do with the training: you can do a lot if you're properly trained.
An Institution That Can Change the Way of Your Life
It's all to do with the training: you can do a lot if you're properly trained.
An Institution That Can Change the Way of Your Life
It's all to do with the training: you can do a lot if you're properly trained.
An Institution That Can Change the Way of Your Life
It's all to do with the training: you can do a lot if you're properly trained.
An Institution That Can Change the Way of Your Life

SQL Server 2014 with Exam Preparation

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

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

Training will be held in Leads Training & Consulting Ltd

FEE - Tk 15000

Prerequisite

n/A

Project Oriented Course

One will practically learn all mentioned tools and techniques by completing a project through this practical training course.

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

Used Tools

MS SQL Server 2014

COURSE SUMMARY

Course Duration : 20 Days
Total Hour : 80 Hours
Number of Batch : 1 Batch

Application Last Date : 27 April, 2017

Class Schedule

Day & Time : Friday 9:00 am - 1:00 pm
Duration : 4 Hours per class

Project:

N/A


Certificate:

n/a