International Kindle Paperwhite
This item cannot be shipped to your selected delivery location. Please choose a different delivery location.
Added to

Sorry, there was a problem.

There was an error retrieving your Wish Lists. Please try again.

Sorry, there was a problem.

List unavailable.
Kindle app logo image

Download the free Kindle app and start reading Kindle books instantly on your smartphone, tablet, or computer - no Kindle device required.

Read instantly on your browser with Kindle for Web.

Using your mobile phone camera - scan the code below and download the Kindle app.

QR code to download the Kindle App

  • Microsoft SQL Server 2000 Weekend Crash Course

Follow the author

Get new release updates & improved recommendations
Alex Kriegel
Follow
Something went wrong. Please try your request again later.

Microsoft SQL Server 2000 Weekend Crash Course Pap/Cdr Edition

by Alex Kriegel (Author)
3.7 out of 5 stars (12)
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.
Read more
Previous slide of product details
  1. ISBN-10
    0764548409
  2. ISBN-13
    978-0764548406
  3. Edition
    Pap/Cdr
  4. Publisher
    Wiley
  5. Publication date
    October 15, 2001
  6. Language
    English
  7. Dimensions
    7.3 x 0.8 x 9.2 inches
  8. Print length
    408 pages
Next slide of product details

Editorial Reviews

From the Back Cover

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 software

About the Author

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.

Product details

  • Publisher ‏ : ‎ Wiley
  • Publication date ‏ : ‎ October 15, 2001
  • Edition ‏ : ‎ Pap/Cdr
  • Language ‏ : ‎ English
  • Print length ‏ : ‎ 408 pages
  • ISBN-10 ‏ : ‎ 0764548409
  • ISBN-13 ‏ : ‎ 978-0764548406
  • Item Weight ‏ : ‎ 1.55 pounds
  • Dimensions ‏ : ‎ 7.3 x 0.8 x 9.2 inches
  • Customer Reviews:
    3.7 out of 5 stars (12)

About the author

Follow authors to get new release updates, plus improved recommendations.
Alex Kriegel

Alex Kriegel

Brief content visible, double tap to read full content.
Full content visible, double tap to read brief content.

Discover more of the author’s books, see similar authors, read book recommendations and more.

Customer reviews

3.7 out of 5 stars
12 global ratings

