Day 1 (March 3): Core Fundamentals & Architecture

Morning (3 hours)

• DBMS Fundamentals (Highest Priority)
  • DBMS definition and components
  • Three-tier architecture
  • Advantages and disadvantages
  • Client-server model

Afternoon (3 hours)

• Normalization (Highest Priority)
  • Quick review of 1NF through BCNF
  • Focus on identifying violations
  • Practice 2-3 normalization problems

Evening (2 hours)

• Previous Paper MCQs - Part 1
  • Review all MCQs related to DBMS architecture
  • Review all MCQs related to normalization
  • Make flashcards for key concepts

Day 2 (March 4): PL/SQL Fundamentals

Morning (3 hours)

• PL/SQL Basics (Highest Priority)
  • Structure and components
  • Exception handling
  • Packages and benefits

Afternoon (3 hours)

• Triggers & Stored Procedures (Highest Priority)
  • Types of triggers (BEFORE, AFTER, INSTEAD OF)
  • Trigger syntax and examples
  • Stored procedures vs. functions
  • Parameter modes (IN, OUT, INOUT)

Evening (2 hours)

• Previous Paper MCQs - Part 2
  • Review all MCQs related to PL/SQL
  • Review all MCQs related to triggers
  • Create quick reference notes for syntax

Day 3 (March 5): Cursors & Transactions

Morning (3 hours)

• Cursors (High Priority)
  • Implicit vs. explicit cursors
  • Cursor attributes (%FOUND, %NOTFOUND, etc.)
  • Cursor examples and implementation

Afternoon (3 hours)

• Transaction Processing & Joins (High Priority)
  • ACID properties
  • COMMIT, ROLLBACK, SAVEPOINT
  • Types of joins with examples
  • Locking mechanisms

Evening (2 hours)