Complete Oracle Apex Web Application Development Training
Back to Dashboard

Course sections

Section 1
Course Overview
1
What is covered in This course
06:59
2
How to purchase course
3
Secret Facebook Group
Section 2
Oracle SQL
1
What is Oracle and Oracle Database ?
2
Introduction to Oracle SQL & Classification
02:09
Section 3
Install Oracle
1
How to Install Oracle Database 19c In Windows
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
5
Introduction to SQL PLUS
6
Introduction to SQL Developer with Installation
Section 4
SQL Query : Common SQL*PLUS commands
1
Common SQL*PLUS commands
Section 5
SQL Query : Writing Basic SQL Statements
1
Selecting Columns
2
Using Arithmetic Operators
3
Defining Null Values
4
Using Column Aliases
5
Using the Concatenation Operators
6
Eliminitating Duplicate Rows
Section 6
SQL Query : Restricting Data
1
Using the Where Clause
2
Comparison Conditions
3
Using the Between Conditions
4
Comparison Conditions
5
Using the Like Conditions
6
Using the Null Conditions
7
Logical Conditions – Using the AND, OR, NOT Operators
Section 7
SQL Query : Sorting Data
1
Order By Clause
2
Sorting by Column Aliase
3
Sorting by Multiple Columns
Section 8
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
Section 9
SQL Query : Displaying Data from Multiple Tables
1
Cartesian-Products
2
Equi-Joins
3
Non-Equi-Joins
4
Outer Joins
5
Self Joins
Section 10
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
Section 11
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
Section 12
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
Section 13
SQL DDL : Including Constraints
1
Including Constraints – Not Null
2
Including Constraints – Primary Key
3
Including Constraints – Foreign Key
4
Including Constraints – Unique Key
5
Including Constraints – Check
Section 14
SQL DDL : Creating and Managing Views
1
Creating and Managing Views
Section 15
SQL Data Manipulation Language (DML)
1
Manipulating Data – Insert
2
Manipulating Data – Update
3
Manipulating Data – Delete
4
Manipulating Data – Merge
Section 16
SQL Other Database Objects
1
Other Database Objects – Sequence
2
Other Database Objects – Index
3
Other Database Objects – Synonym
Section 17
SQL Data Control Language (DCL)
1
Controlling User Access
Section 18
SQL Transaction Control
1
Data Control with Rollback and Commit
2
Data Update on Different Sessions
Section 19
SQL Others
1
The UNION [ALL], INTERSECT, MINUS Operators
2
Top-N-Analysys
3
If Condition in SQL : Case
Section 20
Oracle SQL Quiz and Free E-books
1
Oracle SQL Quiz
25 questions
2
E-books
Section 21
Oracle PLSQL - Introduction
1
Introduction to PL/SQL
Section 22
PLSQL - Declaring PLSQL Variables
1
Types of PLSQL blocks
2
DBMS_OUTPUT IN Oracle SQL Developer
3
Anonymous Block
4
What are Bind Variables?
5
Data Types & %TYPE Attribute
6
Declaring PLSQL Variables
7
Declaring PLSQL Constants
Section 23
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
Section 24
Writing Control Structure
1
IF STATEMENTS
2
CASE Statements
3
GO TO Statements
4
NULL Statements
Section 25
Iterative Processing with loops
1
Basic Loop
2
While Loop
3
GO TO Statements
4
NULL Statements
Section 26
Using Cursors
1
Using Implicit Cursors
2
Using Explicit Cursors
3
Cursor with parameters
4
PLSQL Records and Cursor
5
Cursor FOR Loops
Section 27
Handling exceptions
1
Handling Exceptions
2
Using Raise Application Error
Section 28
Creating Procedures
1
Creating Procedures
2
Parameter In Procedures
3
The %ROWTYPE Attribute
Section 29
Creating Functions
1
Creating Functions
Section 30
Creating Packages
1
Creating and Using Packages
Section 31
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
Section 32
Oracle Apex
1
Introducing Oracle Application Express
2
Application Express Overview. Create Apps in apex.oracle.com
Section 33
Installation of Oracle Apex
1
Installation Script
2
Install Java
3
Install Tomcat
4
Install Oracle Apex
5
Install ORDS
Section 34
Creating a Desktop and Mobile Database Application
1
Application Builder Overview & Creating Database Applications
2
Creating Report with Forms
3
How to add Blob Image Column in Table
4
How to upload Image in Blob Image Column
Section 35
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
Section 36
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
Section 37
Creating Forms
1
Creating Forms
2
Creating Editable Interactive Grid
3
Copy Pages inside or outside of Application
Section 38
Working with Pages and Regions
1
Working with Page Regions
2
Working with Pages
Section 39
Adding Items and Buttons
1
Creating List of Value (LOV) Type of Items
2
Using Buttons
3
Introducing Items
Section 40
Understanding Session State
1
Understanding Session State in Oracle Application Express
Section 41
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
Section 42
Creating Charts and Calendars
1
Creating and Using Charts
2
Using Calendars
Section 43
Using Dynamic Actions and Plug-ins
1
Using Dynamic Actions
2
Using Plug-Ins
Section 44
Software Projects on Human Resource Management Systems
1
Requirement Analysys
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
Section 45
Software Project: Automobile Workshop Management Systems (Sales Apps)
1
Requirement Analysys
2
Creating User, Workspace and Entity Objects (Tables)
3
Upload the Sample Data to Table
4
Create Forms and Reports – Customer
5
Create Forms and Reports – Car
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
Section 46
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
Section 47
Oracle Apex Reporting
1
How to Install Oracle Developer Suite 10g In Windows 10

Oracle SQL

Introduction to Oracle SQL & Classification

SQL Classifications :

SELECT Query
INSERT

UPDATE

DELETE

MERGE

 Data Manipulation Language (DML)
CREATE

ALTER

DROP

RENAME

TRUNCATE

 Data Definition Language (DDL)
GRANT

REVOKE

 Data Control Language (DCL)
COMMIT

ROLLBACK

SAVEPOINT

 Transaction Control
×

Powered by WhatsApp Chat

WhatsApp Chat is free, download and try it now here!

×