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]
LAST latency replication 2nd leaf pages learning styles 2nd LEFT OUTER JOIN statement 2nd 3rd 4th libraries managing Client Network utility LIKE filtering data 2nd 3rd 4th full-text searches limitations of SQL Server 2000 linked servers creating 2nd 3rd 4th 5th 6th 7th usage 2nd lists ordering data into 2nd Lloyd's hospital case study (logical database design) 2nd 3rd 4th LOCAL 2nd local partitioned views local scope variables 2nd lock contention reducing 2nd lock granularity 2nd lock information Current Activity window 2nd 3rd 4th Lock\ Acquired Cancel Deadlock Deadlock Chain Escalation Released Timeout locking deadlocks 2nd 3rd avoiding isolation levels 2nd lock contention reducing 2nd lock granularity 2nd tables locks compatibility matrix 2nd diagnosing with profile traces 2nd isolation levels 2nd modes of 2nd types of viewing behaviors with Enterprise Manager log files (databases) default names using multiple Log Reader agent 2nd 3rd logging and triggers logical database design 2nd client/server model 2nd 3rd Internet applications 2nd one- tier systems third-party database connectivity three-tier systems 2nd two-tier systems 2nd very large database applications data integrity 2nd data types 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th domain integrity 2nd 3rd 4th entity integrity 2nd 3rd 4th referential integrity 2nd 3rd denormalization 2nd 3rd ER Model 2nd 3rd attributes 2nd 3rd 4th 5th 6th 7th 8th entities 2nd 3rd 4th 5th entity keys 2nd 3rd 4th 5th 6th relationships 2nd 3rd 4th 5th 6th 7th 8th 9th Lloyd's hospital case study 2nd 3rd 4th normalization 2nd first normal form 2nd second normal form 2nd 3rd third normal form 2nd 3rd 4th software for logical operators 2nd 3rd logins adding looping structures loops WHILE 2nd
|