MCSA SQL Server 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
FULL-TIME
Duration
5 Days (Intensive Bootcamp Training)
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.
Reviews
There are no reviews yet.