Oracle OCA course for Working professional by LogiqueMantra

Database Design

o Database Models
o Beginnings
o Some Introductory Terminology
o Codd s 12 Rules
o Normalization
o First Normal Form
o Higher Order Normal Forms

Oracle Standard Interfaces

o SQL
o SQL*Plus
o Oracle Architecture
o Interfaces to Oracle
o Command Line Interface
o Viewing a Sample Table
o The Graphical User Interface
o The SQL Buffer
o The Web-Based Interface
o Describe

The Sample Database

o The Entity Relationship Model
o Entity Relationship Diagrams
o The Sample Database
o ER Diagram for Sample Database
o Creating the Sample Data
o Viewing Sample Data
o Data Types of the Sample Data

Data Definition Language

o Categories of SQL Statements
o Oracle Datatypes
o The CREATE Statement
o The DROP Command
o The ALTER Command
o Integrity Constraints
o Entity Integrity Constraints
o Referential Integrity Constraints
o Modifying Table to Use Constraints
o Checking Constraints
o The Data Dictionary
Introduction PLSQL

o SQL vs. PL/SQL
o A Few Simple Examples
o Saving Procedures
o A More Complete Picture
o Comments
o Variable Substitution
o Simple Exception Handling
o Advantages of PL/SQL
o Assignments

Declarations and Data Types

o Declarations
o Standard Data Types
o Initialization
o Variable Names
o Specialized Data Types - %TYPE
o Specialized Data Types - %ROWTYPE
o Building Your Own Data Types - Records
o A Quick look at Loops
o Arrays
o Tables
o Nested Blocks

Language Components

o Introduction
o Assignments
o Decision Making Statements
o Simple Loops
o Loops - for
o Loops - indefinite
o Loops - while
o Simple Loops
o Nested Loops
o Boolean Variables
o PL/SQL Relational Operators
o PL/SQL Logical Operators
o The CASE Construct

Cursors

o Introduction
o Cursor Manipulation
o Using the Cursor
o For Loops Cursors
o Cursor Attributes
o Cursor Parameters
o Nested Cursors
o Cursor Exceptions

Data Manipulation Language

o DML Statements
o The SELECT Statement
o The INSERT Statement
o The DELETE Statement
o The UPDATE Statement
o More SQL*Plus Commands

Transaction Control

o Transactions
o Command Classification
o Savepoints
o The SET TRANSACTION Command

SQL Operators

o Simple Selects
o Comparison Operators
o IN and NOT IN Operators
o BETWEEN Operator
o The LIKE Operator
o Logical Operators
o IS NULL and IS NOT NULL
o ANY
o ALL

SQL FUNCTIONS

o Introduction
o The DISTINCT Keyword
o Aliases
o Miscellaneous Functions
o Mathematical Functions
o String Functions
o Date Functions
o Conversion Functions
o Pseudo Columns

Joining Tables

o Joins
o Cartesian Product
o Inner Joins
o Equi-Join
o Table Aliases
o Non-Equi Join
o Non-Key Join
o Reflexive Join
o Natural Join
o Outer Joins
o Right Outer Join
o Left Outer Join
o Full Outer Join
o Oracle-Specific Syntax for Outer Joins
Exceptions

o Errors in Programs
o Run Time Exceptions
o Oracle Built In Exceptions
o Unnamed Exceptions
o Built in Exception Functions
o Creating Your Own Exceptions
o Building Non Terminating Exceptions

Functions and Procedures

o Introduction
o Creating a Procedure
o Example Procedure
o Using Parameters
o Functions
o Procedures and Exceptions

An SQL and SQL*Plus Reference

o DDL Statements
o DML Statements
o Transaction Control Statements
o Operators

Set Operators

o Introduction
o Selection Criteria
o Union
o Union All
o Intersect
o Minus

SQL Subqueries

o Introduction
o Using a Subquery with a DML Statement
o Typical Subqueries
o Subquery Operators
o Standard vs. Correlated Subqueries
o Correlated Subquery Example
o Predicate Operators

Groups

o SQL Statements
o GROUP BY Clause
o HAVING Clause
o Order of a SELECT Statement

More Database Objects

o More Database Objects
o Relational Views
o Updating a View
o Create or Replace
o Forcing a View
o The Data Dictionary Revisited
o Indexes
o Synonyms

Reports

o Report Features
o Session Control
o The SET Command
o The COLUMN Command
o The BREAK Command
o The COMPUTE Command