MCSE Training Guide (70-229). Designing and Implementing Databases with MicrosoftR SQL ServerT 2000 Enterprise Edition
MCSE Training Guide (70-229). Designing and Implementing Databases with MicrosoftR SQL ServerT 2000 Enterprise Edition
ISBN: N/A
EAN: N/A
EAN: N/A
Year: 2003
Pages: 228
Pages: 228
- Main Page
- Table of content
- Copyright
- CramSession Approved Study Material
- About CramSession.com
- About the Author
- Contributing Authors
- About the Technical Reviewers
- Acknowledgments
- We Want to Hear from You
- How to Use This Book
- Chapter Opener
- Instructional Features Within the Chapter
- Case Studies
- Extensive Review and Self-test Options
- Introduction
- How This Book Helps You
- What Exam 70-229: Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition Covers
- Hardware and Software You ll Need
- Advice on Taking the Exam
- Que Certification
- Part I: Exam Preparation
- Chapter 1. Introducing SQL Server 2000
- Introduction
- Getting to Know SQL Server 2000
- Structured Query Language (SQL)
- The Complete SQL Server 2000 Software
- Books Online
- SQL Server 2000 Limitations
- SQL Server 2000 Versions
- Case Study: ACME Generators
- Chapter Summary
- Apply Your Knowledge
- Chapter 2. Database Design for SQL Server 2000
- Introduction
- A Case Scenario Approach
- Entity Relationship Modeling
- Designing Entity Keys
- Understanding Database Normalization
- Maintaining Data Integrity
- The ClientServer Model
- Case Study: Jones Sons
- Chapter Summary
- Apply Your Knowledge
- Chapter 3. Physical Database Design and Implementation
- Introduction
- Creating and Altering Databases
- Creating and Altering Database Objects
- Multiple Server Implementations
- Troubleshooting SQL Server Objects
- Case Study: ACME Distributors
- Chapter Summary
- Apply Your Knowledge
- Chapter 4. Querying and Modifying Data
- Introduction
- Data Retrieval
- Filtering and Formatting Data
- Data Summary
- Making Data Modifications
- Case Study: Address Book Application
- Chapter Summary
- Apply Your Knowledge
- Chapter 5. Advanced Data Retrieval and Modification
- Retrieve and Filter Data Using Transact-SQL
- Grouping Data with Transact-SQL
- Summarizing Data with Transact-SQL
- Manipulating Heterogeneous Data with OPENQUERY , OPENROWSET , and Linked Servers
- Extracting Data into XML
- Using OPENXML to Read XML Data
- Importing and Exporting Data
- Case Study: Porter Steak Company
- Chapter Summary
- Apply Your Knowledge
- Chapter 6. Programming SQL Server 2000
- Introduction
- Scripts, Batches, and Transactions
- Working with Variables
- Comments
- Statement Blocks with BEGIN...END
- Conditional Statements and Branching with IF...THEN...ELSE
- WHILE loops
- Managing Result Sets by Using Cursors and Transact-SQL
- Concurrency and Locking
- Enforcing Procedural Business Logic Using Transactions
- Managing Data Manipulation Using Transactions
- Implementing Security
- Case Study: Doug s Car Wash and Donuts
- Chapter Summary
- Apply Your Knowledge
- Chapter 7. Working with Views
- Introduction
- Understanding Views
- Create and Alter Views
- Modifying Data Through Views
- Alter Database Objects to Support Partitioned Views
- Control Data Access by Using Views
- Case Study: Boss Needs to Screen Data
- Chapter Summary
- Apply Your Knowledge
- Chapter 8. Triggers
- Introduction
- Constraining Data Modifications
- Triggers
- Trigger Actions and Order
- Security Implications with Triggers
- Troubleshooting Triggers
- Case Study: Emerald Sharp
- Chapter Summary
- Apply Your Knowledge
- Chapter 9. Stored Procedures and User-Defined Functions
- Introduction
- Managing Data Manipulation Using Stored Procedures
- Calling Stored Procedures
- Enforcing Procedural Business Logic with Stored Procedures
- Filtering Data Using Stored Procedures
- Implementing Error Handling in Stored Procedures
- Managing Data Manipulation with User-Defined Functions
- Passing and Returning Parameters To and From User-Defined Functions
- Enforcing Procedural Business Logic Using User-Defined Functions
- Filtering Data with User-Defined Functions
- Implementing Error Handling in User-Defined Functions
- Case Study: Joe s Burger and Malt Shop
- Chapter Summary
- Apply Your Knowledge
- Chapter 10. Boosting Performance with Indexes
- Introduction
- Overview of Indexing
- Creating and Altering Indexes
- Index Maintenance
- Indexed Views
- Full-Text Searches
- Case Study: Western Furniture Ltd.
- Chapter Summary
- Apply Your Knowledge
- Chapter 11. Implementing and Understanding Replication Methodologies
- Introduction
- Replication
- Benefits of Replication
- Understanding Replication Components: The PublisherSubscriber Metaphor
- Replication Configurations
- Types of Replication
- Replication Agents
- Replication Internals
- Updating Subscribers
- Heterogeneous Interoperability
- Enabling Replication in Your Application
- Configuring the Distribution Server
- Case Study: Dave s Video Rental Chain
- Chapter Summary
- Apply Your Knowledge
- Chapter 12. Monitoring and Tuning SQL Server Databases
- Introduction
- Tools Available for Monitoring and Tuning
- Optimizing the OS Configuration
- Optimizing SQL Server Configuration
- Monitor Activity with the Profiler
- Trace Playback and Diagnosis
- SQL Server Optimizer
- Securing Objects
- Case Study: Menaubi Foods
- Chapter Summary
- Apply Your Knowledge
- Part II: Final Review
- Fast Facts
- Exam 70-229: Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition
- SQL Server 2000 Requirements
- Database Design for SQL Server 2000
- Physical Database Design and Implementation
- Querying and Modifying Data
- Advanced Data Retrieval and Modification
- Programming SQL Server 2000
- Working with Views
- Use of Triggers
- Stored Procedures and User-Defined Functions
- Boosting Performance with Indexes
- Implementing and Understanding Replication Methodologies
- Monitoring and Tuning SQL Server Databases
- Study and Exam Prep Tips
- Learning Styles
- Study Tips
- Exam Prep Tips
- Final Considerations
- Practice Exam
- Exam Questions
- Part III: Appendixes
- Appendix A. Glossary
- Appendix B. Overview of the Certification Process
- Types of Certification
- Certification Requirements
- Appendix C. What s on the CD-ROM
- PrepLogic Practice Tests, Preview Edition
- Appendix D. Using the PrepLogic Practice Tests, Preview Edition Software
- Exam Simulation
- Question Quality
- Interface Design
- Effective Learning Environment
- Software Requirements
- Installing PrepLogic Practice Tests, Preview Edition
- Using PrepLogic Practice Tests, Preview Edition
- Get More Exams
- Customer Service
- Index
- Index SYMBOL
- Index A
- Index B
- Index C
- Index D
- Index E
- Index F
- Index G
- Index H
- Index I
- Index J
- Index K
- Index L
- Index M
- Index N
- Index O
- Index P
- Index Q
- Index R
- Index S
- Index T
- Index U
- Index V
- Index W
MCSE Training Guide (70-229). Designing and Implementing Databases with MicrosoftR SQL ServerT 2000 Enterprise Edition
ISBN: N/A
EAN: N/A
EAN: N/A
Year: 2003
Pages: 228
Pages: 228