Designing Database Solutions for Microsoft SQL Server 2008/2012
- Overview: Designing Database Solutions for Microsoft SQL Server 2012 - Overview
- Overview: Designing a Database Server Infrastructure
- Lesson 1: Planning a Database Server Infrastructure
- Lesson 2: Planning Server Hardware
- Lesson 3: Considerations for Database Server Consolidation
- Lesson 4: Managing Server Resources in a Consolidated Database Server Infrastructure
- Lab : Planning Database Server Consolidation
- Overview: Designing a Logical Database Schema
- Lesson 1: Relational Database Design Techniques
- Lesson 2: Planning Schemas and Tables
- Lab 2: Designing a Logical Database Schema
- Overview: Designing a Physical Database Implementation
- Lesson 1: Planning Files and Filegroups
- Lesson 2: Planning a Partitioning Strategy
- Lesson 3: Planning Compression
- Lab 3: Designing a Physical Database Implementation
- Overview: Incorporating Data Files into Databases
- Lesson 1: Considerations for Working with Data Files in SQL Server 2012
- Lesson 2: Implementing FILESTREAM and FileTables
- Lesson 3: Searching Data Files
- Lab 4: Implementing a Solution for Storing Data Files
- Overview: Tuning Database Performance
- Lesson 1: Optimizing Query Performance by Using Indexes
- Lesson 2: Working with Query Plans
- Lesson 3: Performance Monitoring
- Lab 5: Using Indexes and Plan Guides
- Overview: Designing Database Security
- Lesson 1: Introduction to Security Planning
- Lesson 2: Planning Security
- Lesson 3: Contained Databases
- Lesson 4: Protecting Databases with Encryption
- Lab 6: Planning and Implementing Security
- Overview: Policy-Based Management
- Lesson 1: Introduction to Policy-Based Management
- Lesson 2: Planning and Implementing Policy-Based Management
- Lab 7: Planning Policy-Based Management
- Overview: Monitoring Server Health
- Lesson 1: Introduction to Server Health Monitoring
- Lesson 2: SQL Server Utility
- Lab 8: Monitoring Server Health
- Overview: Designing a Database Backup Solution
- Lesson 1: SQL Server Backup and Restore
- Lesson 2: Disaster Recovery Planning
- Lab 9: Planning and Implementing a Backup Strategy
- Overview: Automating Multi-Server Maintenance
- Lesson 1: Overview of Maintenance Automation
- Lesson 2: Managing Multiple Servers
- Lab 10: Automating Multi-Server Maintenance
- Overview: Managing SQL Server with Windows PowerShell
- Lesson 1: Introduction to Windows PowerShell
- Lesson 2: Scripting with Windows PowerShell
- Lab 11: Managing SQL Server with Windows PowerShell
- Overview: Replicating Data
- Lesson 1: SQL Server Replication
- Lesson 2: Planning Replication
- Lab 12: Planning and Implementing Replication
- Overview: Planning High Availability
- Lesson 1: High Availability in SQL Server 2012
- Lesson 2: AlwaysOn Availability Groups
- Lab 13: Working with AlwaysOn Availability Groups
- Bonus 1: SQL Azure
Az oktatóról
