Microsoft SQL Server 2000 Weekend Crash Course (Paperback, CD-ROM)

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.