Microsoft® SQL Server(TM) 2000 Programming Step by Step (Step by Step (Microsoft)) [Paperback]

Rebecca Riordan (Author)

Book Description

ISBN-10: 0735611424 | ISBN-13: 978-0735611429 | Publication Date: December 29, 2000

With scalability for the most demanding applications, Microsoft® SQL Server™ 2000 can dramatically reduce the time needed to bring e-commerce, data warehousing, and line-of-business applications to market. Whether you’re new to databases or familiar with Microsoft Access, Oracle, and other relational databases, MICROSOFT SQL SERVER 2000 PROGRAMMING STEP BY STEP is the ideal way to learn how SQL Server can work for you. Written by an experienced database developer and author and replete with examples and exercises, this book will help you quickly get up to speed with creating and maintaining databases using the interactive tools provided by SQL Server 2000 Personal, Standard, and Enterprise Editions. It’s a must-have resource for anyone who wants to create and maintain databases and program with Transact-SQL.

This title shows you how to: Get started with SQL Server:

• Use the Enterprise Manager to connect to a database; start, stop, and pause SQL Server
• Back up and restore a database and use the Maintenance Plan Wizard to create a monthly backup plan and manage SQL Server security functions.
• Create a SQL database: Create and manage databases, tables, indexes, relationships, constraints, table objects, and database diagrams.
• Retrieve data: Retrieve rows, use the SELECT statement, join tables and summarize data, and view data in a variety of ways.
• Work with data: Add, delete, and update rows, and import and export data.
• Use the Transact-SQL programming language: Understand operators, variables, parameters, and control of flow
• Use stored procedures; create and manage triggers
• Learn error handling

Included on CD-ROM!

Sample database files

Sample script code in Transact-SQL

A Note Regarding the CD or DVD

The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to [e-mail].

Product Details

• Paperback: 690 pages
• Publisher: Microsoft Press (December 29, 2000)
• Language: English
• ISBN-10: 0735611424
• ISBN-13: 978-0735611429
• Product Dimensions: 9.2 x 7.4 x 1.7 inches
• Shipping Weight: 1 pounds
• Average Customer Review: 2.7 out of 5 stars  See all reviews (17 customer reviews)
• Amazon Best Sellers Rank: #1,691,993 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

8 of 8 people found the following review helpful:

5.0 out of 5 stars Excellent SQL Starter Guide!, January 5, 2001

By 

Stephen Jeffries - See all my reviews

This review is from: Microsoft® SQL Server(TM) 2000 Programming Step by Step (Step by Step (Microsoft)) (Paperback)

Once again Rebecca has taken a difficult topic - SQL Server 2000 - and turned the complexitities of the topic around. I have found this book to be an excellent guide to using Microsoft SQL Server 2000, and a good reference to fall back on.

I would recommend this to anyone who is either planning or currently doing work with SQL Server 2000, you will find this to be an invaluable additional to the reference material included with SQL Server.

Buy it today, you will not regret it!

14 of 18 people found the following review helpful:

2.0 out of 5 stars A waste of money..., April 24, 2001

By 

Robert M. Downey (Cambridge, MA United States) - See all my reviews
(REAL NAME)   

This review is from: Microsoft® SQL Server(TM) 2000 Programming Step by Step (Step by Step (Microsoft)) (Paperback)

I am very new to SQL Server 2000 (or any SQL Server for that matter), so I wanted a book that was robust, but was easy to follow. "Step by Step" seemed to be the way to go, but this book leaves MUCH to be desired.

It is WAY too basic. I mean, the language SQL Server uses is called TRANSACT-SQL, but not ONCE in the book does she go over TRANSACTIONS!! She reiterated the same points over and over, and used WAY too many screen shots. I would say at least 70% of the book is comprised of useless screen shots. You get hardly any actual content at all... and best of all, the examples are VERY weak.

I am a big fan of WROX books, since WROX books are very complete and can be used as a desk reference. This book, however, is usless the second you finish it. I recommend it ONLY to people who have never programmed ANYTHING before, and to those who don't care about learning fundementals like transactions.

The entire contents of this book can be learned from a 30 minute reading of some of the MSDN documentation.

4 of 4 people found the following review helpful:

4.0 out of 5 stars 'Step by Step Microsoft SQL Server 2000 Programming', March 14, 2001

By A Customer

This review is from: Microsoft® SQL Server(TM) 2000 Programming Step by Step (Step by Step (Microsoft)) (Paperback)

This is a well written book suitable for beginners like myself with limited exposure on database etc. The examples are clear and free of errors. I completed the first 21 chapters in two days. I would recommend this book to anyone new to the subject of SQL servers.