Oracle 19c PL/SQL Fundamentals

Trivera Technologies LLC
Training overview
Professional Course
3 days

Course description

Oracle 19c PL/SQL Fundamentals

Oracle 19C PL/SQL Fundamentals provides a complete, hands-on, comprehensive introduction to PL/SQL including the use of both SQL Developer and SQL*Plus.

Want to find out more?

Who should attend?

This course is appropriate for anyone needing to interface with an Oracle database or those needing a general understanding of Oracle database functionality. That would include end users, business analysts, application developers and database administrators.

Attendees should have basic computer skills. A basic knowledge of databases is helpful, but not required.

Training content


  1. PL/SQL PROGRAM STRUCTURE
    • PL/SQL VS. SQL
    • PL/SQL ENGINES AVAILABLE
    • ANONYMOUS PL/SQL BLOCK STRUCTURE
    • OBJECT NAMING RULES
    • VARIABLE DECLARATIONS
    • AVAILABLE DATATYPES
    • EXECUTABLE STATEMENTS
    • EXPRESSIONS
    • BLOCK LABELING
    • VARIABLE SCOPING RULES
    • COMMENTS IN PROGRAMS AND SCRIPTS
    • BASIC CODING STANDARDS
  2. PL/SQL FLOW CONTROL
    • CONDITIONAL CONTROL
    • COMPARISON OPERATORS
    • LOGICAL OPERATORS
    • REPETITION CONTROL
    • THE GOTO STATEMENT
    • CASE EXPRESSIONS / STATEMENTS
    • BIND VARIABLES
    • SUBSTITUTION VARIABLES
  3. SQL DEVELOPER AND PL/SQL
    • SQL DEVELOPER AND PL/SQL
    • CREATING AND EXECUTING SCRIPTS
  4. SELECT INTO
    • SELECTING SINGLE ROWS OF DATA
    • ANCHORING VARIABLES TO DATATYPES
    • DML IN PL/SQL
    • RETURNING … INTO
    • SEQUENCES IN PL/SQL
    • TRANSACTION CONTROL IN PL/SQL
    • AUTONOMOUS TRANSACTIONS
  5. THE PL/SQL CURSOR
    • DECLARING EXPLICIT CURSORS
    • OPENING AND CLOSING EXPLICIT CURSORS
    • USING EXPLICIT CURSORS TO RETRIEVE VALUES
    • EXPLICIT CURSOR ATTRIBUTES
    • USING A LOOP WITH AN EXPLICIT CURSOR
    • USING %ROWTYPE WITH CURSORS
    • THE CURSOR FOR LOOP
    • DBMS_OUTPUT
    • LAB 5: THE PL/SQL CURSOR
    • LAB 5 SOLUTIONS: THE PL/SQL CURSOR
  6. OPTIMIZATION
    • TIMING PL/SQL
    • FOR UPDATE / WHERE CURRENT OF
  7. PL/SQL EXCEPTION HANDLING
    • THE EXCEPTION SECTION
    • ORACLE NAMED EXCEPTIONS
    • PRAGMA EXCEPTION_INIT
    • USER DEFINED EXCEPTIONS
    • RAISING NAMED EXCEPTIONS
    • EXCEPTION PROPAGATION
    • RAISING AN EXCEPTION AGAIN
    • LIFE AFTER AN EXCEPTION
    • WHEN OTHERS
    • TAKING YOUR BALL AND GOING HOME
    • DBMS_ERRLOG
  8. STORED PROCEDURES
    • PROCEDURES
    • BENEFITS OF STORED PROCEDURES
    • PARAMETERS AND STORED PROCEDURES
    • STORED OBJECT CREATION
    • COMPILATION ERRORS
    • VIEWING COMPILED CODE
    • DROPPING A PROCEDURE
    • THE ALTER COMMAND AND STORED PROCEDURES
  9. CREATING FUNCTIONS IN PL/SQL
    • FUNCTIONS
    • PURITY LEVELS
    • USING WHITE LISTS
    • OPTIMIZATIONS
    • PARALLEL_ENABLE
    • DETERMINISTIC FUNCTIONS
    • PL/SQL RESULT CACHE
    • NOCOPY
    • DBMS_OUTPUT IN FUNCTIONS
    • USING THE WITH CLAUSE FOR FUNCTIONS
    • PRAGMA UDF
    • PRAGMA INLINE
    • USING SQL DEVELOPER WITH STORED PROCEDURES
    • DEBUGGING
  10. PACKAGES
    • CREATING PACKAGES
    • PACKAGE BENEFITS
    • A SIMPLE PACKAGE
    • OVERLOADING
    • BODILESS PACKAGES
    • SOURCE CODE ENCRYPTION
    • CREATING PACKAGES FROM PROCEDURES AND FUNCTIONS
  11. CREATING DML TRIGGERS
    • DML TRIGGERS
    • DML TRIGGER STRUCTURE
    • CONDITIONAL TRIGGERING PREDICATES
    • TRIGGERS FOR BUSINESS RULES ENFORCEMENT
    • MUTATING AND CONSTRAINING TABLES
    • COMPOUND TRIGGERS
    • CONTROLLING FIRING ORDER
    • DDL FOR TRIGGERS
    • VIEWING TRIGGER SOURCE
    • INSTEAD OF TRIGGERS
  12. ADVANCED CONCEPTS
    • EMBEDDED PROCEDURES
    • THE OPTIMIZING COMPILER
    • PL/SQL COMPILER WARNINGS
    • COMPILING FOR DEBUGGING
    • CONDITIONAL COMPILATION / INQUIRY DIRECTIVES
    • DBMS_DB_VERSION
    • NATIVE COMPILATION
  13. FILE OPERATIONS
    • MOVING FILES BETWEEN DATABASES
    • DIRECTORY ACCESS
    • FILE MANIPULATION
  14. COLLECTIONS
    • DEFINING RECORDS
    • COLLECTIONS
    • Associative Arrays
    • Nested Tables
    • COLLECTION METHODS
    • SET THEORY AND NESTED TABLES
  15. BULK OPERATIONS
    • BULK BINDING
    • FORALL
    • SQL%BULK_ROWCOUNT
    • SAVE EXCEPTIONS / SQL%BULK_EXCEPTIONS
    • BULK COLLECT
    • PIPELINED TABLE FUNCTIONS
    • MULTIDIMENSIONAL COLLECTIONS

Costs

  • Price: 1,995.00
  • Discounted Price: 1,296.75

Why choose Trivera Technologies LLC?

Over 25 years of technology training expertise.

Robust portfolio of over 1,000 leading edge technology courses.

Guaranteed to run courses and flexible learning options.

About Trivera Technologies LLC

Trivera Technologies

Trivera Technologies is a IT education services & courseware firm that offers a range of wide professional technical education services including: end to end IT training development and delivery, skills-based mentoring programs,new hire training and re-skilling services, courseware licensing and...


Read more and show all training delivered by this supplier

Contact this provider

Before we redirect you to this supplier's website, do you mind filling out this form so that we can stay in touch? You can unsubscribe at any time.

Country *

Contact info

Trivera Technologies LLC

7862 West Irlo Bronson Highway
STE 626
Kissimmee FL 34747

 Show phone number
www.triveratech.com

Learn more!

Before we redirect you to this supplier's website, do you mind filling out this form so that we can stay in touch? You can unsubscribe at any time.

View again
Supplier Directory
Join our Supplier Directory to:
- Gain Traffic
- Get Noticed
- Showcase Your Services
- Free Listing Available