MCSE database design on SQL Server 7 exam cram by Jeffrey Garbus, David Pascuzzi, Alvin Chang

By:

Garbus, Jeffrey

Contributor(s):

Material type: Text

TextPublication details: Scottsdale, Ariz. Coriolis c1999Description: xxxix, 464 p. 23cmISBN:

1576102289

Subject(s):

DDC classification:

005.7585

Holdings
Item type	Current library	Call number	Status	Date due	Barcode
Standard Loan	Moylish Library Main Collection	005.7585 GAR (Browse shelf(Opens below))	Available		39002000178328

Enhanced descriptions from Syndetics:

A test preparation guide for the Microsoft's Designing and Implementing a Database with SQL Server 7.0 certification exam 70-029. Individual chapters cover data definition, retrieving data, modifying table data, session configuration, triggers, transactions, the data transaction service, and monitor

Table of contents provided by Syndetics

Introduction (p. xvii)
Self-Assessment (p. xxxi)
Chapter 1 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)
Chapter 2 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)
Chapter 3 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)
Chapter 4 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)
Chapter 5 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)
Chapter 6 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)
Chapter 7 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)
Chapter 8 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)
Chapter 9 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)
Chapter 10 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)
Chapter 11 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)
Chapter 12 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)
Chapter 13 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)
Chapter 14 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)
Chapter 15 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)
Chapter 16 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)
Chapter 17 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)
Chapter 18 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)
Chapter 19 Answer Key (p. 383)
Appendix A Pubs Database (p. 393)
Appendix B Functions (p. 401)
Appendix C Transact-SQL Syntax (p. 413)
Glossary (p. 433)
Index (p. 451)

Author notes provided by Syndetics

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.