Corvit Systems Peshawar proudly offers a specialized Oracle Developer course designed to build strong foundations in Oracle SQL, PL/SQL, and Oracle APEX. This hands-on training program prepares students to develop robust, secure, and scalable applications using Oracle’s powerful development tools. Taught by industry expert Sir Noor Hassan — an Oracle Certified Professional with over 16 years of teaching and industry experience — the course equips learners with the skills required to work as professional Oracle Developers in the IT industry.
Trainer: Sir Noor Hassan (Oracle Certified Professional, 16 Years of Experience)
Duration: 2.5 Months
Fees: Rs. 24,000
Oracle APEX Concepts
Oracle APEX Main Components
Introduction to Workspace and Creating a Workspace, schema, user
Logging into APEX workspace
Running an Application
Browse, create and modify database objects using Object browser
Execute SQL scripts using SQL Command and SQL Scripts
Build and save SQL queries using Query Builder
Import and export data using Utilities
Identify the components of a database application.
Creating a database application from scratch.
Exporting/ importing database applications from different environments.
Identify the types of reports in application express
Create classical reports
Create, manipulate and customize interactive reports
Create and modify classic and wizard reports
Create, manipulate and customize interactive grid reports
Create Charts
Create Menus
Create Tree Region
Identify the types of forms in application express
Create and modify various types of forms
Understanding various properties of forms.
View and edit page definitions and attributes
Create and modify a region and sub region
Understanding importance of Page Zero and creating it
Identify different types of items
Creating items and edit item attributes
Creating buttons and edit button attributes
Understanding the difference between page rendering and page processing
Creating computations in application pages
Creating page processes and branches
Creating validations to verify user input
use of shared components in an application
Creating and editing tabs, navigation bar entries, lists and breadcrumbs
Themes and templates
Creating and editing a template
concept of Dynamic action
Creating and using a dynamic action
Importing and using a plugin
Creating and modify a chart
Creating a calendar
Creating a tree
concept of Dynamic action
Creating and using a dynamic action
Importing and using a plugin
Creating and modify a chart
Creating a calendar
Creating a tree
List the different ways to secure apex application
Differentiate between authentication and authorization
Creating an authentication scheme for the application
Creating an authorization scheme using Access Control
Enabling and configuring Session State Protection
Identify the supporting objects for apex application
Exporting an application and its supporting objects
Importing an application
Usage of JavaScript in Apex
Different examples of JavaScript
Usage of CSS in apex page
Corvit Systems Peshawar proudly offers a specialized Oracle Developer course designed to build strong foundations in Oracle SQL, PL/SQL, and Oracle APEX. This hands-on training program prepares students to develop robust, secure, and scalable applications using Oracle’s powerful development tools. Taught by industry expert Sir Noor Hassan — an Oracle Certified Professional with over 16 years of teaching and industry experience — the course equips learners with the skills required to work as professional Oracle Developers in the IT industry.
Trainer: Sir Noor Hassan (Oracle Certified Professional, 16 Years of Experience)
Duration: 2.5 Months
Fees: Rs. 24,000
1. Introduction Database
2. Understanding DBMS vs RDBMS
3. Gone through SQL Standards
4. Difference between 10g vs 11g vs 19c
5. Installation of 19c
6. About SQL*Plus and use of developer tool
7. Data types in Oracle
1. How to use select statement in different ways to retrieve records?
2. Working with Column alias
3. Working with Table alias
4. Data filtering and sorting with in single table
5. Clauses and its types in oracle
6. Where clause
7. Having clause
8. From clause
9. Group by clause
10. Order by clause
11. Using clause
12. Constraint clause
13. For update clause
1. Table creation using CREATE statement
2. Creating table from another table
3. Dropping a table using DROP command
4. Altering the column of a table
5. Modifying the column data type in a table
6. Renaming the column of a table
7. Renaming an entire table
8. Using truncate command
9. Difference between Delete and Truncate command
1. How to copy data from one table to another table?
2. How to copy the structure alone from a table?
3. Different types of inserting row to an existing table
4. Updating any value of with in a record using UPDATE command
5. Deleting a particular record from a table
6. Using merge & insert all command
1. How to declare column level constraints?
2. How to declare row level constraints ?
3. How to add constraints to an existing table?
4. Types of integrity constraints
5. Not null
6. Unique key
7. Primary key
8. Referential integrity
9. Check integrity
10. How to enable and disable constraints?
11. How to get information about constraints?
1. Understanding Single row functions
2. How to use single row functions using dummy table?
3. Types of single row functions
4. String functions
5. Date functions
6. Mathematical functions
7. Conversion functions
8. Special functions
9. Analytical functions
10. Working with multi row functions
1. Working with aggregate function
2. Count()
3. Sum()
4. Max()
5. Min()
6. Avg()
7. Working with group by clause
8. Working with having clause
9. Difference between WHERE and HAVING clause
1. Understanding joins and its uses
2. Types of joins
3. Equi join
4. Non – equi join
5. Self join
6. Outer join
7. Left & Right outer join
8. Full outer join
9. Cross join
1. How to use set operators in a single table content?
2. Working with set operator types
3. UNION
4. UNION ALL
5. INTERSECT
6. MINUS
7. Working with pseudo columns using the following
8. ROWID
9. ROWNUM
1. Importance of sub queries
2. Using different types of sub queries
3. Single row sub queries
4. Multi row sub queries
5. Nested queries
6. Multi column sub queries
7. Correlated sub queries
1. Working with data query language using TCL
2. Working with data control language commands
3. Use of commit and rollback
4. How to give system privileges to an user?
5. How to invoke and revoke object privileges?
6. How to create users and roles?
1. Creating and working with Views
2. Working with Synonyms
3. Creating Index and clusters
4. Working with in materialized view
5. Understanding sequences and its types.
Corvit Systems Peshawar proudly offers a specialized Oracle Developer course designed to build strong foundations in Oracle SQL, PL/SQL, and Oracle APEX. This hands-on training program prepares students to develop robust, secure, and scalable applications using Oracle’s powerful development tools. Taught by industry expert Sir Noor Hassan — an Oracle Certified Professional with over 16 years of teaching and industry experience — the course equips learners with the skills required to work as professional Oracle Developers in the IT industry.
Trainer: Sir Noor Hassan (Oracle Certified Professional, 16 Years of Experience)
Duration: 2.5 Months
Fees: Rs. 24,000
• What is Database Programming
• PL/SQL Programming
• PL/SQL Program Structure
• Language Syntax Rules
• About the Declare Section
• Declare Primitive Types
• Declaration Options
• Not Null
• Constant
• % Type
• Declare Simple User-Defined Types
• Type … Table
• Type … Record
• Extended User Defined Types
• About the Begin Section
• Manipulating Program Data
• Logic Control
• LOOP
• IF-THEN-ELSE
• CASE
• About the Exception Section
• Isolating the Specific Exception
• Pragma Exception_INIT
• SQLCODE &SQLERRM Example
• SQL%ROWCOUNT & Select … Into
• About Explicit Cursors
• Extend Cursor Techniques
• For Update of Clause
• Where Current of Clause
• Using for … Loop Cursors
• Stored Procedures & Functions
• Create Procedure / Create Function
• Creating Procedures & Functions
• The Parameter Specification
• Default Clause
• System & Object Privileges
• Calling Procedures & Functions
• Unit Testing with Execute
• Anonymous Block Unit Testing
• Specifying a Parameter Notation
• Calling Functions from SQL
• Recompiling Programs
• Mass Recompilation Using UTL_RECOMP()
• Dropping Procedures & Functions
• Drop Procedures & Functions.
• Data Dictionary Metadata
• Using USER_OBJECTS
• Using USER_SOURCE
• Using USER_ERRORS
• Using USER_OBJECT_SIZE
• Using USER_DEPENDENCIES
• About Packages
• Creating Packages
• Maintaining Packages
• Using Cursor Variables
• Using SYS_REFCURSOR
• Using Cursor Expressions
• DBMS_OUTPUT()
• UTL_FILE()
• FOPEN()
• About Database Triggers
• DML Event Trigger Sub-Types
• Database Trigger Scenario
• Trigger Exhaustion Mechanisms
• Statement Level Triggers
• Using Raise Application_Error()
• Row-Level & Instead of Triggers
• Triggers within and Application
• Trigger Maintenance
• Show Errors Trigger
• Drop & Alter Trigger
• Multiple Triggers for a Table
• Defining the Scope
• Available System Events
• System Event Attributes
Trusted and reputed institute for professional IT and database training
Expert instructor – Sir Noor Hassan, Oracle Certified Professional with 16 years of teaching and industry experience
Complete coverage of Oracle SQL, PL/SQL, and Oracle APEX development
Emphasis on real-world projects and practical programming skills
Up-to-date course content aligned with industry and job market needs
Modern lab facilities for hands-on learning and development
Affordable fee structure with flexible class schedules
Focused support for certification exams and career building
Proven track record of successful students working in top companies
Supportive and interactive learning environment to ensure clarity and confidence
Spaces are limited — Don’t miss out on this opportunity.
Location: Main university road jehangir abad city tower plaza office No 201 block B second floor Corvit systems Peshawar
Expert IT & Tech Courses at Corvit Peshawar – Build your future.
© 2025 Mr. AD | Corvit Systems Peshawar. All rights reserved.
Stay updated with the latest courses, new batch timings, admission info, and special announcements from CORVIT SYSTEMS PESHAWAR.