Training
Automating SQL Server Management
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 create and schedule automated tasks using SQL Server Agent. An introduction to importing and exporting data is also provided. 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
AD213
Using SQL Server Agent to Automate Management
- Implementing SQL Server Agent Jobs
- Scheduling SQL Server Jobs
- Securing SQL Server Jobs using Credentials and Proxy Accounts
- LAB: Using SQL Server Agent to Automate Management
1
AD214
Using Alerts and Notifications to Monitor SQL Server Servers and Jobs
- Implementing Database Mail
- Implementing Operators
- Implementing Alerts and Notifications
- Troubleshooting Job Failures
- LAB: Using Alerts and Notifications to Monitor SQL Server Servers and Jobs
1
AD215
Automating Routine Database Maintenance
- Using DBCC CHECKDB to Check Database Consistency and Allocations
- Rebuilding and Reorganizing Indexes to Correct Index Fragmentation
- Using Database Maintenance Plans
- Alternatives to the Microsoft Database Maintenance Plan Wizard
- LAB: Automating Routine Database Maintenance
1
AD216
Importing and Exporting SQL Server Data
- Using bcp
- Using BULK INSERT
- Using OPENROWSET
- Using SQL Server Integration Services
- LAB: Importing and Exporting SQL Server Data
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