Wiley
Wiley.com
Print this page Share
Textbook

70-432: Microsoft SQL Server 2008 Implementation and Maintenance

February 2011, ©2011
70-432: Microsoft SQL Server 2008 Implementation and Maintenance (EHEP001958) cover image
 
This book is for students preparing to become certified for the 70-432 Microsoft SQL Server 2008 Database Administration exam.  The Microsoft Official Academic Course (MOAC) lessons correlate and are mapped to the Microsoft Certified Information Technology Professional, (MCITP) 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. 

See More

1 Introduction.

2 Installing Microsoft SQL Server.

3 Navigating SQL Server.

4 Data Types.

5 Databases.

6 Tables.

7 Views.

8 Constraints.

9 Stored Procedures.

10 Functions.

11 Service Broker.

12 Data Integrity.

13 Permissions.

14 Logins, Roles, and Credentials.

15 Additional Security Tools.

16 Backing Up and Restoring Databases.

17 Endpoints.

18 Linking Servers.

19 Triggers.

20 Replication.

21 Performing Indexing and Full-Text Searching.

22 Transactions and Locks.

23 Moving Data.

24 Handling Specialty Data.

25 High-Availability Methods.

26 Maintaining and Automating SQL Server.

27 Monitoring and Optimizing SQL Server.

28 SQL Server Management Tools.

29 Troubleshooting Techniques.

Appendix A.

Appendix B.

Appendix C.

Glossary.

Index.

See More
Instructors Resources
Wiley Instructor Companion Site
DREAMSPARK PREMIUM Subscription
Update your lab to Windows Vista or Windows XP for free by adopting a MOAC title. DREAMSPARK PREMIUM Subscription is free upon adoption of MOAC titles for new subscribers.
Instructor Guide
Practice Test
POWERPOINT SLIDES
Created to convey key concepts addressed in the text.
Image Gallery
Available Materials
by Microsoft Official Academic Course
978-0-470-18368-7
February 2011, ©2011, Paperback (E-book also available)
The lab manual is included with appropriate sets, or can be purchased separately.
by Microsoft Official Academic Course
978EOARC00161
December 2012, ©2011, Digital Content
by Microsoft Official Academic Course
978-1-118-12996-8
November 2011, ©2009, Paperback
by Microsoft Official Academic Course
978-1-118-41300-5
May 2012, ©2012, Paperback
See More
See Less
Students Resources
Wiley Student Companion Site
Practice Test
Available Materials
by Microsoft Official Academic Course
978-0-470-18368-7
February 2011, ©2011, Paperback (E-book also available)
The lab manual is included with appropriate sets, or can be purchased separately.
by Microsoft Official Academic Course
978EOARC00161
December 2012, ©2011, Digital Content
by Microsoft Official Academic Course
978-1-118-12996-8
November 2011, ©2009, Paperback
by Microsoft Official Academic Course
978-1-118-41300-5
May 2012, ©2012, Paperback
See More
See Less
Purchase Options
Wiley E-Text   
Exam 70-432: Microsoft SQL Server 2008 Implementation and Maintenance
ISBN : 978-1-118-10239-8
552 pages
April 2011, ©2011
$71.50   BUY

Digital Content   
70-432 MOAC Labs Online OA Reg Code with Wiley eText Digital Set
ISBN : 978-1-118-75748-2
July 2013, ©2013
$124.50   BUY

Paperback   
Exam 70-432: Microsoft SQL Server 2008 Implementation and Maintenance
ISBN : 978-0-470-18367-0
552 pages
February 2011, ©2011
$147.95   BUY

Paperback   
Exam 70-432: Microsoft SQL Server 2008 Implementation and Maintenance with Lab Manual Set
ISBN : 978-0-470-18376-2
648 pages
February 2011, ©2011
$168.95   BUY

Paperback   
Exam 70-432: Microsoft SQL Server 2008 Implementation and Maintenance with MOAC Labs Online Set
ISBN : 978-1-118-15592-9
February 2012, ©2011
$210.95   BUY

Paperback   
Exam 70-432: Microsoft SQL Server 2008 Implementation and Maintenance with Lab Manual and MOAC Labs Online Set
ISBN : 978-1-118-13455-9
1057 pages
September 2011, ©2011
$228.95   BUY

Related Titles

Back to Top