Oracle PL/SQL Developer Curriculum

Day 1

• Introduction to Oracle

• SQL Overview

o What is SQL

o Why SQL

Day 2

• SQL Process

• SQL Commands

o DDL and DML

Day 3

• SQL RDBMS Concepts

o Tables

o Fields

o Constraints

o Keys

o Other objects

Day 4

• SQL RDBMS Database

o ORACLE Features

o SQL Syntax

o Data types

Day 5

• SQL RDBMS Database (continue…)

o SQL Operators

o SQL Commands

o SQL Functions

Day 6

• Introduction to PL/SQL

o Need for PL/SQL

o Benefits of PL/SQL

o Different types of PL/SQL blocks

 o Environment setup

Day 7

• Basic Syntax

o PL/SQL identifiers, Delimiters and Comments

o PL/SQL Program Units

o Data Types

Day 8

• Variables

o Constants

o Operators

o Examples

Day 9

• Conditions/flow charts

o If – then

o If – then – else

o If – then – elsif

Day 10

• Loops

o For loop

o Exit when

o While loop

Day 11

• Test and Assessment of syllabus covered so far

• Allocation of Project work Assignment for Next day

• Project should be turned in within 20 hours

Day 12

• Pl/sql functions

o Lower

o Upper

o NVL, ETC

Day 13

• Procedures

o Parts of subprogram

o Creating procedure

 o Executing procedure

Day 14

• Cursors with in procedure

o Explicit cursors

o Declaring and handling cursors

Day 15

• Records

Day 16

• Exception handling

Day 17

• Test and Assessment of syllabus covered so far

• Allocation of Project work Assignment for Next day

• Project should be turned in within 20 hours

Day 18

• Review of project work

• Allocation of Seminar Assignments for students who will prepare on the topics

Allocated to them to present In the Next class

Day 19

• Review of project work and Seminar

Day 20

• Triggers

o Benefits

o Creating

o Examples

 o Triggering

Day 21

• Triggers (continue…)

Day 22

• Functions

o Benefits

o Creating

o Examples

Day 23

• Functions (continue…)

Day 24

• Functions (continue…)

Day 25

• Test and Assessment of syllabus covered so far

• Allocation of Project work Assignment for Next day

• Project should be turned in within 20 hours

Day 26

• Test and Assessment of syllabus covered so far

Day 27

• Packages

o Specifications

o Package body

o Package body elements

Day 28

• Packages (continue…)

Day 29

 • Packages (continue…)