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

Administering Microsoft SQL Serverr

A 3 day
training course
**Due to the current COVID-19 isolation rules all our courses are being delivered via virtual instructor led learning until further notice**

Administering 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 2016 product features and tools related to maintaining a database.
Note: This course is designed for customers who are interested in learning SQL Server 2014 or SQL Server 2016. It covers the new features in SQL Server 2016, 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.
  • Configure SQL Server databases and storage.
  • Import and export data.
  • Monitor SQL Server.
  • Trace SQL Server activity.
  • Manage SQL Server security.
  • Audit data access and encrypt data.

Administering Microsoft SQL Server training course details

Who will benefit:
Individuals who work with SQL Server databases.
Individuals who develop applications that deliver content from SQL Server databases.
Introduction to data communications & networking.
3 days

Training approach

This structured course uses Instructor Led Training to provide the best possible learning experience. Small class sizes ensure students benefit from our engaging and interactive style of teaching with delegates encouraged to ask questions throughout the course. Quizzes follow each major section allowing checking of learning. Hands on sessions are used throughout to allow delegates to consolidate their new skills.

Overall rating:

Customer reviews

"Excellent use of practical to reinforce theory."
P. R.QinetiQ
"Good content at the right pace."

Administering 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.

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.

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.

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.

Updating Your Skills to SQL Server 2017

See Dates & Prices for this course

To enquire about this course

To reserve this course online