Scribd
Upload
26 views2 pages

1 Week PLSQL Roadmap

The document outlines a 1-week roadmap for learning PL/SQL using GeeksforGeeks, covering essential topics each day. It includes basics, control flow statements, cursors, procedures and functions, exception handling, triggers, and concludes with practice and revision. Each day focuses on specific concepts and practical applications to reinforce learning.

Uploaded by

ajitmusale645
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
26 views2 pages

1 Week PLSQL Roadmap

The document outlines a 1-week roadmap for learning PL/SQL using GeeksforGeeks, covering essential topics each day. It includes basics, control flow statements, cursors, procedures and functions, exception handling, triggers, and concludes with practice and revision. Each day focuses on specific concepts and practical applications to reinforce learning.

Uploaded by

ajitmusale645
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

1-Week PL/SQL Roadmap (Using GeeksforGeeks)

Day 1: PL/SQL Basics

- What is PL/SQL?
- PL/SQL Block Structure (DECLARE, BEGIN, EXCEPTION, END)
- Basic Syntax, Variables and Constants
- Comments and Data Types

Day 2: Control Flow Statements

- IF, IF-ELSE, Nested IF-ELSE


- CASE Statements
- LOOPS: Simple Loop, WHILE, FOR
- EXIT, EXIT WHEN, CONTINUE

Day 3: Cursors

- Introduction to Cursors
- Implicit vs Explicit Cursors
- Cursor FOR Loop
- Cursor Attributes (%FOUND, %NOTFOUND, %ROWCOUNT, %ISOPEN)

Day 4: Procedures & Functions

- Creating and Executing Procedures


- IN, OUT, IN OUT Parameters
- Creating Functions and Returning Values
- Difference Between Procedures and Functions

Day 5: Exception Handling

- Predefined Exceptions (NO_DATA_FOUND, TOO_MANY_ROWS, etc.)


- User-Defined Exceptions
- RAISE, RAISE_APPLICATION_ERROR
- Nested Exception Handling

Day 6: Triggers

- What are Triggers?


- BEFORE, AFTER, INSTEAD OF Triggers
- Row-level and Statement-level Triggers
- Trigger Examples and Use Cases

Day 7: Practice & Revision

- Solve 10+ PL/SQL Practice Problems from GeeksforGeeks


- Revise Key Concepts and Syntax
- Mock Test or Mini Project (e.g. Student Database Procedure)
- Summarize Learnings in Notes or Cheatsheet

You might also like