Title Details

Michael Lee, MCT, MCITP, MCPD, SCJP, has been teaching SQL Server since 1995, providing training and consulting services in SQL Server and Enterprise Data Architecture to companies across the U.S. and Europe. Mike Mansfield is a Senior Technical Trainer for signal learning in Indianapolis, Indiana, and holds many 2008 products certifications. Mike began teaching at Missouri State University in 2003. Prior to 2003, he worked in production environments and as a consultant for nearly two decades. Mike has authored or designed many courses and specialized training.

Chapter 1: Installing SQL Server 2008.

Chapter 2: Configuring SQL Server 2008.

Chapter 3: Creating Databases, Files, and Tables.

Chapter 4: Executing Basic Queries.

Part II: Data Integrity and Security.

Chapter 5: Managing Data Integrity.

Chapter 6: Managing Transactions and Locking.

Chapter 7: Managing Security.

Part III: Data Administration.

Chapter 8: Implementing Availability and Replication.

Chapter 9: Extracting, Transforming, and Loading Data.

Chapter 10: Managing Data Recovery.

Part IV: Performance and Advanced Features.

Chapter 11: Monitoring and Tuning SQL Server.

Chapter 12: Planning and Creating Indexes.

Chapter 13: Implementing Policy-Based Administration.

Chapter 14: Automating with the SQL Agent Service.