M55353A - Administering a SQL Database Infrastructure

Trained 50k+ People

Over 100+ Countries

By Specialist Trainers

With Over 20 Years' Experience

Enquire Now
Book Now
Download Overview

By the end of this course, learners will be able to install and configure SQL Server instances, manage databases and objects, implement security and permissions, perform backups and restores, monitor and optimize database performance, configure high availability solutions, and troubleshoot common database issues, ensuring SQL Server environments run efficiently and securely.

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

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.

Instructor-led sessions, lab exercises, course slides, practice datasets

Experience with relational databases, basic SQL querying knowledge, and familiarity with Windows Server

Microsoft Docs: SQL Server Administration

This course prepares learners for the Microsoft DP-300: Administering Relational Databases certification exam. The exam evaluates your ability to implement, manage, and monitor SQL Server databases, including performance tuning, security, high availability, backup and recovery, and troubleshooting. The assessment includes multiple-choice questions, scenario-based questions, and practical exercises that reflect real-world SQL Server administration tasks. Passing the exam demonstrates readiness for a database administrator role and validates expertise in managing SQL Server infrastructure.

Proctored Exam

Microsoft Certified: Database Administrator Skills

After this course, learners can pursue advanced SQL Server certifications, such as Azure Database Administrator Associate or specialized database administration and performance tuning courses.

Prerequisites

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.

Why Choose Us?

We Are Here To Help You Pass

All of our trainers have achieved exceptionally high delegate pass rates for accredited examinations for all our courses. We also offer complimentary pre and post-course support for any questions you may have.

We Are Flexible

We try and be as flexible as we can and accommodate your needs. We can swap delegates at any time with no charge. We can also create bespoke content should this be required.

We Are The Specialists

We specialise in IT Service and Project Management. All of our Trainers and Consultants have considerable years of hands-on experience in IT Service / Project Management, working across a wide number of industry sectors.

We Are Professionals

Our training, sales and admin staff are all professional, helpful, friendly and approachable. We believe in providing excellent customer service. You will always have a dedicated friendly Account Manager

Reviews

Purple Griffon recently delivered 2 service management courses for the MOD and we all found it to be a very positive experience. The Company is very professional, with extremely knowledgeable and experienced trainers, who have real world skills.

Garry Jones - Procurement Manager, MOD

It was a beast of a course but very rewarding. Thanks for the assistance around the booking - the customer service was excellent. I no longer have to hide behind my project management team and can say loud and proud I am a PRINCE2® practitioner!

Matthew Slater - Service Delivery Manager, InTechnology

The training was organised well, administrative help was quick and relevant which made the information gathering and training preparations fast & easy. The trainer was knowledgeable and experienced. We’ve received very good feedback.

Karolina Manka - Training Specialist, Accenture

I passed! which I must admit was 100% down to your trainer Bob. He gave us enough stories and tips to get me through it and sometimes the stories sink in better than anything else. Thanks again, I'd definitely use your company again because of him.

Tracy Iqbal - IT Assistant, MacRoberts

Feedback from staff has been positive and you have helped us to effectively embed the ITIL® framework into our working processes and achieve key organisational goals. We look forward to continuing with rest of our ITIL® courses throughout the year.

Max Khalid - ITSM Specialist, London Programme for IT

I have self-funded several courses with Purple Griffon, and passed all of my exams to gain ITIL® Expert accreditation. This wouldn't have been possible without the help from the team and tutors. This makes Purple Griffon my first choice of training provider.

Sarah Jamieson - Individual , Self-Funded

Excellent course material and exercises and discussion facilitate learning in the classroom. Managed to pass all exams of courses taken with Purple Griffon! And I believe on this latest course a 100% pass rate from all delegates on the course!

Rob James - Individual, Self-Funded

Great company and Steve is a really knowledgeable guy as well!

Maurits Van Der Plas - Director, Van Haren Learning Solutions

I could not find any other training exclusively focused on the IT SDM roles and responsibilities elsewhere, making this course possibly the best IT SDM training in the world! I consider this course among the top courses I've had the pleasure of attending.

Michael Hilliker - IT Branch, Gouvernement Du Canada

The free "Introduction To The World Of The Service Desk" provided a great insight into the world of IT Service Management. Excellent slides.

Chinonyerem Mpamah - Learner, Self-Funded

I have been using Purple Griffon since 2013 after taking a course with another company and didn't receive the best experience. Since 2013 I haven't used anyone else. Excellent courses and very personable trainers and high pass rates.

Terry Wilder - Learner, Self-Funded

The Purple Griffon E-Learning study material is very complete, and prepared me for the exam in an excellent way. I am happy to have used the Purple Griffon material and I am planning to do so again in the near future.

Louis Rademaker - Learner, Self-Funded

I've taken classroom training via Purple Griffon and their exceptional team on several occasions. In my case it has been ITIL® based and I can only recommend their services.

David Barrow - Learner, Self-Funded

From what I see the course for CDS is well organised and staff that prepared the materials are really looking for their students to pass the exam with good marks. I wish that whenever I need extra help the staff will help me immediately

Fawaz Yelda - Professional, Control Risks

I got studying material from Purple Griffon and the quality is more than good. Good work!

Sergio Enriquez - Learner, Self-Funded

Very good training provider and the instructor was very knowledgeable

Nigel Rooms - Professional, CDW

Great training - passed my ITIL® exam!

Luca Bakshi - Technical Analyst, Trayport

I found the ITIL® 4 Foundation online training course very good and easy to follow. I think good values.

Keith Brain - Individual, Self-Funded

The Digital Twins Basics Online Workshop (60 Minutes) was simple and the content was easy to understand.

Titilayo Iya Y - Individual, Self-Funded

INFORMATION

M55353A - Administering a SQL Database Infrastructure Course Dates

There are currently no course dates that match your selected filter options. Please try another filter or contact one of our dedicated account managers on +44 208 1428 961 to discuss your requirements. Thanks.