::Computeach:: Technology training for the real world
navbar
This text is replaced by the Flash movie.




Course: Database Programming (SQL Server 2000)

Overview
This course provides students with the technical skills required to design, create and administer a database solution using Microsoft SQL Server 2000. The material covered will prepare a student for the MCDBA and MCAD certification.

Topics Included in Training
Logical Database Design
Entities and Attributes
Constraints
Integrity
Database Creation
Database Properties and Settings
Growth Strategies
Transact SQL DDL
Database Objects
Tables
Constraints
Indexes
Triggers
Stored Procedures
Functions
Views
Security
Roles
Encryption
Tables
Primary Keys
Cascading
Constraints
Clustering
Default Values
Fill Factor
Foreign Keys
Replication
Strategy
Application
Data Import and Export
Import/Export Wizard
BCP
DTS
XML Support
Querying External Data Sources
Linked Server
XML
Administration
Enterprise Manager
Query Analyzer
Troubleshooting
SQL Profiler
Optimization
Indexing
Indexing Tuning Wizard
Best Practices
Naming Conventions
Error Handling

Prerequisite: Introduction to Computers (A+) or Equivalent Knowledge
Database Design or Equivalent Knowledge
Certification Tests: Offered in our Vue Testing Center
MS 70-229 Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition
Format: 40 Hours (5 Days) Instructor Led Training
Daytime and Evening/Saturday Classes Available

Course Content Subject to Change without Notice
Version 016-303A
::Computeach:: Technology training for the real world