SQL Server 2000

SQLServer 2000

LENGTH OF COURSE:
3 Days

DESCRIPTION: This course is designed to be a comprehensive overview of SQL Server 2000. The course begins with the basics of SQL Server and walks the student through the design and implementation of systems using SQL Server. In addition, students will have an opportunity to work with more advanced features such as Stored Procedures, Triggers, Replication, Full-Text Indexes, User -Defined Functions and much more. This course is a must for any person that will be using, programming, administering, and managing an environment that is using SQL Server.

PREREQUISITES: Students are expected to have a basic knowledge of Relational Database Concepts. Knowledge of SQL is helpful, but not required. The instructor will evaluate the students knowledge base and pace the course materials according to existing knowledge or skills.
INSTRUCTION TECHNIQUES: A combination of Lecture, Exercises, and Labs (when/where available).

AUDIENCE

Application Users, Developers, Managers, and Technicians that need to access and format relational data using SQL Server. The course will concentrate on how to use SQL Server in a development and production environment

KEY HIGHLIGHTS:

SQL Server 2000 Overview
- SQL Server Architecture
- Components of the SQL Server:
  - Databases
  - Tables
  - Database Diagrams
  - Indexes and Views
  - Stored Procedures
  - Triggers
  - Full-Text Indexes
  - User-Defined Functions
Creating a Database
- Creating a Database Manually and with the Wizard
- Defining a Maintenance Plan
- Creating a Database with Transact-SQL
- Changing Database Characteristics
- Deleting a Database
- Viewing Database Components
Tables
- Characteristics
- Filegroups, Datatypes, Synonyms, Constraints
- Column Characteristics
  - Identifier
  - Nulls
  - Primary Key
  - Foreign Key
  - UNIQUE & CHECK

Query Analyzer
- Connecting to the Server
- The Working Screen
- Executing Commands
- Executing a Query
- Analyzing a Query
- Saving and Recovering a Query
- Saving the Results Panel
SQL Basics and Advanced
- SQL Server 2000 and SQL
- SQL Essentials
  - Data Definition Language
  - Data Manipulation Language
  - Data Types
  - Expressions and Operators
  - SELECT, INSERT, DELETE, UPDATE, DROP, EXISTS
Indexes
- Types of Indexes
- Fill Factor
- Creating Indexes
- Reconstructing an Index
- Viewing an Index
- Deleting an Index
Views
- Creating, Saving, Expanding, Editing, Renaming, and Deleting

Stored Procedures
- Structure
- Types
- Parameter and Return Codes
- Creating and Running
- Recompiling
- Deleting
Triggers
- Components
- Limitations
- Creating and Changing
- Deleting a Trigger
Replicating
- Replication Model
- Types of Replication
- Subscribing a Pub
- Defining a Pub
- Dispatching the Pub
- Checking and Testing
- Merge Replication
Data Warehousing & OLA
OLA Manager
Data Transformation Services
Tools, Backups and Restore
SQL Server & XML

Return to Home Page.

Return to Alphabetic Listing of Courses.

Return to Courses by Subject.

Request More Information or Contact Us.