To receive updates and new releases subscribe today.
EXAM 70-229: Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition
 Instructor
Course Outline
|
  Online Delivery
$695
$595
DVD-ROM Delivery
$695
$595
 DVD Lending License
$1738
$1488
|
COURSE OVERVIEW
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)
PACKAGE INCLUDES
- 1 DVD featuring live instructor-led classroom sessions with full audio, video and demonstration components
- Printable courseware
-
Exclusive LearningZone Live Mentor Click for Details (Value at $695)
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
- Proven technique- Actual Exam Secrets Review
- Free 1 Year Upgrade Policy
YOUR INSTRUCTOR
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.
FEATURES
-
Main Menu
The organized and effective structure enables users to browse through hours of comprehensive content rapidly and with ease. -
PowerPoint
PowerPoint presentations improve instruction by displaying all types of information for users. They can better comprehend material by viewing graphs, definitions, charts, etc. -
Exclusive Learning Zone
Train anywhere in the world at any time. Certified online instructors are situated at international support centers in the United States, United Kingdom, Australia, and Singapore to offer support and answer technology-related questions 24 hours a day. In other words, no matter where you live, you can communicate with specialists at any time. This level of interaction between instructors and students makes it possible for students to get answers to specific questions at their convenience. -
Controls
Move ahead, review, or repeat previous topics and sections. A progress bar monitors progress as you complete exercises. -
Full Motion Video
Every course offers full-motion videos of classroom instruction. It's as if you're sitting in a classroom. Our one of a kind delivery mimics a one-on-one classroom setting for more personalized educational experiences. -
Study Guides
Users can print entire course study guides, permitting them to view and review course material at their convenience. -
Review Exercises
Every section contains a review quiz to assist and enhance learning by testing whether students comprehend course concepts before moving forward. -
Resume
Every course resumes where you finished during the previous session in case you forget where you stopped. -
Live Demonstrations
Instructors provide live and "hands on" demonstrations to explain and show users how to complete tasks. This enables users to witness professionals perform everyday tasks in real world settings as often as they like. -
Certificate of Completion
We are internationally recognized for our technology-centered IT training programs. Once you finish a program, you'll receive a Certificate of Completion.
COURSE OUTLINE
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
3.2 Examples of Transactions
3.3 Locks
3.4 Basic Trips
3.5 Review
Product Code: MS-70229