55316: Administering a SQL Database

Course DateStart TimeEnd TimeTime ZoneLocationDaysPrice
Feb 6, 202309:0005:00ESTIn Class or by Video Conference5$3,695 USDPurchase
Apr 17, 202309:0005:00EDTIn Class or by Video Conference5$3,695 USDPurchase


55316

Administering a SQL Database

This instructor-led 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, you will learn to carry out these important tasks.

Duration: 5 Days

Prerequisites

  • Experience using applications on Windows Servers
  • Experience working with SQL Server or another RDMS

Audience

  • Individuals who administer and maintain SQL Server databases
  • Individuals who develop applications that deliver content from SQL Server databases

Learning Objectives

  • 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

Topics

  • SQL Server Security
  • Assigning Server and Database Roles
  • Authorizing Users to Access Resources
  • Protecting Data with Encryption and Auditing
  • Recovery Models and Backup Strategies
  • Backing Up SQL Server Databases
  • Restoring SQL Server Databases
  • Automating SQL Server Management
  • Configuring Security for SQL Server Agent
  • Monitoring SQL Server with Alerts and Notifications
  • Introduction to Managing SQL Server by using PowerShell
  • Tracing Access to SQL Server with Extended Events
  • Monitoring SQL Server
  • Troubleshooting SQL Server
  • Importing and Exporting Data
Right Menu IconMENU