Description
This course provides an introduction to SQL and Sybase’s Transact-SQL. It is designed for all new users of SQL as well as those not familiar with Sybase’s implementation of it.

Audience
Programmers, database administrators, and database designers. It is also useful for end users who need to access data using SQL.

Prerequisites
Familiarity with the fundamentals of relational databases is helpful.

Hardware and Software
A SQL-compliant database with enough logins for the instructor and the students.

Format

• Presentation
  
• Written Exercises
  

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

• Write Transact-SQL statements to add, amend, and delete data in a Sybase Adaptive Server database
• Write SQL queries to retrieve, sort, summarize, and change data managed by a relational database

Introduction to Relational Database Systems

• Why databases?
• Advantages of database approach
• Relational model
• Database tools
• Client/server model

Fundamental Concepts and Terminology

• Entities, attributes, and relationships
• Logical and physical data models
• Data model diagrams
• The relational model
• Data retrieval

SQL Server Fundamentals

• Sybase SQL Server
• Client/server communication
• Open server
• Database security and integrity
• System tables and stored procedures
• Sessions

Interactive SQL

• What is a batch?
• Getting started with ISQL
• Using Transact-SQL Script Files

Structured Query Language (SQL)

• History
• Usage and limitations
• Using SQL
• Identifiers
• Databases, users, and tables
• The language
• Data Definition Language (DDL)
• Data Manipulation Language (DML)
• Joins
• Aggregate functions
• Subqueries
• Analyzing data by grouping rows