Oracle Syllabus

SQL


Writing Basic SQL SELECT Statements

check icon Basic SELECT Statement
check icon Selecting All Columns
check icon Selecting Specific Columns
check icon Writing SQL Statements
check icon Column Heading Defaults
check icon Arithmetic Expressions
check icon Using Arithmetic Operators
check icon Operator Precedence
check icon Using Parentheses
check icon Defining a Null Value
check icon Null Values in Arithmetic Expressions
check icon Defining a Column Alias
check icon Using Column Aliases
check icon Concatenation Operator
check icon Using the Concatenation Operator
check icon Literal Character Strings
check icon Using Literal Character Strings
check icon Duplicate Rows
check icon Eliminating Duplicate Rows

Restricting and Sorting Data

check icon Limiting Rows Using a Selection
check icon Limiting the Rows Selected
check icon Using the WHERE Clause
check icon Character Strings and Dates
check icon Comparison Conditions
check icon Using Comparison Conditions
check icon Other Comparison Conditions
check icon Using the BETWEEN Condition
check icon Using the IN Condition
check icon Using the LIKE Condition
check icon Using the NULL Conditions
check icon Logical Conditions
check icon Using the AND Operator
check icon Using the OR Operator
check icon Using the NOT Operator
check icon Rules of Precedence
check icon ORDER BY Clause
check icon Sorting in Descending Order
check icon Sorting by Column Alias
check icon Sorting by Multiple Columns

Single-Row Functions

check icon SQL Function
check icon Two Types of SQL Functions
check icon Single-Row Functions
check icon Single-Row Functions
check icon Character Functions
check icon Character Functions
check icon Case Manipulation Functions
check icon Using Case Manipulation Functions
check icon Character-Manipulation Functions
check icon Using the Character-Manipulation Functions
check icon Number Functions
check icon Using the ROUND Function
check icon Using the TRUNC Function
check icon Using the MOD Function
check icon Working with Dates
check icon Arithmetic with Dates
check icon Using Arithmetic Operators with Dates
check icon Date Functions
check icon Using Date Functions
check icon Practice 3, Part One:
check icon Conversion Functions
check icon Implicit Data Type Conversion
check icon Explicit Data Type Conversion
check icon Using the TO_CHAR Function with Dates
check icon Elements of the Date Format Model
check icon Using the TO_CHAR Function with Dates
check icon Using the TO_CHAR Function with Numbers
check icon Using the TO_NUMBER and TO_DATE Functions
check icon RR Date Format
check icon Example of RR Date Format
check icon Nesting Functions
check icon General Functions
check icon NVL Function
check icon Using the NVL Function
check icon Using the NVL2 Function
check icon Using the NULLIF Function
check icon Using the COALESCE Function
check icon Conditional Expressions
check icon The CASE Expression
check icon Using the CASE Expression
check icon The DECODE Function
check icon Using the DECODE Function

Displaying Data from Multiple Tables

check icon Obtaining Data from Multiple Tables
check icon Cartesian Products
check icon Generating a Cartesian Product
check icon Types of Joins
check icon Joining Tables Using Oracle Syntax
check icon What is an Equijoin?
check icon Retrieving Records with Equijoins
check icon Additional Search Conditions Using the AND Operator
check icon Qualifying Ambiguous Column Names
check icon Using Table Aliases
check icon Joining More than Two Tables
check icon Non-Equijoins
check icon Retrieving Records with Non-Equijoins
check icon Outer Joins Outer Joins Syntax
check icon Using Outer Joins
check icon Self Joins
check icon Joining a Table to Itself
check icon Joining Tables Using SQL: 1999 Syntax
check icon Creating Cross Joins
check icon Creating Natural Joins
check icon Retrieving Records with Natural Joins
check icon Creating Joins with the USING Clause
check icon Retrieving Records with the USING Clause
check icon Creating Joins with the ON Clause
check icon Retrieving Records with the ON Clause
check icon Creating Three-Way Joins with the ON Clause
check icon INNER Versus OUTER Joins
check icon LEFT OUTER JOIN
check icon RIGHT OUTER JOIN
check icon FULL OUTER JOIN
check icon Additional Conditions

