This instructor-led course provides students with the knowledge and skills to administer Microsoft® SQL Server® 2014 Databases. The course focuses on teaching individuals how to use SQL Server 2014 product features and tools related to maintaining a database.

Download the course details
      After completing this course, students will be able to:
    • Describe core database administration tasks and tools
    • Install and configure SQL Server 2014
    • Configure SQL Server databases and storage.
    • Plan and implement a backup strategy.
    • Restore databases from backups.
    • Import and export data.
    • Monitor SQL Server.
    • Trace SQL Server activity.
    • Manage SQL Server security.
    • Audit data access and encrypt data.
    • Perform on-going database maintenance.
    • Automate SQL Server maintenance with SQL Server Agent Jobs.
    • Configure Database Mail, alerts and notifications.
  • Full colour manual or book.
  • Take away exercises used in the course to practice at home.
  • USB stick to take the exercises away (where relevant).
  • Freshly prepared lunch in our onsite cafeteria.
  • Refreshments though out the day.
  • Training in fully air conditioned facilities.
  • Database Adminstration Overview
  • Introduction to the SQL Server Platform
  • Database Management Tools and Techniques
  • Using SQL Server Administrative Tools
  • Planning SQL Server Installation
  • Installing SQL Server 2014
  • Post-Installation Configuration
  • Installing SQL Server 2014
  • 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
  • Managing Database Storage
  • Understanding SQL Server Recovery Models
  • Planning a Backup Strategy
  • Backing up Databases and Transaction Logs
  • Using Backup Options
  • Ensuring Backup Reliability
  • Backing Up Databases
  • Understanding the Restore Process
  • Restoring Databases
  • Advanced Restore Scenarios
  • Point-in-Time Recovery
  • Restoring SQL Server Databases
  • Introduction to Transferring Data
  • Importing and Exporting Data
  • Copying or Moving a Database
  • Importing and Exporting Data
  • Introduction to Monitoring SQL Server
  • Dynamic Management Views and Functions
  • Performance Monitor
  • Monitoring SQL Server 2014
  • Tracing SQL Server Workload Activity 8-2
  • Using Traces 8-9
  • Tracing SQL Server Workload Activity 8-18
  • Introduction to SQL Server Security
  • Managing Server-Level Security
  • Managing Database-Level Principals
  • Managing Database Permissions
  • Managing SQL Server Security
  • Auditing Data Access in SQL Server
  • Implementing SQL Server Audit
  • Encrypting Databases
  • Auditing Data Access and Encrypting Data
  • Ensuring Database Integrity
  • Maintaining Indexes
  • Automating Routine Database Maintenance
  • Performing Ongoing Database Maintenance
  • Automating SQL Server Management
  • Implementing SQL Server Agent Jobs
  • Managing SQL Server Agent Jobs
  • Managing Job Step Security Contexts
  • Managing Jobs on Multiple Servers
  • Automating SQL Server Management
  • Monitoring SQL Server Errors
  • Configuring Database Mail
  • Configuring Operators, Notifications, and Alerts
  • Using Notifications and Alerts
Dates & Prices

This course is run by arrangement for private groups and 1-2-1 sessions.

Please contact us for more information

01483 688488

Contact us

Have a question?

We're here to answer them

01483 688488

Contact us
We’re trusted by