SQL Server Administration Core Skills (5 days)


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 exams, we believe that it provides the best coverage of the material required for the administration exams, of any five day administration course that is available.

 

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
On-demand Please contact us

 



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
DAY 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
DAY 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
DAY 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
DAY 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
DAY 3 AD209 UNDERSTANDING SQL SERVER TABLE AND INDEX STRUCTURES
Understanding Table Structures
Understanding Nonclustered Indexes
Understanding Indexed Views
Understanding In-Memory Tables and Natively Compiled Stored Procedures
LAB: Understanding SQL Server Table Structures
DAY 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
DAY 3 AD211 IMPLEMENTING TABLE COMPRESSION

Understanding Compression
Implementing Row and Page Compression
Implementing Column Store Indexes
SQL Server 2014 and 2016 Enhancements
LAB: Implementing Table Compression
DAY 3 AD212 MPLEMENTING FILESTREAM AND FILETABLES
Understanding Filestream
Implementing Filestream
Implementing FileTables
LAB: Implementing Filestream and FileTables
DAY 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
DAY 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
DAY 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
DAY 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
DAY 5 AD217 INTRODUCING RESOURCE GOVERNOR CONCEPTS
Introducing Resource Governance Requirements
Alternatives to Resource Governor
Introducing Resource Governor
LAB: Introducing Resource Governor Concepts
DAY 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
DAY 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
DAY 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