·          Introduction to SQL Server 2000

·          Overview of Database Concepts

·          Databases

o         File Server and Client – Server Databases

o         Relational Databases

o         OLTP and OLAP Databases

o         Transaction Logs   

·          Tables

o         Records, Fields and Values

o         Rows and Columns

o         Null Values

o         Field Properties

o         Keys and Relationships

o         Indexes and Constraints

o         Rules and Defaults   

·          Views

o         SQL

o         Locking

o         DDL and DML

o         Query Plan   

·          Stored Procedures

o         Triggers

o         Transactions

o         System Stored Procedures   

·          Ownership and Security   

·          Jobs, Alerts and Operators   

·          Replication   

·          Application Programming Interfaces   

·          Overview of SQL Server   

·          Programs installed with SQL Server

o         Books Online

o         Client Network Utility

o         Server Network Utility

o         Service Manager

o         Profiler

o         Query Analyzer

o         OSQL

o         Bulk Copy Program (BCP)

o         Enterprise Manager   

·          Parts of a Database

o         Tables

o         Views

o         Stored Procedures

o         Diagrams

o         Database User Accounts

o         Database Roles

o         User – Defined Data types

o         User – Defined Functions

o         Rules and Constraints

o         Defaults

o         Full – Text Catalogs   

·          SQL Server Storage Concepts

o         Pages

o         Extents   

·          Database Design and Normalization   

·          What is Normalization?   

o         Key Concepts of Normalization   

·          First Normal Form

o         Defining First Normal Form

o         Identifying a Primary Key   

·          Second Normal Form

o         Foreign Keys and Relations   

·          Third Normal Form   

·          Boyce – Codd Normal Form   

·          Advanced Normalization   

o         Forth Normal Form

o         Fifth Normal Form   

·          Denormalization

o         Making the Trade – offs   

·          Tools for Normalization in SQL Server

o         Identity Columns

o         Constraints

o         Rules

o         Declarative Referential Integrity (DRI)

o         Triggers

o         Database Diagrams   

·          Transact – SQL Overview and Basics   

·          What is Transact – SQL?   

o         ANSI SQL

o         SQL Dialects

o         SQL Configuration Options   

·          T – SQL Syntax and Conventions

o         Reading Syntax Diagrams

o         Valid Identifiers

o         Referring to Objects

o         Reserved Words   

·          Datatypes

o         Integers

o         Text

o         Decimal

o         Money

o         Floating Point

o         Date

o         Binary Data

o         Miscellaneous

o         Synonyms for Datatypes   

·          Operators

o         Available Operators

o         Operator Precedence and Grouping   

·          Wild Cards   

·          Variables   

o         System Global Variables

o         Local Variables   

·          Functions

o         Generating GUIs         

·          Executing T – SQL

o         Using Query Analyzer

o         Using SQL Server Enterprise Manager

o         Using OSQL   

·          Select Queries   

·          Using Basic SELECT Queries   

o         Limiting Records with the WHERE Clause

·          Using Joins

o         INNER JOINS

o         OUTER JOINS

o         JOINing Multiple Tables   

·          Turning Result Sets into Reports

o         Using ORDER BY

o         Using GROU BY and HAVING

o         Using ROLLUP

o         Using CUBE and GROUPING

o         Using COMPUTE and COMPUTE BY

o         Using TOP N

·          Full – Text Searching

o         Installing and Configuring Full – Text Search

o         Performing Full – Text Search

o         Administrating Full – Text Search   

·          Linked Server queries   

·          Action Queries   

·          What are Action Queries?   

·          Delete Queries   

o         Syntax of DELETE

o         Limitations of DELETE

o         Examples of DELETE

o         Syntax of TRUNCATE TABLE

o         Limitations of TRUNCATE TABLE

o         Example of TRUNCATE TABLE   

·          Update Queries

o         Syntax of UPDATE

o         Limitations of UPDATE

o         Examples of UPDATE

o         The WRITETEXT Statement

o         The UDATETEXT Statement   

·          Insert Queries

o         Syntax of INSERT

o         Limitations of INSERT

o         Examples of INSERT

o         Syntax of SELECT INTO

o         Limitations of SELECT INTO

o         Examples of SELECT INTO   

·          Advanced Transact – SQL Transactions

o         What are Transactions?

o         The ACID Properties

o         Using Transactions

o         Distributed Transactions

o         Transaction Tips   

·          Rowset Functions

o         CONTAINSTABLE

o         FREETEXTTABLE

o         OPENQUERY

o         OPENROWSET

o         OPENDATASOURCE   

·          Cursors

o         What are Cursors?

o         DECLARE CURSOR

o         OEN and @@CURSOR_ROWS

o         FETCH and @@FETCH_STATUS

o         CLOSE0

o         DEALLOCATE

o         A Cursor Example   

·          Tables   

·          Planning Tables   

·          Creating Tables   

·          Restricting the Data   

o         Enforcing Domain Integrity

o         Enforcing Entity Integrity

o         Enforcing Referential Integrity

o         Using Database Diagrams   

·          Indexing

·          Index Architecture

o         Understanding Heaps

o         Understanding Clustered Index

o         Understanding Nonclustered Indexes

·          Creating Indexes

o         Creating Indexes with Enterprise Manager

o         Creating Indexes with the Index Tuning Wizard   

·          Views   

·          Using views to Partition Tables   

o         Creating a View with the Create View Wizard

o         Modifying a View in the View Designer

o         Using Aliases in a View

o         Organizing the Result Set   

·          Using Views to Join Tables

o         JOINing Two Tables in a View

o         JOINing Multile Tables in a View   

·          Modifying Data through a View   

·          Working with Indexed Views   

o         Considerations

o         Creating Indexed Views

o         Enhancing Indexed Views with Inline User – Defined Functions   

·          Stored Procedures

o         Understanding Stored Procedures

o         Using System and Extended Stored Procedures   

·          Using Triggers   

·          Understanding Triggers   

o         Working with INSERT Triggers

o         Working with DELETE Triggers

o         Working with UDATE Triggers

o         Working with INSTEAD OF Triggers   

·          Advanced Considerations

o         Combining Trigger Types

o         Reporting Errors with RAISERROR()

o       Recursive Triggers