SQL & Database (Oracle)

Master database design, SQL and PL/SQL basics using Oracle Database.

Course Overview

Learn how data is designed, stored and queried in real applications. This course covers database design, SQL from basics to advanced queries, and an introduction to PL/SQL using Oracle Database, with practice on real-world datasets.

Curriculum

1. Database Fundamentals: What databases are, the relational model, tables, keys and relationships.
2. Database Design: ER diagrams, normalization (1NF–3NF) and designing schemas.
3. SQL Basics: SELECT, WHERE, ORDER BY, operators and single-row functions.
4. Joins & Aggregation: Inner and outer joins, GROUP BY, HAVING and aggregate functions.
5. Subqueries & Set Operators: Single and multi-row subqueries, UNION, INTERSECT and MINUS.
6. DDL, DML & Constraints: Creating and altering tables, INSERT/UPDATE/DELETE, constraints and transactions.
7. Views, Indexes & Sequences: Creating database objects and improving query performance.
8. Introduction to PL/SQL: Blocks, variables, conditions, loops, procedures and functions.

Projects

• Design a database for a college or hospital
• Sales reporting queries on a real dataset
• Inventory system with PL/SQL procedures

Who Can Join

• Students from any IT or computer background
• Developers who want strong database skills
• Freshers preparing for data or backend roles