Oracle9i SQL Introduction

This three day course provides a comprehensive foundation in SQL language and Oracle's SQL*Plus extensions. This course will teach students about creating and maintaining table definitions in the data dictionary, specifying data types, manipulating tables and developing sophisticated queries quickly and accurately.

Target audience

This course has been developed for all Oracle professionals including developers, database administrators, designers and analysts. Students should have a basic understanding of computer programming concepts.

Course content

SQL data definition language Create table statement • Select • Not null • Default • Alter • Drop • Describe • Rename

Using the SQL*Plus tool Interactive SQL with SQL*Plus • Graphical SQL*PLus • EXIT or QUIT • HOST or $ • SPOOL • START or @ • LIST • SAVE • GET • RUN or / • EDIT • APPEND • CHANGE • DEL • INPUT

SQL data manipulation language About SQL DML • SELECT • INSERT • INSERT using SELECT • DELETE • UPDATE • About transactions • ROLLBACK • COMMIT • SAVEPOINT • Complex table references

Introduction to SQL queries SELECT • DISTINCT • Alias names

Building a WHERE clause EQUALITY • INEQUALITY • BOOLEAN • NULL and BETWEEN • IS [NOT] NULL • [NOT] BETWEEN • [NOT] LIKE • IN

Ordering the result table About the order by clause • Including multiple columns • Specifying the sort sequence • Null values and order by • Sorting by un-selected columns • Referring to column aliases

Pseudo columns and functions The pseudo columns • ROWNUM • SYSDATE • USER and UID • The dual table

Joining tables EQUI-JOIN • REFLEXIVE JOIN • NON KEY-JOIN • OUTER JOIN

Using set operators upon tables Set operator examples • UNION • INTERSECT • MINUS • Performing a full outer join

About summary functions

Using subqueries

Creating and selecting groups GROUP BY example • Selecting data from the base tables • HAVING

Creating and using views

Indexes and synonyms

Understanding the data dictionary About the data dictionary • Query DD: USER_TABLES, USER_TAB_COLUMNS, USER_OBJECTS

Build simple SQL*Plus reports

About Courseware Company :: Instructor-led training courseware :: Self-study solutions :: Buy online today