Microsoft Data & Power BI
Administering a SQL Database Infrastructure (55353)
Administer SQL Server databases.
5 daysIntermediate15 modules55353
About this course
Administer SQL Server databases. Over five days you will authenticate users and assign roles, protect data with encryption and auditing, plan and run backups and restores, automate with SQL Server Agent and PowerShell, and monitor and troubleshoot.
What you'll learn
- Authenticate users and assign database roles
- Configure SQL Server auditing, agent security, and backup strategies
- Manage SQL Server using PowerShell and automation techniques
- Monitor SQL Server activity using Extended Events
- Troubleshoot performance issues and import/export data
Curriculum
15 modules
- Authenticate logins and authorize users to access databases
- Configure SQL Server login options
- Authorization across servers and partially contained databases
- Understand fixed and custom database roles
- Assign and manage server roles
- Use database roles and application roles
- Implement role-based access to secure data
- Configure SQL Server Audit and manage audit logs
- Encrypt sensitive data and enforce auditing policies
- Understand backup strategies for transactional integrity
- Plan SQL Server recovery using appropriate models
- Perform full and differential database backups
- Manage backup files and automate backup jobs
- Use restore options and perform point-in-time recovery
- Handle advanced restore scenarios
- Configure SQL Server Agent for scheduled jobs
- Automate repetitive tasks using job steps and notifications
- Set up credentials, proxies, and secure agent access
- Create operators and configure alerting
- Monitor Azure SQL Database events and performance
- Use PowerShell to configure SQL Server
- Administer and maintain SQL Server infrastructure
- Manage Azure SQL using PowerShell
- Capture login and query activity
- Use Extended Events to analyze SQL Server performance
- Monitor usage metrics and server performance
- Analyze collected data using SQL Server Utility
- Resolve service, login, and connectivity issues
- Apply a troubleshooting methodology for performance
- Import and export data using BCP and BULK INSERT
- Deploy and manage data-tier applications
Who it's for
Database administrators and IT staff who manage SQL Server.
Before you start
- 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.
Related courses
More in Microsoft Data & Power BI →IntermediateDP-300 Exam Prep/DP-300T00
Administering Microsoft Azure SQL Solutions (DP-300 Exam Prep/DP-300T00)
Microsoft Data & Power BI
View course →IntermediateDP-3001
DP-3001 Migrate SQL Server workload to Azure SQL
Microsoft Data & Power BI
View course →Intermediate
55128 Writing Reports with Report Builder and SSRS Level 2
Microsoft Data & Power BI
View course →Intermediate
55232 Writing Analytical Queries for Business Intelligence
Microsoft Data & Power BI
View course →Foundation
55315 Introduction to SQL Databases
Microsoft Data & Power BI
View course →Foundation
Data Analysis using Power BI Desktop - Level 1: Report Builder
Microsoft Data & Power BI
View course →Let's plan your next step together.
Tell us the course or certification you have in mind and we'll send the outline, upcoming dates, fees and private-team options.