+44 (0)1737 821590
Administering Microsoft SQL Server  |    A 3 day   hands on   training course

Administering Microsoft SQL Server 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.

What will you learn
  • 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 course details

Administering Microsoft SQL Server course contents

  • Introduction to SQL Server administration
  • Database administration, SQL Server platform, database management tools and techniques.
    Hands on 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.
    Hands on Configuring tempdb storage, creating databases, attaching a database.

  • Importing and exporting data
  • Transferring data, importing and exporting table data, copying or moving a database.
    Hands on 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.
    Hands on Baseline metrics, monitoring a workload.

  • Tracing SQL Server activity
  • Tracing workload activity, using traces.
    Hands on 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.
    Hands on SQL Server security. Testing access.

Learning path

Reviews

5.0

Based on overall ratings

M. H. - Bovis Homes

"Able to customise course which was excellent."


D. R. - Janet

"Good pace. Well tailored to fit the needs of the group."

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.