Imate žicu za učenje?

PL/SQL Packages

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...

PL/SQL Triggers

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...

Using Composite Data Types

Overview/Description To identify the benefits associated with records and collections, declare and initialize nested tables and VARRAYs, and create and reference an INDEX BY table and table of records 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 and the SQL programming language; ability to write queries against single and multiple tables, manipulate data in tables, create database objects, and query metadata Expected...

Using Control Structures

Overview/Description To implement a suitable conditional control statement in PL/SQL, simple and searched CASE expressions, and a suitable loop construct 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 and the SQL programming language; 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 ObjectivesUsing...

Using PL/SQL with an Oracle Server

Overview/Description To write lexical units in their correct format in a PL/SQL block, perform data conversion in PL/SQL, write PL/SQL anonymous blocks, and recognize the correct structure of a PL/SQL program block 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 and the SQL programming language; ability to write queries against single and multiple tables, manipulate data in tables, create database objects, and query...

Koraci do učenja

1Prijavi se

Prijavite se, a ako nemate korisničko ime, registrirajte se.

2Pronađi i upiši program

Pronađite edukacijske programe u Katalogu i Certifikaciji, ili koristite polje za pretragu.

3Uči

Upisani programi dostupni su u meniju Korisnik, Moji tečajevi.

»Detaljne upute

Trebate pomoć?