MCSA: SQL 2016 Database Administration

Code: 3211

6 days

List Tuition : $4,095.00 USD

Course Overview

    Download PDF Certification Path

The SQL 2016 Bootcamp provides students hands-on experience with SQL Server 2016. The MCSA: SQL 2016 Database Administration Certification validates your skills with database installation, maintenance, configuration, and provisioning tasks, and will qualify you for a position as a database administrator or infrastructure specialist.

The boot camp will highlight what is new in SQL Server 2016 in comparison to SQL Server 2012/2014 . It provides guidance on installing, configuring, and maintaining SQL Server 2016

This course incorporates content from Microsoft Official Courses (MOC):

  • Administering a SQL Database Infrastructure (20764B)
  • Provisioning SQL Databases (20765B)

Included are Two (2) Microsoft Exam Vouchers (Unlimited Retakes):

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

Learn More About the MCSA: SQL 2016 Database Administration Certification

  • The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job.
  • Authenticate and authorize users
  • Assign server and database roles
  • Authorize users to access resources
  • Protect data with encryption and auditing
  • Describe recovery models and backup strategies
  • Backup SQL Server databases
  • Restore SQL Server databases
  • Automate database management
  • Configure security for the SQL Server agent
  • Manage alerts and notifications
  • Managing SQL Server using PowerShell
  • Trace access to SQL Server
  • Monitor a SQL Server infrastructure
  • Troubleshoot a SQL Server infrastructure
  • Import and export data
  • Provision a Database Server
  • Upgrade SQL Server
  • Configure SQL Server
  • Manage Databases and Files (shared)
    • Microsoft Certified Trainers
    • Microsoft Official Course Material
      • Administering a SQL Database Infrastructure (20764B)
      • Provisioning SQL Databases (20765B)
    • Exam Voucher(s) Included with Class
      • Exam 70-764 Administering a SQL Database Infrastructure
      • Exam 70-765 Provisioning SQL Database
    • Exam Pass Guarantee: Unlimited Retakes Until You Pass the Exam
    • Work in virtual labs that provide real-world experience
    • For Virtual Classes Learn at your own pace from your home, office, or any place that has an Internet connection
    • Repeat part or all of the class at no additional cost, often for up to a year
    • Work in virtual labs that provide real-world experience
    • Certification of Completion at the End of Class
    • Water, Soda, and Snacks Provided in Class
    • Time intensive accelerated training for teams with budget and time
    • Access to practice labs after the class

    Request a Discounted Quote




    Bring Training to You

    Request schedule for this course

    Request a Quote for this Class

    We provide government and government contractor discounts, please request a quote

    Schedule



    total option: 0

    Hotel and Travel can be included on your quote.
    For immediate response, you can call 1-855-515-2170 or we will provide a quote within 4 business hours. Travel must be booked 14 days before training for rate to apply.

    Learn How to Become a Managed Learning Member

    Request a Quote

    Thank you for requesting a quote, we will be in touch shortly with a quote. If you need immediate assistance, please call 855-515-2170.

    Request Other Date

    Request date or location you need

    Don’t see the date or location you need? Contact us and let us know, we are adding dates and locations daily.