MCSA SQL Server 2016 Database Administration

by The Code Academy Claim Listing

MCSA: SQL Server Database Administration certification covers everything from designing, installing, configuring, and maintaining a Microsoft Database environment, to implementing and troubleshooting database objects.

₹2875

Contact the Institutes

Fill this form

Advertisement

The Code Academy Logo

img Duration

5 Days

Course Details

The Academy of South Florida offers the fastest, most effective method to learn the industry-standard, fundamental features of Microsoft SQL Server that have made Microsoft’s premiere database solution a worldwide leader in data-driven business and application infrastructure.

With this SQL Server 2016 boot camp, you will gain valuable insight into the new, powerful capabilities that SQL Server 2016 adds to a database developer and administrator’s solutions toolbox.

MCSA: SQL Server Database Administration certification covers everything from designing, installing, configuring, and maintaining a Microsoft Database environment, to implementing and troubleshooting database objects. This program covers all material and exams necessary to achieve an MCSA in Microsoft SQL Server 2016 Database Administration

This 5-day boot camp is a combination of the following official Microsoft courses:

  • 20764B: Administering a SQL Database Infrastructure; Exam 70-764
  • 20765B: Provisioning SQL Databases; Exam 70-765

This course provides students with the technical skills required to authenticate and authorize users. Assign Server and Database roles. This course helps people prepare for exams 70-764. This course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2016 database. The course focuses on teaching individuals how to use SQL Server 2016 product features and tools related to maintaining a database. Also, this course helps you prepare for the Exam 70-765. This course provides students with the knowledge and skills to provision, both on-premise and in Azure SQL Server 2016.

After completing this course, students will be able to:

  • 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)
  • Miami Branch

    3737 NW 7 Street, Miami
  • Los Angeles Branch

    8560 W. Sunset Blvd Suite 400 and 500, Los Angeles
  • Boston Branch

    60 State Street Suite 700, Boston

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy