MCSA SQL Server 2016 Database Administration Boot Camp
8/17/2020 - 8/22/202010/19/2020 - 10/24/2020COURSE LENGTH:
9:00am - 4:30pm
About VTEC Boot Camps:
Our all-inclusive Boot Camps provide an accelerated, intensive, and immersive hands-on learning environment, that gives students with the necessary skills and knowledge to not only pass the Microsoft Certification exams, but to also excel in their IT career paths.
- All course materials, practice exams and official certification exams
- Onsite Pearson VUE Testing Center
- Hands-on instruction by a certified instructor
Breakfast Snack and Lunch provided each day
AUDIENCE AND PREREQUISITES
This boot camp is intended for database professionals who perform installation, maintenance, and configuration tasks. Other responsibilities include setting up database systems, making sure those systems operate efficiently, and regularly storing, backing up, and securing data from unauthorized access.
PREREQUISITE COURSESFOLLOW UP COURSES
- IT professionals with at least two years of hands-on experience implementing and administering database systems
- Database administrators, systems engineers, systems analysts, and technical consultants who want to prepare for their MCSA: SQL Server 2012/2014 credential in an accelerated format
*Course Cost listed does not include the cost of courseware or lunch. Course is subject to minimum enrollment. Course may run virtually as a Virtual Instructor-Led class if minimum enrollment is not met.
Note: This course is eligible for Microsoft SATVs.
Module 1: Authenticating and Authorizing Users Authenticating connections to SQL Server Authorizing logins to access databases Authorization across servers Partially contained databases Lab: Authenticating UsersModule 2: Assigning Server and Database Roles Working with server roles Working with Fixed database roles Creating user-defined database roles Lab: Assigning server and database rolesModule 3: Authorizing Users to Access Resources Authorizing user access to objects Authorizing users to execute code Configuring permissions at the schema level Lab: Authorizing users to access resourcesModule 4: Protecting Data with Encryption and Auditing Implementing SQL Server audit Managing SQL Server audit Protecting data with encryption Lab: Using Auditing and EncryptionModule 5: SQL Server Recovery Models Backup strategies Understanding SQL Server transaction login Planning a SQL Server backup strategy Lab: Understanding SQL Server recovery modelsModule 6: Backup of SQL Server Databases Backing up databases and transaction logs Managing database backups Working with backup options Lab: Backing up SQL Server databasesModule 7: Restoring SQL Server Databases Understanding the restore process Restoring databases Working with point-in-time recovery Restoring system databases and individual files Lab: Restoring SQL Server User DatabasesModule 8: Automating SQL Server Management Automating SQL Server management Working with SQL Server agent Managing SQL Server agent jobs Multi-server management Lab: Automating SQL Server ManagementModule 9: Configuring Security for SQL Server Agent Understanding SQL Server Agent Security Configuring credentials Configuring proxy accounts Lab: Configuring Security for SQL Server AgentModule 10: Monitoring SQL Server with Alerts and Notifications Configuration of database mail Monitoring SQL Server errors Configuring operators, alerts, and notifications Alerts in Azure SQL database Lab: Monitoring SQL Server with Alerts and NotificationsModule 11: Introduction to Managing SQL Server by using PowerShell Configure SQL Server using PowerShell Administer SQL Server using PowerShell Maintain the SQL Server environment using PowerShell Managing Azure SQL Server databases using PowerShell Lab: Administering SQL Server using PowerShellModule 12: Tracing Access to SQL Server Capturing activity using SQL Server profiler Improving performance with the database engine tuning advisor Working with tracing options Distributed replay Monitoring locks Lab: Tracing Access to SQL ServerModule 13: Monitoring SQL Server Monitoring activity Capturing and managing performance data Analyzing collected performance data SQL Server utility Lab: Monitoring SQL ServerModule 14: Troubleshooting SQL Server SQL Server troubleshooting methodology Resolving service related issues Resolving login and connectivity issues Troubleshooting common issues Lab: Troubleshooting Common IssuesModule 15: Importing and Exporting Data Transferring data to/from SQL Server Importing and exporting table data Using BCP and BULK INSERT to import data Deploying and upgrading data-tier applications Lab: Importing and Exporting DataModule 16: SQL Server 2016 Components Introduction to the SQL Server Platform Overview of SQL Server Architecture SQL Server Services and Configuration Options Lab: SQL Server Versions (Discussion session)Module 17: Installing SQL Server 2016 Considerations for installing SQL Server TempDB Files Installing SQL Server 2016 Automating Installation Lab: Installing SQL ServerModule 18: Upgrading SQL Server to SQL Server 2016 Upgrade Requirements Upgrade SQL Server Services Migrating SQL Server Data and Applications Lab: Upgrading SQL ServerModule 19: Deploying SQL Server on Microsoft Azure SQL Server Virtual Machines in Azure Deploying an Azure SQL Database Migrating an On-Premise Database to an Azure SQL Database Lab: Migrating SQL Server with AzureModule 20: Working with Databases Overview of SQL Server Databases Creating Databases Database Files and Filegroups Moving Database Files Buffer Pool Extension Lab: Migrating SQL Server with AzureModule 21: Database Storage Options SQL Server storage Performance SMB Fileshare SQL Server Storage in Azure Stretch Databases Lab: Implementing Stretch DatabaseModule 22: Performing Database Maintenance Ensuring Database Integrity Maintaining Indexes Automating Routine Database Maintenance Lab: Migrating SQL Server with Azure