Administering a SQL Database

Course M55316

  • Duration:
    • 5 days

Dates:

Dates on request - if no dates are listed, please contact us to arrange an individual date by e-mail at it-campus@softwareone.com or by phone on +49 341 2568-486.

This five-day course provides delegates who manage SQL Server and Azure SQL databases with the knowledge and skills required to manage a SQL Server database infrastructure. The course is also aimed at people who develop applications that deliver content from SQL Server databases. This material updates and replaces course MOC20764.

Pn this course, participants will gain the following skills:

  • Authenticate and authorise users
  • Assign server and database roles
  • Authorise users to access resources
  • Use encryption and auditing features to protect data
  • Describe recovery models and backup strategies
  • Back up and restore SQL Server databases
  • Automate database administration
  • Configure security for the SQL Server agent
  • Manage alerts and notifications
  • Managing SQL Server with PowerShell
  • Track access to SQL Server
  • Monitoring a SQL Server infrastructure
  • Troubleshooting a SQL Server infrastructure
  • Importing and exporting data

SQL Server Security

  • Authentication of connections to SQL Server
  • Authorisation of logins to connect to databases
  • Authorisation on different servers
  • Partially contained databases

Assigning server and database roles

  • Working with server roles
  • Working with fixed database roles
  • User-defined database roles

Authorising users to access resources

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

Protecting data with encryption and auditing

  • Options for monitoring data access in SQL Server
  • Implementing SQL Server Audit
  • Managing SQL Server Audit
  • Protecting data with encryption

Recovery models and backup strategies

  • Understanding backup strategies
  • SQL Server transaction logs
  • Planning backup strategies

Backing up SQL Server databases

  • Backing up databases and transaction logs
  • Managing database backups
  • Advanced database options

Restoring SQL Server Databases

  • Understanding the recovery process
  • Restoring databases
  • Advanced recovery scenarios
  • Point-in-Time Recovery

Automating SQL Server Management

  • Automating SQL Server Management
  • Working with SQL Server Agent
  • Managing SQL Server Agent jobs
  • Managing multiple servers

Configuring security for the SQL Server Agent

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

Monitoring SQL Server with alarms and notifications

  • Monitoring SQL Server errors
  • Configuring database mail
  • Operators, alarms and notifications
  • Alerts in Azure SQL Database

Introduction to managing SQL Server using PowerShell

  • Getting started with Windows PowerShell
  • Configuring SQL Server with PowerShell
  • Managing and Maintaining SQL Server with PowerShell
  • Managing Azure SQL Databases with PowerShell

Tracking Access to SQL Server with Advanced Events

  • Core concepts for extended events
  • Working with extended events

Monitoring SQL Server

  • Monitoring activities
  • Collecting and managing performance data
  • Analysing collected performance data

Troubleshooting SQL Server

  • Apply a troubleshooting methodology
  • Resolve service-related problems
  • Resolve connectivity and logon issues

Import and export data

  • Transferring data to and from SQL Server
  • Importing and exporting table data
  • Using bcp and BULK INSERT to import data
  • Deploying data tier applications

This course is primarily aimed at people who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility or work in environments where databases play a key role in their primary job.

The secondary audience for this course is individuals who develop applications that deliver content from SQL Server databases.

  • Experience in working with applications on Windows servers
  • Experience working with SQL Server or another RDMS

The course price includes:
- Training materials in English and digital form
- Refreshments during breaks in the classroom training: drinks, pastries and lunch.

We are also happy to conduct this training as an in-house seminar. Please request your individual offer.

The course is offered in German and English.

Contact us

SoftwareONE

IT CAMPUS
Customer Training Solutions

Blochstraße 1
D-04329 Leipzig
*The services of SoftwareONE Deutschland GmbH directly serving school and educational purposes are predominantly VAT-exempt according to § 4 No. 21 a) bb) UStG. Contact us - we are happy to help!