Administering Microsoft SQL Server

Description

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.