Relational Database Overview

SQL Server Evolution

The 2000 Release & it's new features

How is data organised in SQL Server & NT 

Creating Databases 

Using File groups to Position Objects 

Shrinking databases.

Designing Tables Through the Database Diagram 

Creating Tables through Enterprise Manager and the basic CREATE TABLE syntax 

SQL Server Data types 

Calculated columns and user-defined data types

Table enforced constraints and Rules

The IDENTITY property 

Setting up Referential Integrity

Querying Microsoft SQL Server 7.0 Tables 

Basic Transact SQL queries 

Transact SQL built-in Functions 

Querying linked servers and other remote data sources

Full-Text Searching

The query optimiser

Index types in SQL Server 2000

Creating Indexes

Using composite indexes for index covering

Analysing index use and optimising SQL Server 2000 indexes

Using optimiser hints effectively

The Uses of Views 

Using Calculated Columns 

Creating views

Indexed Views

How data is changed in SQL Server 2000

Inserting, copying, changing & removing records 

Transaction processing commands 

Distributed Transactions 

Locking Issues, transaction isolation levels and locking 'hints'

The Query Analyzer as a developer's environment 

Transact SQL Batch and script rules 

Using Variables and control of flow statements 

Using Global Variables 

Using The EXEC() function. 

Error Handling 

Using Cursors

SQL Server 2000 Query caching & related issues

Uses for Stored Procedures & User-Defined functions

A useful UDF. 

Compilation problems and methods 

Stored procedures parameters 

Returning values and updating parameters 

Temporary procedures and AutoStart Procedures

Basic Trigger assumptions and syntax 

Uses for triggers 

AFTER triggers and INSTEAD OF triggers 

Nested Triggers 

Changing the order of trigger execution 

Disabling Triggers

DTS Overview 

Building DTS packages with ActiveScript

The DTSObjects library and how to manipulate it

SQL Server's own library - DMO (Distributed Management Objects)

Using DMO

Rapid Application development with Microsoft Access 2000

Access Project Concepts

Upsizing from Jet to Microsoft SQL Server

Converting DAO to ADO

Building scalable solutions with MSDE

What is OLE-DB? 

The ActiveX Data Object Model 

Connection Management 

ADO Resultsets 

ADO Commands

DAO and Jet

RDO.

Using Microsoft Access 2000 and Front Page to build data-driven web-pages

Building data-driven web pages using Active Server Pages 

XML overview 

Driving web-pages with SQL Server data using XML

Introduction to Data Warehousing and Analysis Services

Designing a Database for OLAP

Using Data Transformation Services to Populate the Warehouse

Using Analysis Manager to create Cubes

Browsing Cubes and the PivotTable Service

Programming Analysis Services: An introduction to MDX and DSO

Maintaining Data Warehouses