MCSE: Administering Microsoft SQL Server 7 (McSe Series) - Hardcover

Byrne, Jeffry

Hardcover

ISBN 10: 0130107956 ISBN 13: 9780130107954

Publisher: Prentice Hall, 1998

Synopsis

This is a great guide to passing Microsoft's System Administration for Microsoft SQL Server 7 exam - and every bit as valuable once you've passed the exam and you're running an SQL Server system. Written by a top SQL Server expert, the book starts with an overview of SQL Server 7 and SQL fundamentals, then shows how to build database objects - including tables, views, database roles, stored procedures, indexes, and more. It reviews key SQL Server components, including the Distributed Transaction Coordinator, SQL Server Agent, SQL Mail, Replication Monitor, Data Transformation Packages and more. From start to finish, it delivers comprehensive guidance on planning, installing, configuring and optimizing SQL Server 7. The book includes test questions at the end of each chapter, sample texts in the appendix, access to an interactive training Web site - even a free CBT Systems course on the CD-ROM, worth $225!

About this title

About the Author

Jeffrey Byrneis a database developer living in Portland, OR. His software books include Understanding Microsoft SQL Server and Building Microsoft SQL Server Websites, both from Prentice Hall PTR.

From the Back Cover

1079E-3

Supercharge your training with EXCLUSIVE Web & interactive resources!

We've teamed with CBT Systems, the world's #1 developer of IT self-paced training, to include a state-of-the-art interactive training course on CD-ROM -- worth $225! And that's not all: Every Prentice Hall PTR MCSE book is 100% integrated with its own exclusive MCSE training Web site, delivering all this, and more...

• Interactive test Q&A section
• Projects you can complete - with detailed solutions
• Virtual Study Lounge: interact with students, authors and trainers on-line!
• Author's Corner: Book & exam updates, training news and more
• Expert techniques for database planning, installation, configuration and security
• Managing databases for maximum integrity, consistency and concurrency
• Publishing SQL Server 7 data on the Web
• Replication: planning, configuration and management
• Backup and restore - step-by-step!
• Complete sample test, plus 100+ extra questions and answers!
• Pass Microsoft's SQL Server 7 MCSE exam - with flying colors!

This isn't just a great guide to passing Microsoft's SQL Server 7 System Administration exam: it's an equally spectacular guide to actually running your SQL Server database system!

You'll start with a detailed overview of SQL Server 7's fundamentals - including logical structures, key components and the Transact-SQL language. Walk step-by-step through planning, installing and configuring your SQL Server 7.0 database for maximum reliability and performance. Master crucial techniques for ensuring data integrity and security - techniques that constantly show up on Microsoft's exam!

Learn how to supercharge productivity by using the SQL Server Agent to automate administration tasks. Master database backup and restoration. Use SQL Server 7 as a high-performance back-end for your Web applications. It's all here, and lots more - including three full chapters on replication, a key component of today's distributed database strategies!

• Ace Microsoft's Exam 70-028: System Administration for Microsoft ® SQL Server ™ 7.0!
• You get 100+ incisive test Q&As, plus a complete sample exam, access to the state-of-the-art Scholars.com interactive training Web site with even more quizzes and help -- and a free CBT Systems SQL Server 7 interactive training course on CD-ROM, worth $225!
• Don't just get a cram guide: get a total learning resource. Get MCSE: System Administration for Microsoft SQL Server!

Edition details

• Publisher: Prentice Hall
• Publication date: 1998
• Language: English
• ISBN 10: 0130107956
• ISBN 13: 9780130107954
• Binding: Hardcover
• Number of pages: 352