Administering a SQL Database Infrastructure

LocationGlasgow

Price ex. VAT
2321 GBP

Start Date03 June 2019

Course typeEssentials

Course codeM20764

Duration5 Days

This five-day instructor-led course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure. Additional it will be of use to individuals who develop applications that deliver content from SQL Server databases.

Audience profile
The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job.

The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases. At course completion

Prerequisites

In addition to their professional experience, students who attend this training should already have the following technical knowledge:

Basic knowledge of the Microsoft Windows operating system and its core functionality.

Module 5: SQL Server Recovery Models
This module describes the concept of the transaction log and SQL Server recovery models. It also introduces the different backup strategies available with SQL Server.

Module 8: Automating SQL Server Management
This module describes how to use SQL Server Agent for automation. It also explains the benefits of using master and target servers to centralize the administration of automation.

Module 12: Tracing Access to SQL Server
This module describes how to use SQL Profiler and SQL Trace stored procedures to capture information about SQL Server. The module also describes how to use Distributed Replay to capture trace information from multiple servers, and how to monitor locking.

Lessons

Capturing activity using SQL Server profiler

Improving performance with the database engine tuning advisor

Working with tracing options

Distributed replay

Monitoring locks

Lab : Tracing Access to SQL Server

Module 13: Monitoring SQL Server
This module explains how to use Distributed Management Views to monitor SQL Server. It also describes configuration of data collection and the SQL Server Utility.

Lessons

Monitoring activity

Capturing and managing performance data

Analyzing collected performance data

SQL Server utility

Lab : Monitoring SQL Server

Module 14: Troubleshooting SQL Server
This module explains the SQL Server troubleshooting methodology and discusses the most common issues that can arise when working with SQL Server systems.

Lessons

SQL Server troubleshooting methodology

Resolving service related issues

Resolving login and connectivity issues

Troubleshooting common issues

Lab : Troubleshooting Common Issues

Module 15: Importing and Exporting Data
This module covers the use of the import/export wizards and explains how they relate to SSIS. The module also introduces BCP and BULK INSERT.

Lessons

Transferring data to/from SQL Server

Importing and exporting table data

Using BCP and BULK INSERT to import data

Deploying and upgrading data-tier applications

Lab : Importing and Exporting Data

Book the course: Administering a SQL Database Infrastructure

*
Number of Attendees

*
Salutation:

*
Firstname:

*
Last Name:

*
Email:

* Attendees Names:

Software Version:

* Telephone No:

Company:

How did you here about us:

Voucher Code:

Comments:

FROG would love to keep in touch about future offers and services we think you’ll like to hear about. To confirm you would like to receive this information by email, please tick the box. Don’t forget, you can also change your marketing contact preferences at any time by emailing training@frog.co.uk or by using the unsubscribe links which you’ll find on all our marketing emails. For further information please see our Privacy Policy