MCITP Administrator
Microsoft SQL Server 2005 Database Server Infrastructure Design Study Guide (Exam 70-443)
1st Edition
Published on 19. September 2006
Book
Paperback/Softback
458 pages
978-0-470-04744-6 (ISBN)
Description
An essential guide for Microsoft's new SQL Server 2005 certification track
With the release of SQL Server 2005, Microsoft is introducing a new multi-exam certification program. This comprehensive book prepares you for Microsoft's all-new exam 70-443, Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005, one of two required Professional Administrator exams in the MCITP: Database Administrator certification path. Inside, find the practical and in-depth instruction you need, including:
* Full coverage of all exam objectives in a systematic approach, so you can be confident you're getting the instruction you need for the exam
* Practical hands-on exercises to reinforce critical skills
* Real-world scenarios that put what you've learned in the context of actual job roles
* Challenging review questions in each chapter to prepare you for exam day
* Exam Essentials, a key feature at the end of each chapter that identifies critical areas you must become proficient in before taking exam 70-443
* A handy fold-out that maps every official exam objective to the corresponding chapter in the book, so you can track your exam prep objective by objective
Look inside for complete coverage of all exam objectives for exam 70-443.
Featured on the CD
SYBEX TEST ENGINE:
Test your knowledge with advanced testing software. Includes all chapter review questions and bonus case study exam questions.
ELECTRONIC FLASHCARDS:
Reinforce your understanding with flashcards that can run on your PC, Pocket PC, or Palm handheld.
Also on the CD is the entire book in searchable and printable PDF. Study anywhere, any time, and approach the exam with confidence.
www.sybex.com
With the release of SQL Server 2005, Microsoft is introducing a new multi-exam certification program. This comprehensive book prepares you for Microsoft's all-new exam 70-443, Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005, one of two required Professional Administrator exams in the MCITP: Database Administrator certification path. Inside, find the practical and in-depth instruction you need, including:
* Full coverage of all exam objectives in a systematic approach, so you can be confident you're getting the instruction you need for the exam
* Practical hands-on exercises to reinforce critical skills
* Real-world scenarios that put what you've learned in the context of actual job roles
* Challenging review questions in each chapter to prepare you for exam day
* Exam Essentials, a key feature at the end of each chapter that identifies critical areas you must become proficient in before taking exam 70-443
* A handy fold-out that maps every official exam objective to the corresponding chapter in the book, so you can track your exam prep objective by objective
Look inside for complete coverage of all exam objectives for exam 70-443.
Featured on the CD
SYBEX TEST ENGINE:
Test your knowledge with advanced testing software. Includes all chapter review questions and bonus case study exam questions.
ELECTRONIC FLASHCARDS:
Reinforce your understanding with flashcards that can run on your PC, Pocket PC, or Palm handheld.
Also on the CD is the entire book in searchable and printable PDF. Study anywhere, any time, and approach the exam with confidence.
www.sybex.com
More details
Edition
1., Auflage
Language
English
Place of publication
Chichester
United Kingdom
Publishing group
John Wiley and Sons Ltd
Target group
College/higher education
Professional and scholarly
Illustrations
Illustrations
Dimensions
Height: 23.3 cm
Width: 18.7 cm
Thickness: 28 mm
Weight
748 gr
ISBN-13
978-0-470-04744-6 (9780470047446)
Schweitzer Classification
Persons
Steve Jones has been working with SQL Server for more than a decade, starting with v4.2 on OS/2 and enjoying the new features and capabilities of every version since. After working as a DBA and developer for a variety of companies, Steve founded SQLServerCentral.com along with Brian Knight and Andy Warren in 2001. SQLServerCentral.com has grown into a wonderful SQL Server community that provides daily articles and questions on all aspects of SQL Server to over 300,000 members. Starting in 2004, Steve became the full-time editor of the community and ensures it continues to evolve into the best resource possible for SQL Server professionals.
Over the last decade, Steve has written more than 200 articles about SQL Server for SQLServerCentral.com, the SQL Server Standard magazine, SQL Server Magazine, and Database Journal. teve has spoken at the PASS Summits where SQLServerCentral.com sponsors an opening reception every year as well as written a prior book for Sybex on SQL Server 2000.
David W. Tschanz is the coauthor of the recent Sybex book Mastering SQL Server 2005. He has been working with and managing large datasets for four decades. His work has included analysis of population dynamics, voting behavior, and epidemiological data. He has been writing on computer topics for the past several years, including 4 books and about 100 articles in the area. e is also a regular contributor to Redmond magazine.
Dave currently lives outside the United States, where his eclectic nature allows him to pursue projects involving databases, IT infrastructure, web development, archaeology, the ancient Nabataean capital of Petra, medical history, military science, and demography. He can be reached by e-mail at desertwriter1121@yahoo.com, or look for him in Connecticut, Saudi Arabia, or Tasmania, his three favorite haunts.
Over the last decade, Steve has written more than 200 articles about SQL Server for SQLServerCentral.com, the SQL Server Standard magazine, SQL Server Magazine, and Database Journal. teve has spoken at the PASS Summits where SQLServerCentral.com sponsors an opening reception every year as well as written a prior book for Sybex on SQL Server 2000.
David W. Tschanz is the coauthor of the recent Sybex book Mastering SQL Server 2005. He has been working with and managing large datasets for four decades. His work has included analysis of population dynamics, voting behavior, and epidemiological data. He has been writing on computer topics for the past several years, including 4 books and about 100 articles in the area. e is also a regular contributor to Redmond magazine.
Dave currently lives outside the United States, where his eclectic nature allows him to pursue projects involving databases, IT infrastructure, web development, archaeology, the ancient Nabataean capital of Petra, medical history, military science, and demography. He can be reached by e-mail at desertwriter1121@yahoo.com, or look for him in Connecticut, Saudi Arabia, or Tasmania, his three favorite haunts.
Content
Introduction.
Assessment Test.
Chapter 1: Designing the Hardware and Software Infrastructure.
Chapter 2: Designing Physical Storage.
Chapter 3: Designing a Consolidation Strategy.
Chapter 4: Designing Database-Level Security.
Chapter 5: Designing Windows Server-Level Security Processes.
Chapter 6: Designing SQL Server Service-Level Security.
Chapter 7: Designing SQL Server Object-Level Security.
Chapter 8: Designing a Physical Database.
Chapter 9: Creating Database Conventions and Standards.
Chapter 10: Designing a SQL Server 2005 Solution for High Availability.
Chapter 11: Designing a Data Recovery Solution for a Database.
Chapter 12: Designing a Data-Archiving Solution.
Glossary.
Index.
Assessment Test.
Chapter 1: Designing the Hardware and Software Infrastructure.
Chapter 2: Designing Physical Storage.
Chapter 3: Designing a Consolidation Strategy.
Chapter 4: Designing Database-Level Security.
Chapter 5: Designing Windows Server-Level Security Processes.
Chapter 6: Designing SQL Server Service-Level Security.
Chapter 7: Designing SQL Server Object-Level Security.
Chapter 8: Designing a Physical Database.
Chapter 9: Creating Database Conventions and Standards.
Chapter 10: Designing a SQL Server 2005 Solution for High Availability.
Chapter 11: Designing a Data Recovery Solution for a Database.
Chapter 12: Designing a Data-Archiving Solution.
Glossary.
Index.