Speak to our team now +44 (0)1737 821590

Administering Microsoft SQL Server

A 5 day
HANDS ON
training course

Microsoft SQL Server training course description

This course provides students with the knowledge and skills to maintain a Microsoft SQL Server database. The course focuses on how to use SQL Server 2014 product features and tools related to maintaining a database. Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.

Key outcomes from this course

By the end of the course delegates 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 ongoing database maintenance.
  • Automate SQL Server maintenance with SQL Server Agent Jobs.
  • Configure Database Mail, alerts and notifications.

Microsoft SQL Server training course details

Who will benefit:
The primary audience for this course is individuals who administer and maintain SQL Server databases.
The secondary audience for this course is individuals who develop applications that deliver content from SQL Server databases.
Prerequisites:
Querying Microsoft SQL server
Duration:
5 days

Training approach

This structured training course seeks to build upon workbook learning through the use of group exercises, dynamic discussion and individual tasks in order to deliver an engaging and interactive module that will ensure all candidates are able to transfer their new skills into the workplace.

Overall ratings for this course:

Course review


"Hard concepts were explained very simply."
J. S., Framestore CFC
"Excellent presentation - very good course structure."
B. M., London Internet Exchange

Microsoft SQL Server training course contents

Introduction to SQL Server administration
Database administration, SQL Server platform, database management tools and techniques. Lab: SQL Server Management Studio, sqlcmd Windows PowerShell with SQL Server.

Installing and configuring SQL Server 2014
Planning SQL Server installation, installing SQL Server 2014, post-installation configuration. Lab: installing SQL Server.

Working with databases and storage
Data storage with SQL Server, managing storage for system databases, managing storage for user databases, moving database files, configuring the buffer pool extension. Lab: Configuring tempdb storage, creating databases, attaching a database.

Backups
SQL Server recovery models, backup strategies, backing up databases and transaction logs, backup options, ensuring backup reliability Lab: Backing up database, database differential, and transaction log backups, partial backup.

Restoring SQL Server 2014 databases
The restore process, restoring databases, advanced restore scenarios, point-in-time recovery. Lab: restoring databases.

Importing and exporting data
Transferring data, importing and exporting table data, copying or moving a database. Lab: import and export wizard, bcp utility, BULK INSERT statement, OPENROWSET function.

Monitoring SQL Server 2014
Monitoring SQL Server, dynamic management views and functions, performance monitor. Lab: Baseline metrics, monitoring a workload.

Tracing SQL Server activity
Tracing workload activity, using traces. Lab: Capturing a trace in SQL Server profiler, generating tuning recommendations.

Managing SQL Server security
SQL Server security, server-level security, database-level principals, database permissions. Lab: SQL Server security. Testing access.

Auditing data access and encrypting data
Auditing data access in SQL Server, SQL Server audit, encrypting databases. Lab: auditing data access and encrypting data.

Performing ongoing database maintenance
Database integrity, maintaining indexes, automate maintenance. Lab: DBCC CHECKDB.

Automating SQL Server 2014 management
Automating SQL Server management, SQL Server agent jobs, job step security contexts, managing jobs on multiple servers. Lab: Creating a job, scheduling a job, configuring job step security contexts

Alerts and notifications
Monitoring SQL Server errors, configuring database mail, configuring operators, alerts, and notifications. Lab: monitoring SQL Server by using alerts and notifications.

Why Choose Us

SNT trainers score an average of over 90% on the three main areas of:
  • Ability to teach
  • Technical knowledge
  • Answering questions
“Excellently presented by a very knowledgeable and enthusiastic trainer.” P.D. General Dynamics

We limit our maximum class size to 8 delegates; often we have less than this. This ensures optimal interactivity between delegates and instructor.
"Excellent course. The small class size was a great benefit…" M.B. IBM

We write our own courses; courseware does not just consist of slides and our slides are diagrams not bullet point text. A typical chapter provides clearly defined objectives with a chapter overview, slides with text underneath, a quiz at the end to check the learning of the students. Hands on exercises are at the end and are used to reinforce the theory.

See Dates & Prices for this course

To enquire about this course

To reserve this course online