Microsoft® SQL Server 2000 Weekend Crash CourseTM

by
Edition: CD
Format: Paperback
Pub. Date: 2001-10-01
Publisher(s): Wiley
List Price: $29.99

Rent Book

Select for Price
There was a problem. Please try again later.

New Book

We're Sorry
Sold Out

Used Book

We're Sorry
Sold Out

eBook

We're Sorry
Not Available

How Marketplace Works:

  • This item is offered by an independent seller and not shipped from our warehouse
  • Item details like edition and cover design may differ from our description; see seller's comments before ordering.
  • Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
  • Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
  • Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.

Summary

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.

Author Biography

<b>Alex Kriegel</b> is a Microsoft Certified Solution Developer who is employed by Psion Teklogix International, Inc., Integration Services Group.<br> 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.<br> ition 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.

Table of Contents

Preface vii
Acknowledgments xiii
FRIDAY 2(2)
Part I---Friday Evening 4(44)
Getting Started
5(14)
Go Configure
19(10)
First Look at Enterprise Manager Console
29(8)
Second Look at Enterprise Manager Console
37(11)
SATURDAY 48(2)
Part II---Saturday Morning 50(74)
Relational Database Concepts
51(10)
SQL Server Databases
61(12)
Creating and Using a Custom Database
73(8)
Transact-SQL Programming Language
81(14)
T-SQL and SQL Query Analyzer
95(12)
Programming with T-SQL
107(17)
Part III---Saturday Afternoon 124(66)
Creating and Using Stored Procedures
125(12)
Trigger Happy
137(8)
Introducing Cursors
145(10)
Understanding Indexes
155(12)
Rules, Defaults, and Constraints
167(10)
Understanding Transactions and Locks
177(13)
Part IV---Saturday Evening 190(48)
Data Transformation Services
191(10)
SQL Server Back Up
201(12)
SQL Server Replication
213(12)
User Management
225(13)
SUNDAY 238(2)
Part V---Sunday Morning 240(68)
Managing Your Databases Visually
241(10)
Distributed Transaction Coordinator
251(12)
Accessing SQL Server System Information
263(10)
Automating Administration Tasks with SQL Server Agent
273(10)
Configuring SQL Server Mail
283(10)
Performance Tuning and Optimization
293(15)
Part VI---Sunday Afternoon 308(47)
Disaster Recovery
309(10)
SQL Server Security
319(12)
Database Connectivity
331(10)
Advanced Features of Microsoft SQL Server 2000
341(14)
Appendix A-Answers to Part Reviews 355(12)
Appendix B-What's on the CD-ROM? 367(4)
Index 371(12)
Hungry Minds, Inc. End-User License Agreement 383(3)
CD-ROM Installation Instructions 386

An electronic version of this book is available through VitalSource.

This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.

By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.

Digital License

You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.

More details can be found here.

A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.

Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.

Please view the compatibility matrix prior to purchase.