close menu
Bookswagon-24x7 online bookstore
close menu
My Account
Home > Computing and Information Technology > Computer programming / software engineering > Database programming > Sams Teach Yourself Microsoft SQL Server 2000 in 21 Days: (English)
Sams Teach Yourself Microsoft SQL Server 2000 in 21 Days: (English)

Sams Teach Yourself Microsoft SQL Server 2000 in 21 Days: (English)

          
5
4
3
2
1

Out of Stock


Premium quality
Premium quality
Bookswagon upholds the quality by delivering untarnished books. Quality, services and satisfaction are everything for us!
Easy Return
Easy return
Not satisfied with this product! Keep it in original condition and packaging to avail easy return policy.
Certified product
Certified product
First impression is the last impression! Address the book’s certification page, ISBN, publisher’s name, copyright page and print quality.
Secure Checkout
Secure checkout
Security at its finest! Login, browse, purchase and pay, every step is safe and secured.
Money back guarantee
Money-back guarantee:
It’s all about customers! For any kind of bad experience with the product, get your actual amount back after returning the product.
On time delivery
On-time delivery
At your doorstep on time! Get this book delivered without any delay.
Notify me when this book is in stock
Add to Wishlist

About the Book

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.

Table of Contents:
(NOTE: Each chapter concludes with a Summary, Q&A, and Workshop.) Introduction. WEEK 1. AT A GLANCE. Day 1. Introducing Relational Databases and Microsoft SQL Server 2000. SQL Server Is Hot! The History of SQL Server. What Is a Database? Designing Relational Databases. SQL Server and the Client/Server Model. Day 2. Installing Microsoft SQL Server 2000. What Kinds of SQL Servers Are Available? SQL Server Requirements. Installing SQL Server 2000. Installing Other SQL Server Optional Components. Postinstallation: What Did You Get? Named Versus Default Instances. Upgrading from a Previous Version of SQL Server. Troubleshooting Your Installation. Removing SQL Server. Apply the Latest Service Pack. Day 3. Working with SQL Server 2000 Management Tools and Utilities. The Microsoft SQL Server Program Group. The Microsoft SQL ServerSwitch Program Group. Other SQL Server Tools/Utilities. Day 4. Creating and Administering Databases and Data Files. Creating a Database. Gathering Database Information. Setting Database Options. Resizing Your Database. Renaming a Database. Working with Database Filegroups. Removing a Database. Day 5. Setting Up Login and User Security. The SQL Server Security Access Model. The Security Modes of SQL Server (Including Logins). Database Users. Roles. Application Roles. Day 6. Establishing Database Permissions. Why Use Permissions? Implementing Database Permissions. SQL Servers Special Permissions. Statement Permissions. Object Permissions. Permissions on Views, Stored Procedures, and Functions. Ownership Chains. Designing a Permissions Strategy. Day 7. Backing Up Your Databases. Protecting Data with Mirroring, Duplexing, and Striping. How Backup Works. Backup Terminology. Backup Considerations. Backing Up User Databases. Backing Up System Databases. Preparing to Implement Backups. Backing Up a Database. Week 1. In Review. WEEK 2. AT A GLANCE. Day 8. Restoring Your Databases. Restoring Databases. Recovery Scenarios. Day 9. Data Types and Creating Tables. Tables. Columns. SQL Server Identifiers. Strings. Binary Data. Integers. Approximate and Exact Numeric Data Types. Special Data Types. Date and Time Data Types. Money. The Auto-incrementing rowversion (timestamp) Data Type. Working with ANSI and Unicode. Creating User-Defined Data Types. Working with Computed Columns. Creating Tables. Day 10. Retrieving Data with the SELECT Statement. Writing Simple SELECT Statements. Manipulating Data. System Functions. Data Conversion. Choosing Rows. Eliminating Duplicate Information. Sorting Data Using the ORDER BY Clause. Midday Review. Aggregate Functions. Super Aggregates (ROLLUP and CUBE). Data Correlation. Working with Subqueries. SELECT INTO. UNION Operator. Day 11. Modifying Data. Transaction Logging. Inserting Data. Deleting Data. Updating Data. Day 12. Using Transact-SQL Extensions. Batches. Scripts. Transactions. Control-of-Flow Language Elements. Locking. Day 13. Indexing for Performance. Why Use Indexes? SQL Server Indexes. Index Usage. Index Maintenance. Managing Indexes with SQL Server Enterprise Manager. Index Selection. Full-Text Indexing. Day 14. Ensuring Data Integrity. How to Enforce Data Integrity. Types of Integrity. Traditional Methods of Integrity. Ensuring Data Accuracy with ANSI Constraints and Declarative Integrity Mechanisms. Ensuring Data Accuracy with SQL Server Enterprise Manager. Week 2. In Review. WEEK 3. AT A GLANCE. Day 15. Creating Views, Triggers, Stored Procedures, and Functions. Creating and Manipulating Views. Working with Stored Procedures. Working with Triggers. Working with User-Defined Functions. Day 16. Understanding Replication Design Methodologies. What Is Replication? Distributed Data Factors. Distribution Methodologies. The Publisher/Subscriber Metaphor. How Does Replication Work? Replication Scenarios. Publishing SQL Server 2000 Databases to the Internet. Best Practices. Replicating Issues in a Heterogeneous Environment. Day 17. Implementing Replication Methodologies. Understanding Security Issues. Setting Up Your Servers. Installing Replication. Replication Considerations. Maintaining Replication. Day 18. Scheduling Jobs with SQL Server Agent. Why Automate SQL Server? Which Scheduling Tool Should You Use? SQLMail Integration. Sending Email from SQL Server. Scheduling Jobs. Setting Up Alerts and Operators. Taking Advantage of Performance Monitor Integration. Using the Database Maintenance Plan Wizard. Day 19. Migrating Data Between Database Servers. Moving Data with a Backup and Restore. Using BCP to Load Data. Working with the BULK INSERT Command. Working with Data Transformation Services. Day 20. Performance Monitoring Basics and Tools. Hardware Selection and Tuning. Windows 2000 Configuration Parameters. Windows 2000 Performance Monitor Counters. Configuring SQL Server. Monitoring SQL Server Performance. The Current Activity Window of SQL Server Enterprise Manager. The Index Tuning Wizard. Day 21. Using XML with SQL Server 2000. What Is XML? Installing SQLXML 3.0 Service Pack 1. Accessing SQL Server via Internet Information Server. Reading and Writing XML in SQL Server. New Features in SQLXML 3.0. Week 3. In Review. WEEK 4. AT A GLANCE. Day 22. An Overview of Analysis Services. Understanding Data Warehousing. Understanding Data Marts. Building a Data Warehouse. Understanding the Components of Analysis Services. Installing Analysis Services. Accessing the Sample Application for Analysis Services. Day 23. An Overview of English Query. English Query Components. How English Query Works. Normalization Requirements. Creating an English Query Application. Adding Synonyms to Your Entities. Adding Relationships to Your Model. Testing an English Query Application. Building an English Query Application. APPENDIXES. Appendix A. Answers to Quiz Questions. Appendix B. Installing MSDE 2000. What Is MSDE 2000? MSDE Licensing. MSDE Components. Installing MSDE 2000. Installing an MSDE 2000 Service Pack. Appendix C. High Availability Overview. Microsoft Cluster Service. Overview of High Availability. Terminology. Cluster Server Architecture. Cluster Service Components. Cluster Formation and Operation. Cluster Installation and Configuration. Log Shipping in SQL Server 2000. Index.


Best Seller

| | See All


Product Details
  • ISBN-13: 9780672324697
  • Publisher: Pearson Education (US)
  • Publisher Imprint: Sams Publishing
  • Edition: 0002-
  • Language: English
  • Series Title: English
  • Weight: 1610 gr
  • ISBN-10: 0672324695
  • Publisher Date: 19 Nov 2002
  • Binding: Paperback
  • Height: 189 mm
  • No of Pages: 960
  • Spine Width: 55 mm
  • Width: 231 mm


Similar Products

How would you rate your experience shopping for books on Bookswagon?

Add Photo
Add Photo

Customer Reviews

REVIEWS           
Click Here To Be The First to Review this Product
Sams Teach Yourself Microsoft SQL Server 2000 in 21 Days: (English)
Pearson Education (US) -
Sams Teach Yourself Microsoft SQL Server 2000 in 21 Days: (English)
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

Sams Teach Yourself Microsoft SQL Server 2000 in 21 Days: (English)

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book
    Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    New Arrivals

    | | See All


    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!
    ASK VIDYA