Course overview for course Oracle Database Develop PL-SQL Program Units Ed 2
The Oracle Database Develop PL-SQL Program Units Ed 2 course is designed for developers with basic PL/SQL and SQL language skills. Students learn to develop, execute, and manage PL/SQL stored program units such as procedures, functions, packages, and database triggers. Students also learn to manage, PL/SQL subprograms and triggers.
Learn To
- Create, and execute stored procedures and functions.
- Design and use PL/SQL packages.
- Create overloaded package subprograms for more flexibility.
- Utilize Oracle-Supplied Packages in Application Development.
- Create triggers to solve business challenges.
- Build and execute SQL statements dynamically.
Objectives for the course Oracle Database Develop PL-SQL Program Units Ed 2
- Create triggers to solve business challenges
- Manage dependencies between PL/SQL subprograms
- Design PL/SQL code for predefined data types, local subprograms, additional pragmas and standardized constants and exceptions
- Use the compiler warnings infrastructure
- Create, use, and debug stored procedures and functions
- Design and use PL/SQL packages to group and contain related constructs
- Create overloaded package subprograms for more flexibility
- Use the Oracle supplied PL/SQL packages to generate screen output, file output, and mail output
- Write dynamic SQL for more coding flexibility
- Use conditional PL/SQL compilation and obfuscate (hide) code
Course Information
- Delivery Method: Classroom
- Course Duration: 3 days
- Course Level: Intermediate
Audience Summary
- IT Professional
- Database Administrators
- PL/SQL Developers
Prerequisites for this course
- Oracle Database: Introduction to SQL
- Oracle Database: SQL Workshop II Ed 2
- Oracle Database: SQL Workshop I Ed 2
Course content summary for Oracle Database Develop PL-SQL Program Units Ed 2
- Introduction
- Working with Oracle Database Exadata Express Cloud Service
- Creating Stored Procedures
- Creating Functions and Debugging Subprograms
- Creating Packages
- Working With Packages
- Using Oracle-Supplied Packages in Application Development
- Using Dynamic SQL
- Creating Triggers
- Creating Compound, DDL, and Event Database Triggers
- Design Considerations for PL/SQL Code
- Using PL/SQL compiler
- Managing Dependencies
More Evolutiontech Courses for Oracle Database
- Oracle Database: Introduction to SQL Ed 2
- Oracle Database: SQL Workshop I Ed 2
- Oracle Database: SQL Workshop II Ed 2
- Oracle Database: Program with PL/SQL
- Oracle Database: PL/SQL Fundamentals Ed 2
- Oracle Database: SQL and PL/SQL Fundamentals Ed 2
Fale Conosco
Solicite o conteúdo programático do treinamento “Oracle Database Develop PL-SQL Program Units Ed 2” ao nosso departamento comercial