java fundamentals
oracle

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

Online course

Del 1 de enero 2020
al 31 de octubre 2020

Programa

  1. Fundamentals 

  2. Defining Variables and Datatypes 

  3. Using SQL in PL/SQL 

  4. Program Structures to Control Execution Flow

  5. Using Cursors and Parameters 

  6. Using Composite Datatypes 

  7. Exception Handling

  8. Using and Managing Procedures

  9. Using and Managing Functions 

  10. Using and Managing Packages 

  11. Getting the Best out of Packages 

  12. Improving PL/SQL Performance 

  13. Using and Managing Triggers 

  14. Recognizing and Managing Dependencies 

  15. Using the PL/SQL Compiler   

Multiples Imagenes
ods gral
ods educación
Otras actividades relacionadas

Suscríbete

Recibe las últimas tendencias tecnológicas y no te pierdas ninguno de nuestros eventos
The subscriber's email address.

Nuestras redes sociales