- About Us
- Corporate Training
MCSA SQL Server Course
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.
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
Mode of Study
5 Days (Intensive Bootcamp Training)
Lectures & Hands-On Practice
Knowledge of databases
MCSA SQL Server
Exam Codes: 70-461, 70-462,
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.