There are currently no ORSQL classes scheduled. Please call for the next scheduled class.

If you have a group of four or more students, we can schedule this class for you.

ORSQL - Introduction to Oracle9i - SQL

Categories	Database Training, Oracle Training, SQL Training
Duration	3 days (21 hours)
Pre-requisites	Familiarity with database terminology and concepts.
Courseware	ORSQL-SID-01 (300 pages)
Price	$1185
Notes

This Introduction to Oracle training 9i class is designed for Oracle professionals including developers, database administrators, designers and analysts. The foundation for all Oracle professionals is the SQL language along with Oracle's SQL*Plus extensions. A detailed consideration of these languages includes such topics as creating and maintaining table definitions in the data dictionary, specifying data types, manipulating tables and developing sophisticated queries quickly and accurately. After completing this course students should be able to understand the concepts of relational databases; create and alter table definitions including column data type declarations; maintain data within tables using INSERT, DELETE and UPDATE statements and build queries using both basic and advanced SQL techniques.

---

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 & 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 & SELECTING GROUPS
      GROUP BY Example
      SELECTING DATA FROM THE BASE TABLES
      HAVING
CREATING & USING VIEWS
INDEXES & SYNONYMS
UNDERSTANDING THE DATA DICTIONARY
      ABOUT THE DATA DICTIONARY
      Query DD: USER_TABLES, USER_TAB_COLUMNS, USER_OBJECTS
BUILD SIMPLE SQL*PLUS REPORTS