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
