Administering a SQL Database Infrastructure Training (20764)

This official Microsoft SQL Server course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL Server database infrastructure. Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases.

Plus, get prepped for MS exam 70-764, a requirement for MCSA: SQL 2016 Database Administration certification.

You Will Learn How 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

With the on-demand version of the course, you receive the same high quality content as the live event, but you can attend on your own time, at your own pace. As an added bonus, you get 2 FREE hours of individual coaching from an MCT Learning Tree Instructor with enrollment in this MOC on demand course.

  • Microsoft SQL Certification Training Course Description (MOC 20764):

    This Microsoft SQL training training course includes 29 hours of Instructor-Led Training (ILT) or Virtual Instructor-Led Training (VILT) presented by a Learning Tree expert instructor who is a Microsoft Certified Trainer (MCT). This course can help you prepare for the Microsoft 70-764 exam, Administering a SQL Database Infrastructure. This is a Microsoft Official Course (MOC) delivered by a Learning Tree expert instructor.

  • Requirements

    • In addition to their professional experience, students who attend this training should already have the following technical knowledge:
      • Basic knowledge of the Microsoft Windows operating system and its core functionality
      • Working knowledge of Transact-SQL
      • Working knowledge of relational databases
      • Some experience with database design

  • Microsoft Exam Information

    This course can help you prepare for the following Microsoft certification exam — 70-764: Administering a SQL Database Infrastructure

  • Redeem Your Microsoft Training Vouchers (SATV):

    • This course is eligible for Microsoft Software Assurance Training Voucher (SATV) redemption.
    • Want to learn more about Microsoft SATVs? Click to view our SATVs infographic.

  • Industry Credits & Certification

    This course offers you the opportunity to earn the following industry credits and certifications:

  • After-Course Computing Sandbox

    You'll be given remote access to a preconfigured virtual machine for you to redo your hands-on exercises, develop/test new code, and experiment with the same software used in your course. Note: The Sandbox is not available for the On-Demand option.