PL SQL TRAINING
Suggested Audience
PL/SQL developers, DW ETL developers, DBAs and production DBAs.
1. PL/SQL Overview
- Definition
- Object-orientation implementation
- Advantages and disadvantages
- Assumed knowledge
- Performance
2. PL/SQL Language Semantics & Constructs
- Block structures
- Variables and constants
- Query processing
- Control structures
- Modules and sub-programs
- Abstract objects (e.g., collections, object types)
- Error and exception handlers
- Use of SQL*Plus
3. PL/SQL Language Properties & Conventions
- Character set
- Lexical elements (e.g., reserve words, comments)
- Declarations
- Defaults
- NULL/NOT NULL
- %TYPE and %ROWTYPE attributes
- Naming conventions
- Scoping
- Name resolution
- Assignments (e.g., to variables)
- Expressions and comparisons
- Built-in functions
- Data types
4. PL/SQL – The Big Picture
- Client-server architecture PL/SQL execution flow SQL*Plus DBMS_OUTPUT.LIN
5. How Sql Interoperates With PL/SQL
- SELECT INTO
- DML within PL/SQL block
- PL/SQL block sequencing
- Savepoints
- Commit/rollback
6. Conditional Constructs
- IF-THEN
- IF-THEN-ELSE
- ELSEIF
- Nested IF
- CASE statements
- NULLIF/COALESCE
- Loops
- EXIT WHEN
- GOTO
7. Exception & Error Handling
- Reason for
- Runtime vs. compile-time errors
- Built-in exceptions
- How exceptions are ‘raised’/’propagated’
8. SQL With PL/SQL Programming
- Definition and concepts
- INSERT, UPDATE and DELETE of PL/SQL records
- FOR loops and cursors
- Subqueries
- REF CURSOR
- Transaction controls
9. PL/SQL Subprograms
- Definition
- Advantages
- Subprogram types
- Procedures
- Functions
- Parameter passing
- Invoking
- Overloading
10. PL/SQL Objects – An Introduction
- Definition
- Advantages
- Structure
- Initialisation
- Attributes
- Constructors
- Methods
- Manipulating
11. Introduction To Package Concepts
- Definition
- Benefits
- pecifications
- Body
- How to call
- Private objects
- Variables and cursors
12. TRIGGERS
- Definition
- When to consider
- BEFORE/AFTER
- ROW/STATEMENT
- INSTEAD OF
13. PL/SQL Debugging
- DBMS_DEBUG
- ADP_DEBUG
- How to debug a PL/SQL block
- How to start the ‘debuggee’
- How to start the ‘debugger’
- Breakpoints
- Executing the debugger
- ‘Stepping’ the debugger
- ADP package definition
- ADP debugger body
- XXX.SQL strings
If you want to know more about PL SQL TRAINING do not hesitate to call +91-7774892805 or mail us on contact@intelogik.com
