Microsoft SQL Server 2008 Implementation and Maintenance (70-432) (Microsoft Official Academic Course) （Lab Manual）

Owen, Dave (EDT)/ Boyer, Wayne (EDT)

John Wiley & Sons Inc（2011/02発売）

ただいまウェブストアではご注文を受け付けておりません。 ⇒古書を探す

製本 Paperback:紙装版/ペーパーバック版／ページ数 648 p.
言語 ENG
商品コード 9780470183762
DDC分類 004

Full Description

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.

Chapter 1 Introduction Chapter 2 Installing Microsoft SQL ServerChapter 3 Navigating SQL ServerChapter 4 Data TypesChapter 5 DatabasesChapter 6 TablesChapter 7 ViewsChapter 8 ConstraintsChapter 9 Stored ProceduresChapter 10 FunctionsChapter 11 Service BrokerChapter 12 Data IntegrityChapter 13 PermissionsChapter 14 Logins, Roles, and CredentialsChapter 15 Additional Security ToolsChapter 16 Backing Up and Restoring DatabasesChapter 17 EndpointsChapter 18 Linking ServersChapter 19 TriggersChapter 20 ReplicationChapter 21 Performing Indexing and Full-TextSearchingChapter 22 Transactions and LocksChapter 23 Moving DataChapter 24 Handling Specialty DataChapter 25 High-Availability MethodsChapter 26 Maintaining and Automating SQL ServerChapter 27 Monitoring and Optimizing SQL ServerChapter 28 SQL Server Management ToolsChapter 29 Troubleshooting TechniquesAppendix AAppendix BAppendix CGlossaryIndex