Administering Microsoft SQL Server

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

Administering Microsoft SQL Server course details

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

Database administration, SQL Server platform, database management tools and techniques.

Hands on SQL Server Management Studio, sqlcmd Windows PowerShell with SQL Server.

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.

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, dynamic management views and functions, performance monitor.

Hands on Baseline metrics, monitoring a workload.

Tracing workload activity, using traces.

Hands on Capturing a trace in SQL Server profiler, generating tuning recommendations.

SQL Server security, server-level security, database-level principals, database permissions.

Hands on SQL Server security. Testing access.