Exam 70-432 -  Microsoft Official Academic Course

Exam 70-432

Microsoft SQL Server 2008 Implementation and Maintenance with Lab Manual Set
Buch | Softcover
648 Seiten
2011
John Wiley & Sons Ltd (Verlag)
978-0-470-18376-2 (ISBN)
48,79 inkl. MwSt
  • Titel ist leider vergriffen;
    keine Neuauflage
  • Artikel merken
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 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.

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.

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

Erscheint lt. Verlag 11.3.2011
Verlagsort Chichester
Sprache englisch
Maße 216 x 272 mm
Gewicht 2132 g
Themenwelt Informatik Datenbanken SQL Server
Informatik Weitere Themen Zertifizierung
ISBN-10 0-470-18376-4 / 0470183764
ISBN-13 978-0-470-18376-2 / 9780470183762
Zustand Neuware
Haben Sie eine Frage zum Produkt?
Mehr entdecken
aus dem Bereich
Der schnelle Einstieg

von Klemens Konopasek

Buch (2018)
Carl Hanser (Verlag)
40,00
Das umfassende Handbuch. Inkl. Analysis und Reporting Services

von Daniel Caesar; Michael R. Friebel; Hans Georg Selent-Knips

Buch | Hardcover (2020)
Rheinwerk (Verlag)
49,90