Administering a SQL Database Infrastructure
- Overview: Administering a SQL Database Infrastructure
- Overview: SQL Server Security
- Lesson 1: Authenticating Connections to SQL Server
- Lesson 2: Authorizing Logins to Connect to Databases
- Lesson 3: Authorization Across Servers
- Lesson 4: Partially Contained Databases
- Lab 1: Authenticating Users
- Overview: Assigning Server and Database Roles
- Lesson 1: Working with Server Roles
- Lesson 2: Working with Fixed Database Roles
- Lesson 3: User-Defined Database Roles
- Lab 2: Assigning Server and Database Roles
- Overview: Authorizing Users to Access Resources
- Lesson 1: Authorizing User Access to Objects
- Lesson 2: Authorizing Users to Execute Code
- Lesson 3: Configuring Permissions at the Schema Level
- Lab 3: Authorizing Users to Access Resources
- Overview: Protecting Data with Encryption and Auditing
- Lesson 1: Options for Auditing Data Access in SQL Server
- Lesson 2: Implementing SQL Server Audit
- Lesson 3: Managing SQL Server Audit
- Lesson 4: Protecting Data with Encryption
- Lab 4: Using Auditing and Encryption
- Overview: Recovery Models and Backup Strategies
- Lesson 1: Understanding Backup Strategies
- Lesson 2: SQL Server Transaction Logs
- Lesson 3: Planning Backup Strategies
- Lab 5: Understanding SQL Server Recovery Models
- Overview: Backing Up SQL Server Databases
- Lesson 1: Backing Up Databases and Transaction Logs
- Lesson 2: Managing Database Backups
- Lesson 3: Advanced Database Options
- Lab 6: Backing Up Databases
- Overview: Restoring SQL Server 2016 Databases
- Lesson 1: Understanding the Restore Process
- Lesson 2: Restoring Databases
- Lesson 3: Advanced Restore Scenarios
- Lesson 4: Point-in-time Recovery
- Lab 7: Restoring SQL Server Databases
- Overview: Automating SQL Server Management
- Lesson 1: Automating SQL Server Management
- Lesson 2: Working with SQL Server Agent
- Lesson 3: Managing SQL Server Agent Jobs
- Lesson 4: Multiserver Management
- Lab 8: Automating SQL Server Management
- Overview: Configuring Security for SQL Server Agent
- Lesson 2: Configuring Credentials
- Lesson 1: Understanding SQL Server Agent Security
- Lesson 3: Configuring Proxy Accounts
- Lab 9: Configuring Security for SQL Server Agent
- Overview: Monitoring SQL Server with Alerts and Notifications
- Lesson 1: Monitoring SQL Server Errors
- Lesson 2: Configuring Database Mail
- Lesson 3: Operators, Alerts, and Notifications
- Lesson 4: Alerts in Azure SQL Database
- Lab 10: Monitoring SQL Server with Alerts and Notifications
- Overview: Introduction to Managing SQL Server Using PowerShell
- Lesson 1: Getting Started with Windows PowerShell
- Lesson 2: Configure SQL Server Using PowerShell
- Lesson 3: Administer and Maintain SQL Server with PowerShell
- Lesson 4: Managing Azure SQL Databases Using PowerShell
- Lab 11: Using PowerShell to Manage SQL Server
- Overview: Tracing Access to SQL Server with Extended Events
- Lesson 1: Extended Events Core Concepts
- Lesson 2: Working with Extended Events
- Lab 12: Extended Events
- Overview: Monitoring SQL Server
- Lesson 1: Monitoring Activity
- Lesson 2: Capturing and Managing Performance Data
- Lesson 3: Analyzing Collected Performance Data
- Lesson 4: SQL Server Utility
- Lab 13: Monitoring SQL Server
- Overview: Troubleshooting SQL Server
- Lesson 1: A Troubleshooting Methodology for SQL Server
- Lesson 2: Resolving Service-Related Issues
- Lesson 3: Resolving Connectivity and Login Issues
- Lab 14: Troubleshooting Common Issues
- Overview: Importing and Exporting Data
- Lesson 1: Transferring Data to and from SQL Server
- Lesson 2: Importing and Exporting Table Data
- Lesson 3: Using bcp and BULK INSERT to Import Data
- Lesson 4: Deploying and Upgrading Data-Tier Applications
- Lab 15: Importing and Exporting Data
Az oktatóról
