Training
Installing and Protecting SQL Server
SQL Server is Microsoft's primary database management tool. This course is designed to take you through a critical aspect of SQL Server Administration, with just the right amount of depth, within one day.

The course is most suitable for those that need to know how to install, backup, and restore a SQL Server system. While not essential to complete the labs (as full detailed instructions are provided), some knowledge of T-SQL would be helpful.

Even though our courses are based on SQL Server 2016, we realise that many customers are not yet running that version. Rather than provide you a course that only covers a single version of SQL Server, our courses are designed to be relevant (wherever possible) to a range of SQL Server versions including SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 and SQL Server 2014. Where there are differences between versions, the differences are clearly highlighted.

City
Dates
Course Price
Early Bird Price
There isn't a public offering for this course scheduled at present but please contact us to register your interest or to request a quote for private training.
Day
Code
Module
1
AD201
Installing and Configuring SQL Server Components
- Planning for SQL Server Installation
- Preparing Systems for SQL Server Installation
- Virtualizing SQL Server
- Installing SQL Server
- LAB: Installing SQL Server Components
1
AD202
Managing SQL Server Databases
- Understanding System and User Databases
- Managing User Database Files and Filegroups
- Managing System Databases
- LAB: Managing SQL Server Databases
1
AD203
Planning a SQL Server Backup and Recovery Strategy
- Understanding the SQL Server Transaction Log and Recovery Models
- Understanding SQL Server Backup Types
- Understanding SQL Server Recovery Types
- LAB: Planning a SQL Server Backup and Recovery Strategy
1
AD204
Implementing SQL Server Backup and Recovery
- Implementing Database Backups
- Implementing Transaction Log Backups
- Implementing Database Full and Point-In-Time Restores and Standby
- Implementing System Database Restores
- LAB: Implementing SQL Server Backup and Recovery
Phone: 1300 SQL SQL (1300 775 775) l International +61 1300 775 775 l Fax: +61 3 8676-4913
Copyright 2017 by SQL Down Under | Terms Of Use | Privacy Statement