Oracle SQL PL/SQL Must read Topics

Business and Data
Old way of storing the data
Database and its usage in a business
Types of Databases
What is RDBMS?
RDBMS Concepts
Codd’s rules

Real world entities (things) which runs the business
Relationship between different entities
Examples which explains the different relation
Conceptual model
Normalization
Logical Modeling

Introduction to Oracle
Oracle RDBMS

Structured Query Language (SQL)

Tables and usage
Data types and constraints
Data Definition Language
Create / Alter / Drop tables
Defining Primary Key and Foreign Key
Data Manipulation Language
Select,
Insert
Update and
Delete statements (Simple)
Data Control Language
Security in Oracle database
Grant and Revoke of permissions.
Simple Selects
Order by clauseSQL functions
String functions
Number functions
Date functions
Group by – selects
Insert Statements (Different Syntax)
Update Statement
Delete Statement, TRUNCATE
Joins
Simple / Equi join
Outer Join (left, right)
ANSI SQL (way of writing)
Full Outer join
Sub query
Co related Sub query
Set Operators
Derived Tables
Data Dictionary
Views
Sequences
Synonyms
Indexes

Database Programming Language (Oracle – PL/SQL)


What is PL/SQL?
Structure of PL/SQL (Blocks)
Variables in PL/SQL
Conditional Statements
Loops
Conditional Loop
Un Conditional Loop
Exceptions
NO_DATA_FOUND
DUP_VAL_ON_INDEX
TOO_MANY_ROWS
ZERO_DIVIDE etc
User Defined exception
Block with in a Block (Scope of variables)
Exception handling with in sub blocks
Commit and Rollback Statements
Cursors
Cursor Types
Cursor Attributes
FOR update cursor
Exceptions related to cursors
Stored procedures
Advantages of Stored procedures
Passing parameters to Stored procedure (IN, OUT)
Functions
Differences between stored procedure and function
Advantages of function
Packages
Global Variables
Local procedures, functions with in a package
Triggers
Statement Level Triggers
Row Level Triggers
Instead of Triggers
Execute Immediate (Dynamic SQL)
DBMS PACKAGES
PL/SQL Tables (Array data types)
Bulk Bind (Advantages over cursors)
UTL_FILE (Dealing with Files from stored programs)