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]
macro study strategies 2nd maintaining indexes maintenance DBCC operations 2nd managing data manipulation with transactions 2nd 3rd transactions 2nd 3rd control of flow 2nd 3rd many-to-many relationship many-to-many relationships implementing Master database mathematical functions 2nd 3rd MAX() function 2nd MCDBA (Microsoft Certified Database Administrator) core exams elective exams requirements Windows 2000 track MCP (Microsoft Certified Professional MCP (Microsoft Certified Professional) MCP exams 2nd exam format adaptive-form 2nd 3rd 4th 5th case study form 2nd fixed-form 2nd question types drag-and-drop-style questions 2nd drop-and-connect questions hot area questions multiple-choice questions 2nd multiple-rating questions ordered list questions simulation questions 2nd 3rd 4th 5th tree questions 2nd MCP+Internet (Microsoft Certified Professional+Internet MCP+Site Building MCSD (Microsoft Certified Solution Developer) core exams elective exams requirements MCSE (Microsoft Certified Systems Engineer) core exams elective exams requirements Windows 2000 track MCSE+Internet (Microsoft Certified Systems Engineer+Internet) MCT (Microsoft Certfied Trainer) MCT (Microsoft Certified Trainer) documentation requirements website Merge agent 2nd 3rd merge replication 2nd 3rd how it works 2nd 3rd meta data functions 2nd 3rd 4th micro study strategies 2nd Microsoft Distributed Coordinator (MS DTC) Microsoft Management Console (MMC) Enterprise Manager Console (EMC) utility configuring 2nd Enterprise Manager utility registering servers 2nd Microsoft Public Newsgroups Microsoft Training and Certification website MIN() function 2nd minimal XML formatting extracting data 2nd Miscellaneous agents miscellaneous DBCC operations 2nd MMC (Microsoft Management Console) Enterprise Manager Console utility configuring 2nd Enterprise Manager utility registering servers 2nd Model database 2nd storing common objects and code modes of locks 2nd modifications triggers controlling 2nd modifying data SELECT 2nd 3rd data through views 2nd deleting rows 2nd 3rd 4th inserting rows 2nd 3rd 4th 5th updating rows 2nd 3rd 4th modifying. [See altering] modulo operator (%) money data type monitoring activities with SQL Profiler 2nd 3rd with templates 2nd with wizards 2nd MS DTC (Microsoft Distributed Coordinator) Msdb database MULTI_USER database configuration option multiple server implementations balancing the load partitioning 2nd replication 2nd multiple-choice questions MCP exams 2nd multiple-rating questions MCP exams
|