MS SQL Server 2000 Implementation - MCDBA Exam 70-229 Taining Course Midlands | Birmingham | Telford | Stafford | Wolverhampton

A three day intensive training course which equips participants with the skills necessary to design, build and implement relational database solutions on Microsoft SQL Server 2000. This course will prepare candidates for the MCDBA 70-229exam.

Topics covered include-

SQL Server fundamentals
Introduction
Access and object basics
Tools and utilities

Database design
Business analysis
Data modeling
Application design and database implementation

Database implementation
Database design
Creating and modifying databases
Managing databases

Implementing tables
Database objects
Data types
Table management
Managing constraints, rules, and defaults
Managing indexes

Data load and transfer
Using bulk copy program (bcp) and BULK INSERT
Using Data Transformation Services (DTS)
Designing for replication

Data retrieval
Data retrieval
T-SQL functions
Organizing data
Joins and subqueries
Heterogeneous data sources
XML data manipulation

SQL programming
Programming fundamentals
Security and error fundamentals
Control-of-flow statements
Views
Stored procedures
User-defined functions (UDFs)

Data manipulation
Data modification
Transactions and locking
Using server cursors
Using triggers

Database optimization
Management tools
Managing locks
Database object optimization
Query optimisation