About us   Registration   Site map    
      New user|Forgot password  
Select Your Country to check the Schedule for this Course
Time Zone:
Course Name Course Code
Oracle 9i,10g/11i SQL/PLSQL Programming 25
Course Contents

SQL 9i/10g and 11g


Introduction to RDBMS

 What's New in the SQL Language?

   * Oracle Database 11g Release 1 New Features in the SQL Language Reference


1 Introduction to Oracle SQL

    * History of SQL

    * SQL Standards

           How SQL Works

          Common Language for All Relational Databases

    * Recent Enhancements


2 SQL Statements:


    * Types of SQL Statements

          Data Definition Language (DDL) Statements

          Data Manipulation Language (DML) Statements

          Transaction Control Statements

          Session Control Statements

          System Control Statement

          Embedded SQL Statements


3 Basic Elements of Oracle SQL

    * Datatypes

           Oracle Built-in Datatypes

           Rowid Datatypes

    * Database Objects

           Schema Objects

           Nonschema Objects

    * Schema Object Names and Qualifiers

           Schema Object Naming Rules

           Schema Object Naming Examples

           Schema Object Naming Guidelines

    * Syntax for Schema Objects and Parts in SQL Statements

          How Oracle Database Resolves Schema Object References


4 Constraints & Pseudocolumns 


5 Operators

 6 Functions


    * About SQL Functions

           Single-Row Functions

          Aggregate Functions

           Analytic Functions

           Object Reference Functions

           Model Functions


7 Expressions

 8 Conditions

 9 Common SQL DDL Clauses

 10 SQL Queries and Sub queries

 11 SQL Statements: Working with Views and MATERIALIZED VIEW

 12 SQL FAQs





































PL/SQL 9i/10g and 11g




     * New PL/SQL Features for 11g Release 1 (11.1)


1 Overview of PL/SQL


    * Advantages of PL/SQL

    * Main Features of PL/SQL

    * Architecture of PL/SQL


2 PL/SQL Language Fundamentals

    * Character Sets and Lexical Units

    * Declarations

    * Naming Conventions

    * Scope and Visibility of PL/SQL Identifiers

    * Assigning Values to Variables

    * PL/SQL Expressions and Comparisons

    * PL/SQL Error-Reporting Functions

    * Using SQL Functions in PL/SQL

    * Conditional Compilation


3 PL/SQL Data types


    * Predefined PL/SQL Scalar Data types and Subtypes

    * Predefined PL/SQL Large Object (LOB) Data types

    * User-Defined PL/SQL Subtypes

    * PL/SQL Data type Conversion


4 Using PL/SQL Control Structures


    * Overview of PL/SQL Control Structures

    * Testing Conditions (IF and CASE Statements)

           Using the IF-THEN Statement

           Using the IF-THEN-ELSE Statement

           Using the IF-THEN-ELSIF Statement

           Using the Simple CASE Statement

           Using the Searched CASE Statement

           Guidelines for IF and CASE Statements

    * Controlling Loop Iterations (LOOP, EXIT, and CONTINUE Statements)

           Using the Basic LOOP Statement

           Using the EXIT Statement

           Using the EXIT-WHEN Statement

           Using the CONTINUE Statement

           Using the CONTINUE-WHEN Statement

           Labeling a PL/SQL Loop

           Using the WHILE-LOOP Statement

           Using the FOR-LOOP Statement

                + How PL/SQL Loops Repeat

                + Dynamic Ranges for Loop Bounds

                + Scope of the Loop Counter Variable

                + Using the EXIT Statement in a FOR Loop

    * Sequential Control (GOTO and NULL Statements)

           Using the GOTO Statement

           GOTO Statement Restrictions

           Using the NULL Statement


5 .Using PL/SQL Collections and Records

 6. Using Static SQL

 7. Using Dynamic SQL

 8. Using PL/SQL Subprograms

 9. Using Triggers

 10. Using PL/SQL Packages

 11. Handling PL/SQL Errors

 12. Tuning PL/SQL Applications for Performance

 13. PL/SQL Language Elements

 14. Oracle File Management

 15. Oracle Utilities

 16. Oracles Advanced PLSQL

 17. Tuning Introduction