55316
Administering a SQL Database Training
55316A is the Community Courseware equivalent of retired MOC Course 20764A - Administering a SQL Database Infrastructure.
The 55316A five-day instructor-led course will provide training in how to administer and maintain SQL Server, Azure SQL Database and other cloud-based SQL Server databases. IT professionals who work in environments where databases play a key role in their job will find this material useful. By using demonstrations and hands-on lab exercises, students will learn to carry out these important tasks.
The 55316A five-day instructor-led course will provide training in how to administer and maintain SQL Server, Azure SQL Database and other cloud-based SQL Server databases. IT professionals who work in environments where databases play a key role in their job will find this material useful. By using demonstrations and hands-on lab exercises, students will learn to carry out these important tasks.
Course Details
Duration
5 days
Prerequisites
- Experience using applications on Windows Servers
- Experience working with SQL Server or another RDMS
Target Audience
- Individuals who administer and maintain SQL Server databases.
- Individuals who develop applications that deliver content from SQL Server databases.
Skills Gained
- Authenticate and authorize users
- Assign server and database roles
- Authorize users to access resources
- Use encryption and auditing features to protect data
- Describe recovery models and backup strategies
- Backup and Restore SQL Server databases
- Automate database management
- Configure security for the SQL Server agent
- Manage alerts and notifications
- Managing SQL Server using PowerShell
- Trace access to SQL Server
- Monitor a SQL Server infrastructure
- Troubleshoot a SQL Server infrastructure
- Import and export data
Course Outline
- SQL Server Security
- Authenticating Connections to SQL Server
- Authorizing Logins to Connect to databases
- Authorization Across Servers
- Partially Contained Databases
- Assigning Server and Database Roles
- Working with Server Roles
- Working with Fixed Database Roles
- User-Defined Database Roles
- Authorizing Users to Access Resources
- Authorizing User Access to Objects
- Authorizing Users to Execute Code
- Configuring Permissions at the Schema Level
- 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
- Recovery Models and Backup Strategies
- Understanding Backup Strategies
- SQL Server Transaction Logs
- Planning Backup Strategies
- Backing Up SQL Server Databases
- Backing Up Databases and Transaction Logs
- Managing Database Backups
- Advanced Database Options
- Restoring SQL Server Databases
- Understanding the Restore Process
- Restoring Databases
- Advanced Restore Scenarios
- Point-in-Time Recovery
- Automating SQL Server Management
- Automating SQL Server management
- Working with SQL Server Agent
- Managing SQL Server Agent Jobs
- Multi-server Management
- Configuring Security for SQL Server Agent
- Understanding SQL Server Agent Security
- Configuring Credentials
- Configuring Proxy Accounts
- Monitoring SQL Server with Alerts and Notifications
- Monitoring SQL Server Errors
- Configuring Database Mail
- Operators, Alerts, and Notifications
- Alerts in Azure SQL Database
- 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
- Tracing Access to SQL Server with Extended Events
- Extended Events Core Concepts
- Working with Extended Events
- Monitoring SQL Server
- Monitoring activity
- Capturing and Managing Performance Data
- Analyzing Collected Performance Data
- Troubleshooting SQL Server
- Applying a Troubleshooting Methodology
- Resolving Service-Related Issues
- Resolving Connectivity and Login issues
- 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
