Administering a SQL Database (55316) Training
Microsoft Official Course 55316 gives database professionals the knowledge and skills to administer a SQL Server database infrastructure. Across five days you cover security and permissions, encryption and auditing, backup and restore strategies, automation with SQL Server Agent, alerting, PowerShell administration, Extended Events, performance monitoring, troubleshooting, and importing and exporting data — for SQL Server and Azure SQL Database alike.
Course Overview
- Microsoft Official Courseware 55316, delivered instructor-led over five days.
- Covers administration of both on-premises SQL Server and Azure SQL Database.
- Security, backup and recovery, automation, monitoring and troubleshooting in one course.
Who Should Attend
- Individuals who administer and maintain SQL Server databases as their primary responsibility.
- Individuals who develop applications that deliver content from SQL Server databases.
Prerequisites
- Experience using applications on Windows Servers.
- Experience working with SQL Server or another relational database management system.
Course Outline
- Module 1: SQL Server Security
- Authenticating connections to SQL Server; authorizing logins to connect to databases; authorization across servers; partially contained databases.
- Module 2: Assigning Server and Database Roles
- Working with server roles; working with fixed database roles; user-defined database roles.
- Module 3: Authorizing Users to Access Resources
- Authorizing user access to objects; authorizing users to execute code; configuring permissions at the schema level.
- Module 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.
- Module 5: Recovery Models and Backup Strategies
- Understanding backup strategies; SQL Server transaction logs; planning backup strategies.
- Module 6: Backing Up SQL Server Databases
- Backing up databases and transaction logs; managing database backups; advanced database options.
- Module 7: Restoring SQL Server Databases
- Understanding the restore process; restoring databases; advanced restore scenarios; point-in-time recovery.
- Module 8: Automating SQL Server Management
- Automating SQL Server management; working with SQL Server Agent; managing SQL Server Agent jobs; multi-server management.
- Module 9: Configuring Security for SQL Server Agent
- Understanding SQL Server Agent security; configuring credentials; configuring proxy accounts.
- Module 10: Monitoring SQL Server with Alerts and Notifications
- Monitoring SQL Server errors; configuring Database Mail; operators, alerts and notifications; alerts in Azure SQL Database.
- Module 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.
- Module 12: Tracing Access to SQL Server with Extended Events
- Extended Events core concepts; working with Extended Events.
- Module 13: Monitoring SQL Server
- Monitoring activity; capturing and managing performance data; analyzing collected performance data.
- Module 14: Configuring the SQL Server Utility
- Configure SQL Server Utility for multi-instance monitoring.
- Module 15: Troubleshooting SQL Server
- Applying a troubleshooting methodology; resolving service-related issues; resolving connectivity and login issues.
- Module 16: 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 data-tier applications.
Related training topics
Justify your training
Use this sample request letter — copy it into an email to your manager and personalize the bracketed details to make the case for the time and budget.
Sample training request letter
Subject: Request for Data Analytics & Databases training from Applied Technology Academy
[Decision Maker Name],
I'm writing to request time and budget approval to complete Applied Technology Academy's course, Administering a SQL Database (55316) Training. The information below outlines how this training benefits our organization, the tasks I'll be able to perform after completing it, and relevant cost and funding details.
Course Description
Microsoft Official Course 55316 gives database professionals the knowledge and skills to administer a SQL Server database infrastructure. Across five days you cover security and permissions, encryption and auditing, backup and restore strategies, automation with SQL Server Agent, alerting, PowerShell administration, Extended Events, performance monitoring, troubleshooting, and importing and exporting data — for SQL Server and Azure SQL Database alike. Applied Technology Academy is an award-winning, SBA-certified woman-owned training provider (est. 2008) whose instructors are active practitioners. The course combines instructor-led training with practical exercises, real-world examples, and computer-based activities designed to reinforce job-relevant skills.
Course Objectives
Once I've completed the course, I'll have job-ready skills in data analytics & databases that I can apply immediately to our work.
Expected Organizational Benefits
After completing this course, I will be better equipped to apply these skills directly to our projects, reduce our reliance on outside expertise, strengthen our team's capabilities, and share what I learn with colleagues.
Expected Cost & Funding
Course fee: [request an itemized quote at the link below]. Applied Technology Academy supports multiple funding paths that may reduce or cover this cost: GSA MAS purchasing and government purchase orders, military credentialing funding (Army CA, AF COOL, CG COOL), VA GI Bill and VR&E, ATA Flexible Spending, and student financing. Private team cohorts are available if colleagues should attend with me.
Conclusion
This training provides practical, hands-on experience I can apply immediately to strengthen our work in data analytics & databases. Additional course information is available at https://appliedtechnologyacademy.com/microsoft-training/administering-a-sql-database-55316-training/.
Thank you for your consideration,
[Your Name]
Design training around your team, not the other way around.
Talk to a training advisor about private cohorts, funding paths and program management.