1

What is covered in This course

06:59

2

How to purchase course

3

Secret Facebook Group

1

What is Oracle and Oracle Database ?

2

Introduction to Oracle SQL & Classification

02:09

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

1

Common SQL*PLUS commands

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

1

Order By Clause

2

Sorting by Column Aliase

3

Sorting by Multiple Columns

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

1

Cartesian-Products

2

Equi-Joins

3

Non-Equi-Joins

4

Outer Joins

5

Self Joins

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

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

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

1

Including Constraints – Not Null

2

Including Constraints – Primary Key

3

Including Constraints – Foreign Key

4

Including Constraints – Unique Key

5

Including Constraints – Check

1

Creating and Managing Views

1

Manipulating Data – Insert

2

Manipulating Data – Update

3

Manipulating Data – Delete

4

Manipulating Data – Merge

1

Other Database Objects – Sequence

2

Other Database Objects – Index

3

Other Database Objects – Synonym

1

Controlling User Access

1

Data Control with Rollback and Commit

2

Data Update on Different Sessions

1

The UNION [ALL], INTERSECT, MINUS Operators

2

Top-N-Analysys

3

If Condition in SQL : Case

1

Oracle SQL Quiz

25 questions

2

E-books

1

Introduction to PL/SQL

1

Types of PLSQL blocks

2

DBMS_OUTPUT IN Oracle SQL Developer

3

Anonymous Block

4

What are Bind Variables?

5

Data Types

6

Declaring PLSQL Variables

7

Declaring PLSQL Constants

1

Writing Executable Statements

2

Learn to Comment the Code

3

Describe Nested Blocks

4

Identify the Operators in PLSQL

5

Indenting the Code

1

IF STATEMENTS

2

CASE Statements

3

GO TO Statements

4

NULL Statements

1

Basic Loop

2

While Loop

3

GO TO Statements

4

NULL Statements

1

Using Implicit Cursors

2

Using Explicit Cursors

3

Cursor with parameters

4

PLSQL Records and Cursor

5

Cursor FOR Loops

1

Handling Exceptions

2

Using Raise Application Error

1

Creating Procedures

2

Parameter In Procedures

3

The %ROWTYPE Attribute

1

Creating Functions

1

Creating and Using Packages

1

What is Trigger

2

Creating Triggers with Raise Application Error

3

Disable, Enable and Drop Triggers

4

DML Triggers

5

System Triggers

1

Introducing Oracle Application Express

2

Application Express Overview. Create Apps in apex.oracle.com

1

Installation Script

2

Install Java

3

Install Tomcat

4

Install Oracle Apex

5

Install ORDS

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

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

1

Creating a Reflow Report

2

Creating Column Toggle Report

3

Report with Form

4

Creating Form and Report in the same page

1

Creating Forms

2

Creating Editable Interactive Grid

3

Copy Pages inside or outside of Application

1

Working with Page Regions

2

Working with Pages

1

Creating List of Value (LOV) Type of Items

2

Using Buttons

3

Introducing Items

1

Understanding Session State in Oracle Application Express

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

1

Creating and Using Charts

2

Using Calendars

1

Using Dynamic Actions

2

Using Plug-Ins

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

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

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

1

How to Install Oracle Developer Suite 10g In Windows 10