Exam 70-229 : Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition

Schedule our instructor led classroom training at your convenience and never miss another lecture or fall behind. You are in complete control. We invited the best SQL Trainers in the industry to help us develop the ultimate training & certification program.

Our SQL Server 2000 Implementing Database Design training course will teach you how to design and implement a powerful, functional database with Microsoft SQL Server 2000. Expert instructor Linda Harris friendly presentation style makes this complex technical subject matter easy to understand. At the conclusion of this course you will understand the core techniques of implementing database design and will be prepared to pass exam #70-229 which provides core credit toward Microsoft Certified Database Administrator certification, elective credit toward Microsoft Certified Systems Engineer certification, and elective credit toward Microsoft Certified Solution Developer certification.

This exam is a requirement for the following Certification(s) :

Microsoft Certified Database Administrator (MCDBA)

Our reputation speaks for itself! See what others are saying... Testimonials

Package Includes:

6 CD-ROMs featuring live instructor-led classroom sessions with full audio, video and demonstration components
Printable courseware
Exclusive LearningZone Live Mentor Click for Details (Value at $195)
Help Whenever you need it! Exclusive LearningZone - Chat Live with our Certified Instructors anytime around the clock (7x24)
Focused on practical solutions to real-world development problems
Microsoft Authorized MeasureUp Exam Simulation
Proven technique- Actual Exam Secrets Review
Certification Exam Pass Guarantee
Free 1 Year Upgrade Policy

Linda Harris is a Microsoft Certified Trainer, Database Administrator and a System and Application Developer. Linda has over 10 years experience as a Database Administrator and programmer. She has mastered and taught several courses utilizing Microsoft's SQL Server tools and technologies. In addition to her specialty in teaching all aspects of Database Programming, she has also taught a number of Microsoft Windows BackOffice courses.

Course Features:

Main Menu
Move through hours of in-depth content - quickly and easily due to the efficient and organized structure.
PowerPoint
Utilizing PowerPoint presentations enhances the delivery by displaying a variety of visual information to the user. This type of representation allows the user to better interpret the material through charts, definitions, graphs, and more...
Exclusive Learning Zone
Train around the clock, around the world. Our certified online instructors are located at global support centers in the U.S., U.K., Australia, and Singapore to provide real-time answers to technology- and soft-skill-related questions 24x7. This means access to a live subject matter expert no matter where you are - day or night. This level of student/instructor interaction provides real-time training specific support and extends training beyond content and instructor-led solutions by providing flexibility to accommodate individual needs and schedules.
Controls
Move forward, back, and repeat entire topics or just a section. A progress bar illuminates as you advance through exercises.
Full Motion Video
All courses feature full-motion videos of instructors teaching the information as if they are speaking directly to you. Our unique delivery simulates a one-on-one classroom environment creating a more personal lesson and learning experience.
Study Guides
Printable study guides for the entire course are available. This allows all material to be viewed, reviewed, and printed for viewing at a later date.
Review Exercises
Each section has a review quiz to aid in the learning process by validating the comprehension of the material covered before moving on to a new section.
Resume
All courses are resumed to where you left off last session allowing you to learn when it is convenient for you without the hassle of remembering where you where.
Microsoft Authorized Practice Exams
CareerAcademy.com includes Authorized Practice Exams from Microsoft Certified Practice Test Provider (MeasureUp) to fully prepare you for the certification exams. Because many companies offer training and practice tests, the Microsoft MCP program has designated MeasureUp as a certified test provider to help IT candidates select the highest quality products and services. Microsoft performs quality reviews on all Practice Test Provider, and only approved practice test vendors bear the Microsoft Certified Practice Test Provider logo.
Live Demonstrations
Demonstrations are a way for the instructor to show and tell the user how to perform a task by actually doing it on screen in front of them. In this format it gives the user the power to see things done by a professional in the intended environment as many times as they would like.
Certificate of Completion
Career Academy is recognized worldwide for its technology-based IT training curriculums. Upon successful completion of our program, you will be receiving a Career Academy Distance Education Certificate of Completion.

Module 1

SQL Server & Database Concept

