MCSE Database Design on SQL Server 7 : Exam Cram

by Garbus, Jeffrey

• ISBN13: 9781576102282
• ISBN10: 1576102289
• Format: Paperback
• Copyright: 1999-02-01
• Publisher: Coriolis Group

Summary

Learn how to implement, administer, and troubleshoot information systems that incorporate Microsoft SQL Server 7.0. The book includes sections on proven test-taking strategies, warning on trick questions, and time-saving study tips and shortcuts.

Author Biography

Jeffrey R. Garbus is a consultant and trainer who has been writing and speaking about SQL Server for almost 10 years. He has written 8 books to date, numerous articles, and spoken at many conferences. David F. Pascuzzi is an MCP who has been developing and maintaining database applications for 10 years. He has worked as a consultant, trainer, and course developer. Alvin T. Chang is an MCP for SQL Server. He is a technical trainer, author, and consultant currently specializing in Microsoft and Sybase System Administration.

Table of Contents

Introduction	p. xvii
Self-Assessment	p. xxxi
Microsoft Certification Exams	p. 1
Assessing Exam-Readiness	p. 2
The Exam Situation	p. 3
Exam Layout And Design	p. 4
Microsoft's Testing Formats	p. 5
Strategies For Different Testing Formats	p. 7
Exam-Taking Basics	p. 8
Question-Handling Strategies	p. 9
Mastering The Inner Game	p. 11
Additional Resources	p. 12
Data Models	p. 15
Overview	p. 16
Logical Phase	p. 17
Physical Model	p. 29
Practice Questions	p. 33
Need To Know More?	p. 36
System Databases, Tables, And Stored Procedures	p. 37
System Databases	p. 38
File Locations	p. 40
System Tables	p. 41
System Stored Procedures	p. 43
Practice Questions	p. 46
Need To Know More?	p. 48
Databases And Files	p. 49
Database Overview	p. 50
Creating Databases	p. 52
Altering Databases	p. 54
Configuring Databases	p. 58
Viewing Database Information	p. 60
Enterprise Manager	p. 61
Using Databases	p. 61
Practice Questions	p. 62
Need To Know More?	p. 65
Data Definition	p. 67
Creating Tables	p. 68
Unique Identifiers	p. 70
Constraints	p. 72
Computed Columns	p. 76
Altering Tables	p. 76
Temporary Tables	p. 79
Dropping Tables	p. 80
Practice Questions	p. 81
Need To Know More?	p. 84
Retrieving Data	p. 85
Parts Of The SELECT Statement	p. 86
The Select List	p. 87
The FROM Clause	p. 89
The WHERE Clause	p. 92
The GROUP BY Clause	p. 96
The HAVING Clause	p. 101
The ORDER BY Clause	p. 102
COMPUTE	p. 102
Functions	p. 103
Joining Tables	p. 113
UNION	p. 118
The TOP Clause	p. 119
Retrieving Text And Image Data	p. 120
Practice Questions	p. 122
Need To Know More?	p. 132
Modifying Table Data	p. 133
Insert	p. 134
Select Into	p. 140
Bulk Insert	p. 141
Update	p. 145
Working With TEXT And IMAGE Data Types	p. 147
Modifying Data With Views	p. 150
Practice Questions	p. 151
Need To Know More?	p. 155
Session Configuration	p. 157
SET Statement	p. 158
Viewing User-Configuration Options	p. 174
Default User-Configuration Options	p. 176
Practice Questions	p. 177
Need To Know More?	p. 181
Indexes	p. 183
Clustered And Nonclustered Indexes	p. 184
Creating Indexes	p. 187
Index Management	p. 189
Practice Questions	p. 191
Need To Know More?	p. 194
Rules, Defaults, And Views	p. 195
Rules	p. 196
Defaults	p. 198
Views	p. 201
Practice Questions	p. 209
Need To Know More?	p. 214
Transact-SQL Programming	p. 215
Batches	p. 216
Comments	p. 217
Variables	p. 217
T-SQL Statements	p. 218
Cursors	p. 227
Stored Procedures	p. 235
Practice Questions	p. 240
Need To Know More?	p. 243
Triggers	p. 245
Using Triggers	p. 246
Firing Triggers	p. 246
Creating Triggers	p. 248
Removing Triggers	p. 250
Modifying Triggers	p. 250
Deleted And Inserted Tables	p. 251
Triggers During Transactions	p. 259
Nested Triggers	p. 262
Examining Triggers	p. 263
Practice Questions	p. 265
Need To Know More?	p. 269
Transactions	p. 271
The Nature Of Transactions	p. 272
Transaction Control Statements	p. 273
Transaction Flow	p. 275
Transaction Limitations	p. 276
Distributed Transactions	p. 277
Transaction Log	p. 278
Locking In Transactions	p. 279
Practice Questions	p. 284
Need To Know More?	p. 287
Importing, Exporting, And Transforming Data	p. 289
BCP	p. 290
Data Transformation Service	p. 294
Practice Questions	p. 302
Need To Know More?	p. 305
Full-Text Search	p. 307
Searching For Text	p. 308
Preparing For A Full-Text Search	p. 308
Creating A Full-Text Index	p. 309
Full-Text Query	p. 313
Practice Questions	p. 317
Need To Know More?	p. 320
Monitoring	p. 321
Showplan	p. 322
Update Statistics	p. 325
Detecting And Resolving Locking Problems	p. 327
Dbcc showcontig	p. 330
SQL Server Profiler	p. 331
Practice Questions	p. 332
Need To Know More?	p. 335
Remote Data Access	p. 337
Remote Procedure Call	p. 338
Distributed Queries	p. 340
Distributed Transactions	p. 344
Practice Questions	p. 348
Need To Know More?	p. 352
Sample Test	p. 353
Questions, Questions, Questions	p. 354
Picking Proper Answers	p. 354
Decoding Ambiguity	p. 355
Working Within The Framework	p. 356
Deciding What To Memorize	p. 357
Preparing For The Test	p. 358
Taking The Test	p. 358
Sample Test	p. 359
Answer Key	p. 383
Pubs Database	p. 393
Functions	p. 401
Transact-SQL Syntax	p. 413
Glossary	p. 433
Index	p. 451
Table of Contents provided by Syndetics. All Rights Reserved.