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
- page 1
Buy on amazon.com >>
Moore T.
<< Previous book
Next page >>
1
2
3
Main Page
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
1
2
3
Buy on amazon.com >>
Moore T.
<< Previous book
Next page >>