Sams Teach Yourself Microsoft SQL Server 2000 in 21 Days

Overview

Sams Teach Yourself Microsoft SQL Server 2000 in 21 Days, 2E will clearly define and walk the reader through the features of SQL Server 2000. The reader will be given tips and tricks for working within the new SQL Server 2000 product environment as well as working with SQL Server databases. The book will ...

See more details below
Available through our Marketplace sellers.
Other sellers (Multimedia Set)
  • All (18) from $1.99   
  • New (4) from $9.94   
  • Used (14) from $1.99   
Close
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$9.94
Seller since 2006

Feedback rating:

(58)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

New
PAPERBACK New 0672319691. New, Unused, Soft-cover Book with minor cover wear and/or page damage (cut, tear or bend/crease typically). Book may have remainder mark on it. Does ... NOT affect book content! Items ship within 24 hours with FREE tracking. Read more Show Less

Ships from: Foley, AL

Usually ships in 1-2 business days

  • Canadian
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$32.59
Seller since 2014

Feedback rating:

(259)

Condition: New
Brand New Item.

Ships from: Chatham, NJ

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$45.00
Seller since 2014

Feedback rating:

(146)

Condition: New
Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
$45.00
Seller since 2014

Feedback rating:

(146)

Condition: New
Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
Page 1 of 1
Showing All
Close
Sort by
Sending request ...

Overview

Sams Teach Yourself Microsoft SQL Server 2000 in 21 Days, 2E will clearly define and walk the reader through the features of SQL Server 2000. The reader will be given tips and tricks for working within the new SQL Server 2000 product environment as well as working with SQL Server databases. The book will feature information on:

  • Create and alter databases.
  • Manage security and implement permissions.
  • Protect, backup, and restore data.
  • Enforce and ensure data integrity.
  • Modify and manipulate data.
  • Create views, triggers, functions, and stored procedures.
Read More Show Less

Editorial Reviews

Booknews
Certified Microsoft Trainers and Solutions Developers structure a mini-course for SQL Server administrators in Microsoft's newest version of its flagship relational database management system, covering SQL Server 2000's improvements and new features (e.g. new administrative tools and desktop installation). Includes a quiz-a- day with answer key for 21 days, though two bonus days extend the course to 23 days. The CD-ROM includes an evaluation copy of the server. Annotation c. Book News, Inc., Portland, OR (booknews.com)
Read More Show Less

Product Details

  • ISBN-13: 9780672319693
  • Publisher: Pearson Education
  • Publication date: 10/19/2000
  • Series: Sams Teach Yourself Series
  • Edition description: BK&CD-ROM
  • Edition number: 1
  • Pages: 880
  • Product dimensions: 7.36 (w) x 9.06 (h) x 1.92 (d)

Meet the Author

Richard Waymire, a group program manager with the SQL Server development team at Microsoft, is also a Microsoft Certified Database Administrator and Systems Engineer. He's been working on various versions of SQL Server since 1994, and joined the Microsoft development team in 1998. Richard has been a programmer, DBA, and trainer on SQL Server before joining Microsoft. Richard still considers himself a database administrator at heart. You can reach Richard at rwaymi@hotmail.com.

Rick Sawtell is a Microsoft Certified Solutions Developer and Certified Trainer. He owns his own consulting firm based in the Hawaiian Islands and currently consults, trains, and writes computer books on several Microsoft products. He has more than 17 years of experience in the consulting and programming arena, with emphasis on database front-end and back-end development. You can reach Rick at r_sawtell@hotmail.com.

Read More Show Less

Table of Contents

Introduction 1
Week 1 At a Glance 7
Day 1 Introducing Relational Databases and Microsoft SQL Server 2000 9
Day 2 Installing Microsoft SQL Server 2000 23
Day 3 Working with SQL Server 2000 Management Tools and Utilities 65
Day 4 Creating and Administering Databases and Data Files 113
Day 5 Setting Up Login and User Security 147
Day 6 Establishing Database Permissions 185
Day 7 Backing Up Your Databases 221
Week 2 At a Glance 265
Day 8 Restoring Your Databases 267
Day 9 Data Types and Creating Tables 299
Day 10 Retrieving Data with the SELECT Statement 327
Day 11 Modifying Data 377
Day 12 Using Transact-SQL Extensions 395
Day 13 Indexing for Performance 431
Day 14 Ensuring Data Integrity 473
Week 3 At a Glance 513
Day 15 Creating Views, Triggers, Stored Procedures, and Functions 515
Day 16 Understanding Replication Design Methodologies 551
Day 17 Implementing Replication Methodologies 585
Day 18 Scheduling Jobs with SQL Server Agent 627
Day 19 Migrating Data Between Database Servers 663
Day 20 Performance Monitoring Basics and Tools 691
Day 21 Using XML with SQL Server 2000 721
Week 4 At a Glance 757
Day 22 An Overview of Analysis Services 759
Day 23 An Overview of English Query 773
Appendix 787
App. A: Answers to Quiz Questions 789
App. B Installing MSDE 2000 813
App. C High Availability Overview 823
Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)