Database Programming with PL/SQL

  • Start Date: March 2018
  • Duration: (6:00 pm - 9:00 pm)
  • Number of sessions: 25
  • Class Schedule: Sun, Tue, Thu
  • Total Hours: 80
  • Certificate: Yes

Fee: Tk. 10,000

Book your Seat

Hotline: +8801976 002 001, +88 02 9615991

info@cloudsolutionltd.com

ashim@cloudsolutionltd.com

  • Objectives:

This course introduces students to PL/SQL, Oracle’s procedural extension language for SQL and the Oracle relational database. Participants explore the differences between SQL and PL/SQL. They also examine the characteristics of PL/SQL and how it is used to extend and automate SQL to administer the Oracle database.
This course culminates with a project that challenges students to program, implement, and demonstrate a database solution for a business or organization.

Some Example of Apex developed Application Link:
https://shop.oracle.com
https://asktom.oracle.com
https://cloud-aps.com/apex/f?p=955
https://cloud-aps.com/apex/f?p=929

  • Class:01

Fundamentals:

  • Introduction to PL/SQL
  • Benefits of PL/SQL
  • Creating PL/SQL Blocks

Defining Variables and Datatypes:

  • Using Variables in PL/SQL
  • Recognizing PL/SQL Lexical Units
  • Recognizing Data Types
  • Using Scalar Data Types
  • Writing PL/SQL Executable Statements
  • Nested Blocks and Variable Scope
  • Good Programming Practices
  • Class:02

Using SQL in PL/SQL Block:

  • Review of SQL DML
  • Retrieving Data in PL/SQL
  • Manipulating Data in PL/SQL
  • Using Transaction Control Statements
  • Class:03

Program Structures to Control Execution Flow:

  • Conditional Control: IF Statements
  • Conditional Control: CASE Statements
  • Iterative Control: Basic Loops
  • Iterative Control: WHILE and FOR Loops
  • Iterative Control: FOR Loops
  • Iterative Control: Nested Loops
  • Class:04

Using Cursors and Parameters:

  • Introduction to Explicit Cursors
  • Using Explicit Cursor Attributes
  • Cursor FOR Loops
  • Cursors with Parameters
  • Using Cursors for UPDATE
  • Using Multiple Cursors
  • Class:05

Using Composite Datatypes:

  • User-Defined Records
  • Indexing Tables of Records

Exception Handling:

  • Handling Exceptions
  • Trapping Oracle Server Exceptions
  • Trapping User-Defined Exceptions
  • Recognizing the Scope of Exceptions
  • Class:06

Using and Managing Procedures:

  • Creating Procedures
  • Using Parameters in Procedures
  • Passing Parameters

Using and Managing Functions:

  • Creating Functions
  • Using Functions in SQL Statements
  • Review of the Data Dictionary
  • Managing Procedures and Functions
  • Review of Object Privileges
  • Using Invoker's Rights and Autonomous Transactions
  • Class:07

Using and Managing Packages:

  • Creating Packages
  • Managing Package Concepts
  • Advanced Package Concepts

Getting the Best out of packages:

  • Persistent State of Package Variables
  • Using Oracle-Supplied Packages
  • Class:08

Improving PL/SQL Performance:

  • Using Dynamic SQL
  • Improving PL/SQL Performance

Using and Managing Triggers:

  • Introduction to Triggers
  • Creating DIVIL Triggers, Part
  • Creating DML Triggers, Part
  • Creating DDL and Database Event Triggers
  • Managing Triggers
  • Class:09

Recognizing and Managing Dependencies:

  • Introduction to Dependencies
  • Understanding Remote Dependencies

Using the PL/SQL Compiler:

  • Using PL/SQL Initialization Parameters
  • Displaying Compiler Warning Messages
  • Using Conditional Compilation
  • Hiding Your Source Code
  • Class:10

Final Exam & Review

  • Testing
  • Final Exam Review
profile

Ashim Kumar Sikder

CTO, Cloud Solution Ltd.

8 years working experience in Apex

Read More
profile

Md Zahidul Islam

Senior Software Developer

2 years working experience in Apex

Read More
  • Who can participate
  • Beginer can participate. Basic SQL, HTML skills are helpful, but not essential
  • Methodology
  • The training is fully hands on. Our strategy is making confidence by doing through hands on labs with real life example as well as power point presentation
  • Reference Oracle Training
  • Vendor Certification: After complete this training course you can attend Oracle Vendor exam
  • Tea-break and Lunch during the workshop

  • Certificate after course