Oracle Apex with SQL & 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. 30,000

Book your Seat

Hotline: +8801976 002 001, +88 02 9615991

info@cloudsolutionltd.com

ashim@cloudsolutionltd.com

  • Class:01

Introduction:

  • Oracle Database
  • Relational Database Technology
  • Oracle Application Express
  • Anatomy of a SQL Statement
  • Class:02

Retrieving Data by SQL (Structured Query Language):

  • Query Commands

Data Change Commands:

  • SELECT
  • INSERT
  • UPDATE
  • DELETE
  • MARGE

Database Structure Change Commands:

  • CREATE
  • ALTER
  • DROP
  • RENAME
  • TRUNCATE
  • COMMENT
  • Class:03

Single Row Functions:

  • Case and Character Manipulation
  • Number Functions
  • Date Functions
  • Conversion Functions
  • NULL Functions
  • Conditional Expressions

JOINs:

  • Cross Joins and Natural Joins
  • Join Clauses
  • Inner versus Outer Joins
  • Self-Joins and Hierarchical Queries
  • Oracle Equijoin and Cartesian Product
  • Oracle Non-equijoins and Outer Joins

Group Functions:

  • Group Functions
  • Oracle Non-equijoins and Outer Joins
  • Using GROUP BY and HAVING Clauses
  • Using Set Operators
  • Class:04

Subqueries:

  • Fundamentals of Sub-queries
  • Single-Row Sub-queries
  • Multiple-Row Sub-queries
  • Correlated Sub-queries

DML (Database Manipulating Language):

  • INSERT Statements
  • Updating Column Values and Deleting Rows
  • DEFAULT Values, MERGE, and Multi-Table Inserts
  • Class:05

DDL (Database Definition Language):

  • Creating Tables
  • Using Data Types
  • Modifying a Table

Constraints:

  • Intro to Constraints; NOT NULL and UNIQUE Constraints
  • PRIMARY KEY, FOREIGN KEY, and CHECK Constraints
  • Managing Constraints
  • Class:06

PL/SQL

Fundamentals:

  • Introduction to PL/SQL
  • Benefits of PL/SQL
  • Creating PL/SQL Blocks
  • Class:07

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:08

Using SQL in PL/SQL Block:

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

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:09

Exception Handling:

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

Using and Managing Procedures:

  • Creating Procedures
  • Using Parameters in Procedures
  • Passing Parameters
  • Class:10

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:11

Using and Managing Packages:

  • Creating Packages
  • Managing Package Concepts
  • Advanced Package Concepts
  • Class:12

Using and Managing Triggers:

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

Introducing Oracle Application Express:

  • Application Express Overview
  • Application Express Terms and Concepts
  • Using Application Express
  • Class:14

Creating a Desktop and Mobile Database Application:

  • Application Builder Overview
  • Introducing Database Applications
  • Creating Database Applications
  • Creating Mobile Application
  • Class:15

Working with Reports for Desktop Application:

  • Introducing Reports
  • Using Classic Reports
  • Using Interactive Reports
  • Creating and Customizing an Interactive Report
  • Class:16

Working with Reports for Mobile Application:

  • Creating Reports for a Mobile Application
  • Creating Column Toggle Report
  • Creating a Reflow Report
  • Class:17

Creating Forms:

  • Using Forms
  • Creating Forms
  • Modifying Forms
  • Creating a Form in a Mobile Application
  • Class:18

Working with Pages and Regions:

  • Introducing Page Definition
  • Working with Page Regions
  • Working with Pages
  • Class:19

Adding Items and Buttons:

  • Introducing Items
  • Using Items
  • Creating List of Value (LOV) Type of Items
  • Using Buttons
  • Class:20

Understanding Session State:

  • Understanding Session State in Oracle Application Express
  • Using Session State in Oracle Application Express
  • Class:21

Including Page Processing:

  • Introducing Page Processing
  • Including Computations
  • Including Processes
  • Including Validations
  • Including Branches
  • Class:22

Adding Shared Components That Aid Navigation:

  • Introducing Shared Components
  • Creating Tabs
  • Creating Lists
  • Creating Breadcrumbs
  • Creating a Navigational Bar
  • Class:23

Working with Themes, Templates and Files:

  • Using Themes
  • Using Templates
  • Using Files
  • Class:24

Creating and Editing Charts:

  • Creating and Using Charts
  • Enhanced Charting Examples
  • Class:25

Adding Calendars and Trees:

  • Using Calendars
  • Using Trees
  • Class:26

Using Dynamic Actions and Plug-Ins:

  • Using Dynamic Actions
  • Using Plug-Ins
  • Class:27

Utilizing Application Express Printing:

  • Printing a Standard Report with Derived Output
  • Class:28

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