Vi ste ovdje
Overview/Description
To write dynamic SQL and use the DBMS_METADATA package
Target Audience
Database administrators, application developers, and database operators
Prerequisites
Familiarity with Oracle Database 10g database technology; an understanding of the basic concepts of relational databases, the SQL programming language, and stored procedures; ability to write queries against single and multiple tables, manipulate data in tables, create database objects, and query metadata
Expected Duration (hours)
2.2
Lesson ObjectivesDynamic SQL and Metadata
identify the execution flow of SQL and...
Overview/Description
To manage dependencies and recompile PL/SQL units
Target Audience
Database administrators, application developers, and database operators
Prerequisites
Familiarity with Oracle Database 10g database technology; an understanding of the basic concepts of relational databases, the SQL programming language, and stored procedures; ability to write queries against single and multiple tables, manipulate data in tables, create database objects, and query metadata
Expected Duration (hours)
1.4
Lesson ObjectivesManaging Dependencies
retrieve local dependency information for a given...
Overview/Description
To use LOBs and the DBMS_LOB package
Target Audience
Database administrators, application developers, and database operators
Prerequisites
Familiarity with Oracle Database 10g database technology; an understanding of the basic concepts of relational databases, the SQL programming language, and stored procedures; ability to write queries against single and multiple tables, manipulate data in tables, create database objects, and query metadata
Expected Duration (hours)
1.9
Lesson ObjectivesManipulating Large Objects in PL/SQL
associate internal and external LOBs with their...
Overview/Description
To use Oracle-supplied packages
Target Audience
Database administrators, application developers, and database operators
Prerequisites
Familiarity with Oracle Database 10g database technology; an understanding of the basic concepts of relational databases, the SQL programming language, and stored procedures; ability to write queries against single and multiple tables, manipulate data in tables, create database objects, and query metadata
Expected Duration (hours)
2.8
Lesson ObjectivesOracle-Supplied Packages and DBMS_SCHEDULER
use the DBMS_OUTPUT package to send a message...
Overview/Description
To create and work with Oracle 10g packages
Target Audience
Database administrators, application developers, and database operators
Prerequisites
Familiarity with Oracle Database 10g database technology; an understanding of the basic concepts of relational databases, the SQL programming language, and stored procedures; ability to write queries against single and multiple tables, manipulate data in tables, create database objects, and query metadata
Expected Duration (hours)
2.8
Lesson ObjectivesPL/SQL Packages
recognize the structure of a package and outline the...
Overview/Description
To create and manage triggers
Target Audience
Database administrators, application developers, and database operators
Prerequisites
Familiarity with Oracle Database 10g database technology; an understanding of the basic concepts of relational databases, the SQL programming language, and stored procedures; ability to write queries against single and multiple tables, manipulate data in tables, create database objects, and query metadata
Expected Duration (hours)
3.8
Lesson ObjectivesPL/SQL Triggers
identify the function, benefits, and enhancements provided by triggers in PL...
Koraci do učenja
Prijavite se, a ako nemate korisničko ime, registrirajte se.
Pronađite edukacijske programe u Katalogu i Certifikaciji, ili koristite polje za pretragu.
Upisani programi dostupni su u meniju Korisnik, Moji tečajevi.
Trebate pomoć?
- Česta pitanja - FAQ
- telefon: +385 1 6558 440
- email: support@cognita.hr
- Kontakt forma
