MCSE Training Guide (70-229). Designing and Implementing Databases with MicrosoftR SQL ServerT 2000 Enterprise Edition
| [SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X]
data adding through views 2nd 3rd altering constraining modifications constraints 2nd defaults rules stored procedures 2nd views controlling access to granting permissions and ownership chains 2nd 3rd deleting 2nd 3rd displaying with SELECT 2nd filtering 2nd 3rd BETWEEN IN LIKE 2nd 3rd 4th operators. [See operators] returning TOP rows 2nd 3rd selecting rows based on null values 2nd with stored procedures 2nd 3rd formatting 2nd CAST 2nd 3rd 4th CONVERT 2nd 3rd 4th inserting with SELECT inserting into tables 2nd 3rd INSERT EXECUTE 2nd INSERT INTO SELECT 2nd SELECT INTO 2nd modifying SELECT 2nd 3rd ordering into lists 2nd summarizing 2nd character functions. [See character functions] date functions. [See date functions] mathematical functions 2nd 3rd system functions. [See system functions] updating 2nd 3rd updating with cursors user -defined functions filtering 2nd 3rd 4th data cache Data Columns tab data dictionaries 2nd data encryption 2nd 3rd data extraction. [See extracting data] data filtering. [See filtering data] data grouping. [See grouping data] data import/export. [See importing/exporting data] data integrity 2nd 3rd data types 2nd 3rd binary data types 2nd character data types 2nd numeric data types 2nd 3rd specialty data types 2nd 3rd user-defined data types 2nd domain integrity 2nd 3rd 4th entity integrity 2nd 3rd 4th referential integrity 2nd 3rd triggers enforcing 2nd 3rd 4th 5th data integrity options data management aggregate functions 2nd 3rd data manipulation managing with transactions 2nd 3rd data model filtering data 2nd 3rd data retrieval FROM 2nd 3rd 4th ORDER 2nd 3rd SELECT 2nd SELECT statement 2nd 3rd 4th 5th arguments changing column headers 2nd 3rd DISTINCT 2nd 3rd string concatenation 2nd T-SQL WHERE 2nd data storage extents indexing 2nd 3rd data summaries. [See summarizing data] Data Transformation Services (DTS) 2nd 3rd 4th 5th 6th 7th 8th 9th 10th Data Transformation Services Import/Export wizard data types 2nd 3rd 4th 5th 6th bigint binary data types 2nd character data types 2nd new numeric data types 2nd 3rd specialty data types 2nd 3rd sql variant table user-defined data types 2nd database creating using the Model database as a template Database Console Command. [See DBCC] database design domain integrity entity integrity ER modeling 2nd foreign keys logical database design. [See logical database design] many-to-many relationship one-to-many relationship one-to-one relationship primary keys referential integrity 2nd SQL Server data types 2nd 3rd UNION operators 2nd database diagrams database engine features Database Maintenance Plan Wizard database objects altering creating and altering tables CHECK constraints 2nd 3rd 4th column descriptors 2nd 3rd creating 2nd indexes 2nd database roles DATABASEPROPERTY DATABASEPROPERTYEX databases altering 2nd configuration settings ANSI_NULL_DEFAULT ANSI_NULLS ANSI_PADDING ANSI_WARNINGS ARITHABORT AUTO_CLOSE AUTO_CREATE_STATISTICS AUTO_SHRINK AUTO_UPDATE_STATISTICS BULK_LOGGED CONCAT_NULL_YIELDS_NULL CURSOR_CLOSE_ON_COMMIT CURSOR_DEFAULT LOCAL MULTI_USER NUMERIC_ROUNDABORT OFFLINE ONLINE QUOTED_IDENTIFIER READ_ONLY READ_WRITE RECOVERY FULL RECURSIVE_TRIGGERS RESTRICTED_USER setting 2nd SIMPLE SINGLE_USER TORN_PAGE_DETECTION WITH creating 2nd 3rd 4th 5th 6th 7th Create Database wizard Enterprise Manager non-default collation sequences T-SQL code database diagrams database roles default defined 2nd fields filegroups backup and restore considerations 2nd creating placement in physical design 2nd 3rd 4th 5th 6th 7th placement of objects 2nd 3rd 4th files creating extensions log files primary files integrity options 2nd 3rd 4th management Enterprise Manager utility Master Model 2nd storing common objects and code Msdb Northwind objects 2nd 3rd physical design file placement 2nd 3rd 4th 5th 6th 7th recoverability 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th space requirements 2nd 3rd 4th 5th system maintenance populating Bulk Copy program properties altering records relational tables Tempdb DATALENGTH 2nd DATALENGTH() function datatypes date functions 2nd 3rd DATEADD 2nd 3rd DATEDIFF 2nd DATENAME 2nd DATEPART 2nd GETDATE 2nd DATEADD function 2nd 3rd DATEDIFF function 2nd DATENAME function 2nd DATEPART function 2nd datetime data type DB ID DB NAME DB-Library future implementation upgrading DBCC maintenance operations 2nd miscellaneous operations 2nd status operations 2nd validation operations 2nd DBCC (Database Console Command) DBCC CHECKALLOC DBCC CHECKCATALOG DBCC CHECKCONSTRAINTS DBCC CHECKDB 2nd 3rd DBCC CHECKFILEGROUP DBCC CHECKIDENT DBCC CHECKTABLE DBCC DBREINDEX 2nd DBCC DBREINDEX statement DBCC DBREPAIR DBCC dllname (FREE) DBCC HELP DBCC INDEXDEFRAG 2nd DBCC INDEXDEFRAG command DBCC INPUTBUFFER DBCC NEWALLOC DBCC OPENTRAN 2nd DBCC OUTPUTBUFFER DBCC PINTABLE DBCC PROCCACHE DBCC ROWLOCK DBCC SHOW STATISTICS DBCC SHOW STATISTICS command DBCC SHOWCONTING DBCC SHRINKDATABASE DBCC SHRINKFILE DBCC SQLPERF DBCC statement parameters SHRINKDATABASE SHRINKFILE DBCC TRACEOFF DBCC TRACEON DBCC TRACESTATUS DBCC UNPINTABLE DBCC UPDATEUSAGE DBCC USEROPTIONS deadlocks 2nd 3rd avoiding DEALLOCATE debugging information viewing with Enterprise Manager DECLARE CURSOR DECLARE CURSOR STATEMENT declaring variables 2nd decomposing attributes 2nd default databases defaults 2nd 3rd data modification constraining definable events DELCARE CURSOR DELETE statement DELETE statements DELETE triggers deleting data 2nd 3rd rows through views 2nd 3rd 4th deleting. [See also dropping] demographics Enterprise Manager initializing denormalization 2nd 3rd 4th derived tables 2nd 3rd descriptions jobs Enterprise Manager design physical designing transactions 2nd designing databases. [See database design] determinism deterministic functions 2nd 3rd DeZign database design software diagnosing locking with profile traces 2nd diagrams direct recursion 2nd 3rd 4th directives XML column aliases 2nd disabling nested triggers transaction logging disadvantages of indexing displaying data with SELECT 2nd DISTINCT data retrieval 2nd 3rd DISTINCT keyword in aggregate functions distributed partitioned views Distribution agent 2nd Distributor distriution servers configuring 2nd 3rd 4th documentation Books Online 2nd 3rd Accessing and Changing Relational Data book Administering SQL Server book Analysis Services book Building SQL Server Applications book Contents tab Creating and Maintaining Databases book Creating and Using Data Warehouses book Data Transformation Services book English Query book Getting Started book Glossary How-To book Index tab Installing SQL Server book Meta Data Services book Optimizing Database Performance book Replication book Search tab Transact -SQL reference Troubleshooting book Using SQL Server Tool book What's New? book XML and Internet Support book domain integrity 2nd 3rd 4th 5th double dash ( ‘) drag-and-drop-style questions MCP exams 2nd DROP FUNCTION DROP INDEX statements DROP PROCEDURE statement DROP TRIGGER statement DROP VIEW command drop-and-connect questions MCP exams dropping indexes 2nd used by constraints stored procedures 2nd triggers 2nd 3rd user-defined functions views 2nd 3rd DTS (Data Transformation Services) 2nd 3rd 4th 5th 6th 7th 8th 9th 10th Durability DYNAMIC 2nd
|