Preface.

Acknowledgments.

FRIDAY.

Part I: Friday Evening.

Session 1: Getting Started.

Session 2: Go Configure.

Session 3: First Look at Enterprise Manager Console.

Session 4: Second Look at Enterprise Manager Console.

SATURDAY.

Part II: Saturday Morning.

Session 5: Relational Database Concepts.

Session 6: SQL Server Databases.

Session 7: Creating and Using a Custom Database.

Session 8: Transact-SQL Programming Language.

Session 9: T-SQL and SQL Query Analyzer.

Session 10: Programming with T-SQL.

Part III: Saturday Afternoon.

Session 11: Creating and Using Stored Procedures.

Session 12: Trigger Happy.

Session 13: Introducing Cursors.

Session 14: Understanding Indexes.

Session 15: Rules, Defaults, and Constraints.

Session 16: Understanding Transactions and Locks.

Part IV: Saturday Evening.

Session 17: Data Transformation Services.

Session 18: SQL Server Back Up.

Session 19: SQL Server Replication.

Session 20: User Management.

SUNDAY.

Part V: Sunday Morning.

Session 21: Managing Your Databases Visually.

Session 22: Distributed Transaction Coordinator.

Session 23: Accessing SQL Server System Information.

Session 24: Automating Administration Tasks with SQL Server Agent.

Session 25: Configuring SQL Server Mail.

Session 26: Performance Tuning and Optimization.

Part VI: Sunday Afternoon.

Session 27: Disaster Recovery.

Session 28: SQL Server Security.

Session 29: Database Connectivity.

Session 30: Advanced Features of Microsoft SQL Server 2000.

Appendix A: Answers to Part Reviews.

Appendix B: What's on the CD-ROM.

Index.

End-User License Agreement.

CD-ROM Installation Instructions.