当前计算机系统的开发、管理、使用及维护需要大量不同层次的专业技术人员,评价各种技术人员的水平是一件既复杂又必不可少的工作。为考查、评测有关人员对微软件操作系统、软件和网络的理解和熟练使用程序,Microsoft 公司设计了如下 几种认证方案:\r\nMicrosoft Certified Professional——MCP ,微软认证专业人员\r\nMicrosoft Certified Solution Developer——MCSD,微软认证软件开发专家\r\nMicrosoft Certified System Engineer——MCSE,微软认主系统工程师\r\nMicrosoft Certified Trainer ——MCT,微软认证培训员\r\n为帮助国内的技术人员学好、用好微软的产品,顺利通过有关的考试,我们分别以翻译和英文原版重印的形式推出了“MCSE学习指南系列”(中文译本)、“MCSE考试指南系列”(英文原版)和“MCSD学习指南系列”(英文原版)三种系列书。\r\n
Table of Contents\r\n\r\nIntroduction\r\n\r\nChapter 1 An Introdution SQL Server 6.5\r\n\r\nSQL Server 6.5 Is new and Improved\r\nSQL Enterprise Manager\r\nTransact-SQL\r\nSQL-DMO\r\nDatabase Maintenance Plan Wizard\r\nSQL Server Capacities\r\nTools and Utilities Included in SQL Server 6.5\r\nISQL/W\r\nWorking with Queries\r\nUsing Graphical Statistics I/O\r\nMS Query\r\nStarting MS Query\r\nWorking with an MS Query SQL Statement\r\nSQL Enterprise Manager\r\nStarting SQL Enterprise Manager\r\nAccessing the Pubs Sample Database\r\nVerifying the Pubs Database\r\nInstalling the Pubs Sample Database\r\nSQL Server Books Online\r\nThe Downtown Delivery Service Project\r\nSummary\r\nReview Questions\r\n\r\nChapter 2 Data Modeling\r\n\r\nThe Relational Model\r\nThe Client/Server Model\r\nFile-Server Versus Distributed Client/Server\r\nThe Entity-Relationship Model\r\nEntity-Relationship Diagramming\r\nEntities\r\nEntities in a Data Model\r\nNaming Entities\r\nDrawing Entities\r\nAdding Attributes to a Data Model\r\nDivide and Conquer\r\nUniqueness and Keys\r\nPrimary Keys\r\nColumn Constraints\r\nUnderstanding NULL and NOT NULL\r\nDisallowing Duplicates\r\nAdding Defaults\r\nProhibiting Changes\r\nImproving the ER Model for the Downtown Delivery Service\r\nRelationships\r\nOne-to-One Relationships\r\nOne-to Many Relationships\r\nMany-to-Many Relationships\r\nEnforcing Data Integrity\r\nEntity Integrity\r\nDomain Integrity\r\nReferential Integrity\r\nNormalizing a Database Design\r\nFirst Normal Form\r\nSecond Normal Form\r\nBenefits of Normalization\r\nDrawbacks of Normalization\r\nSummary\r\nReview Questions\r\n\r\nChapter 3 System Databases and Tables\r\n\r\nExamining the System Databases\r\nIdentifying the Role of the Model Database\r\nIdentifying the Role of the msdb Database\r\nIdentifying the Types of Temporary Tables\r\nAdjusting the Size of the Tempdb Database\r\nPlacing empdb in RAM\r\nDiscussing System Tables\r\nSystem Catalog\r\nDatabase Catalog\r\nQuerying System Tables\r\nAccessing the System with System Stored Procedures\r\nCatalog Stored Procedures\r\nExtended Stored Procedures\r\nReplication Stored Procedures\r\nSQL Executive Stored Procedures\r\nSystem Stored Procedures\r\nExecuting Stored Procedures\r\nsp_help [objectname]\r\nsp_helpdb[bdname]\r\nsp_helpsql[topic]\r\nsp_who\r\nEstimating Space Requirements\r\nUnderstanding SQL Server's Units of Storage\r\nData Pages\r\nData Rows\r\nAllocation Units\r\nCalculating Row and Table Size\r\nCalculating the Number of Nonclustered Index Pages \r\nCalculating the Size of the Inventory Table\r\nSummary \r\nReview Questions\r\n\r\nChapter 4 Data Definition\r\n\r\nManaging Database Devices\r\nCreating a Device\r\nCreating the DownTown2 Device\r\nViewing Information about a Device\r\nUsing SQL Enterprise Manager to View Information about All Devices\r\nUsing sp_helpdevice to View Information about a Device\r\nExpanding a Database Device\r\nUsing the Enterprise Manager to Expand a Database Device\r\nUsing Transact-SQL to Expand a Database Device\r\nExpanding a Device with DISK RESIZE\r\nDropping a Device\r\nDropping a Device with SQL Enterprise Manager\r\nDropping a Device with sp_dropdevice Stored Procedure\r\nIntroducing SQL Server Databases\r\nExploring the Transaction Logs Role in SQL Server\r\nFollowing the Execution Path of the Transaction Log\r\nManaging SQL Server Databases\r\nCreating a Database Using SQL Enterprise Manager\r\nCreating a Database with the CREATE DATABASE Statement\r\nUsing CREATE DATABASE to Create a Database\r\nExploring the Available Database Options\r\nSetting Database Options from within SQL Enterprise manager\r\nUsing sp_dboption to Set Database Options\r\nSetting Off an ANSI Null default with sp_dboption\r\nModifying Databases and Transaction Logs\r\nExpanding a Database\r\nUsing SQL Enterprise manager to Expand a Database\r\nincreasing the Size of a Database with ALTER DATABASE\r\nUsing ALTER DATABASE to Increase a Database's Size\r\nShrinking a Database\r\nUsing SQL Enterprise Manager to Shrink a Database\r\nShrinking a Database with DBCC SHRINKDB\r\nUsing DBCC SHRINKDB to Shrink the DowntownDB Database\r\nDropping a Database\r\nDropping a Database from SQL Enterprise Manager\r\nUsing DROP DATABASE to Drop a Database\r\nDropping a Database with DROP DATABASE\r\nUnderstanding SQL Server 6.5 Datatypes\r\nSystem Supplied Datatypes\r\nUser-Defined Datatypes\r\nManaging Tables in SQL Server 6.5\r\nCreating a Table with SQL Enterprise Manager\r\nUsing the CREATE TABLE Statement to Create a Table\r\nCreating a Table with CREATE TABLE\r\nDropping a Table\r\nDropping a Table with SQL Enterprise Manager\r\nUsing DROP TABLE to Delete a Table\r\nDropping a Table with DROP TABLE\r\nDiscussing Data Integrity\r\nIdentifying the Types of Data Integrity\r\nEnforcing Data Integrity with the IDENTITY Property\r\nIdentifying Guidelines Associated with the IDENTITY Property\r\nCreating an Identity Column\r\nCreating a Table with an Identity Column\r\nAdding a Column with the IDENTITY Property to an Existing Table\r\nUsing Constraints to Enforce Data Integrity\r\nManaging Constraints with the SQL Enterprise Manager\r\nManaging Constraints with the CREATE TABLE and ALTERTABLE Statements\r\nCreating a PRIMARY KEY Constraint\r\nCreating a FOREIGN KEY Constraint\r\nCreating a UNIQUE Constraint\r\nCreating a CHECK Constraint\r\nSummary\r\nReview Questions\r\n\r\nChapter 5 Data Retrieval\r\n\r\nA Refresher Course in SQL\r\nCoding a SQL SELECT Statement\r\nUsing Character Strings and Quotes\r\nArithmetic Operators\r\nOperator Precedence\r\nComparison Operators in SQL Statements\r\nKeywords Used in a WHERE Clause\r\nUsing SQL Statements\r\nCoding the SELECT Statement\r\nQuerying with Wildcards and the LIKE Clause\r\nSorting Records with the ORDER BY Clause\r\nUsing SQL's Built-In Functions to Format Output Data\r\nConverting Datatypes with the CONVERT Functions\r\nPerforming Mathematical Operations with the Built-in Mathematical Functions\r\nPerforming Operations with String Functions\r\nRetrieving Special Server or Database Information with System Functions\r\nUsing Text and Image Functions\r\nSummary\r\nReview Questions\r\n\r\nChapter 6 Advanced Data Retrieval Techniques\r\n\r\nReturning Summary Values with Aggregate Functions\r\nCalculating an Average\r\nCounting Rows with the COUNT Aggregate Function\r\nCounting Rows With Nulls\r\nCounting All Rows with COUNT(*)\r\nFinding the Maximum Value with MAX\r\nFinding the Minimum Value with MIN\r\nAdding the Value of a Column with SUM\r\nUsing the GROUP BY Clause\r\nGrouping the Impact of the ALL Keyword on a GROUP BY Clause\r\nCounting Groups of Data\r\nAVG. and SUM with the GROUP BY Clause\r\nRestricting Rows with the HAVING Clause\r\nCoding a HAVING Clause\r\nIncluding Multiple Conditions in a HAVING Clause\r\nUsing the COMPUTE and COMPUTE BY Clauses\r\nComputing Totals with COMPUTE\r\nComputing Multiple Values for the Same Column\r\nAdding BY to a COMPUTE Clause\r\nUsing COMPUTE BY Multiple Times in the Same SELECT Statement\r\nJoining Tables\r\nANSI-Standard versus Old-Style Joins\r\nCreating a CROSS JOIN\r\nCreating an INNER JOIN\r\nCreating Outer Joins\r\nCreating a LEFT OUTER JOIN\r\nCreating a RIGHT OUTER JOIN\r\nCreating a RIGHT OUTER JOIN\r\nCreating a FULL OUTER JOIN\r\nUsing Self-Joins\r\nCreating Joins with MS Query\r\nUsing Subqueries\r\nTypes of Subqueries\r\nDefining Subquery Rules\r\nCreating Subqueries That Return a Single Value\r\nCreating Subqueries That Return Multiple Values\r\nAdding NOT IN to a Subquery\r\nTesting Existence with Subqueries\r\nWriting Correlated Subqueries\r\nCreating Derived Tables\r\nSummary\r\nReview Questions\r\n\r\nChapter 7 Creating Action Queries with Transact-SQL to Modify Data\r\n\r\nAdding Rows with the Insert Statement\r\nExploring the INSERT Statement Rules\r\nInserting Rows with Values\r\nInserting a Partial Row with a Column List\r\nAdding a Row with Defaults and Nulls\r\nUsing DEFAULT to Insert a Value for a Column a Row\r\nInserting Rows in a Table with an IDENTITY Column\r\nInserting Specific Values into an IDENTITY Column\r\nInserting Multiple Rows with a SELECT Statement\r\nInserting Rows with a SELECT Statement\r\nInserting Rows with a SELECT Clause\r\nCopying a Subset of Data\r\nCopying a Subset of Rows\r\nAdding Constants to the Copied Data\r\nCleaning UP\r\nModifying Data with the UPDATE Statement\r\nOverview of Direct and Deferred Updates\r\nWriting a Simple UPDATE Statement\r\nUpdating Select Rows\r\nUsing Arithmetic in Updates\r\nIncluding Subqueries in an UPDATE Statement\r\nProviding a Column Value with a Subquery\r\nTransact-SQL Extensions for the UPDATE Statement\r\nTransact-SQL UPDATE Extension Example\r\nCleaning Up after Inserting Data\r\nDeleting Rows of Data with the DELETE Statement\r\nDefining the Rules for the DELETE Statement\r\nDeleting All Rows from a Table\r\nDeleting Selected Rows\r\nDeleting Rows of Data Based on a Subquery\r\nDeleting Rows Based on the Value in a Subquery\r\nTransact-SQL Extensions for the DELETE Statement\r\nDeleting Data with Transact -SQL Extensions\r\nCleaning Up after Deleting Data\r\nImporting and Exporting\r\nUsing SQL Transfer Manager to Import and Export Data and Objects\r\nVerifying Permissions Needed to Transfer Data\r\nIdentifying the Transfer Manager Options\r\nTransferring the Authors Table with the Transfer Manager\r\nVerifying the Results of the Transfer Manager\r\nExamining the Files Created by the Transfer Manager\r\nTransferring Data with the Bulk Copy Program\r\nPermissions Requirements to Perform a Transfer with the Bulk Copy Program\r\nDefining BCP Rules\r\nDefining the BCP Mode Types\r\nSaving Your BCP Options in a Format File\r\nCopying a Table with the BCP Utility\r\nComparing the Transfer Manager and the Bulk Copy Program Review Questions\r\n\r\nChapter 8 Using Indexes\r\n\r\nAdvantages to Using Indexes\r\nDisadvantages to Using Indexes\r\nCreating Useful Indexes\r\nSelecting the Right Index\r\nGuidelines for Choosing Indexes\r\nGuidelines for Choosing What Not to Index\r\nSQL Server Index Types\r\nExamining Clustered Indexes\r\nExploring Nonclustered Indexes\r\nRefining Index Characteristics\r\nKeeping Up with Index Statistics\r\nManaging SQL Server Indexes\r\nDefining the CREATE INDEX Options\r\nApplying the FILLFACTOR and PAD_INDEX Options\r\nUsing the SORTED_DATA and SORTED_DATA_REORG Options\r\nRebuilding an Index\r\nExamining the DBCC DBREINDEX Syntax\r\nRebuilding a Specific Index\r\nRebuilding All Indexes in a Table\r\nDropping Indexes\r\nUnderstanding DROP INDEX Permissions\r\nDropping an Index\r\nMonitoring an Index's Performance and Use\r\nManaging Indexes with SQL Enterprise manager\r\nSummary\r\nReview Questions\r\n\r\nChapter 9 Designing and Using Views,Defaults ,and Rules\r\n\r\nAn Overview to a View\r\nCreating a View\r\nGuidelines for Creating Views\r\nThe CREATE VIEW Statement\r\nRecognizing the Benefits of Using Views\r\nSimplifying Queries\r\nFocusing on Data\r\nProviding Constant Data\r\nEnforcing Security\r\nExporting Data\r\nRecognizing a View's Limitations\r\nCreating Views\r\nSelecting Specific Columns\r\nSelecting Specific Rows\r\nJoining Tables to Create a View\r\nIncluding Aggregate Functions in Views\r\nCreating Views on Views\r\nModifying Data through Views\r\nInserting Rows through Views\r\nDeleting Rows through Views\r\nUpdating Rows through Views\r\nDropping Rows through Views\r\nDropping Views\r\nDefining the DROP VIEW Statement\r\nUnderstanding Rules and Defaults\r\nCreating Rules\r\nExamining the CREATE RULE Statement\r\nUnderstanding a Rule's Limitations\r\nCreating a Sample Rule\r\nCreating a Rule with the SQL Enterprise Manager\r\nCreating Defaults\r\nExamining the CREATE DEFAULT Statement\r\nDefining a Default's Limitations\r\nCreating a Sample Default\r\nCreating a Default with the SQL Enterprise manager\r\nBinding Rules\r\nSome Guidelines for Binding Rules\r\nExamining the sp_bindrule System Stored Procedure\r\nBinding a Rule\r\nUsing SQL Enterprise Manager to Bind a Rule\r\nUnbinding Rules\r\nExamining the sp_unbindrule System Stored Procedure\r\nAn Example of unbinding a Rule\r\nUsing SQL Enterprise Manager to Unbind a Rule\r\nDropping Rules\r\nUsing SQL Enterprise Manager to Unbind a Rule\r\nDropping Rules\r\nUsing SQL Enterprise Manager to Unbind a Rule\r\nDropping Rules \r\nUsing SQL Enterprise Manager to Drop a Rule\r\nBinding Defaults\r\nGuidelines for Binding Defaults\r\nExamining the sp_bindefault System Stored Procedure\r\nBinding a Default\r\nUsing SQL Enterprise Manager to Bind a Default\r\nUnbinding Default\r\nUsing SQL Enterprise Manager to Bind a Default\r\nUnbinding Defaults\r\nExamining the sp_unbindefault System Stored Procedure\r\nBinding a Default\r\nUsing SQL Enterprise manager to Bind a Default\r\nDropping Defaults Examining the DROP DEFAULT Statement\r\nUsing SQL Enterprise Manager to Drop a Default\r\nSummary\r\nReview Questions\r\n\r\nChapter 10 Programmability\r\n\r\nStatement Execution with Batches\r\nWorking with Variables\r\nDefining and Using Local Variables\r\nExamining the Syntax Required to Declare and Assign a Local Variable\r\nDeclaring and Assigning a Local Variable\r\nUsing Global Variables\r\nobtaining the Version of SQL Server with a Global Variable\r\nAdding Comments to Your Code\r\nUsing Control-of-Flow Statements\r\nCreating Statement Blocks with BEGIN and END\r\nUsing CASE Expressions\r\nInspecting the Syntax of the CASE Expression\r\nTesting a CASE Expression\r\nMoving to a Label with GOTO\r\nInvestigating the GOTO Syntax\r\nTransferring Execution with a GOTO Command\r\nControlling Program Execution with IF...ELSE\r\nIF...ELSE Guidelines\r\nExecuting Code Based on an IF...ELSE Statement Block\r\nStopping Execution with the RETURN Command\r\nExiting a Batch with the RETURN Statement\r\nTiming Execution with WAITFOR\r\nProcessing in the Future with WAITFOR\r\nCreating Loops with WHILE Blocks\r\nCreating a Loop with a WHILE Block\r\nWorking with Cursors\r\nExploring Cursor States\r\nDeclaring a Cursor\r\nGuidelines for Declaring Cursors\r\nOpening a Cursor\r\nCounting the Number of Rows in an Opened Cursor\r\nFetching Data for a Cursor\r\nGuidelines for the FETCH Statement\r\nKeeping Track of the FETCH Status\r\nClosing a Cursor\r\nDeallocating a Cursor\r\nDemonstrating Cursors\r\nDiscussing the Benefits of Using Stored Procedures\r\nAchieving Faster Execution\r\nProducing Modula Programming\r\nRealizing Enhanced Reliability\r\nEnforcing Consistency\r\nEnhancing Security\r\nDiscussing the Capabilities of SQL Server and MAPI\r\nUsing MAPI to Respond to Server Problems\r\nUnderstanding MAPI's Stored Procedures\r\nExamining the String and Variable Extensions to the EXECUTE Statement\r\nExecuting Procedures\r\nExamining the EXECUTE Statement Syntax for a Stored Procedure\r\nEXECUTE Procedure Guidelines\r\nExecuting a Stored Procedure\r\nReturning the Status of a Stored Procedure\r\nExecuting a Procedure with a Variable\r\nExecuting String Statements\r\nExamining the EXECUTE Statement Syntax for a Character String\r\nExecuting a Character String\r\nManaging User-Defined Error Messages\r\nProviding Feedback with the RAISERROR Statement\r\nDiscussing RAISERROR Specifics\r\nRaising a User-Defined Error\r\nSummary \r\nReview Questions\r\n\r\nChapter 11 Triggers\r\n\r\nUnderstanding How Triggers Work\r\nCreating Triggers\r\nExamining the Syntax of the CREATE TRIGGER Statement\r\nTrigger Guidelines\r\nIdentifying the Limitations of Triggers\r\nCreating an INSERT Trigger\r\nCreating an UPDATE Trigger\r\nCreating a Table Level UPDATE Trigger\r\nCreating a Column Level UPDATE Trigger\r\nCreating a DELETE Trigger\r\nDropping Triggers\r\nEnforcing Referential Integrity\r\nCreating Triggers to Enforce Referential Integrity\r\nEnforcing Data Integrity\r\nSummary\r\nReview Questions\r\n\r\nChapter 12 Replication\r\n\r\nExamining the Publisher/Subscriber Metaphor\r\nApplying Replication Appropriately\r\nApplying the Appropriate Replication Model\r\nCentral Publisher\r\nCentral Publisher with a Remote Distributor\r\nPublishing Subscriber\r\nMultiple Publishers of One Table\r\nDownloaded Data\r\nTracing the Log Reader Process\r\nExamining the Server's Role in Replication\r\nRecognizing the Role of the Publication Server\r\nManaging the Publications\r\nManaging Articles\r\nReplication Synchronization\r\nReplication Security\r\nExamining the Frequency of Replication\r\nRecognizing the Role of the Distribution Server\r\nRecognizing the Role of the Subscription Server\r\nIdentifying the Tables Used in Replication\r\nTracing the Replication Process\r\nThe Publisher\r\nThe Distributor\r\nThe Subscriber\r\nSummary\r\nReview Questions\r\n\r\nChapter 13 Application Development and Open Data Services\r\n\r\nDefining Open Architecture\r\nOpen Database Connectivity's Role in SQL Server\r\nCreating an ODBC Data Source\r\nUsing ODBC with Visual Basic and SQL Server\r\nData Access Objects\r\nRemote Data Objects\r\nActiveX Data Objects\r\nThe Benefits of Integrating OLE Architecture with SQL Server\r\nExposing Objects with SQL-Distributed Management Objects\r\nExamining the SQL-DMO Model\r\nUnderstanding Application Objects and Collections\r\nUsing SQL-DMO\r\nExtending SQL Server with DB-Library\r\nExtending SQL Server with Open Data Services\r\nIntroducing SQL Distributed Management Framework\r\nThe SQL-DMF Model\r\nSummary\r\nReview Questions\r\n\r\nAppendix A Review Questions and Answers
无封面