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

Check out more MCSA courses in USA

Technical Institute of America Logo

MCSA: Windows Server 2016 Training

Earning an MCSA: Windows Server 2016 certification qualifies you for a position as a network or computer systems administrator or as a computer network specialist, and it is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

by Technical Institute of America [Claim Listing ]
  • Price
  • Start Date
  • Duration
CED Solutions Logo

MCSA Certification Training

MCSA Certification Training is offered by CED Solutions. While attending most of our certification courses, over 80% receive their certification during the course. 

by CED Solutions [Claim Listing ]
The Code Academy Logo

MCSA (Cloud)

The Academy’s MCSA: Cloud platform boot camp covers the new features and enhancements for transforming virtualization and cloud computing, which have been made available with Windows Server 2012 / 2016.

by The Code Academy [Claim Listing ]
Hartmann Software Group Logo

MCSA (Windows Server 2016 Boot Camp Training)

An in-depth and broad training class that covers the following Microsoft training topics and exams: 70-740: Installation, Storage, and Compute with Windows Server 2016 70-741: Networking with Windows Server 2016 70-742: Identity with Windows Server 2016.

by Hartmann Software Group [Claim Listing ]
New Beginnings Computer Training Logo

Microsoft Certified Solutions Associate (MCSA)

This course teaches the primary set of Windows Server 2012 skills required to reduce IT costs and deliver more business value.

by New Beginnings Computer Training [Claim Listing ]

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