Header
Group Services: Technology Consulting
phone +91-9999-283-283/9540-283-283
email info@sisoft.in

Course Details

Course Outline for Oracle PL/SQL

OL 101: Introduction to Oracle

Goal:

This course is designed to aim at imparting a basic level Oracle database. After completing the course the incumbent is able to the write, execute and understand sql statement and basic PL/SQL programming.

Pre-requisites:

Student should have basic knowledge of programming.

Prepares for:

Oracle database and PL/SQL programming

Audience:

IT professionals or B.Tech / MCA students etc.

Duration:

1.5 Months (30 hours)

Course Outline:

Overview of Oracle:

  • Overview of Oracle Database and architecture
  • Overview of Transactions
  • Commit and Undo Transactions
  • Savepoints
  • Overview of Oracle SQL

Overview of SQL:

  • Use of DDL Statements to Create and Manage Tables
  • Overview of Datatypes
  • Overview of Data Integrity, Integrity Constraints & Keys
  • Data Manipulation Statements
  • DCL - Data Control Language. Some examples:
  • TCL - Transaction Control:
  • Retrieve Data using the SQL SELECT Statement
  • Learn to Restrict and Sort Data
  • Usage of Single-Row Functions to Customize Output
  • Invoke Conversion Functions and Conditional Expressions
  • Aggregate Data Using the Group Functions
  • Display Data From Multiple Tables Using Joins
  • Use Sub-queries to Solve Queries
  • The SET Operators
  • Function
  • Expressions
  • Other Schema Objects
  • Pseudocolumns

Overview of PL/SQL:

  • Understanding the basic Features of PL/SQL
  • Block Structure
  • Variables, Assignment and Operators
  • Writing Control Structures
  • Cursors
  • Cursor FOR Loops
  • Cursor Variables Attributes
  • Procedures
  • Functions
  • Packages
  • Triggers
  • Error Handling

OL 102: Advance Oracle

Goal:

This course is designed to aim at imparting advance level Oracle database. After completing the course the incumbent is able to do Advance level oracle database handling and PL/SQL programming.

Pre-requisites:

Student should have basic knowledge of oracle (OL 101)

Prepares for:

Advance level Oracle PL/SQL Programming

Audience:

IT professionals or B.Tech / MCA students etc.

Duration:

1.5 Months (30 hours)

Course Outline:

  • Advance on Oracle:
  • Advance on Oracle architecture
  • Physical Database Structures
  • Logical Database Structures
  • Schemas and Common Schema Objects
  • System Global Area
  • Program Global Area
  • Oracle Background Processes
  • Overview of Datawarehousing with oracle
  • How to Write Tuned Queries
  • Advance on Indexes
  • Concepts of View/Materialized view
  • Concepts of Table partitioning
  • Database Security

Advance on PL/SQL:

  • PL/SQL Architecture
  • OOP with PL/SQL
  • Different types of Cursors and their attributes
  • IF Vs. CASE
  • Working with Collections
  • Concept of BULK
  • Use of built-in oracle packages.
  • Use of advance features of packages
  • Use of Dynamic SQL
  • Tuning PL/SQL Application
  • Concepts on creating flat files.