Oracle 11g Contents

SQL 9i/10g and 11g

Introduction to RDBMS

What is New in the SQL Language?Oracle Database 11g Release 1 New Features in the SQL Language Reference

Introduction to Oracle SQL

* History of SQL
* SQL Standards
* How SQL Works
* Common Language for All Relational Databases
* Recent Enhancements

SQL Statements:

Types of SQL Statements

Constraints & Pseudocolumns

Operators

Functions

* About SQL Functions
* Single-Row Functions
* Aggregate Functions
* Analytic Functions
* Object Reference Functions
* Model Functions

Expressions

Conditions

Common SQL DDL Clauses
SQL Queries and Sub queries

SQL Statements: Working with Views and MATERIALIZED VIEW

SQL FAQs

PL/SQL 9i/10g and 11g

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

Overview of PL/SQL

Advantages of PL/SQL
Main Features of PL/SQL
Architecture of PL/SQL

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

PL/SQL Data types

* Predefined PL/SQL Scalar Datatypes and Subtypes
* Predefined PL/SQL Large Object (LOB) Datatypes
* User-Defined PL/SQL Subtypes
* PL/SQL Datatype Conversion

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

Using PL/SQL Collections and Records

Using Static SQL

Using Dynamic SQL

Using PL/SQL Subprograms

Using Triggers

Using PL/SQL Packages

Handling PL/SQL Errors

Tuning PL/SQL Applications for Performance

PL/SQL Language Elements

Oracle File Management

Oracle Utilities

Oracles Advanced PLSQL

Tuning Introduction

PL/SQL FAQs

* Data Definition Language (DDL) Statements
* Data Manipulation Language (DML) Statement
* Transaction Control Statement
* Session Control Statements
* System Control Statement
* Embedded SQL Statements

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