- Shopping Bag ( 0 items )
Other sellers (Paperback)
-
All (9) from $1.99
-
Used (9) from $1.99
Ships from: Mishawaka, IN
Usually ships in 1-2 business days
Ships from: Reno, NV
Usually ships in 1-2 business days
Ships from: Valley Cottage, NY
Usually ships in 1-2 business days
Ships from: Valley Cottage, NY
Usually ships in 1-2 business days
Ships from: Murphy, TX
Usually ships in 1-2 business days
Ships from: Fort Mill, SC
Usually ships in 1-2 business days
Ships from: Goring-By-Sea, United Kingdom
Usually ships in 1-2 business days
Ships from: Chatham, NJ
Usually ships in 1-2 business days
Ships from: Chatham, NJ
Usually ships in 1-2 business days
*Over 250 practice exam questions
*CD-ROM with exclusive test yourself exam software,detailed score analysis,timed live exams,and expert answers.
*Special exam watch warnings based on post-exam research
*Hands-on drills emphasizing skills likely to be on the exam
*Certification summaries that offer to-the-point review of important information Don't Let the Real Test Be Your First Test! Prepare to pass the MCDBA/MCSE SQL Server 7 Database Design exam - while gaining practical knowledge of Microsoft's relational database technology for on-the-job success. Built on the proven training methodology of Global Knowledge,this complete study guide and CD-ROM package offers actual classroom techniques used by more than 200,000 IT professionals each year. The MCDBA SQL Server 7 Database Design Study Guide covers the topics you need to review for the exam,including how to: Group data into entities by applying normalization rules. Choose the foreign key that will enforce a relationship between entities and will ensure referential integrity. Assess the potential impact of the logical design onperformance,maintaining,extensibility,scalability,availability,and security. Create and manage explicit,implicit,and distributed transactions to ensure data consistency and recoverability. Write INSERT,DELETE,UPDATE,and SELECT statements that retrieve and modify data. Create scripts using Transact-SQL. Programming elements include control-of-flow methods,local and global variables,functions,and error-handling methods. Create result sets that provide summary data.
Query types include TOP n PERCENT and GROUP BY,specifically HAVING,CUBE,and ROLLUP. Create and manage files,file groups,and transaction logs that define a database. Populate the database with data from an external data source.
| 1 | Microsoft SQL Server 7.0 Overview | 1 |
| 2 | Transact-SQL Overview | 37 |
| 3 | Creating and Managing Files and Databases | 75 |
| 4 | Developing a Logical Data Model | 125 |
| 5 | Planning and Creating Indexes | 163 |
| 6 | Queries | 197 |
| 7 | Summarizing Data | 243 |
| 8 | Managing Transactions and Locks | 279 |
| 9 | Implementing Views | 313 |
| 10 | Implementing Stored Procedures | 351 |
| 11 | Implementing Triggers | 377 |
| 12 | Working with Distributed and External Data | 401 |
| A: Self Test Answers | 441 | |
| B: About the CD | 481 | |
| C: About the Website | 487 | |
| D | SQL References (Electronic and Printed) | 489 |
| E | T-SQL Command Reference for Database Implementors | 495 |
| Glossary | 503 | |
| Index | 535 |
Overview