Administering SQL Database Infrastructure

Overview Schedule Dates Course Content Faqs

Course Overview

The Administering SQL Database Infrastructure course is designed to provide IT professionals with the skills and knowledge needed to administer SQL Server database infrastructures. This comprehensive course covers all aspects of SQL Server administration, including installation, configuration, maintenance, and troubleshooting, ensuring participants are well-prepared to manage and optimize SQL Server environments effectively.

Course Objectives

By the end of this course, participants will be able to:

Install and configure SQL Server and its components.
Plan and manage databases and files.
Perform backup and restore operations.
Implement and manage security, including auditing.
Monitor and troubleshoot SQL Server performance.
Automate administrative tasks using SQL Server Agent.
Implement high availability and disaster recovery solutions.
Utilize tools and techniques for optimizing database performance.

Learning Options

Online Instructor Led

Learn from the comforts of your home/office with our expert trainers via online platforms.

Classroom Training

Face-to-face physical classroom training with max interactions at our 5* training venues.

Onsite Training

Learn in your own environment from our expert trainers for maximum impact.

Overseas Training

Choose your desired country for learning with our expert trainers.

Target Audiance

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.

Schedule Dates

Administering SQL Database Infrastructure

16 September 2024 - 20 September 2024

Administering SQL Database Infrastructure

16 December 2024 - 20 December 2024

Administering SQL Database Infrastructure

17 March 2025 - 21 March 2025

Administering SQL Database Infrastructure

23 June 2025 - 27 June 2025

Course Content

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

FAQs

This course is designed for database administrators, IT professionals responsible for managing and maintaining SQL Server databases, developers who work with SQL Server, and anyone preparing for the Microsoft Certified: Azure Database Administrator Associate certification.

Before attending this course, participants should have:

Basic knowledge of the Microsoft Windows operating system and its core functionality.
Working knowledge of Transact-SQL (T-SQL).
Experience with relational databases.

The course is offered in various formats, including instructor-led classroom training, online virtual training, and self-paced learning modules.

This course provides you with the essential skills and knowledge to effectively manage and maintain SQL Server databases. It prepares you for roles such as Database Administrator, SQL Server Specialist, and IT Manager, and helps in achieving the Microsoft Certified: Azure Database Administrator Associate certification.

Yes, after completing this course, you may consider advanced SQL Server courses, such as “Designing and Implementing a Data Warehouse” or “Implementing Data Models and Reports with SQL Server,” to further enhance your skills and knowledge in specialized areas of SQL Server.