Home / Courses / Software Development & Programming / 55353 Administering a SQL Database Infrastructure

55353 Administering a SQL Database Infrastructure

Name: 55353 Administering a SQL Database Infrastructure
Price: 2995.00 USD
Availability: InStock
Rating: 4.6 (5878 reviews)

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. Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases.

4.6 out of 5 rating
Last updated : 23/07/2026
English

Available as Instructor Led Training, Live Online & In Person at your Offices or Ours.

Duration:

40.00 hours

32.5 CPD hours

Overview:

Description:

Course Outline:

1 - SQL Server Security

Authenticating Connections to SQL Server
Authorizing Logins to Connect to databases
Authorization Across Servers
Partially Contained Databases

2 - Assigning Server and Database Roles

Working with server roles
Working with Fixed Database Roles
Assigning User-Defined Database Roles

3 - Authorizing Users to Access Resources

Describe and use server roles to manage server-level security.
Describe and use fixed database roles.
Use custom database roles and application roles to manage database-level security. 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
5 - Recovery Models and Backup Strategies
- Understanding Backup Strategies
- SQL Server Transaction Logs
- Planning Backup Strategies
6 - Backing Up SQL Server Databases
- Backing Up Databases and Transaction Logs
- Managing Database Backups
- Advanced Database Options
7 - Restoring SQL Server Databases
- Understanding the Restore Process
- Restoring Databases
- Advanced Restore Scenarios
- Point-in-Time Recovery
8 - Automating SQL Server Management
- Automating SQL Server management
- Working with SQL Server Agent
- Managing SQL Server Agent Jobs
- Multi-server Management
9 - Configuring Security for SQL Server Agent
- Understanding SQL Server Agent Security
- Configuring Credentials
- Configuring Proxy Accounts
10 - Monitoring SQL Server with Alerts and Notifications
- Monitoring SQL Server Errors
- Configuring Database Mail
- Operators, Alerts, and Notifications
- Alerts in Azure SQL Database
11 - Introduction to Managing SQL Server by using PowerShell
- Getting Started with Windows PowerShell
- Configure SQL Server using PowerShell
- Administer and Maintain SQL Server with PowerShell
- Managing Azure SQL Databases using PowerShell
12 - Tracing Access to SQL Server with Extended events
- Extended Events Core Concepts
- Working with Extended Events
13 - Monitoring SQL Server
- Monitoring activity
- Capturing and Managing Performance Data
- Analyzing Collected Performance Data
- SQL Server Utility
14 - Troubleshooting SQL Server
- A Trouble Shooting Methodology for SQL Server
- Resolving Service Related Issues
- Resolving Connectivity and Log-in issues
15 - Importing and Exporting Data
- Transferring Data to and from SQL Server
- Importing and Exporting Table Data
- Using bcp and BULK INSERT to Import Data
- Deploying and Upgrading Data-Tier Application
,
SQL Server Security
- Authenticate logins and authorize users to access databases
- Configure SQL Server login options
- Authorization across servers and partially contained databases
Assigning Server and Database Roles
- Understand fixed and custom database roles
- Assign and manage server roles
Authorizing Users to Access Resources
- Use database roles and application roles
- Implement role-based access to secure data
Protecting Data with Encryption and Auditing
- Configure SQL Server Audit and manage audit logs
- Encrypt sensitive data and enforce auditing policies
Recovery Models and Backup Strategies
- Understand backup strategies for transactional integrity
- Plan SQL Server recovery using appropriate models
Backing Up SQL Server Databases
- Perform full and differential database backups
- Manage backup files and automate backup jobs
Restoring SQL Server Databases
- Use restore options and perform point-in-time recovery
- Handle advanced restore scenarios
Automating SQL Server Management
- Configure SQL Server Agent for scheduled jobs
- Automate repetitive tasks using job steps and notifications
Configuring Security for SQL Server Agent
- Set up credentials, proxies, and secure agent access
Monitoring with Alerts and Notifications
- Create operators and configure alerting
- Monitor Azure SQL Database events and performance
Managing SQL Server with PowerShell
- Use PowerShell to configure SQL Server
- Administer and maintain SQL Server infrastructure
- Manage Azure SQL using PowerShell
Tracing Access with Extended Events
- Capture login and query activity
- Use Extended Events to analyze SQL Server performance
Monitoring SQL Server
- Monitor usage metrics and server performance
- Analyze collected data using SQL Server Utility
Troubleshooting SQL Server
- Resolve service, login, and connectivity issues
- Apply a troubleshooting methodology for performance
Importing and Exporting Data
- Import and export data using BCP and BULK INSERT
- Deploy and manage data-tier applications

