Imate žicu za učenje?

Getting Started with SQL and PL/SQL New Features

Overview/Description To recognize the scope and capabilities of enhancements to SQL and PL/SQL, including tools such as SQL*Plus and SQL Developer, and use them to create reports and scripts, browse and manage database objects, find subpatterns, and track dependencies Target Audience PL/SQL developers, developers, system analysts, data warehouse administrators, and application developers Prerequisites The learner should have experience and knowledge of SQL and PL/SQL from prior Oracle releases, and hands on experience using PL/SQL Expected Duration (hours) 1.8 Lesson ObjectivesOracle Database...

Using Dynamic SQL and Implementing Performance Improvements

Overview/Description To recognize the steps for improving SQL and PL/SQL flexibility, usability, and performance, using dynamic SQL, language enhancements, and a variety of performance enhancements Target Audience PL/SQL developers, developers, system analysts, data warehouse administrators, and application developers Prerequisites The learner should have experience and knowledge of SQL and PL/SQL from prior Oracle releases, and hands on experience using PL/SQL Expected Duration (hours) 1.3 Lesson ObjectivesOracle Database 11g: Using Dynamic SQL and Implementing Performance Improvements...

Using the PL/SQL Debugger, Collections and Data Warehousing

Overview/Description To recognize ways to utilize the PL/SQL Debugger to analyze your code, identify the uses and benefits of collections, and identify the steps for employing data warehousing enhancements to improve query execution times. Target Audience PL/SQL developers, developers, system analysts, data warehouse administrators, and application developers Prerequisites The learner should have experience and knowledge of SQL and PL/SQL from prior Oracle releases, and hands on experience using PL/SQL Expected Duration (hours) 1.2 Lesson ObjectivesOracle Database 11g: Using the PL/SQL...

Using Trigger, Data Warehousing, and Pivoting Enhancements

Overview/Description To recognize the steps for improving performance, managing scalabilty, enhancing control and processing speed, and reducing network load using enhanced features such as compound triggers, SecureFile LOBs, and PIVOT operations Target Audience PL/SQL developers, developers, system analysts, data warehouse administrators, and application developers Prerequisites The learner should have experience and knowledge of SQL and PL/SQL from prior Oracle releases, and hands on experience using PL/SQL Expected Duration (hours) 1.3 Lesson ObjectivesOracle Database 11g: Using Trigger,...

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ć?