Training
SQL Server Administration Core Skills
SQL Server is Microsoft's primary database management tool. This course is designed to take you through the most important aspects of SQL Server Administration, with just the right amount of depth, within five days.

The course is most suitable for those that need to manage a SQL Server system (including "Accidental DBAs" such as developers) and for DBAs that want to update or refresh their skills. While not essential to complete the labs (as full detailed instructions are provided), some knowledge of T-SQL would be helpful.

The course starts by looking at what's involved in planning for and implementing the installation of SQL Server, then continues through working with database files and filegroups. Next you'll cover how to backup and restore systems and how to secure and audit them. During the third day, you'll learn how to automate the management of a server and how to import and export data. The fourth day will see you learning how to monitor the server and how to improve its capabilities through the implementation of partitioning and compression. Finally, on day five, you'll learn how to plan for more advanced capabilities with filestream, replication, and high availability. To round out the course, you'll see how to resolve some of the common problems that DBAs deal with regularly.

While the course isn't targeted directly at achieving certification through Microsoft Exam 70-462, we believe that it provides the best coverage of the material required for that exam, of any five day administration course that is available.

Even though our courses are based on SQL Server 2014, 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
2
AD205
Managing Users and Roles
- Working with SQL Server Authentication Options
- Managing Database Users
- Managing Server and Database Roles
- LAB: Managing Users and Roles
2
AD206
Managing Server and Database Permissions
- Managing Permissions for Server Objects
- Managing Permissions for Database Objects
- Managing Permissions for Code Execution
- LAB: Managing Server and Database Permissions
2
AD207
Managing SQL Server Certificates and Encryption
- Understanding Certificates and Encryption
- Managing Column Encryption
- Managing Transparent Database Encryption
- Managing Extensible Key Management
- LAB: Managing SQL Server Certificates and Encryption
2
AD208
Auditing SQL Server Databases
- Understanding Audit Options for SQL Server
- Configuring SQL Server Audits
- Configuring Server Audit Specifications
- Configuring Database Audit Specifications
- Reading Audit Output
- LAB: Auditing SQL Server Databases
3
AD209
Understanding SQL Server Table and Index Structures
- Understanding Table Structures
- Understanding Nonclustered Indexes
- Understanding Indexed Views
- LAB: Understanding SQL Server Table Structures
3
AD210
Implementing Table Partitioning
- Working with Partition Functions and Partition Schemes
- Working with Partitioned Tables
- Implementing Sliding-Window Designs
- Switching Data In and Out of Partitioned Tables
- LAB: Implementing Table Partitioning
3
AD211
Implementing Table Compression
- Understanding Compression
- Implementing Row and Page Compression
- Implementing Column Store Indexes
- Upcoming SQL Server 2014 Enhancements
- LAB: Implementing Table Compression
3
AD212
Implementing Filestream and FileTables
- Understanding Filestream
- Implementing Filestream
- Implementing FileTables
- LAB: Implementing Filestream and FileTables
4
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
4
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
4
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
4
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
5
AD217
Introducing Resource Governor Concepts
- Introducing Resource Governance Requirements
- Alternatives to Resource Governor
- Introducing Resource Governor
- LAB: Introducing Resource Governor Concepts
5
AD218
Introducing Replication Concepts
- Introducing Publications, Distribution, and Subscriptions
- Introducing Transactional, Snapshot, and Peer-to-Peer Replication
- Introducing Merge Replication
- LAB: Introducing Replication Concepts
5
AD219
Introducing Policy Based Management and Data Collection Concepts
- Introducing Policy Management Requirements
- Alternatives to Policy Based Management
- Introducing Policy Based Management
- Introducing Data Collection
- Introducing Policy Based Management and Data Collection Concepts
5
AD220
Introducing High Availability Concepts
- Defining High Availability
- Introducing Log Shipping
- Introducing Database Mirroring
- Introducing Failover Clustering
- Introducing Availability Groups
- LAB: Introducing High Availability Concepts
Phone: 1300 SQL SQL (1300 775 775) l International +61 1300 775 775 l Fax: +61 3 8676-4913
Copyright 2014 by SQL Down Under | Terms Of Use | Privacy Statement | Client login