MCSA SQL 2016 Database Administration

Speak to us about 0% finance.

MCSA SQL 2016 Database Administration

Course Information

MCSA SQL 2016 Database Administration

Course Details

Certification: MCSA SQL 2016 Database Administration
Vendor: Microsoft
Course prerequisite: Although there are no formal prerequisites to studying this course, it is recommended that you have some experience in working with databases.
Study time: 20-30 hours per course
Practical learning: Practice labs are available for the MCSA SQL 2016 Database Administration courses.

Certification Details

To gain the MCSA: SQL 2016 Database Administration qualification the following exams must be passed:

Exam 70-764: Administering a SQL Database Infrastructure
Exam 70-765: Provisioning SQL Databases

Once you have passed both exams, you will have earned your internationally recognised MCSA: SQL 2016 Database Administration certification which is awarded by Microsoft.

Career Path Opportunities

Database Administrator
Database Analyst
Database Engineer
Database Consultant

What's Included

  • Administering a SQL Database Infrastructure Course (70-764)
  • Provisioning SQL Databases Course (70-765)
  • 12 months unlimited access
  • Student mentor
  • Student care team
  • Career support

Why Learn With Us

Let us help you become the best you can be.

Career Support

Students receive access to our recruitment resource pack which includes our CV review guide, enabling you to showcase your new skills.

Learn more

Student Support

Our dedicated student support team is only a phone call or email away, to answer your questions and help you prepare for exams.

Learn more

Flexible Finance

Our 0% interest finance plans are fully flexible and range from 6 to 12 months, allowing you to enrol on your course with complete peace of mind.

Learn more

Partnered with Leaders

We partner with the world’s leading course providers to make sure you have high-quality learning materials that will accelerate your learning.

Learn more

Expert Team

Our team undergo daily training for the latest updates and demands in the industry, to help find you the perfect role to begin your career.

Learn more

Get This Qualification On Your CV

Transform your career today

Validate your technical expertise with industry recognised certifications from the world's biggest software maker, Microsoft

Course Curriculum

MCSA SQL 2016 Database Administration

Exam 70-764: Administering a SQL Database Infrastructure
  1. Configure Encryption
  2. Configure Data Access and Permissions
  3. Configure Auditing
  4. Develop a Backup Strategy
  5. Restore Databases
  6. Manage Database Integrity
  7. Monitor Database Activity
  8. Monitor Queries
  9. Manage Indexes
  10. Monitor SQL Server Instances
  11. Implement Log Shipping
  12. Implement Failover Cluster Instances
  13. Implement Always On Availability Groups
Exam 70-765: Provisioning SQL Databases
  1. Deploy a Microsoft Azure SQL Database
  2. Plan for SQL Server Installation
  3. Deploy SQL Server Instances
  4. Deploy SQL Server databases to Azure virtual machines
  5. Configure secure access to Microsoft Azure SQL Databases
  6. Configure SQL Server performance settings
  7. Manage SQL Server instances
  8. Manage SQL Storage
  9. Perform Database Maintenance

Why Get Qualified?

Gain new skills and knowledge

Thinking ahead and learning the skills needed to move forward in your current career path will mean you are more likely to be considered for future roles.

Gain credibility early in your career

A certification from IT Online Learning shows prospective employees that you have the right skills and credentials needed to succeed in your career.

Increase your opportunity for promotion

Gaining the right set of qualifications will increase your chances of moving into a supervisory or management role, giving you the opportunity to increase your salary.

Average Salary Projection

Source: Adzuna
Average Salary
Database Engineer
Average Salary
You Can Earn
Average Salary
Database Administrator

Salary Projection

Average Salary

Database Consultant


You can earn an average of £38k a year

Enquire About MCSA SQL 2016 Database Administration

  • This field is for validation purposes and should be left unchanged.

Learn more about how we use your data.