Description

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

Course Images

55316 Administering a SQL Database

By Nexus Human

Booking options

Highlights

Description

About The Provider

Tags

Reviews