You are here:Courses|Microsoft|Microsoft SQL SERVER 2012|Database Administrator for Microsoft SQL Server

Database Administrator for Microsoft SQL Server

The Database Administrator for Microsoft SQL Server Training covers all aspects of implementing and managing SQL Server 2012 databases successfully. This course is a combination of theoretical learning and hands on practical sessions to give professionals in-depth understanding of executing and administering database operations.

 

Course Objectives :

The course structure of this training program will cover the following modules:

  • Fundamentals of Windows Server Administration
  • Fundamentals of Networking
  • Fundamentals of implementing Security
  • Fundamentals of Database Administration
  • Querying SQL Server 2012 Databases
  • Administering SQL Databases
  • Using a Data Warehouse in SQL Server 2012
  • Developing SQL Databases
  • Designing and executing Database Solutions
  • Optimization and internal workings of SQL Server
  • Understanding SQL Azure and Cloud Computing
  • Simulated Internship

The Database Administrator for Microsoft SQL Server is highly recommended for professionals who wish to gain core working knowledge and expertise in successfully implementing and administering SQL Server 2012 databases in a Microsoft environment. Completing this comprehensive course will make you a seasoned database administrator who can design, implement, troubleshoot, support and maintain complex database environments with ease. They will also be able to architect, build, and scale databases for future growth and capacity management.

Course# Course Contents Exam# Exam Regular Track
(days)
40365A Windows Server Administration Fundamentals 98-365 MTA IT Infrastructure track 2
40366A Networking Fundamentals 98-366 2
40367A Security Fundamentals 98-367 2
  Hands On     2
40364A Database Administration Fundamentals 98-364 MTA Database track 2
Break   2
10774A Querying Microsoft SQL Server 2012 Databases 70-461 MCSA : SQL Server 2012 5
10775A Administering Microsoft SQL Server 2012 Databases 70-462 5
  Hands On   2
10777A Implementing a Data Warehouse with Microsoft SQL Server 2012 70-463 5
  Hands On     2
Break   2
10776A Developing Microsoft SQL Server 2012 Databases 70-464 Developing Microsoft SQL Server 2012 Databases 5
20465B Designing Database Solutions for Microsoft SQL Server 2012 70-465 MCSE Data Platform 5
- Introduction to Cloud Computing and SQL Azure - - 1
Balance Days for day of arrival,exam(s) and practice 15
Total duration 59

 

Our Location

Get In Touch

1st Floor of CHABAH House,

Chabah Bus Stop on the Odokor-Mallam HighWay

Opposite Total Filling Station

P. O. Box DS 2022

Accra, Ghana

Phone: +233 303 393 1256 / +233 302 325 815

Cell: +233 244036 522

Email:[email protected]