Aggregating Data Using Group Functions

check icon What Are Group Functions?
check icon Types of Group Functions
check icon Group Functions Syntax
check icon Using the AVG and SUM Functions
check icon Using the MIN and MAX Functions
check icon Using the COUNT Function
check icon Using the DISTINCT Keyword
check icon Group Functions and Null Values
check icon Using the NVL Function with Group Functions
check icon Creating Groups of Data
check icon Creating Groups of Data: The GROUP BY Clause Syntax
check icon Using the GROUP BY Clause
check icon Grouping by More Than One Column
check icon Using the GROUP BY Clause on Multiple Columns
check icon Illegal Queries Using Group Functions
check icon Excluding Group Results
check icon Excluding Group Results: The HAVING Clause
check icon Using the HAVING Clause
check icon Nesting Group Functions

Subqueries

check icon Objectives
check icon Using a Subquery to Solve a Problem
check icon Subquery Syntax
check icon Using a Subquery
check icon Guidelines for Using Subqueries
check icon Types of Subqueries
check icon Single-Row Subqueries
check icon Executing Single-Row Subqueries
check icon Using Group Functions in a Subquery
check icon The HAVING Clause with Subqueries
check icon What is Wrong with this Statement?
check icon Will this Statement Return Rows?
check icon Multiple-Row Subqueries
check icon Using the ANY Operator in Multiple-Row Subqueries
check icon Using the ALL Operator in Multiple-Row Subqueries
check icon Null Values in a Subquery

Manipulating Data

check icon Data Manipulation Language
check icon Adding a New Row to a Table
check icon The INSERT Statement Syntax 8-5
check icon Inserting New Rows
check icon Inserting Rows with Null Values
check icon Inserting Special Values
check icon Inserting Specific Date Values
check icon Creating a Script
check icon Copying Rows from Another Table
check icon Changing Data in a Table
check icon The UPDATE Statement Syntax
check icon Updating Rows in a Table
check icon Updating Two Columns with a Subquery
check icon Updating Rows Based on Another Table
check icon Updating Rows: Integrity Constraint Error
check icon Removing a Row from a Table
check icon The DELETE Statement
check icon Deleting Rows from a Table
check icon Deleting Rows Based on Another Table
check icon Deleting Rows: Integrity Constraint Error
check icon Using a Subquery in an INSERT Statement
check icon Using the WITH CHECK OPTION Keyword on DML Statements
check icon Overview of the Explicit Default Feature
check icon Using Explicit Default Values
check icon The MERGE Statement
check icon The MERGE Statement Syntax
check icon Merging Rows
check icon Database Transactions
check icon Advantages of COMMIT and ROLLBACK Statements
check icon Controlling Transactions
check icon Rolling Back Changes to a Marker
check icon Implicit Transaction Processing
check icon State of the Data Before COMMIT or ROLLBACK
check icon State of the Data after COMMIT
check icon Committing Data
check icon State of the Data After ROLLBACK
check icon Statement-Level Rollback
check icon Read Consistency
check icon Implementation of Read Consistency
check icon Locking
check icon Implicit Locking
check icon Read Consistency Example

Creating and Managing Tables

check icon Database Objects
check icon Naming Rules
check icon The CREATE TABLE Statement
check icon Referencing Another User?s Tables
check icon The DEFAULT Option
check icon Creating Tables
check icon Tables in the Oracle Database
check icon Querying the Data Dictionary 9-10
check icon Data Types
check icon DateTime Data Types
check icon TIMESTAMP WITH TIME ZONE Data Type
check icon TIMESTAMP WITH LOCAL TIME Data Type
check icon INTERVAL YEAR TO MONTH Data Type
check icon INTERVAL DAY TO SECOND Data Type
check icon Creating a Table by Using a Subquery Syntax
check icon Creating a Table by Using a Subquery
check icon The ALTER TABLE Statement
check icon Adding a Column
check icon Modifying a Column
check icon Dropping a Column
check icon The SET UNUSED Option
check icon Dropping a Table
check icon Changing the Name of an Object
check icon Truncating a Table
check icon Adding Comments to a Table

