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

Byrne, Jeffry

9780130107954: MCSE: Administering Microsoft SQL Server 7 (McSe Series)

Hardcover

ISBN 10: 0130107956 ISBN 13: 9780130107954

Publisher: Prentice Hall, 1998

This isn't just a guide to passing Microsoft's SQL Server 7 System Administration exam: it's a 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.

"synopsis" may belong to another edition of this title.

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!

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" may belong to another edition of this title.