Monday, July 9, 2012

Training Kit (Exam 70-462): Administering Microsoft SQL Server 2012 Databases

Publisher:?Microsoft Press

Released:?June 2012

Pages:?624

EXAM PREP GUIDE

Ace your preparation for the skills measured by Exam 70-462?and on the job?with this official Microsoft study guide. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce and apply what you?ve learned through real-world case scenarios and practice exercises.

Maximize your performance on the exam by mastering the skills and experience measured by these objectives:

  • Install and configure SQL Server
  • Maintain instances and databases
  • Optimize and troubleshoot SQL Server
  • Manage data
  • Implement security
  • Implement high availability

PRACTICE TESTS

Assess your skills with the practice tests on CD. You can work through hundreds of questions using multiple testing modes to meet your specific learning needs. You get detailed explanations for right and wrong answers?including a customized learning path that describes how and where to focus your studies.

  1. Chapter 1 Planning and Installing SQL Server 2012

    1. Before You Begin

    2. Lesson 1: Planning Your Installation

    3. Lesson 2: Installing SQL Server and Related Services

    4. Case Scenarios

    5. Suggested Practices

    6. Answers

  2. Chapter 2 Configuring and Managing SQL Server Instances

    1. Before You Begin

    2. Lesson 1: Configuring SQL Server Instances

    3. Lesson 2: Managing SQL Server Instances

    4. Case Scenarios

    5. Suggested Practices

    6. Answers

  3. Chapter 3 Configuring SQL Server 2012 Components

    1. Before You Begin

    2. Lesson 1: Configuring Additional SQL Server Components

    3. Lesson 2: Managing and Configuring Databases

    4. Case Scenarios

    5. Suggested Practices

    6. Answers

  4. Chapter 4 Migrating, Importing, and Exporting

    1. Before You Begin

    2. Lesson 1: Migrating to SQL Server 2012

    3. Lesson 2: Exporting and Importing Data

    4. Case Scenarios

    5. Suggested Practices

    6. Answers

  5. Chapter 5 SQL Server Logins, Roles, and Users

    1. Before You Begin

    2. Lesson 1: Managing Logins and Server Roles

    3. Lesson 2: Managing Users and Database Roles

    4. Case Scenarios

    5. Suggested Practices

    6. Answers

  6. Chapter 6 Securing SQL Server 2012

    1. Before You Begin

    2. Lesson 1: Managing Database Permissions

    3. Lesson 2: Troubleshooting SQL Server Security

    4. Lesson 3: Auditing SQL Server Instances

    5. Case Scenarios

    6. Suggested Practices

    7. Answers

  7. Chapter 7 Mirroring and Replication

    1. Before You Begin

    2. Lesson 1: Mirroring Databases

    3. Lesson 2: Database Replication

    4. Case Scenarios

    5. Suggested Practices

    6. Answers

  8. Chapter 8 Clustering and AlwaysOn

    1. Before You Begin

    2. Lesson 1: Clustering SQL Server 2012

    3. Lesson 2: AlwaysOn Availability Groups

    4. Case Scenarios

    5. Suggested Practices

    6. Answers

  9. Chapter 9 Troubleshooting SQL Server 2012

    1. Before You Begin

    2. Lesson 1: Working with Performance Monitor

    3. Lesson 2: Working with SQL Server Profiler

    4. Lesson 3: Monitoring SQL Server

    5. Lesson 4: Using the Data Collector Tool

    6. Lesson 5: Identifying Bottlenecks

    7. Case Scenarios

    8. Suggested Practices

    9. Answers

  10. Chapter 10 Indexes and Concurrency

    1. Before You Begin

    2. Lesson 1: Implementing and Maintaining Indexes

    3. Lesson 2: Identifying and Resolving Concurrency Problems

    4. Case Scenarios

    5. Suggested Practices

    6. Answers

  11. Chapter 11 SQL Server Agent, Backup, and Restore

    1. Before You Begin

    2. Lesson 1: Managing SQL Server Agent

    3. Lesson 2: Configuring and Maintaining a Backup Strategy

    4. Lesson 3: Restoring SQL Server Databases

    5. Case Scenarios

    6. Suggested Practices

    7. Answers

  12. Chapter 12 Code Case Studies

    1. Case Study 1

    2. Case Study 2

    3. Case Study 3

    4. Case Study 4

    5. Answers

    Title:
    Training Kit (Exam 70-462): Administering Microsoft? SQL Server? 2012 Databases
    By:
    Orin Thomas, Peter Ward, boB Taylor
    Publisher:
    Microsoft Press
    Formats:
    • Print
    • Ebook
    • Safari Books Online
    Print:
    July 2012 (est.)
    Ebook:
    June 2012
    Pages:
    624 (est.)
    Print ISBN:
    978-0-7356-6607-8
    | ISBN 10:
    0-7356-6607-5
    Ebook ISBN:
    978-0-7356-6606-1
    | ISBN 10:
    0-7356-6606-7

    1. Orin Thomas

      Orin Thomas is a consultant, writer, and Microsoft MVP whose books include the Microsoft Press Training Kits for Exams 70-646, 70-647, 70-662, and 70-680. He is also a contributing editor for Windows IT Pro magazine.

      View Orin Thomas's full profile page.

    2. Peter Ward

      Peter Ward, MVP, is a highly regarded consultant, speaker, and trainer who provides solutions for some of the largest SQL Server sites in Australia. He is a Microsoft MVP for SQL Server.

      View Peter Ward's full profile page.

    3. boB Taylor

      boB Taylor, MCM, is a SQL Server Principal Premier Field Engineer and database architect for with Microsoft. He has 30+ years of programming experience and multiple certifications.

      View boB Taylor's full profile page.

    Description

    Table of Contents

    Product Details

    About the Author

    Recommended for You

    Customer Reviews

    		 ?
    ?

    Source: http://feedproxy.google.com/~r/oreilly/newbooks/~3/zLF47qllbDU/

    artie lange nascar daytona 2012 kasey kahne angelina jolie right leg saving face academy award winners best picture

    Posted by at

    No comments:

    Post a Comment

    Note: Only a member of this blog may post a comment.

    Subscribe to: Post Comments (Atom)