|
|
Oracle10g SQL and SQL*Plus
| Duration: 3 days |
| Participants: Application Developers, Programmers, and Database Administrators working with Oracle Databases. |
|
Objectives:
Upon successful completion of this course you will be able to:
- Write Oracle SQL queries using the SQL*Plus tool. |
|
Topics:
- Relational Database Overview - SQL Overview - Database Design Considerations - SQL*Plus Overview - Select Processing - Sub-query Processing - Join Processing - Union Procesing - Aggregate Functions - Built-in Functions - Modifying Data |
| Overview: This is an introductory course to writing Oracle SQL queries using the SQL*Plus tool. Lecture sessions are followed with Hands-on Lab exercises which provide the participants with a good basic knowledge, and experience writing queries using the SQL*Plus tool. |
| Prerequisites: Participants should possess a basic understanding of data processing concepts. |
| Format: Lecture and discussion with hands-on Lab exercises to reinforce the topics covered. |
|
Topic Outline:
- Overview of SQL*Plus SQL Environment Oracle Database Management System (RDBMS) Accessing Tables - Database Terminology and Design Considerations General Terminology Datatypes Syntax Rules Data Modeling (Normalization) Keys – Primary, Foreign - Retrieval Queries Format of SQL Statements Predicates Nulls Connectors Sorting Retrieved Data - DML Advanced Features Group Functions Conversion Functions Number Functions Character Functions Miscellaneous Functions - SQL*Plus Commands Session Commands Format and Control Commands Edit Commands SQL*Plus Variables - Accessing Multiple Tables Subqueries Inner and Outer Joins Union, Intersect, Minus Functions - Table Maintenance SQL Environment Manipulating Data in Tables Transaction Management - Data Definition Language (DDL) DDL SQL Statements Creating Objects – Tables, Indexes - Views Creating Views Updating through Views Materialized Views |
|
|