Setup Menus in Admin Panel

Course Detail

Administering a SQL Database Infrastructure - MS20764

$0 $0

Administering a SQL Database Infrastructure - MS20764

Download pdf
Request Course Detail

In addition to their professional experience, students who attend this training should already have the following technical knowledge: Basic knowledge of the Microsoft Windows operating system and its core functionality; Working knowledge of Transact-SQL; Working knowledge of relational databases; Some experience with database design.

5 - SQL Server Recovery Models

Backup strategies

Understanding SQL Server transaction login

Planning a SQL Server backup strategy

Lab: Understanding SQL Server recovery models

6 - Backup of SQL Server Databases

Backing up databases and transaction logs

Managing database backups

Working with backup options

Lab: Backing up SQL Server databases

7 - Restoring SQL Server Databases

Understanding the restore process

Restoring databases

Working with point-in-time recovery

Restoring system databases and individual files

Lab: Restoring SQL Server User Databases

8 - Automating SQL Server Management

Automating SQL Server management

Working with SQL Server agent

Managing SQL Server agent jobs

Multi-server management

Lab: Automating SQL Server Management

9 - Configuring Security for SQL Server Agent

Understanding SQL Server Agent Security

Configuring credentials

Configuring proxy accounts

Lab: Configuring Security for SQL Server Agent

10 - Monitoring SQL Server with Alerts & Notifications

Configuration of database mail

Monitoring SQL Server errors

Configuring operators, alerts, and notifications

Alerts in Azure SQL database

Lab: Monitoring SQL Server with Alerts and Notifications

11 - Introduction to Managing SQL Server by Using PowerShell

Configure SQL Server using PowerShell

Administer SQL Server using PowerShell

Maintain the SQL Server environment using PowerShell

Managing Azure SQL Server databases using PowerShell

Lab: Administering SQL Server using PowerShell

12 - Tracing Access to SQL Server

Capturing activity using SQL Server profiler

Improving performance with the database engine tuning advisor

Working with tracing options

Distributed replay

Monitoring locks

Lab: Tracing Access to SQL Server

13 - Monitoring SQL Server

Monitoring activity

Capturing and managing performance data

Analyzing collected performance data

SQL Server utility

Lab: Monitoring SQL Server

14 - Troubleshooting SQL Server

SQL Server troubleshooting methodology

Resolving service related issues

Resolving login and connectivity issues

Troubleshooting common issues

Lab: Troubleshooting Common Issues

15 - Importing & Exporting Data

Transferring data to/from SQL Server

Importing and exporting table data

Using BCP and BULK INSERT to import data

Deploying and upgrading data-tier applications

Lab: Importing and Exporting Data
After completing this course, students will be able to: Authenticate and authorize users Assign server and database roles Authorize users to access resources Protect data with encryption and auditing Describe recovery models and backup strategies Backup SQL Server databases 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 provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure.
1 - Authenticating and Authorizing Users

Authenticating connections to SQL Server

Authorizing logins to access databases

Authorization across servers

Partially contained databases

Lab: Authenticating Users

2 - Assigning Servers & Database Roles

Working with server roles

Working with Fixed database roles

Creating user-defined database roles

Lab: Assigning server and database roles

3 - Authorizing Users to Access Resources

Authorizing user access to objects

Authorizing users to execute code

Configuring permissions at the schema level

Lab: Authorizing users to access resources

4 - Protecting Data with Encryption & Auditing

Options for auditing data access in SQL Server

Implementing SQL Server audit

Managing SQL Server audit

Protecting data with encryption

Lab: Using Auditing and Encryption

Copyright 2016