Blog - OraDemy E-Learning

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

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

Using the TO_CHAR functions with Dates

6

Using the TO_CHAR functions with Numbers

Using the NVL Functions

10

Using the DECODE Functions

Section 9

SQL Query : Displaying Data from Multiple Tables

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

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

Section 25

Iterative Processing with loops

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

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

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

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

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

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

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

Complete Oracle Apex Web Application Development Training

Course sections

Course Overview

Oracle SQL

Install Oracle

SQL Query : Common SQL*PLUS commands

SQL Query : Writing Basic SQL Statements

SQL Query : Restricting Data

SQL Query : Sorting Data

SQL Query : Single Row Functions

SQL Query : Displaying Data from Multiple Tables

SQL Query : Aggregating Data Using Group Functions

SQL Query : Subqueries

SQL DDL : Creating and Managing Tables

SQL DDL : Including Constraints

SQL DDL : Creating and Managing Views

SQL Data Manipulation Language (DML)

SQL Other Database Objects

SQL Data Control Language (DCL)

SQL Transaction Control

SQL Others

Oracle SQL Quiz and Free E-books

Oracle PLSQL - Introduction

PLSQL - Declaring PLSQL Variables

Writing Executable Statements

Writing Control Structure

Iterative Processing with loops

Using Cursors

Handling exceptions

Creating Procedures

Creating Functions

Creating Packages

Creating Triggers

Oracle Apex

Installation of Oracle Apex

Creating a Desktop and Mobile Database Application

Working with Reports for Desktop and Mobile Application

Working with Reports for Mobile Application

Creating Forms

Working with Pages and Regions

Adding Items and Buttons

Understanding Session State

Including DML Page Processing

Creating Charts and Calendars

Using Dynamic Actions and Plug-ins

Software Projects on Human Resource Management Systems

Software Project: Automobile Workshop Management Systems (Sales Apps)

Oracle Apex on Cloud – Build Oracle Apex Environment on Cloud VPS

Oracle Apex Reporting

SQL Query : Sorting Data

Order By Clause