• Thousands have come from all over the world to visit our Training Facilities in South Florida!
    Thousands have come from all over the world to visit our Training Facilities in South Florida!
  • Interested in Cyber Security? Register for The Academy's Cyber Security Program!
    Interested in Cyber Security? Register for The Academy's Cyber Security Program!
  • Put your Microsoft Software Assurance Training Vouchers to use here!
    Put your Microsoft Software Assurance Training Vouchers to use here!
  • Now offering training for Government employees through GSA!
    Now offering training for Government employees through GSA!
  • Cisco is launching new voice certifications: CCNA & CCNP Collaboration.
    Cisco is launching new voice certifications: CCNA & CCNP Collaboration.
  • NEW for 2015! The Academy is now offering MCSE training!
    NEW for 2015! The Academy is now offering MCSE training!

MCSA SQL SERVER 2016 DATABASE ADMINISTRATION

Microsoft Developer Tools Application MCSA SQL SERVER 2016 DATABASE ADMINISTRATION

Click Here to View Schedules & Pricing and to Enroll Online

Duration: 5 Days

Descriptiion

MCSA SQL SERVER Database Administration Boot Camp

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 tool box.

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:
• 20764A: Administering a SQL Database Infrastructure 
• 20765A: Provisioning SQL Databases

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 exam 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:

 

Prerequisites

Before attending this course, students must have:

Before attending this course, students should have:

Curriculum

Module 1: Authenticating and Authorizing Users

Module 2: Assigning Server and Database Roles

Module 3: Authorizing Users to Access Resources

Module 4: Protecting Data with Encryption and Auditing

Module 5: SQL Server Recovery Models

Module 6: Backup of SQL Server Databases

Module 7: Restoring SQL Server Databases

Module 8: Automating SQL Server Management

Module 9: Configuring Security for SQL Server Agent

Module 10: Monitoring SQL Server with Alerts and Notifications

Module 11: Introduction to Managing SQL Server by using PowerShell

Module 12: Tracing Access to SQL Server

Module 13: Monitoring SQL Server

Module 14: Troubleshooting SQL Server

Module 15: Importing and Exporting Data

Module 16: SQL Server 2016 Components

Module 17: Installing SQL Server 2016

Module 18: Upgrading SQL Server to SQL Server 2016

Module 19: Deploying SQL Server on Microsoft Azure

Module 20: Working with Databases

Module 21: Performing Database Maintenance.

What’s Included:
Training Formats

With several convenient training delivery methods offered, The Academy makes getting the training you need easy. Whether you prefer to learn in a classroom or an online live learning virtual environment, training videos hosted online, and private group classes hosted at your site. We offer expert instruction to individuals, government agencies, non-profits, and corporations. Our live classes, on-sites, and online training videos all feature certified instructors who teach a detailed curriculum and share their expertise and insights with trainees. No matter how you prefer to receive the training, you can count on The Academy for an engaging and effective learning experience.

Methods

Speak to an Admissions Representative for complete details