Including Constraints

check icon What are Constraints?
check icon Constraint Guidelines
check icon Defining Constraints
check icon The NOT NULL Constraint
check icon The UNIQUE Constraint
check icon The PRIMARY KEY Constraint
check icon The FOREIGN KEY Constraint
check icon FOREIGN KEY Constraint Keywords
check icon The CHECK Constraint
check icon Adding a Constraint Syntax
check icon Adding a Constraint
check icon Dropping a Constraint
check icon Disabling Constraints
check icon Enabling Constraints
check icon Cascading Constraints
check icon Viewing Constraints
check icon Viewing the Columns Associated with Constraints

Creating Views

check icon Database Objects
check icon What is a View?
check icon Why use Views?
check icon Simple Views and Complex Views
check icon Creating a View
check icon Retrieving Data from a View
check icon Querying a View
check icon Modifying a View
check icon Creating a Complex View
check icon Rules for Performing DML Operations on a View
check icon Using the WITH CHECK OPTION Clause
check icon Denying DML Operations
check icon Removing a View
check icon Inline Views
check icon Top-N Analysis
check icon Performing Top-N Analysis
check icon Example of Top-N Analysis

Other Database Objects

check icon Database Objects
check icon What is a Sequence?
check icon The CREATE SEQUENCE Statement Syntax
check icon Creating a Sequence
check icon Confirming Sequences
check icon NEXTVAL and CURRVAL Pseudocolumns
check icon Using a Sequence
check icon Modifying a Sequence
check icon Guidelines for Modifying a Sequence
check icon Removing a Sequence
check icon What is an Index?
check icon How Are Indexes Created?
check icon Creating an Index
check icon When to Create an Index
check icon When Not to Create an Index
check icon Confirming Indexes
check icon Function-Based Indexes
check icon Removing an Index
check icon Creating and Removing Synonyms

Controlling User Access

check icon Objectives
check icon Controlling User Access
check icon Privileges
check icon System Privileges
check icon Creating Users
check icon User System Privileges
check icon Granting System Privileges
check icon What is a Role?
check icon Creating and Granting Privileges to a Role
check icon Changing Your Password
check icon Object Privileges
check icon Granting Object Privileges
check icon Using the WITH GRANT OPTION and PUBLIC Keywords
check icon Confirming Privileges Granted
check icon How to Revoke Object Privileges
check icon Revoking Object Privileges
check icon Database Links

SQL Workshop

check icon Workshop Overview

Using SET Operators

check icon The SET Operators
check icon Tables Used in This Lesson
check icon The UNION Operator
check icon Using the UNION Operator
check icon The UNION ALL Operator
check icon Using the UNION ALL Operator
check icon The INTERSECT Operator
check icon Using the INTERSECT Operator
check icon The MINUS Operator
check icon SET Operator Guidelines
check icon The Oracle Server and SET Operators
check icon Matching the SELECT Statements
check icon Controlling the Order of Rows

Enhancements to the GROUP BY Clause

check icon Review of Group Functions
check icon Review of the GROUP BY Clause
check icon Review of the HAVING Clause
check icon GROUP BY with ROLLUP and CUBE Operators
check icon ROLLUP Operator
check icon ROLLUP Operator Example
check icon CUBE Operator
check icon CUBE Operator: Example
check icon GROUPING Function
check icon GROUPING Function: Example
check icon GROUPING SETS
check icon GROUPING SETS: Example
check icon Composite Columns
check icon Composite Columns: Example
check icon Concatenated Groupings
check icon Concatenated Groupings Example

Advanced Subqueries

