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:
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:
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)
Before attending this course, students must have:
• Working knowledge of relational databases.
• Basic knowledge of the Microsoft Windows operating system and its core functionality.
Before attending this course, students should have:
• Basic understanding of virtualization technology (Classroom labs utilize virtual machines)