Flylib.com
MCAD/MCSE/MCDBA 70-229 Exam Cram 2: Designing & Implementing Databases w/SQL Server 2000 Enterprise Edition
MCAD/MCSE/MCDBA 70-229 Exam Cram 2: Designing & Implementing Databases w/SQL Server 2000 Enterprise Edition
ISBN: 0789731061
EAN: 2147483647
Year: 2005
Pages: 154
Authors:
Thomas Moore
,
Ed Tittel
BUY ON AMAZON
EXAM CRAM 2 Designing and Implementing Databases with SQL Server 2000 Enterprise Edition
Table of Contents
Copyright
A Note from Series Editor Ed Tittel
About the Author
Acknowledgments
We Want to Hear from You
Introduction
About the Exam and Content Areas
How to Prepare for the Exam
What This Book Will Do
What This Book Will Not Do
About the Book
Self-Assessment
Database Implementation and Administration as an MCDBA
Testing Your Exam Readiness
Well, Let s Get to It
Chapter 1. Database Development on SQL Server 2000
Introduction
The Server and Its Components
The Exam
SQL Server Objects
Types of Data
Exam Prep Questions
Chapter 2. Creating a Logical Data Model
Introduction
Data Modeling and Logical Data Design
Data Normalization
Denormalization
Relationships Between Entities
Exam Prep Questions
Chapter 3. Implementing the Physical Database
Introduction
A Hardware Dialogue
The File System
Database Creation
Inside the Database
Trigger Utilization
Troubleshooting Failed Object Creation
Exam Prep Questions
Chapter 4. Advanced Physical Database Implementation
Introduction
The Need for a More Complex Design
Database Configuration Options
Other Multiple Machine Database Implementations
Exam Prep Questions
Chapter 5. Retrieving and Modifying Data
Introduction
Moving a Mountain of Data
Selecting Information from the Data
Joining Multiple Sets of Data
Extensible Markup Language (XML)
Exam Prep Questions
Chapter 6. Programming Business Logic
Introduction
Start with Data Analysis Prior to Coding
Providing the Orders to Be Followed
Converting Constructs to Code
Alternative Coding Mechanisms
Exam Prep Questions
Chapter 7. Tuning and Optimizing Analysis
Introduction
Information Gathering
Query Optimization
Exam Prep Questions
Chapter 8. Designing for Optimized Data Access
Introduction
Optimization Through Design
Maintaining the System to Get Back Performance
Exam Prep Questions
Chapter 9. Designing a Database Security Plan
Introduction
Troubleshooting Security Issues
Exam Prep Questions
Chapter 10. Completing a Business System Design
Introduction
SQL Server Supporting Applications
Coding for Distributed Data
SQL Server Automation of Processes
Exam Prep Questions
Chapter 11. Practice Exam One
Chapter 12. Answers to Practice Exam One
Chapter 13. Practice Exam Two
Chapter 14. Answers to Practice Exam Two
Appendix A. What s on the CD-ROM?
Multiple Test Modes
Question Types
Random Questions and Order of Answers
Detailed Explanations of Correct and Incorrect Answers
Attention to Exam Objectives
Installing the CD
Technical Support
Appendix B. Need to Know More?
Chapter 1
Chapter 2
Chapter 3
Chapter 4
Chapter 5
Chapter 6
Chapter 7
Chapter 8
Chapter 9
Chapter 10
Glossary
A
B
C
D
E
F
G
H
I
J
K-L
M
N
O
P
Q
R
S
T
U
V
W
X-Z
Index
SYMBOL
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
MCAD/MCSE/MCDBA 70-229 Exam Cram 2: Designing & Implementing Databases w/SQL Server 2000 Enterprise Edition
ISBN: 0789731061
EAN: 2147483647
Year: 2005
Pages: 154
Authors:
Thomas Moore
,
Ed Tittel
BUY ON AMAZON
Database Modeling with MicrosoftВ® Visio for Enterprise Architects (The Morgan Kaufmann Series in Data Management Systems)
Object Types, Predicates, and Basic Constraints
Editing Logical Models”Advanced Aspects
Reverse Engineering Physical Schemas to Logical Models
Logical Database Model Reports
Change Propagation and Round Trip Engineering
Qshell for iSeries
Running Qshell
C and C++ Development Tools
Appendix A Summary of Changes by Release
Appendix B Qshell versus DOS
Appendix C Qshell and CL Commands for the IFS
Strategies for Information Technology Governance
An Emerging Strategy for E-Business IT Governance
Measuring and Managing E-Business Initiatives Through the Balanced Scorecard
A View on Knowledge Management: Utilizing a Balanced Scorecard Methodology for Analyzing Knowledge Metrics
Governing Information Technology Through COBIT
The Evolution of IT Governance at NB Power
Practical Intrusion Analysis: Prevention and Detection for the Twenty-First Century: Prevention and Detection for the Twenty-First Century
Understanding Intrusion Detection
IDS and IPS Internals
Internet Security Systems RealSecure
Cisco Secure IDS
Laws, Standards, and Organizations
Mapping Hacks: Tips & Tools for Electronic Cartography
Hacks 14-21
Hack 38. Add Location to Weblogs and RSS Feeds
Hack 57. Connect to Your GPS from Multiple Applications
Hack 81. Clean Up U.S. Addresses
Hack 90. Crawl the Geospatial Web with RedSpider
Quantitative Methods in Project Management
Project Value: The Source of all Quantitative Measures
Introduction to Probability and Statistics for Projects
Making Quantitative Decisions
Risk-Adjusted Financial Management
Expense Accounting and Earned Value
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