55316 Administering a SQL Database

Duration

5 Days

30 CPD hours

This course is intended for

The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job. The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases.

Overview

After completing this course, you will be able to:
Authenticate and authorize users
Assign server and database roles
Authorize users to access resources
Use encryption and auditing features to protect data
Describe recovery models and backup strategies
Backup and Restore SQL Server databases
Automate database management
Configure security for the SQL Server agent
Manage alerts and notifications
Managing SQL Server using PowerShell
Trace access to SQL Server
Monitor a SQL Server infrastructure
Troubleshoot a SQL Server infrastructure
Import and export data

This course will provide training in how to administer and maintain SQL Server, Azure SQL Database and other cloud-based SQL Server databases. IT professionals who work in environments where databases play a key role in their job will find this material useful. By using demonstrations and hands-on lab exercises, students will learn to carry out these important tasks.
This course covers content that was in retired Microsoft Course 20764: Administering a SQL Database Infrastructure.

1 - Creating advanced functions

• Lesson 1: Converting a command into an advanced function
• Lesson 2: Creating a script module
• Lesson 3: Defining parameter attributes and input validation
• Lesson 4: Writing functions that accept pipeline input
• Lesson 5: Producing complex pipeline output
• Lesson 6: Using comment-based Help
• Lesson 7: Using Whatif and Confirm parameters

2 - Using Microsoft .NET Framework and REST API in Windows PowerShell

• Lesson 1: Using .NET Framework in PowerShell
• Lesson 2: Using REST API in PowerShell

3 - Writing controller scripts

• Lesson 1: Understanding controller scripts
• Lesson 2: Writing controller scripts with a user interface
• Lesson 3: Writing controller scripts that create reports

4 - Handling script errors

• Lesson 1: Understanding error handling
• Lesson 2: Handling errors in a script

5 - Using XML, JSON, and custom-formatted data

• Lesson 1: Working with XML formatted data
• Lesson 2: Working with JSON formatted data
• Lesson 3: Working with custom-formatted data

6 - Enhancing server management with Desired State Configuration and Just Enough Administration

• Lesson 1: Implementing Desired State Configuration
• Lesson 2: Implementing Just Enough Administration

7 - Analyzing and debugging scripts

• Lesson 1: Debugging in Windows PowerShell
• Lesson 2: Analyzing and debugging an existing script

8 - Understanding Windows PowerShell Workflow

• Lesson 1: Understanding Windows PowerShell Workflows
• Lesson 2: Running Windows PowerShell Workflows