CART

(0) items

Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005, Exam 70-444 Package,9780470183762
This item qualifies for
FREE SHIPPING!

FREE SHIPPING OVER $59!

Your order must be $59 or more, you must select US Postal Service Shipping as your shipping preference, and the "Group my items into as few shipments as possible" option when you place your order.

Bulk sales, PO's, Marketplace Items, eBooks, Apparel, and DVDs not included.

Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005, Exam 70-444 Package

by
Edition:
Lab
ISBN13:

9780470183762

ISBN10:
0470183764
Format:
Paperback
Pub. Date:
2/1/2011
Publisher(s):
Wiley
List Price: $174.66

Buy New Textbook

Currently Available, Usually Ships in 24-48 Hours
N9780470183762
$166.93

Rent Textbook

We're Sorry
Sold Out

Used Textbook

We're Sorry
Sold Out

eTextbook

We're Sorry
Not Available

More New and Used
from Private Sellers
Starting at $97.11
See Prices

Questions About This Book?

What version or edition is this?
This is the Lab edition with a publication date of 2/1/2011.
What is included with this book?
  • The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any CDs, lab manuals, study guides, etc.

Summary

This book is for students preparing to become certified for the 70-444 and 70-432 Microsoft SQL Server 2005/2008 Database Administration exam. The Microsoft Official Academic Course (MOAC) lessons correlate and are mapped to the Microsoft Certified Information Technology Professional, (MCITP) 70-444 and 70-432 certification exam. This text covers installing and configuring Microsoft SQL Server and managing and maintaining databases and multidimensional databases, user accounts, database availability, recovery, and reporting. This text guides students through the design and implementation of security or server automation as well as monitoring and troubleshooting SQL Server activity. The MOAC IT Professional series is the Official from Microsoft, turn-key Workforce training program that leads to professional certification and was authored for college instructors and college students.MOAC gets instructors ready to teach and students ready for work by delivering essential resources in 5 key areas: Instructor readiness, student software, student assessment, instruction resources, and learning validation. With the Microsoft Official Academic course program, you are getting instructional support from Microsoft; materials that are accurate and make course delivery easy.

Table of Contents

Chapter 1 Introduction

Chapter 2 Installing Microsoft SQL Server

Chapter 3 Navigating SQL Server

Chapter 4 Data Types

Chapter 5 Databases

Chapter 6 Tables

Chapter 7 Views

Chapter 8 Constraints

Chapter 9 Stored Procedures

Chapter 10 Functions

Chapter 11 Service Broker

Chapter 12 Data Integrity

Chapter 13 Permissions

Chapter 14 Logins, Roles, and Credentials

Chapter 15 Additional Security Tools

Chapter 16 Backing Up and Restoring Databases

Chapter 17 Endpoints

Chapter 18 Linking Servers

Chapter 19 Triggers

Chapter 20 Replication

Chapter 21 Performing Indexing and Full-Text Searching

Chapter 22 Transactions and Locks

Chapter 23 Moving Data

Chapter 24 Handling Specialty Data

Chapter 25 High-Availability Methods

Chapter 26 Maintaining and Automating SQL Server

Chapter 27 Monitoring and Optimizing SQL Server

Chapter 28 SQL Server Management Tools

Chapter 29 Troubleshooting Techniques

Appendix A

Appendix B

Appendix C

Glossary

Index



Please wait while the item is added to your cart...