SQL SERVER 7 DATABASE DESIGN 学习指南 (2008 年度畅销榜NO.54599 )

当前计算机系统的开发、管理、使用及维护需要大量不同层次的专业技术人员，评价各种技术人员的水平是一件既复杂又必不可少的工作。为考查、评测有关人员对微软件操作系统、软件和网络的理解和熟练使用程序，Microsoft 公司设计了如下 几种认证方案：\r\n Microsoft Certified Professional——MCP ,微软认证专业人员\r\n Microsoft Certified Solution Developer——MCSD，微软认证软件开发专家\r\n Microsoft Certified System Engineer——MCSE，微软认主系统工程师\r\n Microsoft Certified Trainer ——MCT，微软认证培训员\r\n 为帮助国内的技术人员学好、用好微软的产品，顺利通过有关的考试，我们分别以翻译和英文原版重印的形式推出了“MCSE学习指南系列”（中文译本）、“MCSE考试指南系列”（英文原版）和“MCSD学习指南系列”（英文原版）三种系列书。

Intoroduction\r\n\r\nChapter 1 An 1ntroduction to SQL Server 7\r\n\r\nSQL Server 7 Is New and Improved\r\nSQL Enterprise Manager\r\nTransact-SQL\r\nSQL--DMO \r\nSQL Server Wizards\r\nSQL Server Capacities \r\nTools and Utilities Included in SQL Server 7\r\nQuery Analyzer \r\nWorking with Queries\r\nViewing the Execution Plan\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 guestions\r\n\r\nChapter 2 Data Modeling\r\n\r\nThe Relational Model\r\nThe Client/Server Model\r\nFile-Server vsDistributed 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 and Foreign Keys\r\nColumn Restrictions\r\nUnderstanding NULL and NOT NULL\r\nDisallowing Duplicates\r\nAdding Defaults\r\nProhibiting Changes\r\nImproving the ER Model fOr the Downtown Delivery Servlce \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\nThird Normal Form\r\nBenefits of Normalization\r\nDrawbacks of Normalization\r\nSummary\r\nReview guestions\r\n\r\nChapter 3 System Databases and Tables \r\n\r\nExamlning the System Databases\r\nIdentifytng the Role of the Model Database\r\nIdentifylng the Role of the Msdb Database\r\nIdentifying the Role of the Tempdb Database\r\nDiscussing System Tables\r\nSystem Catalog\r\nThe Database Catalog\r\nguetying System Tables\r\nAccessing the System with System Stored Procedures\r\nCatalog Stored Procedures\r\nExtended Stored Procedures\r\nReplication Stored Procedures\r\nSystem Stored Procedures\r\nExecuting Stored Procedures\r\nsp--help [objectnamel \r\nsp--helpdb [dbnamel\r\nsp--Who \r\nConfigurlng SQL Server\r\nSummary\r\nReview guestions\r\n\r\nChapter 4 Data Definition\r\n\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 with 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\r\nManager\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 DATAASE\r\nShrinking a Database\r\nUsing SQL EnterPrise Manager to Shrink a Database\r\nShrinking a Database with DBCC\r\nUsing DBCC SHRINKDATABASE to Shrink the DowntownDB\r\nDatabase\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 7 Data Whes\r\nSystem--Supplied Data bees\r\nUser--Defined Data bees\r\nManaging Tables in SQL Server 7\r\nCreating a Tab1e with SQL EnterPrise Manager\r\nT Jsing the CREATE TABLE Statement to Create a Table \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\nUnderstanding Data Integrity\r\nIdentifying the Whes of Data Integrity\r\nEnfOrcing Data Iritegrity with the IDENTITY Property\r\nIdentifying Guidelines Associated with the IDENTITY\r\nProperty\r\nCreating an Identity Column\r\nCreating a Table with an ldentity Column\r\nAdding a Column with the IDENTITY Property to an Existing\r\nTable \r\nUsing Uniqueidentifier and NEWID to Generate Unique Values \r\nUsing Constraints to Enforce Data Integrity\r\nManaging Constraints with the SQL EnterPrise Manager\r\nManaging Constraints with the CREATE TABKE and ALTER\r\nTABLK StotementH\r\nCreating a PRIMARY KEY Constraint\r\nCreating a FOREIGN KEY Constraint\r\nCreating a UNIgUE Constraint \r\nCreating a CHECK Constraint \r\nCreating a DEFAULT Constraint\r\nSummary\r\nReview guestions\r\n\r\nChapter 5 Data Retrieval \r\n\r\nA Refresher Course in SQL\r\nCoding an SQL SELECT Statement\r\nUsing Character Strings and guotes\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 SQLs Built--In Functions to Format Output Data\r\nConverting Data twes with the CONVERT Function\r\nManipulating Datetime Values with Date Functions\r\nPerforming Mathematical Operations with the built--In\r\nMathematlcal Functions\r\nPerfOrming Operations with String Functions\r\nRetrieving Special Server or Database Information with\r\nSystem Functions\r\nUsing Text and Image Functions\r\nSummary\r\nReview guestions\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 Data with the GROUP BY Clause \r\nExamining the Impact of the ALL KeyWord on a GROUP BY\r\nClause \r\nCounting Groups of Data\r\nAVG and SUM with the GROUP BY Clause\r\nRestricting Rows with the HAVING Clause\r\nCoding a HAWNG Clause \r\nIncluding Multiple Coriditions 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 the COMPUTE BY Multiple Times in the Same SELECT\r\nStatement\r\nReturning TOP n Queries\r\nUsing CUBE and ROLLUP\r\nJoining Tables \r\nANSI--Standard vsOld--Style Joins\r\nCreating a CROSS JOIN \r\nCreating an INNER JOIN \r\nCreating OUTER JOINs \r\nCreating a LErv OUTER JOIN\r\nCreatin\r\nCreating a RIGHT OUTER JOIN \r\nCreating a FULL OUTER JOIN\r\nUsing Self Joins \r\nUsing Subqueries \r\nbees 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\nDistributed Queries\r\nAd Hoc Queries \r\nSetting Up and Using a Linked Server\r\nSummary -\r\nReview guestions -\r\n\r\nChapter 7 Creating Action Queries with Transact-SQL to Modify Data\r\n\r\nAdding Rows with the INSERT Statement\r\nINSERT Statement Syntax \r\nEXPlorlng 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\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 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\nUnderstanding the Rules for the UPDATE Statement\r\nUpdating Rows\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\nDELETE Statement Syntax\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 Data Transformation Services to Transfer Data and\r\nObjects \r\nCreating a DTS Package\r\nTfansferring the Authors Table with DTS \r\nVerifying the Results of the Transfer\r\nTransferring Data with the Bulk Copy Program\r\nPermissions Requirements to Perform a Transfer with the\r\nBulk Copy Program"\r\nDefining BCP Syntax and Parameters\r\nUnderstanding Some BCP Rules\r\nDefining the BCP Mode bees \r\nSaving Your BCP Options in a Format File\r\nCopying a Table with the BCP Utility\r\nComparing Data TransfOrmation Services and the Bulk Copy\r\nProgram\r\nSummary\r\nReview guestions\r\n\r\nChapter 8 Uslng 1ndexes \r\n\r\nAdvantages to Using Indexes\r\nDisadvantages to Using Indexes\r\nCreating Useful Indexes\r\nSelectlng the Right Index\r\nGuldellnes for Choosing What to Index\r\nGuidellnes for Choosing What Not to Index\r\nSQL Server Index bees \r\nExamining Clustered Indexes\r\nExPlorlng 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\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 Indexs PerfOrmance and Use \r\nFull--Text Searches\r\nSearch Service Objects\r\nCreating Full-Text Indexes\r\nDeactivating Full-Text Indexes\r\nCreating a Full-Text Index\r\nUsing Full-Text Queries\r\nSummary \r\nReview guestions \r\n\r\nChapter 9 Designing and Using Views \r\n\r\nAn Overview of 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 Views Limitations\r\nCreating Views \r\nSelecting Specific Columns\r\nSelecting Specific Rows\r\nJoining Tables to Create a View\r\nIncluding Aggregate Furictions in Views\r\nCreating Views ofl Views\r\nModifying Data through Views\r\nInserting Rows through Views\r\nDeleting Rows through Views\r\nUpdatirig Rows through Views\r\nDropping Views\r\nDefining the DROP VIEW Statement\r\nSummary\r\nReview guestions\r\n\r\nChaPter 1O Programmability\r\n\r\nUsing Batehes \r\nWorking with Variables\r\nDefining and Using Local Variables\r\nExamining the Syntax Required to Declare and Assign a\r\nLocal 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\nUslng Coritrol-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 Sy11tax\r\nTransferring ExecutioIl with a GOTO Command \r\nControlling PrograIn Execution with IFELSE\r\nIFELSE Guidelines\r\nExecutillg Code Based on an lFELSE Statement Block \r\nTiming Execlltion with WAITFOR\r\nProcessing in the Future with WAITFOR\r\nCreating Loops with WHILE Blocks\r\nUsing the WHILE I3lock to Create a Loop\r\nWorking with C1Jrsors\r\nExploring Cursor States\r\nDeclaring a Cursor\r\nGuidelines for Declaring Cllrsors\r\nOpening a Cursor \r\nCounting the Number of Rows in an Operied Cursor\r\nFetching Data from a Cursor \r\nGuidelines for the FETCH Statement\r\nKeepirig Track of the FETCH Status \r\nClosing a Cursor \r\nDeallocating a Cursor\r\nDemonstrating Cursors\r\nThe Benefits of Usirig Stored Procedures\r\nExamining the String and Variable Extensions to the\r\nEXECUTE Statement\r\nExecuting Procedures\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\nExecuting a Character String \r\nUsing Input and Output Parameters\r\nManaging User-Defined Error Messages\r\nProviding Feedback with the RAISERROR Statement\r\nRAISERROR Specifics\r\nRaising a User--Defined Error\r\nStopping Execution with the RETURN Command \r\nExiting a Batch with the RETURN Statement\r\nRecompiling Stored Procedures\r\nUsing Transactions \r\nDefining the Transaction Isolation Level\r\nDesigning Transactions of APpropriate Length\r\nAvoiding or Handling Deadlocks \r\nUsing ..trancount to Implement Error Handling\r\nSummary\r\nReview guestions\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 guestions\r\npeter 12 Malntaining a Database\r\nUsing the DataBase Consistency Checker\r\nOptimizing Execution Plan Performance\r\nQuery Execution Plans\r\nSQL Server Locks \r\nUsing SQL Server Profiler\r\nSummary\r\nReview guestions\r\n7 Review guestions\r\nf Wendis A Revlew 9uestions and Answers\r\n\r\nChapter l \r\nChapter 2 \r\nChapter 3\r\nChapter 4 \r\nChapter 5 \r\nChapter 6 \r\nChapter 7 \r\nChapter 8 \r\nChapter 9 \r\nChapter 1O\r\nChapter l1\r\nChapter l2