INTRODUCTION

Microsoft SQL Server is the heart of mission- critical environments. The Microsoft Certified Solutions

Associate (MCSA): SQL Server certification provides the necessary technical background and hands-on labs required to design, build, maintain, and query an SQL environment. This certification is intended for database administrators, database developers, as well as business intelligence enthusiasts.

This certification is covered in 3 exams (70-461, 70-462, 70-463) and is a prerequisite certification for 2 Microsoft Certified Solutions Expert (MCSE) specialisations, specifically Data Platform and Business Intelligence.

COURSE CONTENT

Querying SQL Server SQL, DML, DDL Constraints, Triggers Data Management Views Data Types, Tables, Views

Error Handling Functions, Stored Procedures Index Optimisation Queries, Subqueries, CTEs Transactions

Administering SQL Server

Audit, Backup, Restore Cluster, AlwaysOn, Mirroring Databases, Filegroups Integration Services (SSIS)

Migration, Import, Export Permissions, Certificates Server & Database Roles SQL Engine & Instances

SQL Server Agent System Monitor, Profiler

Implementing Data Warehouse

Data flows, Control Flow Data Quality Services Dimensions, Facts Event Handling, DTUTIL, SSIS package, Script tasks

COURSE DETAILS

Mode of Study

PART TIME

Saturdays only

Duration

3 months (Weekend)

10am to 2pm

Delivery Method

Lectures & Hands-On Practice

Entry Requirements

Knowledge of databases

Award

MCSA SQL Server

Exam Codes: 70-461, 70-462,

70-463

Price: GHC 1,700

Study Experience includes: Training by a Microsoft Certified Trainer (MCT), Official Microsoft Courseware (Format: PDFs and Videos), Official Microsoft Practice Tests, Official Microsoft Exams.