Introduction to Oracle10g:
 SQL, SQL*Plus and PL/SQL

Duration:   5 days

Participants:   Application Developers, Programmers, Database Administrators, and end-users who need a practical introduction to Oracle10g.

Objectives:   Upon successful completion of this course you will be able to: -  Code application modules in PL/SQL. -  Develop and create PL/SQL stored procedures, functions, packages and database triggers. -  Write queries using the SQL*Plus tool.

Topics: -  Relational Database Overview -  SQL Statements and Syntax -  SQL*Plus Commands and Syntax -  Accessing and Manipulating Data Using SQL -  Sub-query Processing -  Inner and Outer Joins -  Aggregate Functions -  Built-in Functions -  PL/SQL Overview -  PL/SQL Blocks -  Stored Procedures -  Functions -  Database Triggers -  Packages

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:   SQL and SQL*Plus Topics -  Overview of SQL*Plus         Sub Oracle10g SQL*Plus Environment         Oracle10g Database Management System (RDBMS)         Accessing Tables -  Database Terminology         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, and 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 PL/SQL Topics -  Overview of PL/SQL         PL/SQL Block Structure         PL/SQL Program Constructs -  PL/SQL Variables         Identifiers         Datatypes         Variables         Expressions -  Manipulating Data Using SQL*Plus         SQL Statements in PL/SQL Blocks         Retrieving Data         Manipulating Data         Transaction Management -  PL/SQL Block Execution         Control Structures         Conditional Statements         Loops -  Cursor Processing in PL/SQL         Implicit Cursors         Explicit Cursors         Parameterized Cursors         Cursor Variables         Cursor for Loops         Collections in PL/SQL         BULK COLLECT Feature -  Handling Exceptions         Predefined Exceptions         Oracle Defined Exceptions         User-Defined Exceptions         RAISE Statement         Propagation of Exceptions -  Subprograms         Procedures         Functions         Parameter Modes         RETURN Statement -  PL/SQL on the Server         Triggers         Packages

Oracle List       Database List       Site Map       Home