check icon What Is a Subquery?
check icon Subqueries
check icon Using a Subquery
check icon Multiple-Column Subqueries
check icon Column Comparisons
check icon Pairwise Comparison Subquery
check icon Nonpairwise Comparison Subquery
check icon Using a Subquery in the FROM Clause
check icon Scalar Subquery Expressions
check icon Scalar Subqueries: Examples
check icon Correlated Subqueries
check icon Using Correlated Subqueries
check icon Using the EXISTS Operator
check icon Using the NOT EXISTS Operator
check icon Correlated UPDATE
check icon Correlated DELETE
check icon The WITH Clause
check icon WITH Clause: Example

Hierarchical Retrieval

check icon Sample Data from the EMPLOYEES Table
check icon Natural Tree Structure
check icon Hierarchical Queries
check icon Walking the Tree
check icon Walking the Tree: From the Bottom Up
check icon Walking the Tree: From the Top Down
check icon Ranking Rows with the LEVEL Pseudocolumn
check icon Formatting Hierarchical Reports Using LEVEL and LPAD
check icon Pruning Branches

Extensions to DML and DDL Statements

check icon Review of the INSERT Statement
check icon Review of the UPDATE Statement
check icon Overview of Multitable INSERT Statements
check icon Overview of Multitable INSERT Statements
check icon Types of Multitable INSERT Statements
check icon Multitable INSERT Statements
check icon Unconditional INSERT ALL
check icon Conditional INSERT ALL
check icon Conditional FIRST INSERT
check icon Pivoting INSERT
check icon External Tables
check icon Creating an External Table
check icon Example of Creating an External Table
check icon Querying External Tables
check icon CREATE INDEX with CREATE TABLE Statement

Plsql syllabus


Part I: Programming in PL/SQL

check icon Introduction to PL/SQL
check icon What Is PL/SQL?
check icon The Origins of PL/SQL
check icon About PL/SQL Versions
check icon Resources for PL/SQL Developers

Creating and Running PL/SQL Code

check icon SQL*Plus
check icon Performing Essential PL/SQL Tasks
check icon Calling PL/SQL from Other Languages
check icon Language Fundamentals
check icon PL/SQL Block Structure
check icon The PL/SQL Character Set
check icon Identifiers
check icon Literals
check icon The Semicolon Delimiter
check icon Comments
check icon The PRAGMA Keyword
check icon Labels

Part II: PL/SQL Program Structure

check icon Conditional and Sequential Control
check icon IF Statements
check icon CASE Statements and Expressions
check icon The GOTO Statement
check icon The NULL Statement
check icon Iterative Processing with Loops

Loop Basics

check icon The Simple Loop
check icon The WHILE Loop
check icon The Numeric FOR Loop
check icon The Cursor FOR Loop
check icon Loop Labels
check icon Tips for Iterative Processing

Exception Handlers

check icon Exception-Handling Concepts and Terminology
check icon Defining Exceptions
check icon Raising Exceptions
check icon Handling Exceptions
check icon Building an Effective Error Management Architecture
check icon Making the Most of PL/SQL Error Management

Part III: PL/SQL Program Data

check icon Working with Program Data
check icon Naming Your Program Data
check icon Overview of PL/SQL Datatypes
check icon Declaring Program Data
check icon Programmer-Defined Subtypes
check icon Conversion Between Datatypes

Strings

check icon String Datatypes
check icon Working with Strings
check icon String Function Quick Reference

Numbers

check icon Numeric Datatypes
check icon Number Conversions
check icon Numeric Functions

Records


check icon Records in PL/SQL

Collections

check icon Collections Overview
check icon Collection Methods (Built-Ins)
check icon Working with Collections
check icon Nested Table Multiset Operations
check icon Maintaining Schema-Level Collections

Miscellaneous Datatypes

check icon The BOOLEAN Datatype
check icon The RAW Datatype
check icon The UROWID and ROWID Datatypes
check icon The LOB Datatypes
check icon Working with LOBs
check icon Predefined Object Types

Part IV: SQL in PL/SQL

