1. Introduction to Databases and Oracle

• Understanding Databases and Database Management Systems (DBMS)

• Introduction to Oracle Database

• Oracle SQL Developer Setup

• Connecting to the Oracle Database

​

2. SQL Basics

• Introduction to SQL

• SELECT Statement

• Filtering Data with WHERE Clause

• Sorting Data with ORDER BY

• Aliases for Column Names

​

3. Retrieving Data from Multiple Tables

• Understanding Table Joins

• INNER JOIN, LEFT JOIN, RIGHT JOIN

• CROSS JOIN, SELF JOIN

• USING Clause

• UNION and UNION ALL Operators

​

4. Filtering Data with Advanced Techniques

• Using the BETWEEN Operator

• Working with NULL Values

• Using IN and NOT IN Operators

• Combining Conditions with AND, OR, NOT

• Subqueries and Nested Queries

​

5. Data Modification and Transactions

• INSERT, UPDATE, and DELETE Statements

• COMMIT and ROLLBACK Statements

• Introduction to Transactions

• Savepoints

​

6. Aggregating and Grouping Data

• GROUP BY Clause

• Aggregate Functions (SUM, AVG, COUNT, MAX, MIN)

• HAVING Clause

• GROUPING SETS and ROLLUP

• Cube and Grouping

​

7. Working with Date and Time Data

• Date and Time Data Types

• Date Functions (TO_DATE, TO_CHAR, TO_TIMESTAMP)

• Calculating Date Differences

• Extracting Date Components

​

8. Managing Data with DDL Statements

• Introduction to Data Definition Language (DDL)

• Creating and Altering Tables

• Constraints (PRIMARY KEY, FOREIGN KEY, UNIQUE, CHECK)

• Indexes