Cart (0)
Digital Cart (0)

Add Another Item

Add Another Item

Add Another Item

Add Another Item

Compare
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)
★★★★★ ★★★★★
7
Hardcover
Author: Mike Hotek
Language: English
Length: 623 pages
Publisher: Phi Learning Pvt. Ltd.
Check Availability at
Invalid Pincode Entered
Available with 3 Sellers at Change
Rs. 695 15% OFF
Rs. 591
(Free delivery)

Sold by

WS Retail 4.3 / 5
84% positive feedback (3,758,166) ratings)
  • 5 star
    2,379,620
  • 4 star
    798,200
  • 3 star
    217,937
  • 2 star
    91,591
  • 1 star
    270,818
Positive
Neutral
Negative
?
Buy with confidence when you see the 'Flipkart Advantage' badge. Products tagged with the Flipkart Advantage badge are quality checked, stocked and shipped by Flipkart. They are also backed by our Friendly Returns Policy, which allows for 30 Day Returns. Expedited delivery options such as Same Day/In-a-Day Guarantee Delivery are an added bonus. Read More

* Shipments from locations where relevant permissions have been obtained.

Delivered By

?
  • Usually Delivered in 2-3 business days.
  • Delivery times may be longer than usual due to festive demand

What is the estimated delivery time?

Sellers generally procure and ship the items within the time specified on the product page. Business days exclude public holidays and Sundays.
Estimated delivery time depends on the following factors:
  • The Seller offering the product
  • Product's availability with the Seller
  • The destination to which you want the order shipped to and the Seller's location

Why does the delivery date not correspond to the delivery timeline of X-Y business days?

It is possible that the Seller or our courier partners observe a holiday between the day you placed your order and the date of delivery, which is based on the timelines shown on the product page. In this case, we add a day to the estimated date. Some courier partners and Sellers do not work on Sundays and this is factored in to the delivery dates.

What do the different tags like "In Stock", "Available" mean?

'In Stock'

For items listed as "In Stock", Sellers will mention the delivery time based on your location pincode (usually 2-3 business days, 4-5 business days or 4-6 business days in areas where standard courier service is available). For other areas, orders will be sent by Registered Post through the Indian Postal Service which may take 1-2 weeks depending on the location.

'Available'

For items listed as "In Stock", Sellers will mention the delivery time based on your location pincode (usually 2-3 business days, 4-5 business days or 4-6 business days in areas where standard courier service is available). For other areas, orders will be sent by Registered Post through the Indian Postal Service which may take 1-2 weeks depending on the location.

'Preorder' or 'Forthcoming'

For items listed as "In Stock", Sellers will mention the delivery time based on your location pincode (usually 2-3 business days, 4-5 business days or 4-6 business days in areas where standard courier service is available). For other areas, orders will be sent by Registered Post through the Indian Postal Service which may take 1-2 weeks depending on the location.

'Out of Stock'

Currently, the item is not available for sale. Use the 'Notify Me' feature to know once it is available for purchase.

'Imported'

Sometimes, items have to be sourced by Sellers from outside India. These items are mentioned as 'Imported' on the product page and can take at least 10 days or more to be delivered to you.

'Back In Stock Soon'

The item is popular and is sold out. You can however 'book' an order for the product and it will be shipped according to the timelines mentioned by the Seller.

'Temporarily Unavailable'

The product is currently out of stock and is not available for purchase. The product could to be in stock soon. Use the 'Notify Me' feature to know when it is available for purchase.

'Permanently Discontinued'

This product is no longer available because it is obsolete and/or its production has been discontinued.

'Out of Print'

This product is not available because it is no longer published and has been permanently discontinued.

Why does the estimated delivery time vary for each seller?

You have probably noticed varying estimated delivery times for Sellers of the product you are interested in. Delivery times are influenced by product availability, geographic location of the Seller, your shipping destination and the courier partner's time-to-deliver to your location.

