SQL Server 2000 Implementation

Topic-Level Outline

Days: 2

Prerequisites: Windows 2000 Server Administration Principles or equivalent experience

Unit 1 : SQL Server fundamentals

Topic A: 0 Introduction

A-1: Understanding SQL Server fundamentals

Topic B: 0 Access and object basics

B-1: Understanding management fundamentals

Topic C: 0 Tools and utilities

C-1: Using Query Analyzer

Unit 2 : Database design

Topic A: 0 Business analysis

A-1: Analyzing business requirements

Topic B: 0 Data modeling

B-1: Creating a data model

Topic C: 0 Application design and database implementation

C-1: Preparing for implementation

Unit 3 : Database implementation

Topic A: 0 Database design

A-1: Determining database requirements

Topic B: 0 Creating and modifying databases

B-1: Creating a database

Topic C: 0 Managing databases

C-1: Managing databases

Unit 4 : Implementing tables

Topic A: 0 Database objects

A-1: Understanding database objects

Topic B: 0 Data types

B-1: Creating user-defined data types

Topic C: 0 Table management

C-1: Creating tables

Topic D: 0 Managing constraints, rules, and defaults

D-1: Managing constraints

Topic E: 0 Managing indexes

E-1: Managing indexes

Unit 5 : Data load and transfer

Topic A: 0 Using bulk copy program (bcp) and BULK INSERT

A-1: Using bcp and BULK INSERT

Topic B: 0 Using Data Transformation Services (DTS)

B-1: Using DTS

Topic C: 0 Designing for replication

C-1: Understanding replication

Unit 6 : Data retrieval

Topic A: 0 Data retrieval

A-1: Running basic queries

Topic B: 0 T-SQL functions

B-1: Using functions

Topic C: 0 Organizing data

C-1: Grouping and organizing data

Topic D: 0 Joins and subqueries

D-1: Using joins and subqueries

Topic E: 0 Heterogeneous data sources

E-1: Retrieving heterogeneous data

Topic F: 0 XML data manipulation

F-1: Understanding XML fundamentals

Unit 7 : SQL programming

Topic A: 0 Programming fundamentals

A-1: Writing batches and scripts

Topic B: 0 Security and error fundamentals

B-1: Managing security

Topic C: 0 Control-of-flow statements

C-1: Using control-of-flow statements

Topic D: 0 Views

D-1: Using views

Topic E: 0 Stored procedures

E-1: Using stored procedures

Topic F: 0 User-defined functions (UDFs)

F-1: Using UDFs

Unit 8 : Data manipulation

Topic A: 0 Data modification

A-1: Using INSERT, UPDATE, and DELETE

Topic B: 0 Transactions and locking

B-1: Managing transactions

Topic C: 0 Using server cursors

C-1: Using cursors

Topic D: 0 Using triggers

D-1: Creating triggers

Unit 9 : Database optimization

Topic A: 0 Management tools

A-1: Using management tools

Topic B: 0 Managing locks

B-1: Clearing deadlocks

Topic C: 0 Database object optimization

C-1: Understanding object optimization

Topic D: 0 Query optimization

D-1: Optimizing queries

Appendix A : Case study

Topic A: 0 Business description

Topic B: 0 Project concerns

Topic C: 0 Project goals

Appendix B : Additional object references

Topic A: 0 System tables

Topic B: 0 System functions

Topic C: 0 Data types and precision storage

Topic D: 0 DBCC command statements