MCTS Self-Paced Training Kit: Exam 70-432: Microsoft SQL Server 2008 Implementation and Maintenance 1st Edition
    Share

    MCTS Self-Paced Training Kit: Exam 70-432: Microsoft SQL Server 2008 Implementation and Maintenance 1st Edition (English, Hardcover, Mike Hotek)

    MCTS Self-Paced Training Kit: Exam 70-432: Microsoft SQL Server 2008 Implementation and Maintenance 1st Edition  (English, Hardcover, Mike Hotek)

    3.9
    14 Ratings & 3 Reviews
    621
    695
    10% off
    Hurry, Only a few left!
  • Bank OfferExtra 5% off* with Axis Bank Buzz Credit Card
    T&C
  • Delivery
    Check
    Check pincode
      Usually delivered in9-10 days
      ?
      Enter pincode for exact delivery dates/charges
    View Details
    Author
    Highlights
    • Language: English
    • Binding: Hardcover
    • Publisher: Phi Learning Pvt. Ltd.
    • ISBN: 9788120337800, 8120337808
    • Edition: 1stEdition, 2009
    • Pages: 623
    Services
    • 10 Days Replacement Policy
      ?
    • Cash on Delivery available
      ?
    Description
    This title does not come with Online Discount Voucher and CD

    Long Description Announcing an all-new Self-paced Training Kit designed to help maximize your performance on 70-432, the required exam for the new Microsoft Certified Technology Specialist (MCTS) certification for SQL Server 2008 Implementation and Maintenance. It comes packed with the tools and features exam candidates want most including in-depth, self-paced training based on final exam content; rigorous, objective-by-objective review; exam tips from expert, exam-certified authors; and customizable testing options. It also provides real-world scenarios, case study examples, and troubleshooting labs for the skills and expertise you can apply to the job. Focusing on implementing and maintaining a SQL Server 2008 database, this official study guide covers installing and configuring SQL Server 2008; managing SQL Server Agent jobs, alerts, and operators; implementing security features; backing up and restoring databases; monitoring and troubleshooting SQL Server; optimizing performance using the Resource Governor and Database Engine Tuning Advisor; and implementing high availability. Work at your own pace through the lessons and lab exercises. Choose timed or untimed testing mode, generate random tests, or focus on discrete objectives. You get detailed explanations for right and wrong answers including pointers back to the book for further study. You also get an evaluation version of SQL Server 2008 software and an exam discount voucher making this kit an exceptional value and a great career investment.

    About The Author
    Mike Hotek is coauthor of MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server 2005--Implementation and Maintenance. Mike Hotek lives in Dallas, Texas.
    Read More
    Specifications
    Book Details
    • Publication Year
      • 2009
    • Table of Contents
      • Contents
        Introduction
        Chapter 1 Installing and Confi guring SQL Server 2008

        • Before You Begin

        Lesson 1: Determining Hardware and Software Requirements

        • Minimum Hardware Requirements
        • Supported Operating Systems
        • Software Requirements
        • Lesson Summary
        • Lesson Review

        Lesson 2: Selecting SQL Server Editions

        • SQL Server Services
        • SQL Server Editions
        • Lesson Summary
        • Lesson Review

        Lesson 3: Installing and Configuring SQL Server Instances

        • Service Accounts
        • Collation Sequences
        • Authentication Modes
        • SQL Server Instances
        • SQL Server Confi guration Manager
        • Lesson Summary
        • Lesson Review

        Lesson 4: Confi guring Database Mail

        • Database Mail
        • Lesson Summary
        • Lesson Review
        • Chapter Review
        • Chapter Summary
        • Key Terms
        • Case Scenario
        • Suggested Practices
        • Installing SQL Server
        • Managing SQL Server Services
        • Take a Practice Test

        Chapter 2 Database Confi guration and Maintenance

        • Before You Begin
        • Lesson 1: Configuring Files and Filegroups
        • Files and Filegroups
        • Transaction Logs
        • FILESTREAM data
        • tempdb Database
        • Lesson Summary
        • Lesson Review

        Lesson 2: Confi guring Database Options

        • Database Options
        • Recovery Options
        • Auto Options
        • Change Tracking
        • Access
        • Parameterization
        • Collation Sequences
        • Lesson Summary
        • Lesson Review

        Lesson 3: Maintaining Database Integrity

        • Database Integrity Checks
        • Lesson Summary
        • Lesson Review
        • Chapter Review
        • Chapter Summary
        • Key Terms
        • Case Scenario
        • Suggested Practices
        • Confi guring Databases
        • Take a Practice Test

        Chapter 3 Tables

        • Before You Begin

        Lesson 1: Creating Tables

        • Schemas
        • Data Types
        • Column Properties
        • Computed Columns
        • Row and Page Compression
        • Creating Tables
        • Lesson Summary
        • Lesson Review

        Lesson 2: Implementing Constraints

        • Primary Keys
        • Foreign Keys
        • Unique Constraints
        • Default Constraints
        • Check Constraints
        • Lesson Summary
        • Lesson Review
        • Chapter Review
        • Chapter Summary
        • Key Terms
        • Case Scenario
        • Suggested Practices
        • Creating Tables
        • Creating Constraints
        • Take a Practice Test

        Chapter 4 Designing SQL Server Indexes

        • Before You Begin

        Lesson 1: Index Architecture

        • Index Structure
        • Balanced Trees (BTrees)
        • Index Levels
        • Lesson Summary
        • Lesson Review

        Lesson 2: Designing Indexes

        • Clustered Indexes
        • Nonclustered Indexes
        • Index Options
        • XML Indexes
        • Spatial Indexes
        • Lesson Summary
        • Lesson Review

        Lesson 3: Maintaining Indexes

        • Index Management and Maintenance
        • Disabling an index
        • Lesson Summary
        • Lesson Review
        • Chapter Review
        • Chapter Summary
        • Key Terms
        • Case Scenario
        • Suggested Practices
        • Creating Indexes
        • Take a Practice Test

        Chapter 5 Full Text Indexing

        • Before You Begin

        Lesson 1: Creating and Populating Full Text Indexes

        • Full Text Catalogs
        • Full Text Indexes
        • Change Tracking
        • Language, Word Breakers and Stemmers
        • Lesson Summary
        • Lesson Review

        Lesson 2: Querying Full Text Data

        • Free Text
        • Contains
        • Lesson Summary
        • Lesson Review

        Lesson 3: Managing Full Text Indexes

        • Thesaurus
        • Stop Lists
        • Populate Full Text Indexes
        • Lesson Summary
        • Lesson Review
        • Chapter Review
        • Chapter Summary
        • Key Terms
        • Case Scenario
        • Suggested Practices
        • Create a Full Text Index
        • Query a Full Text Index
        • Create a Thesaurus File
        • Create a Stop List
        • Take a Practice Test

        Chapter 6 Distributing and Partitioning Data

        • Before You Begin

        Lesson 1: Creating a Partition Function

        • Partition Functions
        • Lesson Summary
        • Lesson Review

        Lesson 2: Creating a Partition Scheme

        • Partition Schemes
        • Lesson Summary
        • Lesson Review

        Lesson 3: Creating Partitioned Tables and Indexes

        • Creating a Partitioned Table
        • Creating a Partitioned Index
        • Lesson Summary
        • Lesson Review

        Lesson 4: Managing Partitions

        • Split and Merge Operators
        • Altering a Partition Scheme
        • Index Alignment
        • Switch Operator
        • Lesson Summary
        • Lesson Review
        • Chapter Review
        • Chapter Summary
        • Key Terms
        • Case Scenario
        • Suggested Practices
        • Partitioning
        • Take a Practice Test

        Chapter 7 Importing and Exporting Data

        • Before You Begin

        Lesson 1: Importing and Exporting Data

        • Bulk Copy Program
        • The Bulk Insert command
        • The SQL Server Import and Export Wizard
        • Lesson Summary
        • Lesson Review
        • Chapter Review
        • Chapter Summary
        • Key Terms
        • Case Scenario
        • Suggested Practices
        • Import and Export Data
        • Take a Practice Test

        Chapter 8 Designing Policy Based Management

        • Before You Begin

        Lesson 1: Designing Policies

        • Facets
        • Conditions
        • Policy Targets
        • Policies
        • Policy Categories
        • Policy Compliance
        • Central Management Server
        • Import and Export Policies
        • Lesson Summary
        • Lesson Review
        • Chapter Review
        • Chapter Summary
        • Key Terms
        • Case Scenario
        • Suggested Practices
        • Implement Policy Based Management
        • Take a Practice Test

        Chapter 9 Backing up and Restoring a Database

        • Before You Begin

        Lesson 1: Backing up Databases

        • Backup Types
        • Full Backups
        • Transaction Log Backups
        • Differential Backups
        • Filegroup Backups
        • Partial Backups
        • Page Corruption
        • Maintenance Plans
        • Certifi cates and Master Keys
        • Validating a Backup
        • Lesson Summary
        • Lesson Review

        Lesson 2: Restoring Databases

        • Transaction Log Internals
        • Database Restores
        • Restoring a Full Backup
        • Restoring a Differential Backup
        • Restoring a Transaction Log Backup
        • Online Restores
        • Restore a Corrupt Page
        • Restoring with Media Errors
        • Lesson Summary
        • Lesson Review

        Lesson 3: Database Snapshots

        • Creating a Database Snapshot
        • Copy on Write Technology
        • Reverting Data Using a Database Snapshot
        • Lesson Summary
        • Lesson Review
        • Chapter Review
        • Chapter Summary
        • Key Terms
        • Case Scenario
        • Suggested Practices
        • Backing up a Database
        • Restoring a Database
        • Take a Practice Test
        • Chapter 10 Automating SQL Server
        • Before You Begin

        Lesson 1: Creating Jobs

        • Job Steps
        • Job Schedules
        • Job History
        • Operators
        • Lesson Summary
        • Lesson Review

        Lesson 2: Creating Alerts

        • SQL Server Agent Alerts
        • Lesson Summary
        • Lesson Review
        • Chapter Review
        • Chapter Summary
        • Key Terms
        • Case Scenario
        • Suggested Practices
        • Create Jobs
        • Create Alerts
        • Take a Practice Test

        Chapter 11 Designing SQL Server Security

        • Before You Begin

        Lesson 1: TCP Endpoints

        • Endpoint Types and Payloads
        • Endpoint Access
        • TCP Endpoints
        • TCP Protocol Arguments
        • Database Mirroring and Service Broker Common Arguments
        • Database Mirroring–Specifi c Arguments
        • Service Broker–Specifi c Arguments
        • Lesson Summary
        • Lesson Review

        Lesson 2: Confi guring the SQL Server

        • Surface Area
        • Surface Area Confi guration
        • Lesson Summary
        • Lesson Review

        Lesson 3: Creating Principals

        • Logins
        • Fixed Server Roles
        • Database Users
        • Loginless Users
        • Fixed Database Roles
        • User Database Roles
        • Lesson Summary
        • Lesson Review

        Lesson 4: Managing Permissions

        • Securables
        • Permissions
        • Metadata Security
        • Ownership Chains
        • Impersonation
        • Master Keys
        • Certifi cates
        • Signatures
        • Lesson Summary
        • Lesson Review

        Lesson 5: Auditing SQL Server Instances

        • DDL Triggers
        • Audit Specifications
        • C2 Auditing
        • Lesson Summary
        • Lesson Review

        Lesson 6: Encrypting Data

        • Data Encryption
        • Hash Algorithms
        • Symmetric Keys
        • Certifi cates and Asymmetric Keys
        • Transparent Data Encryption
        • Encryption Key Management
        • Lesson Summary
        • Lesson Review
        • Chapter Review
        • Chapter Summary
        • Key Terms
        • Case Scenario: Designing SQL Server Security
        • Suggested Practices
        • Manage Logins and Server Roles
        • Manage Users and Database Roles
        • Manage SQL Server Instance Permissions
        • Manage Database Permissions
        • Manage Schema Permissions and Object Permissions
        • Audit SQL Server Instances
        • Manage Transparent Data Encryption
        • Take a Practice Test

        Chapter 12 Monitoring Microsoft SQL Server

        • Before You Begin

        Lesson 1: Working with System Monitor

        • System Monitor Overview
        • Capturing Counter Logs
        • Performance Counters
        • Lesson Summary
        • Lesson Review

        Lesson 2: Working with the SQL Server Profiler

        • Defi ning a Trace
        • Specifying Trace Events
        • Selecting Data Columns
        • Applying Filters
        • Managing Traces
        • Correlating Performance and Monitoring Data
        • Lesson Summary
        • Lesson Review

        Lesson 3: Diagnosing Database Failures

        • SQL Server Logs
        • Database Space Issues
        • Lesson Summary
        • Lesson Review

        Lesson 4: Diagnosing Service Failures

        • Finding Service Startup Failures
        • Configuration Manager
        • Lesson Summary
        • Lesson Review

        Lesson 5: Diagnosing Hardware Failures

        • Disk Drives
        • Memory and Processors
        • Lesson Summary
        • Lesson Review

        Lesson 6: Resolving Blocking and Deadlocking Issues

        • Locks
        • Transaction Isolation Levels
        • Blocked Processes
        • Deadlocks
        • Lesson Summary
        • Lesson Review
        • Chapter Review
        • Chapter Summary
        • Key Terms
        • Case Scenario
        • Suggested Practices
        • Creating a Trace Using SQL Server Profiler to
        • Diagnose Performance and Deadlock Issues
        • Create a Counter Log Using System Monitor to
        • Diagnose Performance, Deadlock and System Issues
        • Take a Practice Test

        Chapter 13 Optimizing Performance

        • Before You Begin

        Lesson 1: Using the Database Engine Tuning Advisor

        • Database Engine Tuning Advisor
        • Lesson Summary
        • Lesson Review

        Lesson 2: Working with Resource Governor

        • Resource Governor
        • Lesson Summary
        • Lesson Review

        Lesson 3: Using Dynamic Management Views and Functions

        • DMV Categories
        • Database Statistics
        • Query Statistics
        • Disk Subsystem Statistics
        • Hardware Resources
        • Lesson Summary
        • Lesson Review

        Lesson 4: Working with the Performance Data Warehouse

        • Performance Data Warehouse
        • Lesson Summary
        • Lesson Review
        • Chapter Review
        • Chapter Summary
        • Key Terms
        • Case Scenario
        • Suggested Practices
        • Using the Performance Data Warehouse to Gather Data
        • for Performance Optimization
        • Using Database Engine Tuning Advisor to Gather Data
        • for Performance Optimization
        • Using Dynamic Management Views to Gather Data
        • for Performance Optimization
        • Take a Practice Test

        Chapter 14 Failover Clustering

        • Before You Begin

        Lesson 1: Designing Windows Clustering

        • Windows Cluster Components
        • Types of Clusters
        • Security Configuration
        • Disk Configuration
        • Network Configuration
        • Cluster Resources
        • Cluster Groups
        • Lesson Summary
        • Lesson Review

        Lesson 2: Designing SQL Server 2008 Failover Cluster Instances

        • Terminology
        • Failover Cluster Instance Components
        • Health Checks
        • Cluster Failover
        • Lesson Summary
        • Lesson Review
        • Chapter Review
        • Chapter Summary
        • Key Terms
        • Case Scenario
        • Suggested Practices
        • Windows Clustering
        • SQL Server Failover Clustering
        • Take a Practice Test

        Chapter 15 Database Mirroring

        • Before You Begin

        Lesson 1: Overview of Database Mirroring

        • Database Mirroring Roles
        • Principal Role
        • Mirror Role
        • Witness Server
        • Database Mirroring Endpoints
        • Operating Modes
        • Caching
        • Transparent Client Redirect
        • Database Mirroring Threading
        • Database Snapshots
        • Lesson Summary
        • Lesson Review

        Lesson 2: Initializing Database Mirroring

        • Recovery Model
        • Backup and Restore
        • Copy System Objects
        • Lesson Summary
        • Lesson Review

        Lesson 3: Designing Failover and Failback Strategies

        • Designing Mirroring Session Failover
        • Designing Mirroring Session Failback
        • Lesson Summary
        • Lesson Review
        • Chapter Review
        • Chapter Summary
        • Key Terms
        • Case Scenario
        • Suggested Practices
        • Establishing Database Mirroring
        • Creating a Database Snapshot Against a Database
        • Mirror
        • Take a Practice Test

        Chapter 16 Log Shipping

        • Before You Begin

        Lesson 1: Overview of Log Shipping

        • Log Shipping Scenarios
        • Log Shipping Components
        • Types of Log Shipping
        • Lesson Summary
        • Lesson Review

        Lesson 2: Initializing Log Shipping

        • Log Shipping Initialization
        • Lesson Summary
        • Lesson Review

        Lesson 3: Designing Failover and Failback

        • Strategies
        • Log Shipping Failover
        • Log Shipping Failback
        • Lesson Summary
        • Lesson Review
        • Chapter Review
        • Chapter Summary
        • Key Terms
        • Case Scenario
        • Suggested Practices
        • Initiating Log Shipping
        • Failover and Failback Log Shipping
        • Take a Practice Test

        Chapter 17 Replication

        • Before You Begin

        Lesson 1: Overview of Replication

        • Replication Components
        • Replication Roles
        • Replication Topologies
        • Replication Agents
        • Agent Profiles
        • Replication Methods
        • Data Conflicts
        • Lesson Summary
        • Lesson Review

        Lesson 2: Transactional Replication

        • Change Tracking
        • Transactional Options
        • Transactional Architectures
        • Monitoring
        • Validation
        • Lesson Summary
        • Lesson Review

        Lesson 3: Merge Replication

        • Change Tracking
        • Validation
        • Lesson Summary
        • Lesson Review
        • Chapter Review
        • Chapter Summary
        • Key Terms
        • Case Scenario
        • Suggested Practices
        • Transactional Replication
        • Merge Replication
        • Take a Practice Test
        • Glossary
        • Answers

        Index

    Contributors
    • Author
      • Mike Hotek
    Frequently Bought Together
    MCTS Self-Paced Training Kit: Exam 70-432: Microsoft SQL Server 2008 Implementation and Maintenance 1st Edition
    MCTS Self-Paced Training Kit: Exam 70-432: Microsoft SQL Server 2...
    3.9
    (14)
    621
    695
    10% off
    1 Item
    621
    2 Add-ons
    892
    Total
    1,513
    Ratings and Reviews
    3.9
    14 Ratings &
    3 Reviews
    • 5
       4
    • 4
       7
    • 3
       1
    • 2
       1
    • 1
       1
    4

    There's no CD with this book.

    This book doesn't come with a CD. Apart from that, all well.


    The quality of binding etc is good and the material in the book is very informative, flipkart delivery and packing is very nice as always.
    READ MORE

    Ravikanth Vijapurapu

    Certified Buyer

    27 Dec, 2012

    2
    0
    Report Abuse
    1

    Why don't you provide CD with mcts exam books.

    I need to buy this book MCTS Self-Paced Training Kit: Exam 70-432: Microsoft SQL Server 2008 Implementation and Maintenance 1st Edition but this book is not available with CD, whereas CD play important role to clear this exam with good marks but Book with CD is not available on your website.
    READ MORE

    Shailendra Mishra

    Certified Buyer

    18 Jun, 2013

    0
    0
    Report Abuse
    3

    Timely Delivery with few Minor Defects

    Of course the title speaks it all !!! Timely Delivery with few Minor Defects !! Book was delivered in Time ! Thanks to flipkart for delivering at the right moment. But i was little bit upset with the way of packing . The corners of the book was folded and giving a shabby look,
    READ MORE

    Mohan Kumar

    Certified Buyer

    16 Mar, 2015

    0
    0
    Report Abuse
    View all 3 reviews
    Have doubts regarding this product?
    Safe and Secure Payments. Easy returns. 100% Authentic products.
    Back to top