Microsoft SQL Server 2000 Weekend Crash Course

Alex Kriegel is a Microsoft Certified Solution Developer who is employed by Psion Teklogix International, Inc., Integration Services Group. Psion Teklogix International Inc, Integration Services's main product is TekRF Integration Components for SAP R/3, which serve as middleware that interfaces terminals into a SAP R/3 System. Alex's company also supplies custom transaction sets to perform all kinds of warehouse operations like picking, put away, and inventory count. Among other technologies, Psion's application uses Microsoft SQL Server 6. In addition to his programming job, Alex has been responsible for troubleshooting SQL Server installations for customers around the world, optimizing performance and devising SQL stored procedures. He has also conducted an internal, hands--on training course on SQL Server for Psion's SAP analysts. It consists of three 2--hour sessions and targets a beginning to intermediate audience.

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.