Complete Oracle Apex Web Application Development Training
Course Overview
3
Secret Facebook Group
Oracle SQL
Install Oracle
2
Enable Pluggable Database with TNSNAMES.ORA file
3
How To Create [TNS Service] Using Oracle Net Configuration Assistant (netCA)
4
UNLOCK HR AND SCOTT USER
6
Introduction to SQL Developer with Installation
SQL Query : Common SQL*PLUS commands
1
Common SQL*PLUS commands
SQL Query : Writing Basic SQL Statements
3
Defining Null Values
4
Using Column Aliases
5
Using the Concatenation Operators
SQL Query : Restricting Data
2
Comparison Conditions
3
Using the Between Conditions
4
Comparison Conditions
5
Using the Like Conditions
7
Logical Conditions – Using the AND, OR, NOT Operators
SQL Query : Sorting Data
3
Sorting by Multiple Columns
SQL Query : Single Row Functions
1
Case-manipulation functions
2
Character-manipulation functions
3
Number Functions
4
Date Functions
5
Using the TO_CHAR functions with Dates
6
Using the TO_CHAR functions with Numbers
7
RRRR Functions
8
Nesting Functions
9
Using the NVL Functions
10
Using the DECODE Functions
SQL Query : Displaying Data from Multiple Tables
1
Cartesian-Products
2
Equi-Joins
3
Non-Equi-Joins
4
Outer Joins
5
Self Joins
SQL Query : Aggregating Data Using Group Functions
1
Types of Group Functions
2
Using the Group By Clause
3
Illegal Queries using group functions
4
Using the HAVING clause
5
Nesting Groups
SQL Query : Subqueries
1
Using the SUBQUERIES
2
Executing Single Row Subqueries
3
Using Group Function in a Subqueries
4
The Having Clause with Subqueries
5
Using the ANY operator in multiple row subqueries
6
Using the ALL operator in multiple row subqueries
7
Null Values in a Subquery
SQL DDL : Creating and Managing Tables
1
Creating and Managing Tables
2
Quering the Data Dictionary Table
3
Creating a Table by Using a Subquery
4
Adding, Modifying and dropping a column
5
The Set Unused Option
6
Dropping a Table
7
Changing the name of an Object
8
Truncating A Table
SQL DDL : Including Constraints
1
Including Constraints – Not Null
2
Including Constraints – Primary Key
4
Including Constraints – Unique Key
5
Including Constraints – Check
SQL DDL : Creating and Managing Views
1
Creating and Managing Views
SQL Data Manipulation Language (DML)
1
Manipulating Data - Insert
2
Manipulating Data - Update
3
Manipulating Data - Delete
4
Manipulating Data – Merge
SQL Other Database Objects
1
Other Database Objects – Sequence
2
Other Database Objects – Index
3
Other Database Objects – Synonym
SQL Data Control Language (DCL)
1
Controlling User Access
SQL Transaction Control
1
Data Control with Rollback and Commit
2
Data Update on Different Sessions
SQL Others
1
The UNION [ALL], INTERSECT, MINUS Operators
2
Top-N-Analysys
3
If Condition in SQL : Case
Oracle SQL Quiz and Free E-books
1
Oracle SQL Quiz
2
E-books
Oracle PLSQL - Introduction
PLSQL - Declaring PLSQL Variables
2
DBMS_OUTPUT IN Oracle SQL Developer
3
Anonymous Block
5
Data Types & %TYPE Attribute
6
Declaring PLSQL Variables
7
Declaring PLSQL Constants
Writing Executable Statements
1
Writing Executable Statements
2
Learn to Comment the Code
3
Describe Nested Blocks
4
Identify the Operators in PLSQL
5
Indenting the Code
Writing Control Structure
1
IF STATEMENTS
2
CASE Statements
3
GO TO Statements
4
NULL Statements
Iterative Processing with loops
1
Basic Loop
2
While Loop
3
GO TO Statements
4
NULL Statements
Using Cursors
1
Using Implicit Cursors
2
Using Explicit Cursors
3
Cursor with parameters
4
PLSQL Records and Cursor
5
Cursor FOR Loops
Handling exceptions
1
Handling Exceptions
2
Using Raise Application Error
Creating Procedures
1
Creating Procedures
2
Parameter In Procedures
3
The %ROWTYPE Attribute
Creating Functions
1
Creating Functions
Creating Packages
1
Creating and Using Packages
Creating Triggers
1
What is Trigger
2
Creating Triggers with Raise Application Error
3
Disable, Enable and Drop Triggers
4
DML Triggers
5
System Triggers
Oracle Apex
Installation of Oracle Apex
1
Installation Script
2
Install Java
3
Install Tomcat
4
Install Oracle Apex
5
Install ORDS
Creating a Desktop and Mobile Database Application
2
Creating Report with Forms
4
How to upload Image in Blob Image Column
Working with Reports for Desktop and Mobile Application
1
Using Classic Reports
2
Creating Classic Reports with Image Item
3
Creating and Customizing an Interactive Report
4
Using Interactive Grid
5
Using Faceted Search
6
Cards Report
7
List View Report
Working with Reports for Mobile Application
1
Creating a Reflow Report
2
Creating Column Toggle Report
3
Report with Form
4
Creating Form and Report in the same page
Creating Forms
1
Creating Forms
2
Creating Editable Interactive Grid
3
Copy Pages inside or outside of Application
Working with Pages and Regions
1
Working with Page Regions
2
Working with Pages
Adding Items and Buttons
1
Creating List of Value (LOV) Type of Items
2
Using Buttons
3
Introducing Items
Understanding Session State
1
Understanding Session State in Oracle Application Express
Including DML Page Processing
1
Create a Data Entry Form Manually
2
Including Processes
3
Including Validations
4
Including Computations
5
Including Branches
6
Upload and Display Image in Form
7
PLSQL Error Message and Success Message
Creating Charts and Calendars
1
Creating and Using Charts
2
Using Calendars
Using Dynamic Actions and Plug-ins
1
Using Dynamic Actions
2
Using Plug-Ins
Software Projects on Human Resource Management Systems
2
Creating User, Workspace and Entity Objects (Tables)
3
CSS in Login and Main Page with Slider
4
Add Favicon Image
5
Creating Forms and Reports : DEPT WITH MODAL DIALOGUE
6
Creating Forms and Reports in same Page
7
Search Dynamically in Reports
8
Image Item
9
Loan Management
10
Leave Management
11
Leave Application
12
Process, Validation and Dynamic Action
13
Upload Excel with plugin and Collection
14
Creating Salary Report with Procedure in Process
15
Plsql Dynamic Content - HTML Report
16
Create Dashboard with Charts
17
Oracle Apex Template - Create Card Report
18
Table Based Sign Up and Login
19
Organize The Menu in Shared Component
20
Create Menu Based on Table
21
User Authenticated Menu - Table Based
Software Project: Automobile Workshop Management Systems (Sales Apps)
2
Creating User, Workspace and Entity Objects (Tables)
3
Upload the Sample Data to Table
4
Create Forms and Reports - Customer
6
Create Forms and Reports - Expense
7
Create Forms and Reports - Supplier
8
Create Forms and Reports - Parts and Service and Unit Type
9
Master Details -Quotation-Create Master Details Forms Manually
10
Master Details -Quotation-Add Process
11
Master Details -Quotation-Delete Quotation and Parts
12
Master Details -Quotation-Add Payments
13
Quotation – Add HTML Report in PLSQL Dynamic Content and link to FORM
14
All Script in one
Oracle Apex on Cloud – Build Oracle Apex Environment on Cloud VPS
1
How to Install Putty and SSH Client
2
Installation of Tomcat 9
3
Secure Tomcat
4
Server Time Zone
5
Disable SeLinux
6
SWAP Space
7
Install Oracle DB in Linux
8
Connect Oracle Database in Cloud from PC
9
How to Install Oracle Apex
10
Install ORDS in Linux and run ORDS in Tomcat
11
Tomcat Re-Direct