M20462 Administering Microsoft SQL Server Databases

GB Direct

Course

In London, Manchester, Bristol and 7 other venues

£ 995 + VAT

The best SQL Server courses

See all

See all

Description

  • Type

    Course

This five-day instructor-led course provides delegates with the knowledge and skills to maintain a Microsoft SQL Server 2014 database. The course focuses on teaching individuals how to use SQL Server 2014 product features and tools related to maintaining a database.

Facilities

Location

Start date

Birmingham (West Midlands)

Start date

On request
Bristol (Avon)

Start date

On request
Exeter (Devon)

Start date

On request
Glasgow (Glasgow City)

Start date

On request
Leeds (North Yorkshire)

Start date

On request
London
See map
Clerks Court 18-20 Farringdon Lane Clerkenwell, EC1R 3AU

Start date

On request
Manchester (Greater Manchester)

Start date

On request
Reading (Berkshire)

Start date

On request
Swindon (Wiltshire)

Start date

On request
Wokingham (Berkshire)

Start date

On request
See all (10)

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • IT
  • Server
  • SQL

Course programme

Introduction to SQL Server 2014 Database Administration

  • Database Administration Overview
  • Introduction to the SQL Server Platform
  • Database Management Tools and Techniques

Installing and Configuring SQL Server 2014

  • Planning SQL Server Installation
  • Installing SQL Server 2014
  • Post-Installation Configuration

Working with Databases and Storage

  • Introduction to Data Storage with SQL Server
  • Managing Storage for System Databases
  • Managing Storage for User Databases
  • Moving Database Files
  • Configuring the Buffer Pool Extension

Planning and Implementing a Backup Strategy

  • Understanding SQL Server Recovery Models
  • Planning a Backup Strategy
  • Backing up Databases and Transaction Logs
  • Using Backup Options
  • Ensuring Backup Reliability

Restoring SQL Server 2014 Databases

  • Understanding the Restore Process
  • Restoring Databases
  • Advanced Restore Scenarios
  • Point-in-Time Recovery

Importing and Exporting Data

  • Introduction to Transferring Data
  • Importing and Exporting Data
  • Copying or Moving a Database

Monitoring SQL Server 2014

  • Introduction to Monitoring SQL Server
  • Dynamic Management Views and Functions
  • Performance Monitor

Tracing SQL Server Activity

  • Tracing SQL Server Workload Activity
  • Using Traces

Managing SQL Server Security

  • Introduction to SQL Server Security
  • Managing Server-Level Security
  • Managing Database-Level Principals
  • Managing Database Permissions

Auditing Data Access and Encrypting Data

  • Auditing Data Access in SQL Server
  • Implementing SQL Server Audit
  • Encrypting Databases

Performing On-going Database Maintenance

  • Ensuring Database Integrity
  • Maintaining Indexes
  • Automating Routine Database Maintenance

Automating SQL Server 2014 Management

  • Automating SQL Server Management
  • Implementing SQL Server Agent Jobs
  • Managing SQL Server Agent Jobs
  • Managing Job Step Security Contexts
  • Managing Jobs on Multiple Servers

Monitoring SQL Server 2014 with Notifications and Alerts

  • Monitoring SQL Server Errors
  • Configuring Database Mail
  • Configuring Operators, Notifications, and Alerts

Follow-On Courses

  • M20463 Implementing a Data Warehouse with Microsoft SQL Server

See related categories

M20462 Administering Microsoft SQL Server Databases

£ 995 + VAT

The best SQL Server courses

See all

See all