Please enter your default pin code on the product page (you don't have to enter it every single time) to know more accurate delivery times on the product page itself.

Seller does not/cannot ship to my area. Why?

Enter your pincode on the product page (you don't have to enter it every single time) to know whether the product can be delivered to your location.

If you haven't provided your pincode until the checkout stage, the pincode in your last used shipping address will be used to check for serviceability.

Whether your location can be serviced or not depends on:

  • Whether the Seller actually ships to your location
  • Legal restrictions, if any, in shipping particular products to your location
  • The availability of reliable courier partners in your location

At times Sellers prefer not to ship to certain locations. This is entirely at their discretion.

More answers in our Shipping FAQs »

Cash On Delivery

?

How do I place a Cash on Delivery (C-o-D) order?

All items that have the "Cash on Delivery Available" icon are valid for order by Cash on Delivery.
Add the item(s) to your cart and proceed to checkout. When prompted to choose a payment option, select "Pay By Cash on Delivery". Enter the CAPTCHA text as shown, for validation.
Once verified and confirmed, your order will be processed for shipment in the time specified, from the date of confirmation. You will be required to make a cash-only payment to our courier partner at the time of delivery of your order to complete the payment.

Terms & Conditions

  • The maximum order value for C-o-D is ₹50,000.
  • e-Gift Vouchers or Store Credit cannot be used for C-o-D orders.
  • Cash-only payment at the time of delivery.
More answers in our Shipping FAQs »
May be available! Enter Pincode to confirm.
30 day Replacement Guarantee. ?
Validity Covers Type Accepted
10 days from delivery Damaged, Defective, Item not as described Replacement
If you have received a damaged or defective product or it is not as described, you can get a replacement within 10 days of delivery at no extra cost.

When does this guarantee not apply?

The guarantee does not extend to:
  • Digital products and services (Flipkart eBooks & music downloads).
  • Innerwear, Lingerie, Socks, Jewellery Freebies and Clothing Freebies
  • Damages due to misuse of product or Incidental damage due to malfunctioning of product.
  • Any consumable item which has been used or installed.
  • Products with tampered or missing serial numbers.
  • Items that are returned without original packaging, freebies or accessories.
  • Any damage / defect which are not covered under the manufacturer's warranty.
  • Made-to-order/Custom Jewellery.
More answers in our Cancellations & Returns »
Validity Covers Type Accepted
30 days from delivery Damaged, Defective, Item not as described Replacement
If you have received a damaged or defective product or it is not as described, you can get a replacement within 30 days of delivery at no extra cost.

When does this guarantee not apply?

The guarantee does not extend to:
  • Digital products and services (Flipkart eBooks & music downloads).
  • Innerwear, Lingerie, Socks, Jewellery Freebies and Clothing Freebies
  • Damages due to misuse of product or Incidental damage due to malfunctioning of product.
  • Any consumable item which has been used or installed.
  • Products with tampered or missing serial numbers.
  • Items that are returned without original packaging, freebies or accessories.
  • Any damage / defect which are not covered under the manufacturer's warranty.
  • Made-to-order/Custom Jewellery.
More answers in our Cancellations & Returns »
Validity Covers Type Accepted
10 days from delivery Exchange for colors and size, Does not fit Exchange
If you have received a damaged or defective product or it is not as described, you can get an exchange within 10 days of delivery at no extra cost.

When does this guarantee not apply?

The guarantee does not extend to:
  • Digital products and services (Flipkart eBooks & music downloads).
  • Innerwear, Lingerie, Socks, Jewellery Freebies and Clothing Freebies
  • Damages due to misuse of product or Incidental damage due to malfunctioning of product.
  • Any consumable item which has been used or installed.
  • Products with tampered or missing serial numbers.
  • Items that are returned without original packaging, freebies or accessories.
  • Any damage / defect which are not covered under the manufacturer's warranty.
  • Made-to-order/Custom Jewellery.
More answers in our Cancellations & Returns »
Validity Covers Type Accepted
30 days from delivery Exchange for colors and size, Does not fit Exchange
If you have received a damaged or defective product or it is not as described, you can get an exchange within 30 days of delivery at no extra cost.

When does this guarantee not apply?

The guarantee does not extend to:
  • Digital products and services (Flipkart eBooks & music downloads).
  • Innerwear, Lingerie, Socks, Jewellery Freebies and Clothing Freebies
  • Damages due to misuse of product or Incidental damage due to malfunctioning of product.
  • Any consumable item which has been used or installed.
  • Products with tampered or missing serial numbers.
  • Items that are returned without original packaging, freebies or accessories.
  • Any damage / defect which are not covered under the manufacturer's warranty.
  • Made-to-order/Custom Jewellery.
More answers in our Cancellations & Returns»

Buy any book and get Free Delivery. View Details

This offer is valid for Seller: 'WS Retail' till the offer ends.
Sold by 3 Sellers
Sorted By:
WS Retail
?
30 day Replacement Guarantee. ?
Cash on Delivery may be available! ?
4.3 / 5
84% positive feedback (3,758,166) ratings)
  • 5 star
    2,379,620
  • 4 star
    798,200
  • 3 star
    217,937
  • 2 star
    91,591
  • 1 star
    270,818
Positive
Neutral
Negative
  • Usually Delivered in 2-3 business days.

What is the estimated delivery time?

Sellers generally procure and ship the items within the time specified on the product page. Business days exclude public holidays and Sundays.
Estimated delivery time depends on the following factors:
  • The Seller offering the product
  • Product's availability with the Seller
  • The destination to which you want the order shipped to and the Seller's location

Why does the delivery date not correspond to the delivery timeline of X-Y business days?

It is possible that the Seller or our courier partners observe a holiday between the day you placed your order and the date of delivery, which is based on the timelines shown on the product page. In this case, we add a day to the estimated date. Some courier partners and Sellers do not work on Sundays and this is factored in to the delivery dates.

What do the different tags like "In Stock", "Available" mean?

'In Stock'

For items listed as "In Stock", Sellers will mention the delivery time based on your location pincode (usually 2-3 business days, 4-5 business days or 4-6 business days in areas where standard courier service is available). For other areas, orders will be sent by Registered Post through the Indian Postal Service which may take 1-2 weeks depending on the location.

'Available'

For items listed as "In Stock", Sellers will mention the delivery time based on your location pincode (usually 2-3 business days, 4-5 business days or 4-6 business days in areas where standard courier service is available). For other areas, orders will be sent by Registered Post through the Indian Postal Service which may take 1-2 weeks depending on the location.

'Preorder' or 'Forthcoming'

For items listed as "In Stock", Sellers will mention the delivery time based on your location pincode (usually 2-3 business days, 4-5 business days or 4-6 business days in areas where standard courier service is available). For other areas, orders will be sent by Registered Post through the Indian Postal Service which may take 1-2 weeks depending on the location.

'Out of Stock'

Currently, the item is not available for sale. Use the 'Notify Me' feature to know once it is available for purchase.

'Imported'

Sometimes, items have to be sourced by Sellers from outside India. These items are mentioned as 'Imported' on the product page and can take at least 10 days or more to be delivered to you.

'Back In Stock Soon'

The item is popular and is sold out. You can however 'book' an order for the product and it will be shipped according to the timelines mentioned by the Seller.

'Temporarily Unavailable'

The product is currently out of stock and is not available for purchase. The product could to be in stock soon. Use the 'Notify Me' feature to know when it is available for purchase.

'Permanently Discontinued'

This product is no longer available because it is obsolete and/or its production has been discontinued.

'Out of Print'

This product is not available because it is no longer published and has been permanently discontinued.

Why does the estimated delivery time vary for each seller?

You have probably noticed varying estimated delivery times for Sellers of the product you are interested in. Delivery times are influenced by product availability, geographic location of the Seller, your shipping destination and the courier partner's time-to-deliver to your location.

Please enter your default pin code on the product page (you don't have to enter it every single time) to know more accurate delivery times on the product page itself.

Seller does not/cannot ship to my area. Why?

Enter your pincode on the product page (you don't have to enter it every single time) to know whether the product can be delivered to your location.

If you haven't provided your pincode until the checkout stage, the pincode in your last used shipping address will be used to check for serviceability.

Whether your location can be serviced or not depends on:

  • Whether the Seller actually ships to your location
  • Legal restrictions, if any, in shipping particular products to your location
  • The availability of reliable courier partners in your location

At times Sellers prefer not to ship to certain locations. This is entirely at their discretion.

More answers in our Shipping FAQs »
Rs. 591
POSYA
30 day Replacement Guarantee. ?
Cash on Delivery may be available! ?
4.1 / 5
  • Usually Delivered in 15-16 business days.

What is the estimated delivery time?

Sellers generally procure and ship the items within the time specified on the product page. Business days exclude public holidays and Sundays.
Estimated delivery time depends on the following factors:
  • The Seller offering the product
  • Product's availability with the Seller
  • The destination to which you want the order shipped to and the Seller's location

Why does the delivery date not correspond to the delivery timeline of X-Y business days?

It is possible that the Seller or our courier partners observe a holiday between the day you placed your order and the date of delivery, which is based on the timelines shown on the product page. In this case, we add a day to the estimated date. Some courier partners and Sellers do not work on Sundays and this is factored in to the delivery dates.

What do the different tags like "In Stock", "Available" mean?

'In Stock'

For items listed as "In Stock", Sellers will mention the delivery time based on your location pincode (usually 2-3 business days, 4-5 business days or 4-6 business days in areas where standard courier service is available). For other areas, orders will be sent by Registered Post through the Indian Postal Service which may take 1-2 weeks depending on the location.

'Available'

For items listed as "In Stock", Sellers will mention the delivery time based on your location pincode (usually 2-3 business days, 4-5 business days or 4-6 business days in areas where standard courier service is available). For other areas, orders will be sent by Registered Post through the Indian Postal Service which may take 1-2 weeks depending on the location.

'Preorder' or 'Forthcoming'

For items listed as "In Stock", Sellers will mention the delivery time based on your location pincode (usually 2-3 business days, 4-5 business days or 4-6 business days in areas where standard courier service is available). For other areas, orders will be sent by Registered Post through the Indian Postal Service which may take 1-2 weeks depending on the location.

'Out of Stock'

Currently, the item is not available for sale. Use the 'Notify Me' feature to know once it is available for purchase.

'Imported'

Sometimes, items have to be sourced by Sellers from outside India. These items are mentioned as 'Imported' on the product page and can take at least 10 days or more to be delivered to you.

'Back In Stock Soon'

The item is popular and is sold out. You can however 'book' an order for the product and it will be shipped according to the timelines mentioned by the Seller.

'Temporarily Unavailable'

The product is currently out of stock and is not available for purchase. The product could to be in stock soon. Use the 'Notify Me' feature to know when it is available for purchase.

'Permanently Discontinued'

This product is no longer available because it is obsolete and/or its production has been discontinued.

'Out of Print'

This product is not available because it is no longer published and has been permanently discontinued.

Why does the estimated delivery time vary for each seller?

You have probably noticed varying estimated delivery times for Sellers of the product you are interested in. Delivery times are influenced by product availability, geographic location of the Seller, your shipping destination and the courier partner's time-to-deliver to your location.

Please enter your default pin code on the product page (you don't have to enter it every single time) to know more accurate delivery times on the product page itself.

Seller does not/cannot ship to my area. Why?

Enter your pincode on the product page (you don't have to enter it every single time) to know whether the product can be delivered to your location.

If you haven't provided your pincode until the checkout stage, the pincode in your last used shipping address will be used to check for serviceability.

Whether your location can be serviced or not depends on:

  • Whether the Seller actually ships to your location
  • Legal restrictions, if any, in shipping particular products to your location
  • The availability of reliable courier partners in your location

At times Sellers prefer not to ship to certain locations. This is entirely at their discretion.

More answers in our Shipping FAQs »
Rs. 626
BOOKSWAGON
30 day Replacement Guarantee. ?
Cash on Delivery may be available! ?
New Seller!
  • Usually Delivered in 15-16 business days.

What is the estimated delivery time?

Sellers generally procure and ship the items within the time specified on the product page. Business days exclude public holidays and Sundays.
Estimated delivery time depends on the following factors:
  • The Seller offering the product
  • Product's availability with the Seller
  • The destination to which you want the order shipped to and the Seller's location

Why does the delivery date not correspond to the delivery timeline of X-Y business days?

It is possible that the Seller or our courier partners observe a holiday between the day you placed your order and the date of delivery, which is based on the timelines shown on the product page. In this case, we add a day to the estimated date. Some courier partners and Sellers do not work on Sundays and this is factored in to the delivery dates.

What do the different tags like "In Stock", "Available" mean?

'In Stock'

For items listed as "In Stock", Sellers will mention the delivery time based on your location pincode (usually 2-3 business days, 4-5 business days or 4-6 business days in areas where standard courier service is available). For other areas, orders will be sent by Registered Post through the Indian Postal Service which may take 1-2 weeks depending on the location.

'Available'

For items listed as "In Stock", Sellers will mention the delivery time based on your location pincode (usually 2-3 business days, 4-5 business days or 4-6 business days in areas where standard courier service is available). For other areas, orders will be sent by Registered Post through the Indian Postal Service which may take 1-2 weeks depending on the location.

'Preorder' or 'Forthcoming'

For items listed as "In Stock", Sellers will mention the delivery time based on your location pincode (usually 2-3 business days, 4-5 business days or 4-6 business days in areas where standard courier service is available). For other areas, orders will be sent by Registered Post through the Indian Postal Service which may take 1-2 weeks depending on the location.

'Out of Stock'

Currently, the item is not available for sale. Use the 'Notify Me' feature to know once it is available for purchase.

'Imported'

Sometimes, items have to be sourced by Sellers from outside India. These items are mentioned as 'Imported' on the product page and can take at least 10 days or more to be delivered to you.

'Back In Stock Soon'

The item is popular and is sold out. You can however 'book' an order for the product and it will be shipped according to the timelines mentioned by the Seller.

'Temporarily Unavailable'

The product is currently out of stock and is not available for purchase. The product could to be in stock soon. Use the 'Notify Me' feature to know when it is available for purchase.

'Permanently Discontinued'

This product is no longer available because it is obsolete and/or its production has been discontinued.

'Out of Print'

This product is not available because it is no longer published and has been permanently discontinued.

Why does the estimated delivery time vary for each seller?

You have probably noticed varying estimated delivery times for Sellers of the product you are interested in. Delivery times are influenced by product availability, geographic location of the Seller, your shipping destination and the courier partner's time-to-deliver to your location.

Please enter your default pin code on the product page (you don't have to enter it every single time) to know more accurate delivery times on the product page itself.

Seller does not/cannot ship to my area. Why?

Enter your pincode on the product page (you don't have to enter it every single time) to know whether the product can be delivered to your location.

If you haven't provided your pincode until the checkout stage, the pincode in your last used shipping address will be used to check for serviceability.

Whether your location can be serviced or not depends on:

  • Whether the Seller actually ships to your location
  • Legal restrictions, if any, in shipping particular products to your location
  • The availability of reliable courier partners in your location

At times Sellers prefer not to ship to certain locations. This is entirely at their discretion.

More answers in our Shipping FAQs »
Rs. 653
Buy with confidence when you see the 'Flipkart Advantage' badge. Products tagged with the Flipkart Advantage badge are quality checked, stocked and shipped by Flipkart. They are also backed by our Friendly Returns Policy, which allows for 30 Day Returns. Expedited delivery options such as Same Day/In-a-Day Guarantee Delivery are an added bonus. Read More

* Shipments from locations where relevant permissions have been obtained.

How do I place a Cash on Delivery (C-o-D) order?

All items that have the "Cash on Delivery Available" icon are valid for order by Cash on Delivery.
Add the item(s) to your cart and proceed to checkout. When prompted to choose a payment option, select "Pay By Cash on Delivery". Enter the CAPTCHA text as shown, for validation.
Once verified and confirmed, your order will be processed for shipment in the time specified, from the date of confirmation. You will be required to make a cash-only payment to our courier partner at the time of delivery of your order to complete the payment.

Terms & Conditions

  • The maximum order value for C-o-D is ₹50,000.
  • e-Gift Vouchers or Store Credit cannot be used for C-o-D orders.
  • Cash-only payment at the time of delivery.
More answers in our Shipping FAQs »
Validity Covers Type Accepted
10 days from delivery Damaged, Defective, Item not as described Replacement
If you have received a damaged or defective product or it is not as described, you can get a replacement within 10 days of delivery at no extra cost.

When does this guarantee not apply?

The guarantee does not extend to:
  • Digital products and services (Flipkart eBooks & music downloads).
  • Innerwear, Lingerie, Socks, Jewellery Freebies and Clothing Freebies
  • Damages due to misuse of product or Incidental damage due to malfunctioning of product.
  • Any consumable item which has been used or installed.
  • Products with tampered or missing serial numbers.
  • Items that are returned without original packaging, freebies or accessories.
  • Any damage / defect which are not covered under the manufacturer's warranty.
  • Made-to-order/Custom Jewellery.
More answers in our Cancellations & Returns »
Validity Covers Type Accepted
30 days from delivery Damaged, Defective, Item not as described Replacement
If you have received a damaged or defective product or it is not as described, you can get a replacement within 30 days of delivery at no extra cost.

When does this guarantee not apply?

The guarantee does not extend to:
  • Digital products and services (Flipkart eBooks & music downloads).
  • Innerwear, Lingerie, Socks, Jewellery Freebies and Clothing Freebies
  • Damages due to misuse of product or Incidental damage due to malfunctioning of product.
  • Any consumable item which has been used or installed.
  • Products with tampered or missing serial numbers.
  • Items that are returned without original packaging, freebies or accessories.
  • Any damage / defect which are not covered under the manufacturer's warranty.
  • Made-to-order/Custom Jewellery.
More answers in our Cancellations & Returns »
Validity Covers Type Accepted
10 days from delivery Exchange for colors and size, Does not fit Exchange
If you have received a damaged or defective product or it is not as described, you can get an exchange within 10 days of delivery at no extra cost.

When does this guarantee not apply?

The guarantee does not extend to:
  • Digital products and services (Flipkart eBooks & music downloads).
  • Innerwear, Lingerie, Socks, Jewellery Freebies and Clothing Freebies
  • Damages due to misuse of product or Incidental damage due to malfunctioning of product.
  • Any consumable item which has been used or installed.
  • Products with tampered or missing serial numbers.
  • Items that are returned without original packaging, freebies or accessories.
  • Any damage / defect which are not covered under the manufacturer's warranty.
  • Made-to-order/Custom Jewellery.
More answers in our Cancellations & Returns »
Validity Covers Type Accepted
30 days from delivery Exchange for colors and size, Does not fit Exchange
If you have received a damaged or defective product or it is not as described, you can get an exchange within 30 days of delivery at no extra cost.

When does this guarantee not apply?

The guarantee does not extend to:
  • Digital products and services (Flipkart eBooks & music downloads).
  • Innerwear, Lingerie, Socks, Jewellery Freebies and Clothing Freebies
  • Damages due to misuse of product or Incidental damage due to malfunctioning of product.
  • Any consumable item which has been used or installed.
  • Products with tampered or missing serial numbers.
  • Items that are returned without original packaging, freebies or accessories.
  • Any damage / defect which are not covered under the manufacturer's warranty.
  • Made-to-order/Custom Jewellery.
More answers in our Cancellations & Returns»

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

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.

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

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)

Recent top reviews

View all
★★★★★
★★★★★

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

Ravikanth Vijapurapu

Dec 27, 2012

First to review
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.

Top reviews

View all top reviews (2)

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

★★★★★
★★★★★

Ravikanth Vijapurapu

Dec 27, 2012

First to review
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.
 

PAYMENT METHOD

POWERED BY
Loading ...