You are here:Courses|Microsoft|Microsoft SQL SERVER 2008|MCSA SQL Server 2008

MCSA SQL Server 2008

The MCSA SQL Server 2008 course offers core expertise and skills required by professionals to configure and maintain a Microsoft SQL Server 2008 database. This course teaches individuals how to use various tools and features available in SQL Server 2008 R2 for maintaining a database.

Course Objectives :

  • Understand the architecture and resource requirements of SQL Server 2008 R2
  • Planning, installing and configuring SQL Server
  • Backing up and restoring the database
  • Import/export wizards and understand them in relation to SSIS
  • Import data using BCP and BULK INSERT
  • Managing security of database
  • Assigning and configuring fixed database roles
  • Creating and assigning user-defined database roles
  • Configuring and assigning permissions
  • Implementing database audits
  • Managing SQL Server Agent and Jobs
  • Configuring database alerts, notifications and mails.
  • Maintaining databases
  • Using Dynamic Management Views to monitor data
  • Executing multi server queries
  • Configuring a central management server
  • Deploying data tier applications
  • Troubleshooting common issues

Apart from these objectives, the course also includes BI application development basic concepts. Students will understand and work with complete suite of BI technologies in SQL Server 2008, including Analysis Services, Reporting Services, and Integration Services.They will learn about configuring, deploying, implementing and maintaining SSIS, SSAS and SSRS solutions in your organization.

Course# Course Contents Exam# Exam Regular Track
(days)
2778A Writing Queries Using Microsoft SQL Server 2008 Transact-SQL 70-432 MCSA: SQL Server 2008 3
6231B Maintaining a Microsoft SQL Server 2008 R2 Database 6
6234A Implementing and Maintaining a Microsoft SQL Server 2008 Analysis Services 70-448 3
6235A Implementing and Maintaining a Microsoft SQL Server 2008 Integration Services 3
6236A Implementing and Maintaining a Microsoft SQL Server 2008 Reporting Services 3
Balance Days  for day of arrival, exam(s) and practice 5
Total duration 23

Prerequisites

  • Basic knowledge of Microsoft Windows operating system and its core functionality.
  • Conceptual understanding of OLAP solutions
  • Experience navigating Microsoft Windows Server environment
  • Experience with Windows services (starting and stopping)
  • Experience creating service accounts and permissions

 

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]