Flylib.com
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
Year: 2003
Pages: 228
BUY ON AMAZON
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
Year: 2003
Pages: 228
BUY ON AMAZON
CompTIA Project+ Study Guide: Exam PK0-003
Assessment Test
Answers to Assessment Test
Project Initiation
Cost Planning
Appendix B Standard IT Project Documents
Cisco IP Communications Express: CallManager Express with Cisco Unity Express
PSTN Trunk Failover
Connected Party Name and Number Services
Security Best Practices for Cisco CME
Troubleshooting a Customized AA
Cisco IPC Express Features and Releases
Introduction to 80x86 Assembly Language and Computer Architecture
Representing Data in a Computer
Elements of Assembly Language
Bit Manipulation
Input/Output
Appendix A Hexadecimal/ASCII conversion
Pocket Guide to the National Electrical Code(R), 2005 Edition (8th Edition)
Article 358 Electrical Metallic Tubing Type EMT
Article 500 Hazardous (Classified) Locations, Classes I, II, and III, Divisions 1 and 2
Article 701 Legally Required Standby Systems
Example No. D2(a) Optional Calculation for One-Family Dwelling Heating Larger than Air Conditioning [See Section 220.82]
Example No. D10 Feeder Ampacity Determination for Adjustable-Speed Drive Control [See 215.2, 430.24, 620.13, 620.14, 620.61, Tables 430.22(E), and 620.14]
Cisco ASA: All-in-One Firewall, IPS, and VPN Adaptive Security Appliance
Advanced ACL Features
Skinny
Directing Traffic to the AIP-SSM
Summary
Summary
The Oracle Hackers Handbook: Hacking and Defending Oracle
Overview of the Oracle RDBMS
The Oracle Network Architecture
Oracle and PL/SQL
Defeating Virtual Private Databases
Accessing the File System
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies