IT Skills Data and Databases Microsoft SQL Server SQL Server 2016
SQL Server 2016 is a scalable database platform with advanced security and analytics, Business Intelligence, and hybrid cloud features. This course covers the tasks and tools involved in administering a SQL Server 2016 database infrastructure and also the objectives for exam 70-764: Administering a SQL Database Infrastructure. This exam is part of the MCSA: SQL 2016 Database Administration certification.
| Objectives |
Backing up Databases - describe the reasons for backing up a database and supported backup types
- determine the appropriate strategy for backing up a database
- determine the appropriate media for backing up a database
- recognize how to plan a retention policy for backing up databases
- create a backup using SQL Server Management Studio
- create a backup using Transact-SQL
- describe how transaction log backup works
- create an automated backup job in SQL Server Management Studio
Backing up to Azure SQL Databases - describe the features and benefits of backing up a database to the Azure Blob Storage Service
- describe best practice and troubleshooting tips for backing up to the Azure Blob Storage Service
- back up a database to Azure
Using Recovery Models - describe the purpose of the three recovery models
- view and change recovery models using SQL Server Management Studio
- recognize how to view and change recovery models using Transact-SQL
- describe tasks that should be completed after changing the recovery model
Restoring a Database - recognize what is involved in restoring a database, what can be restored, and restore scenario models
- describe the purpose and prerequisites of restoring a database backup under the simple recovery model
- restore a database under the simple recovery model
- describe the purpose of and considerations for restoring a database under the full recovery model
- restore a database under the full recovery model
- restore a database under the full recovery model
- automate and test restores
Performing Point-in-time Recovery - describe point-in-time recovery and perform point-in-time recovery using SQL Server Management Studio
- perform point-in-time recovery using Transact-SQL
Performing File and Page Restores - describe the goal of file restore and how it differs in the simple recovery model versus the full recovery model
- Restoring File and Filegroups
- restore files to a new location
- restore files and filegroups over existing files
- recognize when a page restore is useful, as well as its limitations and restrictions
- restore pages using SQL Server Management Studio and Transact-SQL
Using Piecemeal Restores - describe the purpose and process of piecemeal restore
- describe the purpose and requirements of piecemeal restore in the simple recovery model
- describe the purpose and requirements of piecemeal restore in the full recovery model
- restore a database using a piecemeal restore
|
