Connecting to your device

Please ensure network connectivity and stay logged in to the Flipkart App.

Notification sent

Try again if you don't receive the notification in 9 seconds Try again if you haven't received the notification yet.

Failed to connect
Either you don't have Flipkart App or not logged into it.

Login to the app and try again or Go back

 
Unlocking Great Deals!
  • Get the link via SMS
Enter One Time Password(OTP)
SMS sent to
Try again if you don't receive the SMS in 45 seconds. Try again if you didn't receive the SMS.
An OTP has been sent to you mobile ,
please enter the same below to get the link.
Failed to send SMS to
Failed to verify OTP for
Failed to connect
We've received too many OTP generation requests from your device .
+91
Resend OTP in 60 seconds Resend OTP
We've sent a notification to your phone. Click here to resend. Click here to send yourself a notification. Get the app now or if you have the app, to get a notification
Cart (0)
Digital Cart (0)
Shortlist 0
Some error has occured while getting your complete shortlist. Retry
Use this space to shortlist the products you like. To add a product here, simply click the icon.
You can't compare with the above items. (Clear all items in the Compare list)

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

(Hardcover)
Hardcover
Author: Mike Hotek
Language: English
Length: 623 pages
Publisher: Phi Learning Pvt. Ltd.
Check Availability at
Invalid Pincode Entered
Available with 4 Sellers at Change
List Price: Rs. 695
Rs. 625 10% OFF
Selling Price
(Free delivery)

Sold by

MEDIAMATICS 4.3 / 5
83% positive feedback (315 ratings)
  • 5 star
    185
  • 4 star
    77
  • 3 star
    23
  • 2 star
    14
  • 1 star
    16
Positive
Neutral
Negative

Delivered By

?
  • Usually Delivered in 5-6 business days.

Cash On Delivery

?
May be available! Enter Pincode to confirm.
30 day Replacement Guarantee. ?
Sold by 4 Sellers
Sort By:
MEDIAMATICS
30 day Replacement Guarantee. ?
Cash on Delivery may be available! ?
4.3 / 5
83% positive feedback (315 ratings)
  • 5 star
    185
  • 4 star
    77
  • 3 star
    23
  • 2 star
    14
  • 1 star
    16
Positive
Neutral
Negative
  • Usually Delivered in 5-6 business days.
Rs. 625
BOOKCENTRE
30 day Replacement Guarantee. ?
Cash on Delivery may be available! ?
4.2 / 5
80% positive feedback (1,526 ratings)
  • 5 star
    922
  • 4 star
    302
  • 3 star
    116
  • 2 star
    47
  • 1 star
    139
Positive
Neutral
Negative
  • Usually Delivered in 8-9 business days.
Rs. 660
uRead
30 day Replacement Guarantee. ?
Cash on Delivery may be available! ?
4.1 / 5
77% positive feedback (7,517 ratings)
  • 5 star
    4,400
  • 4 star
    1,403
  • 3 star
    515
  • 2 star
    273
  • 1 star
    926
Positive
Neutral
Negative
  • Usually Delivered in 14-15 business days.
Rs. 680
MulliganBooks
?
30 day Replacement Guarantee. ?
Cash on Delivery may be available! ?
4.3 / 5
83% positive feedback (682 ratings)
  • 5 star
    443
  • 4 star
    125
  • 3 star
    40
  • 2 star
    14
  • 1 star
    60
Positive
Neutral
Negative
  • Usually Delivered in 2-3 business days.
Rs. 695

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

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

Book Details
Publisher Phi Learning Pvt. Ltd.
ISBN-10 8120337808
Edition 1stEdition
Number of Pages 623 Pages
Publication Year 2009
Language English
ISBN-13 9788120337800
Binding Hardcover
Contributors
Author Mike Hotek
Was the product specification helpful?
Yes
No
Thanks for your vote!
Please write your feedback before submitting.

Please Note: All products sold on Flipkart are brand new and 100% genuine

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

Top reviews

'Top Reviews' lists the most relevant product reviews only. Show ALL instead?

★★★★★
★★★★★

Ravikanth Vijapurapu

Dec 27, 2012

The 'certified buyer' badge indicates that this user has purchased this product on flipkart.com.
certified buyer

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.
★★★★★
★★★★★

Shailendra Mishra

Jun 18, 2013

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.
Were these reviews helpful?
Yes
No
Thanks for your vote!
Please write your feedback before submitting.
 

PAYMENT METHOD

Loading ...