MICROSOFT

NETWORKING

SECURITY

SUPPORT

PROGRAMMING

WEB DESIGN

DATABASES

PROJECT MANAGEMENT

DOCUMENT MANAGEMENT

OFFICE SKILLS

 

About us

 

 

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

 

 

 

 


0845 234 0848
speak with one of our dedicated course advisers today to kick start your career.
Full Name
Email*
Daytime Phone*
Course of Interest?*
Career Interest?


We value your privacy.
Your email address will never be rented, sold or abused.
You can unsubscribe your address at any time.






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

Login