SQL

Sql Intro
SQL Database & User Creation
listener Trouble Shoot for database connect
Oracle & SQL developer installation & uninstallation

=================================DDL ====================================

Create Table(DDL-Data Definition Language)
Alter Table
Drop Table
Truncate Table
Rename Table
Copy Table

Sample Tables

=================================DML====================================

Insert(Data Manipulation Language)
Update
Delete
Difference between Truncate / Delete / Drop

===============================DRL  / DSL=================================

Where Clause

Having Clause

Order By Clause(Asc, Desc, Limit, Random)

Select Clause(from, where, group by, order by, distinct, count, top, limit)

Group By Clause

Distinct Clause

Differences (group by v/s order by, having v/s where)

https://data-flair.training/blogs/sql-clauses/

Date Functions

General / NVL functions 

LISTAGG?

=================================Sub Queries ============================

Sub Queries

Single Row Subqueries

Multiple Row and Column Subqueries

Correlated Subqueries

Nested subqueries

==================================JOINS ================================

JOINS

INNER Join

LEFT Join / LEFT OUTER JOIN

RIGHT JOIN /RIGHT OUTER JOIN

FULL JOIN / FULL OUTER JOIN

SELF JOIN

Cross / Cartesian Join

==================================VIEWS======================================

VIEWS

Simple View

Complex View

Inline VIEW 

Materialized View

==================================Conditional Expressions==================

CASE Statement

Nested CASE Statement

DECODE()