Exam 70-432 Microsoft SQL Server 2008 Implementation and Maintenance with Lab Manual Set
by Microsoft Official Academic Course (Microsoft Corporation)Edition: Lab
Format: Paperback
Pub. Date: 2011-02-15
Publisher(s): Wiley
Other versions by this Author
-
This Item Qualifies for Free Shipping!*
*Excludes marketplace orders.
List Price: $208.26
Buy New
Arriving Soon. Will ship when available.
$198.34
Buy Used
In stock
$148.76
Rent Textbook
Select for Price
eTextbook
We're Sorry
Not Available
How Marketplace Works:
- This item is offered by an independent seller and not shipped from our warehouse
- Item details like edition and cover design may differ from our description; see seller's comments before ordering.
- Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
- Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
- Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.
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.
Author Biography
The Microsoft Official Academic Course series is a complete program for instructors and institutions to prepare and deliver great courses on Microsoft software technologies. With MOAC, we recognize that, because of the rapid pace of change in the technology and curriculum developed by Microsoft, there is an ongoing set of needs beyond classroom instruction tools for an instructor to be ready to teach the course. MOAC endeavors to provide solutions for all these needs in a systematic manner in order to ensure a successful and rewarding course experience for both instructor and student—technical and curriculum training for instructor readiness with new software releases, the software itself for student use at home for building hands-on skills, assessment and validation of skill development, and a great set of tools for delivering instruction in the classroom and lab. All are important to the smooth delivery of an interesting course on Microsoft software, and all are provided with the Microsoft Official Academic Course program.
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
An electronic version of this book is available through VitalSource.
This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.
By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.
Digital License
You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.
More details can be found here.
A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.
Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.
Please view the compatibility matrix prior to purchase.