Top reviews from the United States

  • Natalie
    5.0 out of 5 stars Great and easy to understand
    Reviewed in the United States on January 28, 2007
    Format: PaperbackVerified Purchase
    If you just starting out or need to refresh your memory -- this is the book.

    Recomend it together with Beginning SQL Server 2005 Programming by Robert Vieira (WROX)
    One person found this helpful
    Helpful
     Report
  • HookedOC
    1.0 out of 5 stars All content removed from CD, only SQL server remains
    Reviewed in the United States on July 24, 2006
    Format: Paperback
    I bought this book because it advertised that examples and code were on the included CD. Wiley (current publisher)has apparently removed the content without removing the promise of content in the book, on the cover, or in the advertising. I tried to contact Wiley and the author, but got no response from either. Lack of promised content makes this book useless as a weekend crash course.
    2 people found this helpful
    Helpful
     Report
  • J. Pagani
    2.0 out of 5 stars Don't waste your time here
    Reviewed in the United States on September 22, 2004
    Format: Paperback
    The book offers to show you all sorts of querys, stored procedures, rules, and in general the T-SQL language. However, No one ever proof read the book to see if the formulas worked. I've spent so much time "De-bugging the examples" I tossed the book out. Makes you wonder what the other reviewers were looking at. What a waste!
    4 people found this helpful
    Helpful
     Report
  • Avid Reader
    4.0 out of 5 stars Great book for beginners! Covers good topics Concisely!
    Reviewed in the United States on February 22, 2005
    Format: Paperback
    This book ideal for:
    1) Those who do not know SQL at all.
    2) Those who knows SQL little but want to learn more but quick and easy way.
    3) Those who do want to know what SQL can do can not do.

    This book is highly recommended. It teaches you quickly and easily. This book do not claim that they will make you mater in two days but they do teach you everything they can and quick and easy way. This book does provide some good references and covers all the quick points about SQL. I have really read this book in weekend and I learn myself from the point where this books ends.

    Pinal Dave (Macromedia Certified Advanced ColdFusion MX Developer)
    5 people found this helpful
    Helpful
     Report
  • Stacy Zellmer
    5.0 out of 5 stars Lives up to its promise
    Reviewed in the United States on September 24, 2004
    Format: Paperback
    Lives up to its promise: introduction ito MSSQL Server, no less, no more.

    I moved from Oracle and was somehow confused by the "database", "filegroups" etc.

    I've got my answers here (and from couple more titles, to be sure)

    I neither had problems with instalation, nor with running the examples (save for one: the

    chapter on cursor sports keyword DEALLOCATED, has to be - DEALLOCATE; had to check BOL on that)

    The Transact-SQL examples could be better (I know PL/SQL, so I had some base here), but again

    the book does not claim to teach T-SQL..

    The code snippets sometime seem to be taken out of the contexts of bigger procedures, and

    I had to figure out how to fit them in; the usp_FindFactorial example seems too complex for

    the task it solves (it uses intermediate table to accumulate results

    instead of calling itself recursively; should it then be a function?),

    but my understanding is that the elegancy was sacrificed to cram in more techniques than requred.

    My examples did run correctly, though

    After I was through with the book, I had to buy an additional one on Transact-SQL

    (IMHO: O'Reily's book Transact-SQL Programming did NOT live up to my expectattions

    and the publisher's reputation; I used Sam's T-SQl in 21 days, and then Ken Henderson's book)

    To sum up: if you are new to SQL server, and find yourself

    somewhat overwhelmed by the Books-On-line style

    (comes free with every MSSQL Server installation), get this book

    NB: better download new installation from microsoft site; the one included with the book does not have latest security patches)
    7 people found this helpful
    Helpful
     Report
  • John
    1.0 out of 5 stars Lots of errors/mistakes
    Reviewed in the United States on November 6, 2003
    Format: Paperback
    I would not recommend this book. It barely skims the surface of what you really need to know to become proficient with SQL Server 2000. The book also contains numerous, and I mean numerous, typos, mistakes and incorrect code that will not work.
    5 people found this helpful
    Helpful
     Report
  • T. Flatau
    5.0 out of 5 stars Great SQL Server 2000 Overview
    Reviewed in the United States on June 28, 2002
    Format: Paperback
    If you are looking for a book that will provide overview of SQL Server 2000 without diving into too many details - This is the book for you!
    This book glances through all the main features of SQL Server 2000, providing a very good introduction to all of them. SQL Server 2000 is a very complex, feature rich product. This book does a wonderful job of explaining the various features with out going to too many details that 99% of the users will not need anyway.
    I especially liked the sections about performance tuning, optimizations and automating administration tasks that provide easy to understand information about those advanced SQL Server features.
    If you are a full time job SQL Server DBA, you will probably want a more in depth book. All other SQL Server users - Go get this book!
    17 people found this helpful
    Helpful
     Report
  • Eldon
    5.0 out of 5 stars Highly recommended
    Reviewed in the United States on November 7, 2003
    Format: Paperback
    Highly recommended. The book goes easy on you,and it does not assume any previous knowledge on your part.It will not make you an accomplished DBA over a weekend, but I recommend it as a olid introduction.Material is well organized and presented, with a fair portion of typos and slips :)I did not encounter any installation problems reported from Colorado: no key was ever required (maybe they print special edition for Boulder, CO?). Nevertheless, I do recommend downloading trial version from Microsoft, as it contains the latest fixes (the book was published in 2001, after all).
    3 people found this helpful
    Helpful
     Report