Available Delivery Options for 55353 Administering a SQL Database Infrastructure

Live Instructor Led Classroom Online (Live Online)
Traditional Instructor Led Classroom training (TILT/ILT)
Delivery at your offices in United Kingdom
Private dedicated course for your staff

How many CPD hours does 55353 Administering a SQL Database Infrastructure provide?

The 5 day 55353 Administering a SQL Database Infrastructure course gives you up to 32.5 CPD hours/structured learning hours.

Who is the correct audience for 55353 Administering a SQL Database Infrastructure?

The primary audience for this course is individuals 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 audiences for this course are individuals who develop applications that deliver content from SQL Server databases.

Do you provide training for 55353 Administering a SQL Database Infrastructure?

Yes, we provide corporate training, dedicated training and closed classes for 55353 Administering a SQL Database Infrastructure. This can take place anywhere in United Kingdom including London, Manchester, Birmingham, Edinburgh or live online.

What is the duration of 55353 Administering a SQL Database Infrastructure?

The 55353 Administering a SQL Database Infrastructure training takes place over 5 day(s), with each day lasting approximately 40.00 hours including breaks.

Why are Nexus Human the best provider for 55353 Administering a SQL Database Infrastructure?

Nexus Human are recognised as one of the best training companies. Our trainers have won awards including Small Firms Best Trainer, national training partner of the year for Ireland, and global top 30 instructor awards in 2012, 2019 and 2021.

Is there a discount code for 55353 Administering a SQL Database Infrastructure?

Yes, the discount code PENPAL5 is currently available for 55353 Administering a SQL Database Infrastructure training. Only one discount code can be used per booking.

DURATION 1 Day

21 Sep 26

09:00 – 17:00

Virtual

$2,995.00

14 Dec 26

09:00 – 17:00

Virtual

$2,995.00

21 Sep 26

09:00 – 17:00

Virtual

$2,995.00

14 Dec 26

09:00 – 17:00

Virtual

$2,995.00

Enquire Now

Download Overview

Training Insurance Included!

When you organise training, we understand that there is a risk that some people may fall ill, become unavailable.

To mitigate the risk we include training insurance for each delegate enrolled on our public schedule, they are welcome to sit on the same Public class within 6 months at no charge, if the case arises.

55353 Administering a SQL Database Infrastructure

Duration:

Overview:

Description:

Course Outline:

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 with Alerts and Notifications

Managing SQL Server with PowerShell

Tracing Access with Extended Events

Monitoring SQL Server

Troubleshooting SQL Server

Importing and Exporting Data

What You'll Learn:

Who Should Attend:

General Prerequisites:

Additional Information:

Available Delivery Options for 55353 Administering a SQL Database Infrastructure

How many CPD hours does 55353 Administering a SQL Database Infrastructure provide?

Who is the correct audience for 55353 Administering a SQL Database Infrastructure?

Do you provide training for 55353 Administering a SQL Database Infrastructure?

What is the duration of 55353 Administering a SQL Database Infrastructure?

Why are Nexus Human the best provider for 55353 Administering a SQL Database Infrastructure?

Is there a discount code for 55353 Administering a SQL Database Infrastructure?

Selected Classes (0)

Training Insurance Included!