MCSE.: Administering Microsoft SQL Server 7
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!
What people are saying - Write a review
We haven't found any reviews in the usual places.
Microsoft SQL Server Overview
What Is SQL?
SQL Server Structure
23 other sections not shown
alert allows application backup device chapter CHECK constraint choose Click the OK client column command configuration connection contains create cursor data files data warehouse datatype default value delete disk displayed ensure entered folder foreign key granted INSERT install SQL Server log file master database master server MCSE memory Microsoft SQL Server Named Pipes NULL ODBC OK button OLE DB operating system parameters password performance permission primary key processor Properties dialog box pubs database Query Analyzer query optimizer replication restore results set role scheduled Server Enterprise Manager Setup shortcut menu specific SQL Mail SQL Server Agent SQL Server database SQL Server Enterprise stored procedure system administrator T-SQL statements target server text box Transact-SQL transaction log trigger True or False update user account varchar versions of SQL Windows NT Wizard ZACHARY