Installing and Protecting SQL Server (1 day)


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.

While our courses are based on SQL Server 2017, 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, SQL Server 2014 and SQL Server 2016. Where there are differences between versions, the differences are clearly highlighted.

 CITY DATES COURSE PRICE EARLY BIRD PRICE
Melbourne 10 Dec 2018

$720+GST

$612+GST if paid by Nov 19

DAY 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
DAY 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
DAY 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
DAY 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