Exam 70-229 MCSE SQL Server 2000 Implementation

0-619-17149-9 © 2003 Publish date: March 4, 2003 606 pages

Buy Now: $59.99 .................

 

Get ready to pass the Microsoft certification exam 70-229 by using the Exam 70-229 study guide. This easy-reading tool focuses completely on the objectives Microsoft has laid out for this exam. By narrowing your studies on these objectives, you will learn exactly what you will be tested on. Your success in the exam room will be followed by success on the job as you learn the ins and outs of implementing SQL Server 2000.

The Exam 70-229 courseware is filled with activities and reviews following each unit so that you will engage in exercises that reinforce the topics you just learned. Like all of our computer training books, this exam prep tool is written by experts who know what they are talking about.

With self-directed courses such as this one, you'll learn on your own terms by studying when and where you want. The typical student will spend about five days following the Exam 70-229 courseware but you can take more or less time as needed to gain a thorough understanding of the course objectives.

As you follow the courseware, you will go through nine full units learning the fundamentals of SQL Server, database design, database implementation, data tables, data load, data retrieval, SQL programming, data manipulation, and optimizing data. At the conclusion of the course, you'll examine actual case studies.

Course Contents

Unit 1 introduces SQL Server fundamentals

• Introduction to SQL Server
• Access and object basics
• Tools and utilities

Unit 2 covers database design

• Business analysis
• Data modeling
• Designing applications and database implementation

Unit 3 discusses database implementation

• Database design
• How to create and modify databases
• Database management

Unit 4 covers implementing tables

• Database objects
• Types of data
• Managing tables
• Managing constraints, rules, and defaults
• Managing indexes

Unit 5 discusses Data load and transfer

• Bulk copy program and BULK INSERT
• Data Transformation Services
• Replication design

Unit 6 covers data retrieval

• Data retrieval
• Functions of T-SQL
• Organizing your data
• Joins and sub-queries
• Heterogeneous data sources
• Manipulating XML data

Unit 7 discusses SQL programming

• Fundamentals of programming
• Fundamentals of security and errors
• Control-of-flow statements
• Views
• Stored procedures
• User-defined functions

Unit 8 covers data manipulation

• Modifying data
• Transactions and locking
• Server cursors
• Using triggers

Unit 9 discusses database optimization

• Management tools
• Managing locks
• Optimizing database objects
• Optimizing queries

Appendix A contains a case study

• Business description
• Project concerns
• Project goals

Appendix B contains additional references

• System tables
• System functions
• Data types and precision storage
• DBCC command statements