Day 1: Introduction to Oracle SQL

• Overview of Oracle SQL:
  • Definition and History
  • Oracle SQL vs. Standard SQL
• Oracle SQL Components:
  • DDL (Data Definition Language)
  • DML (Data Manipulation Language)
  • DCL (Data Control Language)
  • TCL (Transaction Control Language)
• Oracle SQL Environments:
  • Oracle SQL Developer and Other Tools

Day 2: Data Definition and Modification

• Creating Tables:
  • CREATE TABLE Statement
  • Defining Columns and Data Types
  • Primary and Foreign Keys
• Modifying Tables:
  • ALTER TABLE Statement
  • Adding, Dropping, and Renaming Columns
• Deleting Tables:
  • DROP TABLE Statement

Day 3: Data Manipulation

• Inserting Data:
  • INSERT INTO Statement
  • Inserting Multiple Rows
• Updating Data:
  • UPDATE Statement
  • Modifying Existing Records
• Deleting Data:
  • DELETE Statement
  • Truncating Tables with TRUNCATE

Day 4: Basic SQL Syntax and Queries in Oracle

• Basic Syntax:
  • Oracle SQL Statements and Keywords
  • Case Sensitivity and Formatting
• Data Retrieval:
  • SELECT Statement
  • Filtering Data with WHERE
  • Sorting Data with ORDER BY
• Data Projection:
  • Selecting Specific Columns
  • Using Aliases

Day 5: Advanced Data Retrieval

• Complex Filtering:
  • BETWEEN, IN, LIKE, and IS NULL
  • Using Logical Operators (AND, OR, NOT)
• String Functions:
  • CONCAT, SUBSTR, REPLACE, TRIM