Overview

Full Product Details

Author:   Alex Kriegel
Publisher:   John Wiley & Sons Inc
Imprint:   Hungry Minds Inc,U.S.
Dimensions:   Width: 18.50cm , Height: 2.00cm , Length: 23.30cm
Weight:   0.614kg
ISBN:  

9780764548406

ISBN 10:   0764548409
Pages:   408
Publication Date:   15 October 2001
Audience:   Professional and scholarly ,  General/trade ,  Professional & Vocational ,  General
Format:   Paperback
Publisher's Status:   Out of Stock Indefinitely
Availability:   Out of stock  

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.

Reviews

Author Information

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.

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions