![oracle](/sites/default/files/2019-11/academy_wht.gif)
Programación con PL/SQL
This course introduces students to PL/SQL, Oracle’s procedural extension language for SQL and the Oracle relational database. Participants explore the differences between SQL and PL/SQL. They also examine the characteristics of PL/SQL and how it is used to extend and automate SQL to administer the Oracle database.
This course culminates with a project that challenges students to program, implement, and demonstrate a database solution for a business or organization.
For college/university faculty who teach computer programming or a related subject and secondary school teachers who teach computer programming
Prerequisites Required: Previous experience with at least one programming language
Duración
180 horas
Curso Online
Programa
-
Fundamentals
-
Defining Variables and Datatypes
-
Using SQL in PL/SQL
-
Program Structures to Control Execution Flow
-
Using Cursors and Parameters
-
Using Composite Datatypes
-
Exception Handling
-
Using and Managing Procedures
-
Using and Managing Functions
-
Using and Managing Packages
-
Getting the Best out of Packages
-
Improving PL/SQL Performance
-
Using and Managing Triggers
-
Recognizing and Managing Dependencies
-
Using the PL/SQL Compiler
![ods gral](/sites/default/files/styles/activity_icon/public/2019-10/ONU_Emblema_10.png?itok=FhdN_6CR)
![ods educación](/sites/default/files/styles/activity_icon/public/2019-10/S_SDG%20goals_icons-individual-rgb-04_20.png?itok=yrJkIMs4)