Mastering SQL - PL/SQL (SEC-02 option A)

Introduction of Relational Database

5 topics

• Data types (NUMBER, CHAR, VARCHAR, VARCHAR2, CLOB, NCLOB, LONG, DATE, RAW, LONGROW)
• ROWID pseudo column & DUAL table
• Join Queries: Inner, Outer (Left/Right/Full), Cross
• Sub Queries with Insert, Update, Delete
• Nested queries

PL/SQL and Conditional Statements

5 topics

• Introduction to PL/SQL (Definition & Block Structure)
• Variables, Constants and Data Type, Assigning Values
• User Defined Record
• Conditional Statements: IF-THEN, IF-ELSE, multiple conditions, nested IF, CASE
• Iterative statements: Loop-End Loop, For-Loop, While Loop, Exit Loop, Continue

Cursors and Exception Handling, Packages, Triggers

5 topics

• Concepts of Cursors: Implicit & Explicit; Declare, open, fetch, close
• Cursor Attributes: %FOUND, %NOTFOUND, %ISOPEN, %ROWCOUNT
• Exception Handling in PL/SQL
• Stored Procedures, Stored Functions & Packages
• Database Triggers

Study this subject

Every topic above is a lesson you can read here, in English, Hindi or Gujarati. In Gri-Learn the same topics are graded decks: the self-checks are scored and your weak topics are tracked. Free, with nothing locked.

Already have an account? Sign in