Course Description:
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.
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.
PL/SQL PROGRAM STRUCTURE
PL/SQL FLOW CONTROL
SQL DEVELOPER AND PL/SQL
SELECT INTO
THE PL/SQL CURSOR
OPTIMIZATION
PL/SQL EXCEPTION HANDLING
STORED PROCEDURES
CREATING FUNCTIONS IN PL/SQL
PACKAGES
CREATING DML TRIGGERS
ADVANCED CONCEPTS
FILE OPERATIONS
COLLECTIONS
BULK OPERATIONS
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.
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.
*For more details call:Â 858-208-4141Â or email:Â training@ccslearningacademy.com; sales@ccslearningacademy.com