Flylib.com
Books
Software
Computers & Technology
Home Computing
Business & Culture
Programming
Software
Web Development
Certification
Networking
Security & Encryption
Computer Science
Operating Systems
Microsoft
Hardware
Databases
Graphic Design
Apple
Digital Music
Digital Photography & Video
Games & Strategy Guides
Project Management
Mobile & Wireless Computing
Education & Reference
Encyclopedias
Test Preparation
Studying & Workbooks
Schools & Teaching
Writing, Research & Publishing Guides
Foreign Language Study & Reference
Atlases & Maps
Dictionaries & Thesauruses
Words, Language & Grammar
College & University
Trivia & Fun Facts
Consumer Guides
Business & Investing
Industries & Professions
Management & Leadership
Organizational Behavior
Personal Finance
Small Business & Entrepreneurship
Popular Economics
Marketing & Sales
Finance
Skills
Business Life
Economics
Job Hunting & Careers
Biography & History
Reference
International
Real Estate
Investing
Women & Business
Science & Math
Mathematics
Technology
Reference
Earth Sciences
Physics
Biological Sciences
Behavioral Sciences
Nature & Ecology
Astronomy & Space Science
History & Philosophy
Experiments, Instruments & Measurement
Agricultural Sciences
Category list
Computers & Technology
Programming
Languages & Tools
Software
Category list
Certification
Microsoft
Microsoft
Development
SQL Server
Databases
Database Management Systems
Education & Reference
Test Preparation
Testing
MCAD/MCSE/MCDBA 70-229 Exam Cram 2: Designing & Implementing Databases w/SQL Server 2000 Enterprise Edition - page 1
Buy on amazon.com >>
Moore T
<< Previous book
Next page >>
1
2
EXAM CRAM 2 Designing and Implementing Databases with SQL Server 2000 Enterprise Edition
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
1
2
Buy on amazon.com >>
Moore T
<< Previous book
Next page >>