1­-855­-778­-7246

Administering a SQL Database Infrastructure (20764)

 

Course Content

This hands-on, 5-day instructor-led course teaches you the knowledge and skills to fully administer a SQL server database infrastructure.

Who should attend

  • IT professionals responsible for administering and maintaining SQL Server databases
  • Anyone pursuing their MCSA: SQL Server 2016 Database Administration
  • Application Developers that work with SQL Server databases

Prerequisites

  • Basic knowledge of the Microsoft Windows operating system and its core functionality
  • Working knowledge of Transact-SQL and relational databases
  • Some experience with database design

Course Objectives

  • 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

Follow On Courses

Outline: Administering a SQL Database Infrastructure (20764)

Module 1: Authenticating and Authorizing Users

  • Authenticating connections to SQL Server
  • Authorizing logins to access databases
  • Authorization across servers
  • Partially contained databases

Module 2: Assigning Server and Database Roles

  • Working with server roles
  • Working with Fixed database roles
  • Creating user-defined database roles

Module 3: Authorizing Users to Access Resources

  • Authorizing user access to objects
  • Authorizing users to execute code
  • Configuring permissions at the schema level

Module 4: Protecting Data with Encryption and Auditing

  • Options for auditing data access in SQL Server
  • Implementing SQL Server audit
  • Managing SQL Server audit
  • Protecting data with encryption

Module 5: SQL Server Recovery Models

  • Backup strategies
  • Understanding SQL Server transaction login
  • Planning a SQL Server backup strategy

Module 6: Backup of SQL Server Databases

  • Backing up databases and transaction logs
  • Managing database backups
  • Working with backup options

Module 7: Restoring SQL Server Databases

  • Understanding the restore process
  • Restoring databases
  • Working with point-in-time recovery
  • Restoring system databases and individual file

s

Module 8: Automating SQL Server Management

  • Automating SQL Server management
  • Working with SQL Server agent
  • Managing SQL Server agent jobs
  • Multi-server management

Module 9: Configuring Security for SQL Server Agent

  • Understanding SQL Server Agent Security
  • Configuring credentials
  • Configuring proxy accounts

Module 10: Monitoring SQL Server with Alerts and Notifications

  • Configuration of database mail
  • Monitoring SQL Server errors
  • Configuring operators, alerts, and notifications
  • Alerts in Azure SQL database

Module 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

Module 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

Module 13: Monitoring SQL Server

  • Monitoring activity
  • Capturing and managing performance data
  • Analyzing collected performance data
  • SQL Server utility

Module 14: Troubleshooting SQL Server

  • SQL Server troubleshooting methodology
  • Resolving service related issues
  • Resolving login and connectivity issues
  • Troubleshooting common issues

Module 15: Importing and 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

Labs

  • Authenticating Users
  • Assigning server and database roles
  • Authorizing users to access resources
  • Using Auditing and Encryption
  • Understanding SQL Server recovery models
  • Backing up SQL Server databases
  • Restoring SQL Server User Databases
  • Automating SQL Server Management
  • Configuring Security for SQL Server Agent
  • Monitoring SQL Server with Alerts and Notifications
  • Administering SQL Server using PowerShell
  • Tracing Access to SQL Server
  • Monitoring SQL Server
  • Troubleshooting Common Issues
  • Importing and Exporting Data
Online Training

Duration 5 days

Price
  • CAD 2,895
  • SA Voucher: 5
Classroom Training

Duration 5 days

Price
  • Canada: CAD 2,895
  • SA Voucher: 5
 
Click on town name to book Schedule
This is an Instructor-Led Classroom course
Instructor-led Online Training:   This computer icon in the schedule indicates that this date/time will be conducted as Instructor-Led Online Training.
This is a FLEX course, which is delivered both virtually and in the classroom.
  *   This class is delivered by a partner.
Canada

Currently there are no training dates scheduled for this course.  For enquiries please write to info@fastlaneca.com.

Fast Lane Flex™ Classroom If you can't find a suitable date, don't forget to check our world-wide FLEX training schedule.