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]
OBJECT ID OBJECT NAME object permissions 2nd 3rd 4th 5th 6th objectives altering database objects to support partitioned views client/server configuration controlling data access with views data filtering with T-SQL modifying and querying 2nd 3rd summarizing data manipulation managing managing through views database objects, creating and altering 2nd 3rd 4th databases, creating and altering 2nd designing a computing environment 2nd domain integrity design enforcing procedural business logic using transactions 2nd entity definition entity key design environment restrictions 2nd extracting data in XML format filtering data grouping data heterogeneous data manipulation importing and exporting data importing data with OPENXML indexing 2nd 3rd creating indexes implementing strategies indexed views maintaining monitoring and tuning SQL Server databases 2nd 3rd 4th normalization of databases objects securing optimizing SQL Server configurations OS configurations optimizing programming environment and coding language 2nd programming objects troubleshooting programming SQL Server 2000 2nd query executions replication methodologies 2nd result sets managing with cursors and Transact -SQL retrieving data SQL Profiler monitoring activity SQL Server features and characteristics 2nd stored procedures 2nd 3rd 4th enforcing procedural business logic error handling filtering data managing data manipulation passing and returning parameters summarizing data tools, utilities, SQL interface, and procedures 2nd traces playback and diagnosis triggers 2nd 3rd 4th 5th managing data manipulation security troubleshooting troubleshooting failed object creating troubleshooting SQL Server objects user -defined functions 2nd 3rd 4th data manipulation error handling filtering data passing and returing parameters procedural business logic View objectives 2nd 3rd 4th views creating OBJECTPROPERTY objects database 2nd 3rd creating and altering tables 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th placement in filegroups 2nd 3rd 4th securing C2 security security audits 2nd statement and object permissions 2nd 3rd system hiding troubleshooting ODBC Structured Query Language (OSQL) executing T-SQL programs 2nd 3rd scheduling OFFLINE database configuration option OLE-DB providers 2nd OLTP (online transaction processing) ON DELETE clause ON UPDATE clause one- tier systems one-to-many relationship one-to-many relationships one-to-one relationship one-to-one relationships ONLINE database configuration option online transaction processing (OLTP) OPEN OPEN statement opening Query Analzyer OPENQUERY OPENQUERY function OPENROWSET 2nd OPENROWSET function 2nd 3rd 4th creating linked servers 2nd 3rd 4th 5th 6th 7th linked server usage 2nd OPENXML function 2nd 3rd preparing XML documents 2nd usage 2nd 3rd 4th 5th 6th operating system service properties, database recoverability 2nd 3rd operators 2nd 3rd bitwise operators 2nd filtering data 2nd arithmetic operators 2nd BETWEEN 2nd 3rd comparison operators 2nd 3rd 4th 5th IN 2nd 3rd logical operators 2nd 3rd unary operators 2nd OPTIMISTIC 2nd optimizing OS configurations 2nd application log 2nd counter values 2nd 3rd 4th Event Viewer 2nd 3rd query governor cost limit 2nd System Monitor 2nd 3rd 4th performance using views SQL Server configurations Current Activity window. [See Current Activity window] stored procedures. [See stored procedures] options data integrity options options. [See parameters] OR ORDER data retrieval 2nd 3rd order of triggers first and last 2nd recursive triggers type order 2nd ORDER BY order of operations filtering data ordered list questions MCP exams ordering data into lists 2nd null values OS configurations optimizing 2nd application log 2nd counter values 2nd 3rd 4th Event Viewer 2nd 3rd query governor cost limit 2nd with System Monitor 2nd 3rd 4th OSQL (ODBC Structured Query Language) executing T-SQL programs 2nd 3rd scheduling OSQL utility outer joins 2nd filtering out NULL values 2nd types of 2nd 3rd 4th ownership chains broken ownership chains 2nd 3rd 4th 5th views 2nd 3rd
|