Administering a Microsoft SQL Server 2008/2012 Database
- Overview: Administering Microsoft SQL Server 2012 Databases - Overview
- Overview: Introduction to SQL Server 2012 and Its Toolset
- Lesson 1: Introduction to the SQL Server Platform
- Lesson 2: Working with SQL Server Tools
- Lesson 3: Configuring SQL Server Services
- Lab 1: Introduction to SQL Server and Its Toolset
- Overview: Preparing Systems for SQL Server 2012
- Lesson 1: Overview of SQL Server Architecture
- Lesson 2: Planning Server Resource Requirements
- Lesson 3: Pre-installation Testing for SQL Server
- Lab 2: Preparing Systems for SQL Server
- Overview: Installing and Configuring SQL Server 2012
- Lesson 1: Preparing to Install SQL Server
- Lesson 2: Installing SQL Server
- Lesson 3: Upgrading and Automating Installation
- Lab 3: Installing and Configuring SQL Server
- Overview: Working with Databases
- Lesson 1: Overview of SQL Server Databases
- Lesson 2: Working with Files and Filegroups
- Lesson 3: Moving Database Files
- Lab 4: Working with Databases
- Overview: Understanding SQL Server 2012 Recovery Models
- Lesson 1: Backup Strategies
- Lesson 2: Understanding SQL Server Transaction Logging
- Lesson 3: Planning a SQL Server Backup Strategy
- Lab 5: Understanding SQL Server Recovery Models
- Overview: Backup of SQL Server 2012 Databases
- Lesson 1: Backing up Databases and Transaction Logs
- Lesson 2: Managing Database Backups
- Lesson 3: Working with Backup Options
- Lab 6: Backup of SQL Server Databases
- Overview: Restoring SQL Server 2012 Databases
- Lesson 1: Understanding the Restore Process
- Lesson 2: Restoring Databases
- Lesson 3: Working with Point-in-time recovery
- Lesson 4: Restoring System Databases and Individual Files
- Lab 7: Restoring SQL Server 2012 Databases
- Overview: Importing and Exporting Data
- Lesson 1: Transferring Data To/From SQL Server
- Lesson 2: Importing & Exporting Table Data
- Lesson 3: Inserting Data in Bulk
- Lab 8: Importing and Exporting Data
- Overview: Authenticating and Authorizing Users
- Lesson 1: Authenticating Connections to SQL Server
- Lesson 2: Authorizing Logins to Access Databases
- Lesson 3: Authorization Across Servers
- Lab 9: Authenticating and Authorizing Users
- Overview: Assigning Server and Database Roles
- Lesson 1: Working with Server Roles
- Lesson 2: Working with Fixed Database Roles
- Lesson 3: Creating User-defined Database Roles
- Lab 10: 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 11: Authorizing Users to Access Resources
- Overview: Auditing SQL Server Environments
- Lesson 1: Options for Auditing Data Access in SQL
- Lesson 2: Implementing SQL Server Audit
- Lesson 3: Managing SQL Server Audit
- Lab 12: Auditing SQL Server Environments
- Bonus 1: Change Data Capture
- Bonus 2: Explicit Encryption
- Bonus 3: Database Encryption
- Bonus 4: DDL Triggers
- Overview: Automating SQL Server 2012 Management
- Lesson 1: Automating SQL Server Management
- Lesson 2: Working with SQL Server Agent
- Lesson 3: Managing SQL Server Agent Jobs
- Lab 13: Automating SQL Server Management
- Overview: Configuring Security for SQL Server Agent
- Lesson 1: Understanding SQL Server Agent Security
- Lesson 2: Configuring Credentials
- Lesson 3: Configuring Proxy Accounts
- Lab 14: Configuring Security for SQL Server Agent
- Overview: Monitoring SQL Server 2012 with Alerts and Notifications
- Lesson 1: Configuration of Database Mail
- Lesson 2: Monitoring SQL Server Errors
- Lesson 3: Configuring Operators, Alerts and Notifications
- Lab 15: Monitoring SQL Agent Jobs with Alerts and Notifications
- Overview: Performing Ongoing Database Maintenance
- Lesson 1: Ensuring Database Integrity
- Lesson 2: Maintaining Indexes
- Lesson 3: Automating Routine Database Maintenance
- Lab 16: Performing Ongoing Database Maintenance
- Overview: Tracing Access to SQL Server 2012
- Lesson 1: Capturing Activity using SQL Server Profiler and Extended Events Profiler
- Lesson 2: Improving Performance with the Database Engine Tuning Advisor
- Lesson 3: Working with Tracing Options
- Lab 17: Tracing Access to SQL Server 2012
- Bonus 1: Resource Governor
- Overview: Monitoring SQL Server 2012
- Lesson 1: Monitoring Activity
- Lesson 2: Capturing and Managing Performance Data
- Lesson 3: Analyzing Collected Performance Data
- Lab 18: Monitoring SQL Server 2012
- Overview: Managing Multiple Servers
- Lesson 1: Working with Multiple Servers
- Lesson 2: Virtualizing SQL Server
- Lesson 3: Deploying and Upgrading Data-tier Applications
- Lab 19: Managing Multiple Servers
- Overview: Troubleshooting Common SQL Server 2012 Administrative Issues
- Lesson 1: SQL Server Troubleshooting Methodology
- Lesson 2: Resolving Service-related Issues
- Lesson 3: Resolving Login and Connectivity Issues
- Lesson 4: Resolving Concurrency Issues
- Lab 20: Troubleshooting Common Issues
- Overview: Core Concepts in SQL Server High Availability and Replication
- Lesson 1: Core Concepts in High Availability
- Lesson 2: Core Concepts in Replication
- Bonus 1: Log Shipping
- Bonus 1: SQL Azure
Az oktatóról
