MCP 70-299 SQL Server 2000 Design
Exam 70-229
Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition -
This certification exam measures your ability to design and implement database solutions by using Microsoft SQL Server 2000 Enterprise Edition. Upon successful completion of this course, the student will be able to pass the Microsoft 70-229 exam, Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition, which is one of the core electives in the Microsoft's MCSE 2003 and one of the core exams in the Microsoft MCDBA certification program.
Learning / Exam module:
- MCSA/MCSE Certification - Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition - Exam 70-229
- Course Duration: up to 50 hours
Learning Segments:
Introduction
Chapter One - Overview
Data Modeling
Organizing Information
Tools
Chapter Two - Designing Database Structure
Database Structure
Database Creation
Managing Size
File Groups
Chapter Three - Table Structures
Creating Tables
Altering Tables
Dropping Tables
Chapter Four - Declarative Integrity
Key Constraints
Default Constraint
Things To Note
Chapter Five - Displaying And Modifying Data
Data Manipulation Language
Operators
Chapter Six - Summarising Data
Group By
Compute And Compute By
Chapter Seven - Joins And Subqueries
Inner Join
Outer Join
Subqueries
Chapter Eight - Views
Creating A View
Definition And Dependencies
Modifying Data
Chapter Nine - Stored Procedures
Kinds Of Stored Procedures
Input Parameters
Output Parameters
Recompiling
Chapter Ten - Functions
Kinds Of Functions
Scalar
In-Line
Multi-Statement
Chapter Eleven - Indexing
Clustered Index
Nonclustered Index
Dropping An Index
Composite Indexes
Defragmenting Indexes
Fill Factor And Pad Index
Index Statistics
Fine Tuning Indexes
Chapter Twelve - Triggers
Creating A Trigger
Modifying Triggers
Nested Triggers
Performance Considerations
Chapter Thirteen - Locking
Kinds Of Locks
Dead Locks
Chapter Fourteen - Distributed Transactions
Linked Server
Pass-Through Query
Chapter Fifteen - Testing
Syntax
Constraints
Stored Procedures
Indexes
Statistics
Transactions And Locks
Other Things To Note
Testimonials
“I’m pleased to tell you that I have passed both A+ exams to day. Your online training and exam prep material did a great job in preparing me to pass!”
Neil Bottomley, Poole, Dorset.
“Great news guys, I passed my ICND part 2 exam. I am now CCNA. You guys have helped to keep me motivated and keep on going even when things were looking really tough.”
Dave Cooper
“15 months ago I was made redundant from a bus company. Now I have a new career as a Microsoft Systems Administrator earning £35,000 a year. I have got LiveTrain Learning to thank for providing me with the learning materials and support to start in an entirely new career direction”
Trevor Linch MCSE, Winchester, Kent
“The quality of the training materials is very impressive and they provide a lot more than just the paper based courseware you would normally get for spending twice as much with other companies. I find the video lectures and demonstrations very informative. Most of all I like the fact that I get lots of hands on practice!”
Irene Vincent, Worthing, Sussex
“We used to send our staff away to learn Microsoft Office at £400 per day; we can now provide each staff member with the same instructor-led style training on site for a fraction of that price”
Sue Herbert, Personnel Manager, Datalink
“This course is very well presented. The instructor is clear and concise, provides a wealth of knowledge and explains the real world applications. The CEH course is definitely for anyone who is serious about Computer Security. I would recommend this course to anyone presently doing programming who wishes to get a better understanding of the different classes of a hacker and the procedures in which a "cracker" (Black Hat Hacker) goes through to gain access into any system. I am enjoying going through this course-- and I am going to complete it ahead of time!”
Paul Turnbull, Manchester