PL/SQL course

In the PL/SQL course, you'll learn to work with variables, control structures, cursors, procedures, functions, packages and triggers, and prepare for the Oracle 1Z0-149 exam.

UX/UI design Backend development Digital marketing

Per week:

2

/day

Duration:

2

/month

Age:

18-50

/age

Per week:

4

/hour

Course program

10 topic 46 lesson
01 PL/SQL basics and variables 6 lessons
  1. 1
    Introduction to PL/SQL: block structure, anonymous blocks, SQL Developer and DBMS_OUTPUT
  2. 2
    Valid and invalid identifiers, lexical units
  3. 3
    Declaring and initializing variables and their scope; bind variables
  4. 4
    Data types with the %TYPE and %ROWTYPE attributes
  5. 5
    Built-in SQL functions and sequences; implicit and explicit conversions
  6. 6
    Nested blocks, labels and writing readable code
02 SQL and control structures in PL/SQL 4 lessons
  1. 7
    DML and transaction control in PL/SQL blocks: COMMIT, ROLLBACK, SAVEPOINT
  2. 8
    Storing results with SELECT INTO
  3. 9
    IF and CASE statements and expressions
  4. 10
    LOOP, WHILE and FOR loops; EXIT and CONTINUE
03 Composite data types 4 lessons
  1. 11
    User-defined records and records with %ROWTYPE
  2. 12
    INDEX BY tables (associative arrays) and INDEX BY tables of records
  3. 13
    Nested tables and VARRAYs
  4. 14
    The differences between records, collections and collections of records, and initializing them
04 Cursors and exception handling 5 lessons
  1. 15
    Implicit and explicit cursors, SQL cursor attributes
  2. 16
    Controlling explicit cursors and cursor FOR loops
  3. 17
    Cursors with parameters; FOR UPDATE and WHERE CURRENT OF
  4. 18
    Exceptions: internal, predefined and user-defined
  5. 19
    RAISE, RAISE_APPLICATION_ERROR, PRAGMA EXCEPTION_INIT and propagating exceptions
05 Procedures and functions 4 lessons
  1. 20
    Subprograms: how they differ from anonymous blocks and their advantages
  2. 21
    Procedures with parameters: IN, OUT, IN OUT and named notation
  3. 22
    Creating, invoking and dropping procedures and handling exceptions in them
  4. 23
    Functions: how they differ from procedures, creating them and using them in SQL
06 Packages 5 lessons
  1. 24
    Package benefits and components: the specification and the body
  2. 25
    Invoking package subprograms, dropping packages and viewing package information
  3. 26
    Overloading and forward declarations
  4. 27
    Package types, variables and constants, and package functions in SQL
  5. 28
    Restricting access to package subprograms with ACCESSIBLE BY
07 Dynamic SQL and code design 6 lessons
  1. 29
    SQL statement execution steps and Native Dynamic SQL (EXECUTE IMMEDIATE)
  2. 30
    Binding PL/SQL types to SQL statements and REF CURSOR
  3. 31
    Standard constants and exceptions, local subprograms
  4. 32
    Runtime privileges (definer's and invoker's rights) and autonomous transactions
  5. 33
    NOCOPY, PARALLEL_ENABLE and DETERMINISTIC
  6. 34
    Bulk binding: BULK COLLECT, FORALL and the RETURNING clause
08 Triggers 4 lessons
  1. 35
    DML triggers: BEFORE/AFTER, row-level and statement-level, INSTEAD OF
  2. 36
    Compound triggers
  3. 37
    Triggers on DDL statements and system events
  4. 38
    Trigger types and use cases
09 The compiler, managing code and dependencies 5 lessons
  1. 39
    The PL/SQL compiler, initialization parameters and compiler warnings
  2. 40
    Conditional compilation
  3. 41
    Granting roles to program units and whitelisting with ACCESSIBLE BY
  4. 42
    Marking code as deprecated
  5. 43
    Tracking and managing procedural dependencies
10 Practice and final project 3 lessons
  1. 44
    Mini project: an inventory management package (procedures, functions, triggers)
  2. 45
    Final project: a bank accounts package with transfers, limit checks, an audit trigger and error handling
  3. 46
    Reviewing 1Z0-149 exam topics and sample questions

Our instructors

Meet our experienced teachers!

  • Leyla İsayeva — instructor

    Leyla İsayeva

    PL/SQL course
  • Ayaz Abdullayev — instructor

    Ayaz Abdullayev

    PL/SQL course

    Don't know where to start?

    Not sure where to start?

    Get free advice

    Fill in the details and we'll get in touch with you.

    +994

    Your data is used only to contact you.

    Contact us directly (+994 10) 234 65 56
    CoursePL/SQL course
    • Address
    • 609 Jafar Jabbarli St., Baku / Globus Center

    • Social networks