1.1 Introduction to SQL Server
1.2 SQL Server Services
1.3 Databases, Objects, & Systems Tables
1.4 Metadata retrieval
1.5 SQL Server Security
1.6 4 Stages of Implementing a SQL Server Database
1.7 Database Normalization

Module 2

Programming SQL Server

1.1 Layers
1.2 Data Access
1.3 Programming Tools
1.4 Transact- SQL
1.5 Statements
1.6 3 Language Statements
1.7 Batch Directives
1.8 Identifiers
1.9 Color Codes
1.10 Query Analyzer Demo
1.11 Additional Language Elements
1.12 Aggregate & Scalar Functions
1.13 Different Types of Statements
1.14 Executing Transact-SQL Statements
1.15 SQL Syntax Review

Module 3

Databases and Database Files

1.1 Defining Databases
1.2 Creating a Database
1.3 How the Transaction Log Works
1.4 Setting Database Options
1.5 Creating Filegroups
1.6 Recommendations
1.7 Review

Module 4

Creating Data Types & Tables

2.1 Data Types
2.2 Create & Drop a Table
2.3 User Defined Data Types
2.4 Data Type Guidelines
2.5 Generating Column Values
2.6 The Identity Property
2.7 Automatically Generating Scripts
2.8 Review

Module 5

Implementing Data Integrity

3.1 Data Integrity & Constraints
3.2 Adding a Default Constraint
3.3 CHECK Constraints
3.4 Adding a CHECK Constraint
3.5 Primary Key, Unique & Foreign Constraint
3.6 Review

Module 6

Indexing Overview

1.1 Storing & Retrieving Data
1.2 Storing Heaps
1.3 B-tree Structures
1.4 Clustered Indexes
1.5 Non-Clustered Indexes
1.6 Querying the Sysindexes Table
1.7 Page Splits, Design & Performance
1.8 Indexing Guidelines
1.9 Performance Considerations
1.10 Review

Module 7

Creating and Maintaining Indexes

2.1 Creating Indexes
2.2 Computed Columns
2.3 Viewing a List of Indexes
2.4 Indexing Options
2.5 Statistic Binary Column
2.6 Creating, Updating & Viewing Statistics
2.7 DBCC Command
2.8 The Turning Wizard & Performance Considerations
2.9 Review

Module 8

Implementing Views

3.1 Introduction to Views
3.2 Creating Views
3.3 Using Indexed Views
3.4 Review

Module 9

Transact-SQL Stored Procedure

1.1 Defining Stored Procedures
1.2 Looking at a Stored Procedure
1.3 Using Parameters
1.4 Creating & Calling a Stored Procedure
1.5 Recompiling Stored Procedures
1.6 Executing an Extended Stored Procedure
1.7 Handling Error Messages
1.8 Review

Module 10

User-defined Functions

2.1 What is a User Defined Function
2.2 Creating a User Defined Function
2.3 Examples of User Defined Functions
2.4 Review

Module 11

Implementing Triggers

3.1 Using & Creating Triggers
3.2 Different types of Triggers
3.3 Creating a Delete Trigger
3.4 Enforcing Data Integrity & Business Rules
3.5 Review

Module 12

Programming Multiple Servers

4.1 Interlocution to Distributed Queries
4.2 Setting Up a Linked Server
4.3 Working with Linked Servers
4.4 Review

Module 13

Optimizing Query Performance

1.1 Introduction to the Query Optimizer
1.2 Viewing STATISTICS Statements Output
1.3 STATISTICS & Show plan Options
1.4 The Graphical Execution Plan
1.5 Comer Queries
1.6 Creating Indexes That Cover a Query
1.7 Creating Indexes That Cover a Query
1.8 Review
1.9 Monitoring Functionality
1.10 SQL Profiler
1.11 Execution Plan

Module 14

Analyzing Queries

2.1 Different Types of Queries & Joins
2.2 Review

Module 15

Managing Transactions & Locks

3.1 Introduction to Transactions & Locks
3.2 Examples of Transactions
3.3 Locks
3.4 Basic Trips
3.5 Review