Microsoft SQL Server 2000 Weekend Crash Course

Microsoft SQL Server 2000 Weekend Crash Course

By (author) 

List price: US$29.99

Currently unavailable

Add to wishlist

AbeBooks may have this title (opens in new window).

Try AbeBooks

Description

Microsoft SQL Server 2000 Weekend Crash Course includes 30 sessions on the key aspects of Microsoft SQL Server 2000. Each session is designed to take 30 minutes to complete, so the Crash Course is an intense 15--hour learning period. You can complete the Crash Course over a weekend ---- but you can also easily adapt the Crash Course sessions to whatever schedule best suits your needs.show more

Product details

  • CD-ROM | 408 pages
  • 188.2 x 234.2 x 25.1mm | 644.11g
  • John Wiley & Sons Inc
  • Hungry Minds Inc,U.S.
  • Foster City, United States
  • English
  • 1. Auflage
  • 0764548409
  • 9780764548406

Back cover copy

Get up to Speed on SQL Server 2000 -- in a Weekend! The big day is Monday. The day you get to show off what you know about SQL Server 2000. The problem is, you're not really up to speed. Maybe it's been a while since you worked with SQL Server. Or maybe you just like a challenge. In any event, we've got a solution for you -- Microsoft SQL Server 2000 Weekend Crash Course. Open the book Friday evening and by Sunday afternoon, after completing 30 fast, focused sessions, you'll be able to get right to work on a SQL Server 2000 databases. It's as simple as that. THE CURRICULUM FRIDAY Evening: 4 Sessions, 2 Hours Microsoft SQL Server 2000: Getting Started; Go Configure: After Installation; First Look at Enterprise Manager Console; Second Look at Enterprise Manager Console SATURDAY Morning: 6 Sessions, 3 Hours Relational Database Concepts; SQL Server Databases; Creating and Using a Custom Database; Transact-SQL Programming; SQL Query Analyzer; More Transact-SQL Programming Afternoon: 6 Session, 3 Hours Creating and Using Stored Procedures; OSQL and ISQL; Introducing Cursors; Understanding Transactions; Locking; Rules, Default, and Constraints Evening: 4 Sessions, 2 Hours Data Transformation; SQL Server Back Up; SQL Server Replication; User Management SUNDAY Morning: 6 Sessions, 3 Hours Managing Your Databases -- Visually; Microsoft Distributed Transaction Coordinator; System Functions and Stored Procedures; Automating Administration Tasks with SQL Server Agent; SQL Mail Agent; Performance Tuning and Optimization Afternoon: 4 Sessions, 2 Hours Disaster Recovery; SQL Server Security; Database Connectivity; Advanced Features of Microsoft SQL Server 2000 2 CD-ROMs INCLUDED: * SQL Server 2000 120-day Evaluation Edition * SQL Programmer trial version * Evaluation versions of database utilities, including Rapid SQL, DB Artisan, and ER/Studio * Web links to useful SQL Server sites * Sample code and script * Assessment softwareshow more

About Alex Kriegel

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.show more

Table of contents

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.show more