1. What is SQL?
2. What is Oracle?
3. History of SQL 

1. Numeric data types
2. Date & Time data types
3. String data types
4. Other data types

1. DDL (Data Definition Language)
2. DQL (Data Query Language)
3. DML(Data Manipulation Language)
4. DCL (Data Control Language)
5. TCL (Transaction Control Language)

1. Create
2. Alter
3. Rename
4. Truncate
5. Drop

1. Insert
2. Update
3. Delete

Select

1. Grant
2. Revoke

1. Commit
2. Rollback

Live

Live

Live

COUNT, SUM, AVG, MIN, MAX, etc...

Eg: SELECT aggregate_function(column) FROM table_name WHERE condition;

1. Arithmetic Operators: +, -, *, /, %
2. Comparison Operators: =, != (or <>), >, <, >=, <=
3. Logical Operators: AND, OR, NOT
4. Assignment Operators: =, +=, -=, *=, /=
5. Concatenation Operator: ||
6. IS NULL Operator
7. LIKE Operator
8. BETWEEN Operator
9. IN Operator
10. EXISTS Operator

1. BETWEEN: Compares two values within a range
2. IN: Compares a value with a set of values
3. LIKE: Compares values in a database
4. IS NULL: Indicates that a column value does not exist

1. ORDER BY
2. GROUP BY
3. DISTINCT Clauses

1. UNIQUE
2. NOT NULL
3. PRIMARY
4. FOREIGN
5. CHECK
6. DEFAULT

1. INNER JOIN
2. LEFT JOIN
3. RIGHT JOIN
4. FULL JOIN
5. CROSS JOIN

1. UNION
2. UNIOPN ALL
3. INTERSECT
4. MINUS

1. View
2. Sequence
3. Synonyms

In SQL, a subquery is a query that is nested inside another query - Nested Queries

1. Introduction
2. Features of PL/SQL
3.  Structure of PL/SQL
4. PL/SQL Language Elements
5. Data Types
6. Control Structure
7. Steps to Create a PL/SQL
8. Iterative Control
9. Select Statement in PL/SQL
10. Cursors
11. Steps to create a Cursors
12. Cursor Attributes
13. Procedure
14. Function
15. Packages
16. Exceptions Handling
17. Database Triggers
18. Types of Triggers