Advanced end-users, technicians, and network administrators facing certification as a MCDBA or MCSE will find this guide filled with hands-on projects and real examples that cover the curriculum objectives for Designing and Implementing Databases with Microsoft SQL Server 7, Exam 70-029. The CD-Rom contains two complete practice exams.

The SQL Server 7 is covered in-depth, with 250 questions that directly map to the certification objectives. "Exam watch warnings" point out exam trouble spots, certification summaries offer a succinct review of information, and two color-end sheets explain the MCDBA structure. Self-testing software comes in a companion CD-ROM.

Covers Exam 70-028.

This test-prep title contains an exclusive interactive CD-ROM allowing readers to practice in an adaptive environment similar to that of the actual exam. The CD features one complete practice test for each: DB Design and Administration.

MCAD/MCSD/MCSE Training Guide (70-229): SQL Server 2000 Database Design and Implementationis the perfect study guide to help you pass the 70-229 exam, which is an elective for the MCSD, MCAD, MCDBA, and MCSE programs. If you are preparing for this exam, you'll find our Training Guide to be the most effective self-study tool in the market! This book is your one-stop shop because of its teaching methodology, the accompanying PrepLogic testing software, and superior Web site support at www.examcram.com. The book follows the exam objectives and features numerous exercises to give you hands-on opportunities, exam tips that give you advice for test day, and warnings that alert you to possible mistakes. The Fast Facts section condenses the most important information for last-minute review, and the practice exam is representative of the actual exam. Each book in the Training Guide series is published under the direction of Series Editor Ed Tittel, the leading authority on IT certification. This book has been subjected to rigorous technical review by a team of industry experts, ensuring content is superior in both coverage and technical accuracy, and has earned the distinction of Cramsession Approved Study Material. The CD features PrepLogic Practice Tests, Preview Edition. This product includes one complete PrepLogic Practice Test with approximately the same number of questions found on the actual vendor exam. Each question contains full, detailed explanations of the correct and incorrect answers. The engine offers two study modes, Practice Test and Flash Review, full exam customization, and a detailed score report.

Learn how to implement, administer, and troubleshoot information systems that incorporate Microsoft SQL Server 7.0. The book includes sections on proven test-taking strategies, warning on trick questions, and time-saving study tips and shortcuts.

Learn how to deliver powerful database solutions using SQL Server 2000 Enterprise Edition and prepare for the Microsoft Certified Professional (MCP) exam with this official Microsoft study guide. Work at your own pace through the lessons and hands-on exercises. And use the special exam-prep section and testing tool to measure what you know and ......

Conquer SQL Server 2017 administration—from the inside out Dive into SQL Server 2017 administration—and really put your SQL Server DBA expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds—all you need to plan, implement, manage, and secure SQL Server 2017 in any production environment: on-premises, cloud, or hybrid. Four SQL Server experts offer a complete tour of DBA capabilities available in SQL Server 2017 Database Engine, SQL Server Data Tools, SQL Server Management Studio, and via PowerShell. Discover how experts tackle today’s essential tasks—and challenge yourself to new levels of mastery. • Install, customize, and use SQL Server 2017’s key administration and development tools • Manage memory, storage, clustering, virtualization, and other components • Architect and implement database infrastructure, including IaaS, Azure SQL, and hybrid cloud configurations • Provision SQL Server and Azure SQL databases • Secure SQL Server via encryption, row-level security, and data masking • Safeguard Azure SQL databases using platform threat protection, firewalling, and auditing • Establish SQL Server IaaS network security groups and user-defined routes • Administer SQL Server user security and permissions • Efficiently design tables using keys, data types, columns, partitioning, and views • Utilize BLOBs and external, temporal, and memory-optimized tables • Master powerful optimization techniques involving concurrency, indexing, parallelism, and execution plans • Plan, deploy, and perform disaster recovery in traditional, cloud, and hybrid environments For Experienced SQL Server Administrators and Other Database Professionals • Your role: Intermediate-to-advanced level SQL Server database administrator, architect, developer, or performance tuning expert • Prerequisites: Basic understanding of database administration procedures

A unique book-and-video package for learning Microsoft SQL Server Integration Services If you need a practical, hands-on introduction to Microsoft SQL Server 2008 Integration Services (SSIS), this book and video package from foremost SSIS authority Brian Knight gets you thoroughly up to speed. Each lesson in the book includes three major components: a thorough description of how each SSIS feature or process works; a tutorial that walks you through the process or technique; and a video lesson that demonstrates it. If you take full advantage of this comprehensive package, you will gain enough experience to tackle your first SSIS project with confidence. SQL Server Integration Services 2008 (SSIS) builds on the revolutionary database product suite first introduced by Microsoft in 2005 and is a powerful tool for performing extraction, transformation, and load (ETL) operations essential to data warehousing If you're just learning SSIS, the step-by-step tutorials in this book and DVD training package will ready you to tackle your own first project Every lesson in the book is supplemented by instructional video on the DVD Note:As a part of this title, video lessons are included on DVD. For the e-book versions, video lessons can be accessed at wrox.com using a link provided in the interior of the e-book.