check icon DML and Transaction Management
check icon DML in PL/SQL
check icon Bulk DML with the FORALL Statement
check icon Transaction Management
check icon Autonomous Transactions

Data Retrieval

check icon Cursor Basics
check icon Working with Implicit Cursors
check icon Working with Explicit Cursors
check icon BULK COLLECT
check icon SELECT ... FOR UPDATE
check icon Cursor Variables and REF CURSORs
check icon Cursor Expressions

Procedures, Functions, and Parameters

check icon Procedures
check icon Functions
check icon Parameters
check icon Local Modules
check icon Module Overloading
check icon Forward Declarations
check icon Advanced Topics
check icon Go Forth and Modularize!

Packages

check icon Why Packages?
check icon Rules for Building Packages
check icon Rules for Calling Packaged Elements
check icon Working with Package Data
check icon When to Use Packages
check icon Packages and Object Types

Triggers

check icon DML Triggers
check icon DDL Triggers
check icon Database Event Triggers
check icon INSTEAD OF Triggers
check icon AFTER SUSPEND Triggers
check icon Maintaining Triggers

Managing PL/SQL Code

check icon Managing Code in the Database
check icon Using Native Compilation
check icon Using the Optimizing Compiler and Compile-Time Warnings
check icon Conditional Compilation
check icon Testing PL/SQL Programs
check icon Debugging PL/SQL Programs
check icon Tuning PL/SQL Programs
check icon Protecting Stored Code

I/O and PL/SQL

check icon Displaying Information
check iconReading and Writing Files
check iconSending Email
check iconWorking with Web-Based Data (HTTP)
check iconOther Types of I/O Available in PL/SQL

Oracle Forms


Oracle Forms Developer 10g: Build Internet Applications

check icon Introducing Oracle Forms Developer and Forms Services
check icon Grid Computing
check icon Oracle 10g Products
check icon Oracle Application Server 10g Architecture
check icon Benefits and Components of Oracle Developer Suite 10g
check icon Running a Forms Developer Application
check icon Working in the Forms Developer Environment
check icon Creating Forms Modules
check icon Working with Data Blocks and Frames
check icon Working with Input Items
check icon Working with Non Input Items
check icon Working with Windows and Canvases
check icon Producing Triggers
check icon Debugging Triggers
check icon Adding Functionality to Items
check icon Run-Time Messages and Alerts
check icon Query Triggers
check icon Validation
check icon Navigation
check icon Transaction Processing
check icon Sharing Objects and Code
check icon Using WebUtil to Interact with the Client
check icon Introducing Multiple Form Applications

Oracle Reports


Oracle Reports Developer 10g: Build Reports

check icon Introduction to Oracle Reports Developer
check icon Business Intelligence
check icon Enterprise Reporting
check icon Oracle Reports Developer
check icon Oracle Database 10g
check icon Oracle Developer Suite 10g
check icon Oracle Application Server 10g
check icon OracleAS Reports Services
check icon OracleAS Reports Services Architecture for the Web
check icon Designing and Running Reports
check icon Exploring Oracle Reports Developer
check icon Creating a Paper Report
check icon Enhancing a Basic Paper Report
check icon Managing Report Templates
check icon Creating a Web Report
check icon Enhancing Reports Using the Data Model: Queries and Groups
check icon Enhancing Reports Using the Data Model: Data Sources
check icon Enhancing Reports Using the Data Model: Creating Columns
check icon Enhancing Reports Using the Paper Layout
check icon Controlling the Paper Layout: Common Properties
check icon Controlling the Paper Layout: Specific Properties
check icon Web Reporting
check icon Extending Functionality Using XML
check icon Creating and Using Report Parameters
check icon Embedding a Graph in a Report
check icon Enhancing Matrix Reports
check icon Coding PL/SQL Triggers
check icon Extending Functionality Using the SRW Package
check icon Maximizing Performance Using
check icon OracleAS Reports Services
check icon Building Reports: Efficiency Guidelines
check icon Working with SQL Worksheet
check icon Using SQL Developer


Enquiry Form