Complete Oracle Apex Web Application Development Training

Course Overview

1
What is covered in This course
06:59
2
How to purchase course
3
Secret Facebook Group

Oracle SQL

1
What is Oracle and Oracle Database ?
2
Introduction to Oracle SQL & Classification
02:09

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

SQL Query : Common SQL*PLUS commands

1
Common SQL*PLUS commands

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

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

SQL Query : Sorting Data

1
Order By Clause
2
Sorting by Column Aliase
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
3
Including Constraints – Foreign 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
25 questions
2
E-books

Oracle PLSQL - Introduction

1
Introduction to PL/SQL

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

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

1
Introducing Oracle Application Express
2
Application Express Overview. Create Apps in apex.oracle.com

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

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

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

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

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

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

Oracle Apex Reporting

1
How to Install Oracle Developer Suite 10g In Windows 10
Get course
Enrolled: 7 students
Duration: 3 Months
Lectures: 210
Video: 16 Hours
Level: Beginner

Archive

Complete Oracle Apex Web Application Development Training
Price:
bdt.7,500
Live Courses