close menu
Bookswagon-24x7 online bookstore
close menu
My Account
Home > Computing and Information Technology > Databases > MCAD/MCSE/MCDBA 70-229 Exam Cram 2: Designing & Implementing Databases w/SQL Server 2000 Enterprise Edition(English)
31%
MCAD/MCSE/MCDBA 70-229 Exam Cram 2: Designing & Implementing Databases w/SQL Server 2000 Enterprise Edition(English)

MCAD/MCSE/MCDBA 70-229 Exam Cram 2: Designing & Implementing Databases w/SQL Server 2000 Enterprise Edition(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
X

About the Book

The MCAD/MCSE/MCDBA 70-229 Exam Cram 2: Designing & Implementing Databases with SQL Server 2000 Enterprise Edition covers exactly what you need to know to pass the 70-229 exam. It is the ideal refresher that ensures readers cover the essentials and the ultimate complement guide for larger training guides, instructor-led classes or CBT training. This comprehensive reference guide also comes with the popular "Cram Sheet" tear card for your last minute cram sessions, and the accompanying CD includes a practice test engine powered by MeasureUp. You will also benefit from the community support at www.examcram2.com, which features industry news, study tips, practice exams, and discussion boards.

Table of Contents:
Introduction. Self-Assessment. 1. Database Development on SQL Server 2000.     Introduction      The Server and Its Components      The Exam      Knowing the New Features Found in SQL Server 2000      Other Relevant Exam Topics      SQL Server Product Implementation      Program Execution      The Query Analyzer      SQL Server Objects      The Master Database      The Msdb Database      The Tempdb Database      The Model Database      The Distribution Database      Objects Within a Database      Other Objects Found on the Server      Types of Data      Object Definitions      Metadata      User Data      Numeric Data Types      Character Data Types      Binary Data Types      Specialty Data Types      User-Defined Data Types      Exam Prep Questions  2. Creating a Logical Data Model.     Introduction      Data Modeling and Logical Data Design      Data Modeling      Modeling with the ER Data Model      Data Normalization      Data Normalization with Normal Forms      Denormalization      Relationships Between Entities      Identification of Relationships      One-To-One Relationship      One-To-Many Relationship      Many-to-Many Relationship      Exam Prep Questions  3. Implementing the Physical Database.     Introduction      A Hardware Dialogue      Defining a SQL Server Database      The File System      Creating Files and Filegroups      File Placement for Performance and Reliability      Database Creation      Using a Collation Sequence      Altering Database Properties      Inside the Database      Tables      Diagrams      Views      Stored Procedures      Users and Roles      Rules      Defaults      User-Defined Data Types and Functions      Full-Text Catalogs      What's on the Table      Data Element Definition      Keys to Success      Using Cascade Action      Maintaining Order with Indexes      Room for Additions      Data Entry Using Defaults      Checks and Balances      Other Bits and Pieces      Trigger Utilization      Troubleshooting Failed Object Creation      Exam Prep Questions  4. Advanced Physical Database Implementation.     Introduction      The Need for a More Complex Design      User Interaction Through Views      Getting a Better View      Utilizing Views      Indexed Views      Schema Binding      Partitioned Views      Operating-System Service Properties      Server Configuration Settings      Database Configuration Options      Settings for Automatic Actions      Moving the Cursor      Settings for Recovery      Set Coding Reaction with SQL Options      The State of the Server      Other Multiple Machine Database Implementations      Standby Servers and Log Shipping      Replicating Data      Replication Strategies      Types of Replication      Exam Prep Questions  5. Retrieving and Modifying Data.     Introduction      Moving a Mountain of Data      Mass Movements of Data via BCP      Using Backup/Restore for More Than Recovery      Data Movement with Manipulation      Selecting Information from the Data      Narrowing the Scope of Data Retrieval      Conditional Filtering of Data      Putting It All in ORDER      Displaying Groups in Output      More Advanced Query Groups      Joining Multiple Sets of Data      Return Output Only When It Matches-Inner      Return Output Even When It Doesn't Match-Outer      Joining Everything to Everything-Crossing      Multiple Datasets-Unions      Adding and Modifying Data      Extensible Markup Language (XML)      Simplifying XML Use      Moving Data Using XML      Exam Prep Questions  6. Programming Business Logic.     Introduction      Start with Data Analysis Prior to Coding      Making Data Presentable      Functions Make Data Work      Aggregate Collective Functions      Functions Used for Deviation and Variance      Checksum Operations     Of Calendars and Clocks      Using Mathematical Functions in T-SQL      String It Up      Working with System-Level Functions      Information Schema Views      Providing the Orders to Be Followed      Coding with Variables      Setting and Using Variables      Server Provided Global Values      Document As You Go      Statement Blocks with BEGIN...END      Conditional Statements with IF...ELSE      Multiple Conditions with CASE      Loops in T-SQL      Traditional Data Processing      Converting Constructs to Code      Using Stored Procedures      Creating Stored Procedures      Results from Procedure Execution      True Customization with User-Defined Functions      Alternative Coding Mechanisms      Code Responses to Actions      Appropriate Use of INSTEAD OF Triggers      Exam Prep Questions  7. Tuning and Optimizing Analysis.     Introduction      Information Gathering      Processes Operating in the Environment      External Tools Provided by the Operating System      Monitor Activity with the Profiler      Using Profiler Traces to Diagnose Locking      Trace Playback and Diagnosis      Query Optimization      The SQL Query Analyzer      Query Execution Plans      Reading Execution Plans      Execution Plan Caching and Sharing      Optimizer Hints      Exam Prep Questions  8. Designing for Optimized Data Access.     Introduction      Concurrency and Locking      Controlling Lock Behavior      Controlling Business Logic Using Transactions      Data Access Using Stored Procedures      Optimization Through Design      Pointing an Index in the Right Direction      Clustered Indexes      Nonclustered Indexes      Index Maintenance over Time      Using the Index Tuning Wizard      Partitioned Views to Optimize Access      Indexing Views for Optimization      Maintaining the System to Get Back Performance      Stored Procedures Used for Maintenance      Problem Analysis Through Statistical Functions      Database Console Command (DBCC)      Exam Prep Questions  9. Designing a Database Security Plan.     Introduction      The SQL Server Login/User Model      Using Security Roles      Defining Your Own Roles      Using Application Roles      Encryption Can Secure Definitions      Auditing User Activity      Security Audits      Statement Permissions      Object Permissions      Using Statement and Object Permissions      Using Views to Enhance Security      Stored Procedures Security Implementations      Controlling, Filtering, and Enforcing Data Access      Troubleshooting Security Issues      Dealing with Broken Ownership Chains      Exam Prep Questions  10. Completing a Business System Design.     Introduction      SQL Server Supporting Applications      One- and Two-Tier Systems      Three- or More Tier Systems      Internet Application Architecture      SQL Server 2000 Back Office Integration      Third-Party Database Interactions      Data Replication      Very Large Database Applications      Coding for Distributed Data      A Brief Discussion on OLE-DB      Using OPENROWSET      Creating a Linked Server      SQL Server Automation of Processes      Job, Operator, Alert Integration      Jobs Perform Recurring Tasks      Operators Can Respond to Events      Alerts Inform Based on Events      Exam Prep Questions  11. Practice Exam One. 12. Answers to Practice Exam One. 13. Practice Exam Two. 14. Answers to Practice Exam Two. Appendix A. What's on the CD?     Multiple Test Modes      Study Mode      Certification Mode      Custom Mode      Missed Question Mode      Non-Duplicate Mode      Question Types      Random Questions and Order of Answers      Detailed Explanations of Correct and Incorrect Answers      Attention to Exam Objectives      Installing the CD      Creating a Shortcut to the MeasureUp Practice Tests      Technical Support  Appendix B. Need to Know More? Glossary. Index.


Best Sellers



Product Details
  • ISBN-13: 9780789731067
  • Publisher: Pearson Education (US)
  • Publisher Imprint: Pearson IT Certification
  • Depth: 31
  • Height: 153 mm
  • No of Pages: 504
  • Spine Width: 28 mm
  • Weight: 644 gr
  • ISBN-10: 0789731061
  • Publisher Date: 23 Jun 2005
  • Binding: SA
  • Edition: PAP/CDR
  • Language: English
  • Series Title: English
  • Sub Title: Designing & Implementing Databases w/SQL Server 2000 Enterprise Edition
  • Width: 229 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
MCAD/MCSE/MCDBA 70-229 Exam Cram 2: Designing & Implementing Databases w/SQL Server 2000 Enterprise Edition(English)
Pearson Education (US) -
MCAD/MCSE/MCDBA 70-229 Exam Cram 2: Designing & Implementing Databases w/SQL Server 2000 Enterprise Edition(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.

MCAD/MCSE/MCDBA 70-229 Exam Cram 2: Designing & Implementing Databases w/SQL Server 2000 Enterprise Edition(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



    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!
    ASK VIDYA