The Fast Track series already covers the four core exams and two of the most popular electives, passing all of which earn the candidate MCSE status. SQL Server 7 Database Design adds to the growing list of popular MCSE electives offered in Fast Track format. This book also expands coverage of MCSD exams under Microsoft's new revision of the MCSD track. Each book has two parts: Part I gets you ready for the test FAST, covering just what you need to know to pass the test. Part II takes you through the test and into real-world use of the technology, with chapters on: Fast Facts Review Section: Digest of each chapter-ending 'What's Important-to-Know' section from Part I; Hotlists of Exam-Critical Concepts; Sample Test Questions: One question per key point made in the book; Insider's Spin: What Microsoft doesn't necessarily want you to know; Did You Know?: Invaluable real-world applications for the technology covered in the exam, taken from the author's training and consulting files.
Sprache
Verlagsort
Verlagsgruppe
Zielgruppe
Für höhere Schule und Studium
Maße
Höhe: 228 mm
Breite: 152 mm
Dicke: 23 mm
Gewicht
ISBN-13
978-0-7357-0040-6 (9780735700406)
Copyright in bibliographic data is held by Nielsen Book Services Limited or its licensors: all rights reserved.
Schweitzer Klassifikation
I. WHAT'S IMPORTANT TO KNOW ABOUT EXAM 70-029.
1. Developing a Logical Data Model.
Database Elements. Normalization Rules for Entity Definition. First Normal Form. Second Normal Form. Third Normal Form. Fourth and Fifth Normal Forms. Identification of Primary Keys. Foreign Key Selection and Referential Integrity. Business Rules and Data Integrity. Modeling Rules and Constraints. Denormalization. What Is Important to Know.
2. Deriving the Physical Design.
Performance. Maintainability. Extensibility. Scalability. Availability. Security. Physical Database Design. What Is Important to Know.
3. Creating Data Services.
The Syntax of Design. Dynamic SQL Model. Stored Procedures Model. Transact-SQL Cursors. Cursor Types. Cursor Selection. Resultset Size. Data Volatility. Cursor Features. Performance. Response. Sensitivity to Change. Cursor Navigation. Cursor Scope. Transaction Management. Explicit Transactions. Implicit Transactions. Distributed Transactions. Data Consistency. Atomicity. Consistency. Transaction Isolation. Service Durability. Recoverability. Automatic Database Recovery. Backup/Restore. Standby Servers. Checkpointing. Isolation. Share Locks. Update and Exclusive Locks. Intent Locks. Schema Locks. Implementing Locking. Lock Manager. Locking Configuration. Transaction Isolation. Read Committed. Read Uncommitted. Repeatable Read. Serializable. Using Isolation. Transaction Control. Bound Connections. Deadlocks. Avoiding Deadlocks. Locking. Optimistic Locking. Pessimistic Locking. @@trancount. SQL Standard Syntax. INSERT. DELETE. UPDATE. SELECT. Joins and Subqueries. Transact-SQL Scripts. Views. Stored Procedures. Triggers. Summarizing Data. Session Level Configuration. Accessing Data. CONTAINSTABLE. FREETEXTTABLE. Putting It All Together. Example: Conditional Error Check. Example: Referential Integrity. What Is Important to Know.
4. Creating a Physical Database.
Maintaining the Physical Implementation. File Management. Creating Database Files. Creating Filegroups. Managing Database Files. Managing Log Files. Maintaining Integrity. Data and Referential Integrity. Data Type Selection. User-Defined Data Types. NULL and NOT NULL. Generated Values. Constraint Implementation. Index Maintenance. Database Population. Full-Text Implementation. What Is Important to Know.
5. Maintaining a Database.
Optimizing and Tuning SQL Server Implementations. Execution Plans. Evaluation of Execution Plans. Optimizing Performance. Query Execution Plans. Evaluation of Query Plans. Optimizing Performance. Locking Problems. Locking Diagnosis. Resolving Locking Problems. SQL Server Profiler. Identifying Events Using Profiler. Putting It All Together. What Is Important to Know. Objective Review Notes.
II. INSIDE EXAM 70-029.
6. Fast Facts Review.
What to Study. Developing a Logical Data Model. Deriving the Physical Design. Creating Data Services. Creating a Physical Database. Maintaining a Database.
7. Insider's Spin on Exam 70-029.
Get into Microsoft's Mind-Set. Understand the Exam's Time Frame. Get Used to Answering Questions Quickly. Taking the Test. Where the Questions Come From. Different Flavors of Questions.
8. Hotlist of Exam-Critical Concepts.
9. Sample Test Questions.
Questions. Answers and Explanations.
10. Did You Know?
Index.
