Participants learn to issue data definition, query, and update commands against a populated sample database.
Special emphasis is given to views, joins, subqueries, and checking for referential integrity.
SQL Plus and its capabilities and functions are also explored. This course is designed for data processing professionals and end users that need to use interactive SQL commands or who will eventually be embedding SQL calls in programs. Participants are not required to have prior experience with SQL or Oracle, some prior programming experience is helpful. All content copyright 1997 - 2001, Center for the Application of Information Technology. All rights reserved.