55353: Administering a SQL Database Infrastructure

Course DateStart TimeEnd TimeTime ZoneLocationDaysPrice
May 6, 202409:0005:00EDTLive Virtual Class5$3,695 USDPurchase
Jun 24, 202409:0005:00EDTLive Virtual Class5$3,695 USDPurchase


55353

Administering a SQL Database Infrastructure

This instructor-led course provides those who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure.

Duration: 5 Days

Prerequisites

  • Professional experience
  • 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

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
  • 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

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