Course

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.