Top Left
Schedules About Us Solutions Training Testing Enquiry Booking Cart Sign Up
Top Left
mid-left
flash
captioncorner

Microsoft Database Management Courses

For IT professionals who want to demonstrate their technical expertise in Microsoft SQL Server in one of three areas: Implementation and Maintenance, Database Development, or Business Intelligence.

The Certification is divided into two: MCTS and MCITP

Microsoft Certified Technology Specialist (MCTS)

Microsoft Certified Technology Specialist (MCTS) certifications enable professionals to target specific technologies and to distinguish themselves by demonstrating in-depth knowledge and expertise in Microsoft specialized technologies.

Microsoft Certified IT Professional (MCITP)

Microsoft Certified IT Professional (MCITP) certifications demonstrate comprehensive skills in planning, deploying, supporting, maintaining, and optimizing IT infrastructures.

Available Certifications:

MCITP: Database Developer

Database developers design and implement relational database models (logical and physical) and database storage objects. They also program servers by using user-defined functions, triggers, stored procedures, Transact-SQL, or the CLR. They retrieve or modify data by using SQL queries or tune and optimize queries. Database developers are typically employed by medium-sized to large organizations.

MCITP: Database Administrator

Database administrators install or configure Microsoft SQL Server and manage or maintain databases or multidimensional databases, user accounts, database availability, recovery, and reporting. They also design or implement security or server automation and monitor and troubleshoot SQL Server activity. Database administrators are typically employed by mid-sized to large organizations.

MCITP: Business Intelligence

Microsoft Certified IT Professional (MCITP): Business Intelligence Developer certification demonstrates that you can design analysis solutions, data transformations, and reports. Business intelligence developers design and implement multi-dimensional database models (logical and physical), data marts, data warehousing, data transforms, data analytics, and reporting solutions. This includes programming and customizing servers that use Multidimensional Expressions (MDX), customer transforms, and custom reporting solutions. Business intelligence developers are typically employed by medium-sized to large organizations.

Certification Details

Microsoft Certified Database Management Courses

  Code Course Duration
Fees(Ksh)
 
2788 Designing High Availability Database Solutions Using Microsoft SQL Server 2005 30hrs
15000
 
2789 Administering and Automating Microsoft SQL Server 2005 Databases and Servers 10hrs
7500
 
2790 Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005 10hrs
7500
 
2781 Designing Microsoft SQL Server 2005 Server-Side Solutions 30 Hrs
15000
 
2782 Designing Microsoft SQL Server 2005 Databases 30 Hrs
15000
 
2783 Designing the Data Tier for Microsoft SQL Server 2005 30 Hrs
15000
 
2784 Tuning and Optimizing Queries Using Microsoft SQL Server 2005 30 Hrs
15000
 
2791 Implementing and Maintaining Microsoft SQL Server 2005 Analysis Services 30 Hrs
15000
 
2792 Implementing and Maintaining Microsoft SQL Server 2005 Integration Services 30 Hrs
15000
 
2793 Implementing and Maintaining Microsoft SQL Server 2005 Reporting Services 30 Hrs
15000
 
2794 Designing a Business Intelligence Solution Architecture for the Enterprise Using Microsoft SQL Serve 20 Hrs
15000
 
2795 Designing an ETL Solution Architecture Using Microsoft SQL Server 2005 Integration Services 20 Hrs
15000
 
2796 Designing an Analysis Solution Architecture Using Microsoft SQL Server 2005 Analysis Services 30 Hrs
15000
 
2797 Designing a Reporting Solution Architecture Using Microsoft SQL Server 2005 Reporting Services 20 Hrs
15000
 
6236 Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services 30 Hrs
15000
 
6231 Maintaining a Microsoft SQL Server 2008 30 hrs
15000
 
6232 Implementing a Microsoft SQL Server 2008 30 hrs
15000
 
2778 Writing Queries Using Microsoft SQL Server 2008 30 hrs
13500
 
2779 Implementing a Microsoft SQL Server 2005 Databases 30hrs
15000
 
2780 Maintaining a Microsoft SQL Server 2005 Database 30hrs
15000
 
6235 Implementing and Maintaining Microsoft SQL Server 2008 Integration Services 20 hrs
15000
 
6234 Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services 20 hrs
13500
 
2786 Designing a Microsoft SQL Server 2005 Infrastructure 15hrs
7500
 
2787 Designing Security for Microsoft SQL Server 2005 15hrs
7500
 

Select the Course and Book online !



Exam Details

MCITP: Database Administrator 2005

 

 


Course
Code
Course
Exam
Code
2779
Implementing a Microsoft SQL Server 2005 Databases
70-431
2780
Maintaining a Microsoft SQL Server 2005 Databases
 
2786
Designing a Microsoft SQL Server 2005 Infrastructure
70-443
2787
Designing Security for Microsoft SQL Server 2005
2788
Designing High Availability Database Solutions Using Microsoft SQL Server 2005
2789
Administering and Automating Microsoft SQL Server 2005 Databases and Servers
70-444
2790
Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005

 

 
MCITP: Database Developer 2005

 

Course Code
Course
Exam Code
2780
Maintaining a Microsoft SQL Server 2005 Database
70-431
2779
 Implementing a Microsoft SQL Server 2005 Database
2785
 Implementing and Maintaining a Microsoft SQL Server 2005 Database
2781
Designing Microsoft SQL Server 2005 Server-Side Solutions
70-441
2782
Designing Microsoft SQL Server 2005 Databases
2781
Designing Microsoft SQL Server 2005 Server-Side Solutions
70-442
2783
Designing the Data Tier for Microsoft SQL Server 2005
2784
Tuning and Optimizing Queries Using Microsoft SQL Server 2005

 

MCITP: Business Intelligence Developer 2005

 

Course Code
Course
Exam Code
2791
Implementing and Maintaining Microsoft SQL Server 2005 Analysis Services
70 - 445
2792
Implementing and Maintaining Microsoft SQL Server 2005 Integration Services
2793
Implementing and Maintaining Microsoft SQL Server 2005 Reporting Services
2794
Designing a Business Intelligence Solution Architecture for the Enterprise Using Microsoft SQL Server 2005
70-446
2795
Designing an ETL Solution Architecture Using Microsoft SQL Server 2005 Integration Services
2796
Designing an Analysis Solution Architecture Using Microsoft SQL Server 2005 Analysis Services
2797
Designing a Reporting Solution Architecture Using Microsoft SQL Server 2005 Reporting Services

 

MCTS: SQL Server 2008, Implementation and Maintenance

 

Course Code
Course
Exam Code
6231
Maintaining a Microsoft SQL Server 2008 Database
70 - 432
6232
Implementing a Microsoft SQL Server 2008 Database

 

MCTS: SQL Server 2008, Database Development

 

Course Code
Course
Exam Code
6232
Implementing a Microsoft SQL Server 2008 Database
70 - 433

 

MCTS: SQL Server 2008, Business Intelligence Development and Maintenance

 

Course Code
Course
Exam Code
6234
Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services
70-448
6235
Implementing and Maintaining Microsoft SQL Server 2008 Integration Services
6236
Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services

 

Prometric Testing Center (Microsoft Online Exams)

 
 
mid right