Course Schedule

Jan 12, 2021 Tue and Thu 6:00 P.M -10:00 P.M EST -

Course Curriculum

 Course Curriculum

Phase

Module

Description

Phase 1

Foundation Training

Module 1

Overview of enterprise applications and N-Tier Infrastructure 

Module 2

Operating System –Windows Server 2012/2016, Unix  

Module 3

 Networking , Active Directory  and  DNS

 

Module 4

Power Shell Scripting, Batch Scripting

 

Module 5

Incident, Problem and Change Management process

Phase 2

Database Administration

Module 6

Designing, Planning, installing, Configuring of Microsoft SQL Server 2012/2014

Module 7

 Administering of SQL Server 2012/2014

Module 8

 Database backup and restore strategy

Module 9

 Database Security and Auditing

Module 10

 Automating database management

 Phase 3

Database Performance

Module 11

 Maintaining Database Indexes and Database Integrity

Module 12

Database Policy Management and Resource Governor

Module 13

Optimizing SQL Server Performance

Module 14

 Monitoring and Tuning of SQL Server

Phase 4

Database Business Intelligent

Module 15

 SQL Server Reporting Service (SSRS)

Module 16

 SQL Server Integrating Services (SSIS)

Module 17

SQL Server Analysis Service (SSAS)

Module 18

 SQL Server Data Warehouse

Phase 5

Database High Availability

Module 19

 Windows Server Failover Clustering(WSFC)

Module 20

Database Mirroring

Module 21

Database Replication

Peer to Peer (P2P) Replication

Merge Replication

Module 22

SQL failover cluster implementation, multi-site clustering, and explain the flexible failover policy provided with SQL Server SQLAlwaysON.

 

 

 

 

 

Phase 6

Database Monitoring

 

Module 23

 

Profiler, Sysmon , Perfmon , Database Engine Tuning Advisor , Index Tuning Wizard ,SQL Activity Monitor , SQL DMV

Module 24

Designing, Planning, installing, Configuring of Microsoft System Center Configuration Manager (SCOM)

Module 25

Idera SQL Diagnostic Manager , Red-Gate SQL Monitor

Phase 7

Microsoft SharePoint

Module 26

 Designing, Planning, installing, Configuring of Microsoft Share point 

Module 27

 Administering Microsoft Share Point

Phase 8

Preparation for job market

 

Module 28

Preparation of Microsoft Exam 70-462

Module 29

 Real-Time Project Based Workshop and Presentation

Module 30

Boot Camp, Resume and Interview Preparation

 

 

Description

Microsoft SQL Server Database Administration with MCSA Certification

Database Administrators (DBAs) are responsible for the design, implementation, support, and maintenance of computerized databases in today's organizations. The role also includes architecting, building and scaling databases for future data growth and capacity. They are also responsible for security, performance, and availability of data to users and customers.
All the above tasks are performed with the help of a Database Management System (DBMS) and among the most widely used DBMS across the world, today is the Microsoft SQL Server Data Platform.


Database Administrator Market Scope:

The US Department of Labor estimates that by 2018 there will be more than 1.4 million total new computing-related job openings in the US.

Database Administrator Employment Projections 2010 – 2020

>> 10-yr Growth Pct: 31% (much faster than avg)

>> 10-yr Growth Volume: 33,900 new jobs

>> Average Salary: $82,000

 

Prerequisites: Students who completed at least one computer training program or have some work experience in IT field with some knowledge of computer hardware & Networking.

 

Course Duration (16 Weeks)

Class: 107 Hours   | Instructor-Led Lab: 53 Hours   |  Total Hours: 160 Hours

 

Training Methodology:

>> Real world scenario labs

>> Each student will be provided one Windows Server accessible from anywhere 24/7

>> Each class is designed with Class Notes and Labs

>> Resume Preparation

>> Interview Training

>> Job Support                                                  

Course Catalog

Please Click to View The Catalog :       Download