Data Deliverance Courseware

Introduction to SQL

Summary
This course introduces the most popular database query language, Structured Query Language (SQL). The ANSI syntax for SQL is illustrated through examples. Oracle and SQL Server extensions are also discussed. The basics of querying, modifying, and adding data are practiced through activities.

Prerequisites
Familiarity with basic operating system commands is required.

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

Intended Audience
This course may prove useful to people such as application developers, business managers, and users who need to develop SQL statements.

Next Steps
Students completing this course may wish to further their knowledge with or some of the vendor-specific courses listed in the catalogue.

Length
2 days

Format
Instructor-led course, with many practical computer-based exercises.

Course Outline

Hardware and Software Requirements
Either Oracle8 or Microsoft SQL Server 7 is recommended. Personal Oracle or Sybase SQL Anywhere can also be used.

Note to Oracle licensees
Your Oracle license may not allow the use of the software for providing training to people outside your organisation. Contact Oracle if you are planning to provide third-party training and have any doubts about your license in this regard.