SQL Server Administration: The Complete Course
(SQLADCP, Live Instructor-Led Training, 4 days)


Description

This SETC certified course covers every aspect of database administration in a production SQL Server environment. Beginning with the configuration of the underlying operating system, the course explores every aspect of the installation and configuration process in both a dedicated and virtual topology. We then tackle the creation of databases, files and filegroups in complex multi-server environments. This is followed by detailed discussions of data import and export, backup and recovery, SQL Server security, SQL Server monitoring and performance tuning. This course also includes a full discussion of indexes, index types and performance tuning. The course concludes with an extensive hands-on lab that allows participants to practice the skills that they have learned in the course.

Dates and Pricing


Jan 23 to Jan 26, 2018$2,500/person Feb 20 to Feb 23, 2018$2,500/person Mar 20 to Mar 23, 2018$2,500/person

Outline

Introduction to SQL Server and its Toolset
Overview of SQL Server Services
SQL Server Services and Features
Working with SQL Server Tools
Designing the Environment: Creating Accounts and Configuring the Firewall
About Virtualizing SQL Server
Configuring Services in an Enterprise Environment
Configuring Protocols: Server and Client
Configuring DCOM Components for Enterprise Applications
Configuring SQL Server Browser
Modifying the Operating System for Performance
Installing SQL Server 2016
Tweaking SQL Server Memory
Configuring TempDB
Working with Databases
About SQL Server Databases. Files and Filegroups
Planning for Space Usage
Creating Databases with TSQL
Creating Files and Filegroups
Attaching and Detaching Database Files
About Database Settings
Retrieving Key Database Information using TSQL
Backup and Recovery
About SQL Server Recovery Models
About Full, Transactional and Incremental Backups
Delving Deeper into Transaction Logging
Planning a SQL Server Backup Strategy
Performing a Backup using TSQL
About Backup Options
Performing a Recovery using TSQL
About Recovery Options
Performing a Point in Time Recovery
Backup Strategies for System Databases
Importing and Exporting Data
Overview of Import/Export Tools
Importing/Exporting Data using Graphical Tools
Importing/Exporting Data using TSQL
Importing/Exporting Data using Integration Services
SQL Server Security
Understanding SQL Server Security Modes
Understanding SQL Server Logins, Users and Roles
Creating SQL Server Logins
Working with Server Roles
Working with Users and Database Roles
Creating Database Roles
Security and Stored Procedure Execution
Troubleshooting Data Access Issues
SQL Server Event Management and Auditing
Enabling SQL Server Auditing
Auditing Data Access in SQL Server
Managing Auditing
Configuring SQL Server Agent
Creating and Scheduling Jobs and Alerts
Creating Operators and Notifications
Ensuring Database Integrity
Maintaining Indexes
Automating Routine Database Maintenance
Working with indexes
Understanding the Anatomy of CRUD Operations
Understanding Page Internals
Understanding Indexes, Index Types and Table Storage
About Fragmentation and Data Storage
Creating Clustered Indexes
Creating Non-Clustered Indexes
Rebuilding Indexes
Managing Fragmentation
Tuning TSQL Statements
Tracing Access to SQL Server
Capturing Activity using SQL Server Profiler
Improving Performance with the Database Engine Tuning Advisor
Working with Tracing Options
Monitoring Activity
Capturing and Managing Performance Data
Analyzing Collected Performance Data
Troubleshooting Common SQL Server Issues
Complete SQL Server Troubleshooting Lab