MICROSOFT OFFICE SUITE - Accra

Ramsys IT Training Centre offers all popular and latest Microsoft certification courses. It is a technology leader that offers various specializations in a gamut of subjects and domains including Office applications, virtualization, database

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 :

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

management, enterprise application management, business intelligence, data analysis, among others.