Description
This course introduces the major features and functions of MS SQL Server 7.0 with a focus on using SQL for the development of single- and multi-table queries and report generation. An overview of Transact-SQL and stored procedures is also provided.

Audience
Anyone who will be using SQL Server data sources.

Prerequisites
A good understanding of relational database concepts is helpful but not required.

Hardware and Software
A PC network with Microsoft SQL Server 7.0 available. MS SQL Server client tools installed. Windows 95/98/ME/2000 or NT clients are appropriate.

Format

• Presentation
  
• Hands-on
  
• Demonstration
  

Objectives
After completing this course, participants should be able to:

• Describe the history and use of SQL
• Describe the SQL Server environment
• Use SQL Server tools and utilities
• Query selected data
• Format result sets
• Evaluate queried data using functions and expressions
• Join data from multiple tables
• Develop queries to answer business questions
• Use Transact-SQL in queries
• Execute stored procedures

Microsoft SQL Server

• Introduction to SQL Server architecture
• Back-end development tools
• SQL Server Enterprise Manager

Relational Databases and SQL

• Relational database concepts
• Normalization
• SQL review

SQL Server Datatypes

• Datatypes and Nulls
• SQL Server data type conversions
• Binary large object data types

Basic Data Structures

• Databases
• Database information
• Tables and Views

Basic Integrity Structures

• Column-based integrity
• User-defined data types
• Rules
• Default values
• Indexes and constraints

SQL Extensions in SQL Server

• Transact SQL
• SQL Server functions
• The Full Text Index

Database Access and Preservation

SQL Server Security

• Database roles
• Backup and restore

Transactions and Locking

• Transactions
• SQL Server locking
• Lock granularity