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.
Do you work at this company and want to update this page?
Is there out-of-date information about your company or courses published here? Fill out this form to get in touch with us.
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
- 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
- PL/SQL FLOW CONTROL
- CONDITIONAL CONTROL
- COMPARISON OPERATORS
- LOGICAL OPERATORS
- REPETITION CONTROL
- THE GOTO STATEMENT
- CASE EXPRESSIONS / STATEMENTS
- BIND VARIABLES
- SUBSTITUTION VARIABLES
- SQL DEVELOPER AND PL/SQL
- SQL DEVELOPER AND PL/SQL
- CREATING AND EXECUTING SCRIPTS
- 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
- 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
- OPTIMIZATION
- TIMING PL/SQL
- FOR UPDATE / WHERE CURRENT OF
- 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
- 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
- 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
- PACKAGES
- CREATING PACKAGES
- PACKAGE BENEFITS
- A SIMPLE PACKAGE
- OVERLOADING
- BODILESS PACKAGES
- SOURCE CODE ENCRYPTION
- CREATING PACKAGES FROM PROCEDURES AND FUNCTIONS
- 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
- ADVANCED CONCEPTS
- EMBEDDED PROCEDURES
- THE OPTIMIZING COMPILER
- PL/SQL COMPILER WARNINGS
- COMPILING FOR DEBUGGING
- CONDITIONAL COMPILATION / INQUIRY DIRECTIVES
- DBMS_DB_VERSION
- NATIVE COMPILATION
- FILE OPERATIONS
- MOVING FILES BETWEEN DATABASES
- DIRECTORY ACCESS
- FILE MANIPULATION
- COLLECTIONS
- DEFINING RECORDS
- COLLECTIONS
- Associative Arrays
- Nested Tables
- COLLECTION METHODS
- SET THEORY AND NESTED TABLES
- 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.
Contact this provider
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...