Course Overview
X-Treme Microsoft SQL Server 2008
Course Outline
5 Days with lectures in the mornings and labs in the afternoons
Installing and Configuring SQL Server
- Preparing to Install SQL Server
- Installing SQL Server
- Configuring a SQL Server Installation
Lab : Installing and Configuring SQL Server
- Installing SQL Server
- Configuring SQL Server
Managing Databases and Files
- Planning Databases
- Creating Databases
- Using Policy-Based Management
Lab : Managing Databases and Files
- Creating a Database
- Monitoring and Managing Filegroup Usage
- Creating a Policy
Disaster Recovery
- Planning a Backup Strategy
- Backing Up User Databases
- Restoring User Databases
- Performing Online Restore Operations
- Recovering Data from Database Snapshots
- System Databases and Disaster Recovery
Lab : Disaster Recovery
- Designing a Backup Strategy
- Implementing a Backup Strategy
- Restoring and Recovering a Database
- Performing Piecemeal Backup and Restore Operations
- Restoring the master Database
Managing Security
- Overview of SQL Server Security
- Protecting the Server Scope
- Protecting the Database Scope
- Protecting the Server Scope
- Auditing Security
Lab : Managing Security
- Creating Logins and Assigning Server-Scope Permissions
- Creating and Managing Users
- Using a Certificate to Protect Data
- Implementing SQL Server Audit
Automating Administrative Tasks
- Automating Administrative Tasks in SQL Server
- Using SQL Server Agent
- Creating Maintenance Plans
- Implementing Alerts
- Managing Multiple Servers
- Managing SQL Server Agent security
Lab : Automating Administrative Tasks
- Configuring SQL Server Agent
- Creating Operators and Jobs
- Creating Alerts
Maintaining High Availability
- Introduction to High Availability
- Implementing Log Shipping
- Implementing Database Mirroring
- Implementing Server Clustering
- Using Distributed High Availability Solutions
Lab : Maintaining High Availability
- Configuring Log Shipping
- Configuring Database Mirroring
- Implementing SQL Server Clustering
Introduction to Business Intelligence
- What is Business Intelligence
- Introduction to Analysis Services
- Introduction to Reporting Services
- Overview of Integration Services
Demo/Optional Lab : Exploring Business Intelligence Features
- Using Analysis Services
- Using Reporting Services
Transferring Data
- Overview of Data Transfer
- Introduction to SQL Server Integration Services
Lab : Transferring Data
- Using the Import/Export Wizard
- Performing a Bulk Load
- Creating an SSIS Solution
Monitoring SQL Server
- Viewing Current Activity
- Using SQL Server Profiler
- Monitoring with DDL Triggers
- Using Event Notifications
Lab : Monitoring SQL Server
- Monitoring SQL Server Activity
- Tracing SQL Server Activity
- Using DDL Triggers
- Using Event Notifications
Troubleshooting and Performance Tuning
- Troubleshooting SQL Server
- Performance Tuning in SQL Server
- Using Resource Governor
- Using Data Collector
Lab : Troubleshooting and Performance Tuning
- Troubleshooting Connectivity Problems
- Troubleshooting Concurrency Problems
- Using the Database Engine Tuning Advisor
- Implementing Resource Governor
- Implementing Data Collector
Implementing Replication
- Overview of Replication
- Managing Publications and Subscriptions
- Configuring Replication in Some Common Scenarios
Lab : Implementing Replication
- Implementing Snapshot Replication
- Implementing Peer-to-Peer Transactional Replication
- Implementing HTTP Merge Replication
What’s New in Transact-SQL
- Working with Data Types
- Cursors and Set-Based Queries
- Dynamic SQL
- Maintaining Query Files
Lab : Exploring New Features of Transact-SQL
- Using Execution Plans
- Converting Data Types
- Implementing a Hierarchy
- Using Cursors and Set-Based Queries
Summarizing Relational Data and Querying Alternate Data
- Summarizing Data by Using Aggregate Functions
- Summarizing Grouped Data
- Ranking Grouped Data
- Creating Crosstab Queries
- Querying Metadata
- Overview of XML
- Querying XML Data
- Overview of Full-Text Indexes
- Querying Full-Text Indexes
Lab : Summarizing Data and Querying Alternate Data
- Summarizing Data by Using Aggregate Functions
- Summarizing Grouped Data
- Ranking Grouped Data
- Creating Crosstab Queries
- Query metadata.
- Describe the functionality of XML.
- Query XML data.
- Describe the functionality of full-text indexes.
- Query full-text indexes.
Prerequisites