MCTS Microsoft SQL Server 2005 Implementation and Maintenance Study Guide
Home > Computing and Information Technology > Computer certification > MCTS Microsoft SQL Server 2005 Implementation and Maintenance Study Guide: Exam 70-431
MCTS Microsoft SQL Server 2005 Implementation and Maintenance Study Guide: Exam 70-431

MCTS Microsoft SQL Server 2005 Implementation and Maintenance Study Guide: Exam 70-431

|
     0     
5
4
3
2
1




Out of Stock


Notify me when this book is in stock
About the Book

With the release of SQL Server 2005, Microsoft is introducing a new multi-exam certification program. The Microsoft SQL Server 2005 Implementation and Maintenance exam (70-431) is the first stop for everyone entering this new certification track, and serves as both a single exam certification as well as the entry exam for the MCITP-level certifications. This book provides an introduction to the development and administrative aspects of SQL Server 2005 and features practical guidance for all aspects of the exam. Get a great start in your certification process today with this comprehensive guide which includes: Hundreds of challenging practice questions plus two bonus exams Leading-edge exam preparation software, including a test engine Authoritative coverage of all key exam objectives, including: Installing and Configuring SQL Server 2005 Implementing High Availability and Disaster Recovery Supporting Data Consumers Maintaining Databases Monitoring and Troubleshooting SQL Server Performance Creating and Implementing Database Objects Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Table of Contents:
Introduction. Assessment Test. Chapter 1 Installing Microsoft SQL Server 2005. Meeting the Prerequisites. Preparing to Install. Choosing Default Instances or Named Instances. Choosing Service Accounts. Selecting an Authentication Mode. Choosing a Collation Setting. Upgrading from a Previous Version. Installing SQL Server 2005. Installing a Second Instance. Troubleshooting the Installation. Chapter 2 Creating and Configuring Databases. Planning Your Database. Introducing Database Files. Introducing Filegroups. Deciding on Database File Placement. Introducing RAID-0. Introducing RAID-1. Introducing RAID-5. Introducing RAID-10. Creating Data Storage Structures. Introducing Extents. Introducing Pages. Estimating Storage Requirements. Estimating Table Storage Requirements. Estimating Index Storage Requirements. Creating and Configuring Databases. Creating a Database. Gathering Information about Your Database. Setting Database Options. Chapter 3 Working with Tables and Views. Planning Tables. Introducing Built-in Datatypes. Introducing Computed Columns. Creating Tables. Restricting the Data. Introducing Constraints. Partitioning Tables. Understanding Views. Modifying Data through a View. Working with Indexed Views. Chapter 4 Performing Indexing and Full-Text Searching. Understanding Index Architecture. Understanding Heaps. Understanding Clustered Indexes. Understanding Nonclustered Indexes. Creating Indexes. Using Primary Keys. Using Full-Text Searching. Chapter 5 Introducing More Database Objects. Introducing Stored Procedures. Understanding the Types of Stored Procedures. Creating Stored Procedures. Recompiling Stored Procedures. Introducing Triggers. Understanding the Types of Triggers. Understanding DML Triggers. Understanding DDL Triggers. Understanding Trigger Recursion and Nesting. Understanding Disabling Triggers. Understanding Event Notifications. Introducing Functions. Understanding the Types of Functions. Using Scalar Functions. Introducing Table-Valued Functions. Introducing Built-in Functions. Introducing CLR Functions. Introducing Deterministic and Nondeterministic Functions. Introducing User-Defined Types. Creating T-SQL User-Defined Types. Creating CLR User-Defined Types. Getting More CLR Functionality. Chapter 6 Implementing Security in SQL Server 2005. Understanding Security Modes 190 Using Windows Authentication Mode 190 Using Mixed Mode 191 Setting the Authentication Mode 191 Understanding SQL Server Logins 193 Using Standard Logins 193 Using Windows Logins 196 Understanding the Items Common to All Logins 199 Understanding Fixed Server Roles 199 Creating Database User Accounts 202 Understanding Permissions 204 Applying Statement Permissions 205 Applying Object Permissions 207 Understanding Database Roles 210 Using Fixed Database Roles 210 Using Custom Database Roles 212 Using Application Roles 215 Understanding Permission States 217 Granting a Permission 217 Revoking a Permission 217 Denying a Permission 217 Introducing Ownership Chains 221 Introducing Linked Server Security 223 Introducing Encryption 224 Creating a Security Plan. Chapter 7 Working with Relational Data. Understanding and Using Transactions 242 Executing Implicit and Explicit Transactions 243 Committing and Rolling Back 244 Executing Distributed Transactions 246 Populating Tables 247 Importing Data Using Bulk Insert 247 Importing Data Using the bcp Utility 248 Copying Data Using SSIS 250 Bulk Inserting XML Data 252 Supporting the Bulk-Logged Recovery Model 253 Supporting Different Collation Types and Orders When Querying Data 255 Formatting and Converting Datatypes 256 Casting and Converting 261 Understanding Datatype Precedence 264 Understanding Collations 265 Introducing Error Handling 266 Using RAISERROR. Using @@ERROR Using Error Messages 267 Using TRY…CATCH Blocks. Chapter 8 Working with XML Data. Understanding XML Data 282 Using the xml Datatype 283 Using Untyped XML 284 Using Typed XML 285 Working with XML Schema 285 Querying XML Data 288 Using the query Method. Using the value Method. Using the exist Method. Using the modify Method. Using the nodes Method. Creating XML Indexes. Chapter 9 Working with Service Broker and HTTP. Understanding the SQL Server Service Broker Architecture. Working with Service Broker. Creating a Message Type. Creating a Queue. Creating a Contract. Creating a Service. Creating a Route. Using Service Broker. Sending Messages. Receiving Messages. Automating the Queue Processing. Introducing HTTP Endpoints. Configuring HTTP Endpoints. Securing HTTP Endpoints. Chapter 10 Maintaining and Automating SQL Server. Maintaining Indexes. Understanding sys.DM_DB_INDEX_PHYSICAL_STATS. Reorganizing and Rebuilding Indexes. Maintaining Statistics. Maintaining Databases. Understanding DBCC CHECKDB. Shrinking Files. Understanding Automation Basics. Configuring Database Mail. Creating Operators. Creating Jobs. Creating Alerts. Creating Event Alerts Based on Standard Errors. Creating Event Alerts Based on Custom Errors. Creating Performance Alerts. Creating WMI Alerts. Using the Maintenance Plan Wizard. Copying Databases. Chapter 11 Performing Backups and Restores. Backing Up Your Data. Understanding How Backups Work. Creating a Backup Device. Performing Full Backups. Performing Differential Backups. Performing Transaction Log Backups. Performing Filegroup Backups. Backing Up to Multiple Devices. Restoring Databases. Performing Standard Restores. Performing Point-in-Time Restores. Performing Piecemeal Restores. Devising a Backup Strategy. Planning for Full Backups Only. Planning for Full with Differential Backups. Planning for Full with Transaction Log Backups. Planning for Full, Differential, and Transaction Log Backups. Planning for Filegroup Backups. Chapter 12 Achieving High Availability through Replication. Introducing Replication. Introducing the Publisher/Subscriber Metaphor. Introducing Articles. Introducing Publications. Understanding Replication Factors and Distribution Types. Using Distributed Transactions. Using Transactional Replication. Using Transactional Replication with Immediate Updating Subscribers. Using Snapshot Replication. Using Snapshot Replication with Immediate Updating Subscribers. Using Merge Replication. Using Queued Updating. Understanding Replication Internals. Understanding Merge Replication. Understanding Snapshot Replication. Understanding Transactional Replication. Considering Publication Issues. Considering Distributor Issues. Introducing Replication Models. Introducing Central Publisher/Central Distributor. Introducing Remote Distribution. Introducing Central Subscriber/Multiple Publishers. Introducing Multiple Publishers/Multiple Subscribers. Replicating over the Internet and to Heterogeneous Database Servers. Using Heterogeneous Replication. Using Internet Replication. Installing and Using Replication. Configuring SQL Server for Replication. Installing a Distribution Server. Adding a Publication. Creating a Subscription. Testing Replication. Managing Replication. Considering Administrative Issues. Considering Replication Backup Issues. Using the Replication Monitor. Working with Replication Scripts. Enhancing Replication Performance. Chapter 13 Introducing More High-Availability Methods. Choosing the High-Availability Features You Need. Implementing Database Mirroring. Understanding Database Mirroring Concepts. Preparing for Mirroring. Creating Endpoints. Specifying Partners and Witnesses. Configuring the Operating Mode. Switching Roles. Implementing Log Shipping. Monitoring the Server. Configuring Log Shipping. Changing Roles. Monitoring Log Shipping. Managing Database Snapshots. Creating a Snapshot. Reverting from a Snapshot. Chapter 14 Monitoring and Optimizing SQL Server 2005. Using System Monitor. Monitoring with SQL Profiler. Replaying a Trace File. Using the Database Engine Tuning Advisor. Troubleshooting SQL Server. Reading Error and Event Logs. Troubleshooting Blocks and Deadlocks. Troubleshooting Jobs. Using the Dedicated Administrator Connection. Glossary. Index.


Best Sellers


Product Details
  • ISBN-13: 9780470296615
  • Publisher: John Wiley & Sons Inc
  • Publisher Imprint: Sybex Inc.,U.S.
  • Language: English
  • Sub Title: Exam 70-431
  • ISBN-10: 0470296615
  • Publisher Date: 10 Dec 2007
  • Binding: Digital (delivered electronically)
  • No of Pages: 634


Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
MCTS Microsoft SQL Server 2005 Implementation and Maintenance Study Guide: Exam 70-431
John Wiley & Sons Inc -
MCTS Microsoft SQL Server 2005 Implementation and Maintenance Study Guide: Exam 70-431
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.

MCTS Microsoft SQL Server 2005 Implementation and Maintenance Study Guide: Exam 70-431

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!