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]
editing views 2nd 3rd 4th editing. [See also altering] elements (XML) ELSE statements 2nd EMC (Enterprise Manager Console) utility configuring 2nd enabling replication 2nd encryption 2nd 3rd ENCRYPTION 2nd encryption END statement blocks 2nd 3rd END keyword in CASE expressions enforcing procedural business functions with user -defined functions 2nd procedural business logic with stored procedures 2nd 3rd 4th 5th referential and data integrity triggers 2nd 3rd 4th 5th enhancing views aggregates 2nd joins 2nd 3rd with views 2nd Enterprise Managaer user-defined functions creating 2nd 3rd 4th Enterprise Manager alerts 2nd triggering altering database properties configuring publishing and distribution mechanisms 2nd 3rd 4th creating databases creating linked servers 2nd 3rd 4th 5th creating views by selecting columns 2nd 3rd demographics initializing indexes creating 2nd jobs descriptions lock behavior viewing publications setting up 2nd 3rd 4th 5th 6th 7th stored procedures creating 2nd 3rd 4th subscriptions pulling 2nd 3rd 4th triggers altering 2nd viewing 2nd UPDATE trigger creating 2nd 3rd 4th viewing SQL Server debugging information Enterprise Manager Console (EMC) utility configuring 2nd Enterprise Manager utility 2nd 3rd registering servers 2nd entities 2nd 3rd 4th 5th associate entities attributes. [See attributes] naming conventions 2nd entity integrity 2nd 3rd 4th 5th entity keys 2nd Foreign Keys Primary Keys 2nd 3rd entity-relationship diagrams (ERDs) Entity-Relationship Model. [See ER Model] ER (Entity-Relationship) Model 2nd 3rd attributes 2nd 3rd 4th decomposing 2nd naming conventions 2nd entities 2nd 3rd 4th 5th entity keys 2nd Foreign Keys Primary Keys 2nd 3rd relationships 2nd 3rd implementing 2nd 3rd many-to-many one-to-many one-to-one ER modeling 2nd ERDs (entity-relationship diagrams) error handling stored procedures 2nd 3rd 4th 5th 6th user-defined functions 2nd 3rd 4th error logs 2nd 3rd error number error severity errors raising 2nd system error messages 2nd user error messages 2nd user-defined errors raising ERWIN databse design software event classes Event Viewer optimizing OS configurations 2nd 3rd exam format MCP exams adaptive-form 2nd 3rd 4th 5th case study form 2nd fixed-form 2nd exam prep tips 2nd 3rd MCP exam 2nd exam simulation exam-taking tips 2nd adaptive exams 2nd case study exams fixed-form exams 2nd Examination Score Report test scores Examination Score Report (PrepLogic practice tests) exams practice customized displaying scores installing modes preconfigured reviewing the exam timed uninstalling retake policy 2nd scheduling exclusive locks EXEC statement stored procedures 2nd 3rd 4th executing full-text searches 2nd with FREETEXT execution plans Query Analyzer 2nd 3rd caching and sharing 2nd hints 2nd 3rd reading 2nd 3rd EXISTS() function EXPLICIT option (FOR XML operator) 2nd 3rd 4th explicitly creating XML formatting extracting data 2nd 3rd 4th exporting/importing data 2nd with BCP 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th with BULK INSERT statement 2nd 3rd with DTS (Data Transformation Services) 2nd 3rd 4th 5th 6th 7th 8th 9th 10th eXtensible Markup Languages. [See XML] extensions to cursors Transact-SQL 2nd 3rd extensions (files) extents extracting data in XML format 2nd automatic formatting 2nd 3rd explicitly creating formatting 2nd 3rd 4th minimal formatting 2nd
|