From Book News, Inc.
A guide to running an SQL Server 7 database system and preparing for Microsoft's SQL Server 7.0 system administration exam 70-028, an elective towards MCSE certification. Covers installation and configuration, security, managing database files, transferring data, monitoring performance, automating tasks, publishing data on the Web, and replication. The CD-ROM contains an interactive course on core server architecture and features. Book News, Inc.®, Portland, OR

Book Info
Presents a detailed overview of SQL Server 7; the fundamentals - including logical structures, key components & the Transact-SQL language to pass Microsoft's SQL Server 7 MCSE exam. DLC: Electronic data processing personnel Certification.

Card catalog description
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.

From the Back Cover
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!

About the Author
JEFFRY BYRNE is a database developer living in Portland, OR. His books include Understanding Microsoft SQL Server and Building Microsoft SQL Server Websites, both from Prentice Hall PTR.

FROM THE PUBLISHER

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

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!

FROM THE CRITICS

Booknews