📚 Oracle SQL Syllabus

🧪 Oracle SQL Lab Tutorial Syllabus

Objective: This lab-based Oracle SQL tutorial is designed to build a strong practical foundation in SQL programming using Oracle Database. Each lab includes step-by-step exercises, real-world scenarios, and SQL scripts for active learning.

🔍 Lab 1: Introduction & Basic Queries

• Explore Oracle SQL*Plus
• SELECT – Retrieve data from a table
• Practice: Query employees and departments

🔃 Lab 2: Sorting and Filtering Data

• ORDER BY, WHERE, DISTINCT
• AND, OR, IN, BETWEEN, LIKE, IS NULL
• Practice: Filter employees by salary, department

🔗 Lab 3: Joining Tables

• INNER, LEFT, RIGHT, FULL OUTER JOIN
• CROSS JOIN, SELF JOIN
• Practice: Combine employee and department data

📊 Lab 4: Grouping and Aggregation

• GROUP BY, HAVING
• CUBE, ROLLUP, GROUPING SETS
• Practice: Salary summaries, department counts

🔁 Lab 5: Subqueries

• Simple and Correlated Subqueries
• EXISTS, NOT EXISTS, ANY, ALL
• Practice: Find high earners per department

➕ Lab 6: Set Operations

• UNION, INTERSECT, MINUS
• Practice: Combine and compare queries

🔄 Lab 7: Pivoting Data

• PIVOT, UNPIVOT
• Practice: Crosstab salary reports

🎚 Lab 8: Limiting Rows

• FETCH FIRST, OFFSET
• Practice: Top earners, latest hires

🏗 Lab 9: Creating and Modifying Tables

• CREATE, ALTER TABLE
• Virtual Columns
• Practice: Create custom project table

📁 Lab 10: Data Types

• NUMBER, CHAR, VARCHAR2, DATE, TIMESTAMP
• NCHAR, NVARCHAR2, INTERVAL
• Practice: Define appropriate types

🔐 Lab 11: Constraints

• PRIMARY KEY, FOREIGN KEY
• NOT NULL, UNIQUE, CHECK, DEFAULT
• Practice: Create relational schema

✏️ Lab 12: Modifying Data

• INSERT, INSERT ALL, UPDATE, DELETE
• MERGE for UPSERT
• Practice: Populate employee/project data

⏳ Lab 13: Temporary Tables

• Global and Private Temporary Tables
• Practice: Use for session-specific data

👁 Lab 14: Views

• CREATE, DROP, Updatable Views
• WITH CHECK OPTION, Inline Views
• Practice: Build report views

⚡ Lab 15: Indexes

• CREATE, DROP, Unique, Function-based, Bitmap Index
• Practice: Improve query performance

📛 Lab 16: Synonyms

• CREATE, DROP SYNONYM
• Practice: Use synonyms for object access

🔢 Lab 17: Sequences

• CREATE, ALTER, DROP SEQUENCE
• Practice: Use sequences for IDs

🧰 Tools Required

• Oracle Database (XE or Standard)
• SQL Developer or compatible tool
• Sample schema: HR, SCOTT, or custom dataset

✅ Learning Outcomes

• Master Oracle SQL fundamentals
• Write optimized SQL queries
• Design and manage Oracle database objects

oracle sql tutorial, oracle database lab, sql practice exercises, oracle lab manual, sql join practice, oracle sql queries, group by sql oracle, subquery oracle, pivot sql, create table sql oracle, oracle views, temporary tables oracle, sql developer lab, dml oracle, ddl commands, oracle index types, sql sequences oracle, sql training beginner, oracle sql beginner, advanced sql oracle, online sql tutorial oracle, sql lab syllabus, sql lab exercises, sql lab topics