2.0 Installing SQL Server 2000
2.1 Operating Systems
2.2 Versions & Configurations
2.3 Multiple Instances
2.4 Licensing
2.5 File Locations
2.6 Sort Orders
2.7 Types of Installations
2.8 Installation Checklist
2.9 Performing an Installation
 

3.0 Database Setup & Maintenance
3.1 Database Objects
3.2 System Stored Procedures & Functions
3.3 Database Layout
3.4 Database Files & File Groups
3.5 Transaction Log
3.6 Database Growth
3.7 Creating Databases using Enterprise Manager
3.8 Creating Databases using T-SQL
3.9 Sp-helpdb
3.10 Expanding a Database
3.11 Shrinking a Database
3.12 Database Options
3.13 Recovery Models
3.14 Database Space Planning
3.15 Multiple Disk Usage

2.0 Backup & Restore
2.1 Why do a Backup?
2.2 Considerations of the backup process
2.3 Managing the Backup Devices
2.4 System database backup
2.5 Multiple Backup Devices
2.6 Backup Planning
2.7 Media Choices
2.8 Backup Types
2.9 Backup Scenarios
2.10 Copying/Moving
2.11 Stand-by servers& Clustering
2.12 Performing a backup
2.13 Restore a Backup

4.0 Web Assistant
4.1 What is the Web Assistant?
4.2 Running the Web Assistant
4.3 Using a Template file
4.4 Triggers generated by Web Assistant

5.0 SQL Server Configuration Options
5.1 SQL Server Registration Properties
5.2 SQL Server Properties Dialog

2.0 Error Logs
2.1 Windows Event Logs
2.2 SQL Server Error Logs
2.3 Demo of Windows Logs
2.4 Demo of SQL Server Logs

4.0 Tips & Tricks
4.1 General Tips & Tricks

2.0 Database Normalisation
2.1 How to Normalise a Database
2.2 Case study: Employee Time Tracking System

4.0 Creating Databases
4.1 SQL Server Databases & Logs
4.2 Files & FileGroups
4.3 Creating a Database
4.4 Database Size Planning
4.5 Using T-SQL to create a database

2.0 Constraints & Indexes
2.1 Data Integrity
2.2 Indexes

3.0 Retrieving Data
3.1 Select Statement
3.2 WHERE Clause
3.3 DISTINCT & Calculated Columns
3.4 ORDER BY Clause
3.5 Using SLQ Query Analyser

2.0 Joining Tables
2.1 Inner Joins
2.2 Outer Joins
2.3 Cross Join & Self Join
2.4 Subqueries
2.5 Unions

4.0 System Function
4.1 Date Functions
4.2 Mathematical Functions
4.3 String Functions
4.4 System Functions
4.5 Security Functions
4.6 Conversion Functions
4.7 User-Defined Functions
4.8 System Variables

2.0 Triggers & Views
2.1 Update Triggers
2.2 Insert Triggers
2.3 Delete Triggers
2.4 INSTEAD OF Triggers
2.5 Views

2.0 Data Transfers
2.1 Services Available
2.2 BCP
2.3 BULK INSERT
2.4 DTS

3.0 Full Text Search
3.1 What is Full Text Search?
3.2 Setting up Full Text Search
3.3 Performing a Full Text Search
3.4 Full Text SystemProcedures
3.5 FTS Enhancements in SQL 2000

5.0 System Databases & Tables
5.1 System Databases
5.2 System Tables

2.0 Application Development
2.1 OLE DB, ODBC & ADO
2.2 Using ADO

2.0 Dimensional Modelling & Planning
2.1 Entity-Relationship modelling vs. Dimensional modelling
2.2 Elements of the Dimensional model

3.0 Planning Facts
3.1 What is a fact?
3.2 Measures

4.0 Planning Dimensions
4.1 Planning a Hierarchy

2.0 Loading the Data-Mart
2.1 Using Staging Tables
2.2 Using Transact SQL for Data Migration

3.0 Maintaining the Data Mart
3.1 Backup and Restoration Considerations
3.2 Handling Changing Facts
3.3 Handling Changing Dimensions
3.4 Securing the Data Mart

2.0 Cube Basics
2.1 Cube Basics & Measures
2.2 Dimensions and Hierarchies
2.3 Aggregations
2.4 Using the Analysis Manager

2.0 Optimising Cubes
2.1 Optimising Aggregations with Storage Models
2.2 Usage-Based Optimisations
2.3 Tuning the Analysis Server

4.0 Connecting Clients Using OLE DB
4.1 Analysis Application Architecture
4.2 Using Excel as an Analysis Server Client
4.3 Overview of Client Interfaces

2.0 Creating Simple MDX Expressions
2.1 Understanding the Hierarchy
2.2 Using Brackets
2.3 Identifying Members
2.4 Qualifying Sets of Members
2.5 Creating Calculated Members

4.0 Performing Aggregations
4.1 Calculating data in an MDX Query
4.2 Using Aggregate Functions
4.3 Using Time Set Functions

5.0 Using MDX with ADOMD
5.1 Connecting to an Analysis Server
5.2 Executing an MDX Query
5.3 Manipulating Results

2.0 Using the FOR XML Transact SQL Statement
2.1 Basic Concepts
2.2 Using the RAW Mode
2.3 Using the AUTO Mode
2.4 Using the EXPLICIT Mode

3.0 Using the OPENXML Transact SQL Statement
3.1 OPENXML Basics
3.2 Mapping Columns to XML
3.3 Defining Complex Mappings
3.4 Performance Issues

5.0 Using XML Templates
5.1 Creating Templates
5.2 Passing Parameters to Templates
5.3 Using XSL Stylesheets with Templates
5.4 Accessing Database Objects

6.0 Using Annotated XMR Schemas
6.1 Annotated Schema Concepts
6.2 Mapping XML Elements to Columns
6.3 Specifying Explicit Mappings
6.4 Specifying Relationships
6.5 Other Annotations

7.0 Using XML with ADO
7.1 Persisting ADO Data as XML
7.2 Executing XML Queries using CommandStream
7.3 Attaching an XSL Style to XML Stream

8.0 Using the XML for SQL Web Update
8.1 Enhancements
8.2 Using Updategrams
8.3 Using the XML Bulk Load Utility