| Unit 1: SQL Server 2005 installation
|
 | Topic A: SQL Server features
|
| Topic B: SQL Server installation
|
| Topic C: Alternative installations
|
| Unit 2: SQL Server management tools
|
| Topic A: SQL Server 2005 services
|
| Topic B: Management tools
|
| Topic C: SQL Server settings
|
| Topic D: Database Mail
|
| Unit 3: Database management
|
| Topic A: SQL Server data storage
|
| Topic B: Database management
|
| Topic C: Capacity planning and management
|
| Unit 4: Data design
|
| Topic A: The data design process
|
| Topic B: Table and data design
|
| Topic C: Data normalization
|
| Topic D: Data types
|
| Unit 5: Tables, constraints, and indexes
|
| Topic A: Objects
|
| Topic B: Tables and constraints
|
| Topic C: Indexes
|
| Unit 6: Data retrieval
|
| Topic A: Queries
|
| Topic B: Transact-SQL functions
|
| Topic C: Data organization
|
| Topic D: Multiple table queries
|
| Topic E: Data modification
|
| Topic F: Query Designer
|
| Unit 7: Programmable objects
|
| Topic A: Programming fundamentals
|
| Topic B: User views
|
| Topic C: Stored procedures
|
| Topic D: User-defined functions
|
| Unit 8: Data management
|
| Topic A: Multiple language support
|
| Topic B: Full-text search
|
| Topic C: Partitions
|
| Topic D: Error handling
|
| Topic E: Transactions and locking
|
| Topic F: Triggers
|
| Unit 9: XML support
|
| Topic A: XML fundamentals
|
| Topic B: The XML data type
|
| Topic C: XML methods and indexes
|
| Topic D: XML and relational data integration
|
| Unit 10: Data transfers
|
| Topic A: Bulk transfers
|
| Topic B: SQL Server 2005 Integration Services
|
| Topic C: XML import and export
|
| Unit 11: SQL Server security
|
| Topic A: Principles
|
| Topic B: Server securables
|
| Topic C: Database and schema securables
|
| Topic D: SQL auditing
|
| Topic E: Encryption
|
| Topic F: CLR security
|
| Unit 12: Management and maintenance
|
| Topic A: SQL Server Agent
|
| Topic B: Distributed queries
|
| Topic C: Replication
|
| Unit 13: SQL Server optimization
|
| Topic A: Monitoring and optimization
|
| Topic B: Database optimization
|
| Topic C: Database tune-ups
|
| Topic D: Query optimization concepts
|
| Unit 14: Reliability and availability
|
| Topic A: Database backup
|
| Topic B: Database restore
|
| Topic C: Log shipping
|
| Topic D: Database snapshots
|
| Topic E: Mirrored databases
|
| Unit 15: Applications
|
| Topic A: Service Broker
|
| Topic B: HTTP endpoints
|
| Unit 16: Troubleshooting and repair
|
| Topic A: Blocks and deadlocks
|
| Topic B: SQL Server errors
|
| Topic C: Recovery |
