Earning an MCSA: SQL 2016 Database Development certification qualifies you for a position as a MCSA Database Developer.
Learners need a computer, laptop, tablet or smartphone and internet connection, courses are designed in video with audio and coupled with unlimited technical support.
Course Fee: MCSA DATABASE DEVELOPER course is R4 495.00 cash or R4 995.00 on terms with R2 250.00 deposit and 6 monthly instalments of R457.60.
Estimated duration: 40 hours, therefore should you study 1 hour per day you could complete the course in less than 2 months.
To register for the MCSA SQL 2016 Database Developer course please click here.
MCSA SQL 2016 DEVELOPER
70-761: Querying Data with Transact-SQL
T-SQL Querying
Querying and Manipulating Data
Filter and Modify Data in SQL Server 2016
Using Functions in SQL Server 2016
Aggregating Data in SQL Server 2016
Subqueries and Predicate
Operators and Expressions in SQL Server 2016
Database Programmability Objects and Non-Relational Data
70-762 Developing SQL Databases
SQL Server 2016 Database Objects
SQL Server 2016 Indexes and Views
Columnstore Indexes
Programmability Objects
Triggers and Functions
Managing Database Concurrency
Optimize SQL Database Objects and Infrastructure
MCSA SQL 2016 ADMINISTRATOR
Earning an MCSA: SQL 2016 Database Administrator certification qualifies you for a position as a Database Administrator.
Learners need a computer, laptop or tablet and internet connection. Courses are designed in video with audio and coupled with unlimited advanced mentoring. Courses are printable and downloadable.
To register for the MCSA SQL 2016 Database Administrator course please click here.
Course Fee: MCSA DATABASE ADMINISTRATOR course is R4 495.00 cash or R4 995.00 on terms with R2 250.00 deposit and 6 monthly instalments of R457.60
Estimated duration: 40 hours, therefore should you study 1 hour per day you could complete the course in less than 2 months.
70-764: Administering a SQL Database Infrastructure
Encryption
Data Access and Permissions
Auditing
Backing Up Databases
Restoring Databases
Managing Database Integrity
Monitoring Database Activity and Queries
Monitoring SQL Server Instances
Managing Indexes and Statistics
High Availability and Disaster Recovery
70-765 Provisioning SQL Databases:
Components of a SQL Server 2016 Installation
Installing and Upgrading SQL Server 2016
SQL Server Virtual Machines on Azure
SQL Server Instances and Storage Considerations
Azure SQL Database Encryption
SQL Server Performance Settings
Deploying Applications to Microsoft Azure SQL Databases
Azure Virtual Machines
Migrating Client Applications
How our courses work:
On enrolment we issue our learners with an username and password to access their courses for a 12 month subscription. At the end of each module you will be required to answer multiple choice questions, these marks are registered in our database. Should you obtain 70% and above you will receive IT Academy Course Mastery Certification by mail, at no additional cost.
International exams are written at any Pearson Vue Testing Centre in South Africa. Discounted international exam vouchers can be purchased through IT Academy at R550.00 each.