Microsoft SQL     <<< zurück

Administering a SQL Database Infrastructure

This five-day instructor-led course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure. Additional it will be of use to individuals who develop applications that deliver content from SQL Server databases.


 Authenticating and Authorizing Users

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

Assigning Server and Database Roles

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

Authorizing Users to Access Resources

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

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

SQL Server Recovery Models

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

Backup of SQL Server Databases

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

Restoring SQL Server Databases

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

Automating SQL Server Management

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

Configuring Security for SQL Server Agent

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

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

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

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

Monitoring SQL Server

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

Troubleshooting SQL Server

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

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


  • 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.
Kurs-Nr.            MOC 20764
Dauer                5 Tage
Preis                  2.350 € (zzgl. MwSt)
Zur Seminaranfrage