MCSA SQL 2016 Database Administration

COURSE OVERVIEW

If you're looking to demonstrate your skill in installing, maintaining and configuring data solutions onsite and in the Cloud, then the MCSA SQL 2016 Database Administrator certification is for you. 

  • 1

    Step forward in your career

    Enhance your skillset and building on your existing knowledge of administering SQL databases

  • 2

    Meet demand

    Meet the ever increasing demand for big data and business intelligence solutions at the enterprise level

  • 3

    Get hired

    Validate your skills by demonstrating your ability to manage and configure Microsoft SQL Server 2016
     

Your quick course guide

Certification: MCSA SQL 2016 Database Administration

Study time: Full time - two weeks | Part time - two months

Vendor: Microsoft

Provider: Skillsoft

Student support: StudentCare™

Prerequisites: Ideally one year of experience administering Windows SQL Server

Assessment: Exam based - 70-764 + 70-765

Resources: Internet access and email

Ideal for: Database architect, infrastructure specialist, senior developor, database professionals

Included in your modules

Essential skills for your career

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

Get certified the Learning People way

Professional development courses that work around you

  • World's #1 eLearning portal
  • 12 months unlimited access
  • Global community of peers
  • Hands on interactive Practice Labs
  • Award winning training used globally by leading corporate clients

Average salaries

2015 JAN
  JUL
2016 JAN
  JUL
2017 JAN
  JUL
Read more

Why join us?

  • Award winning customer support
  • We know the job market inside out
  • Trusted by the giants
  • Value for money
  • CV detox - exclusive to our students
  • We're with you from start to finish
  • Expert career advice
  • Progress reports
  • Exam booking support
  • All UK students receive an NUS student discount card
  • Your success is our success

CV detox

It's not just about your CV...