img

Oracle PL/SQL Developer Certified Associate



$ 61

Talk to an expert for free!

Overview

Individual holding the Oracle PL/SQL Developer Certified Associates certification demonstrate expertise in building database-centric Internet applications for 10g & 11g Oracle databases.

Target Audience

Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.

Expected Duration

00:29 (HH:MM)

e-Learning

29 Hours 25 Minutes of elearning content

Glossary

Glossary

Course

Course Index

Transcript

Toggle Closed Captions

Report

Detailed test scores and print test score report

Topic

Learning points – Navigate to different parts of the topic or previous topic or next topic in the course

Topic

Complete in a single session or multiple sessions

bookmardimage

Return to last topic view using Return to bookmark feature

Badge

Course Completion Certificate & Badge

Validity

1 year Validity

Lesson-1

Using SQL to Query Your Database

  Topic 1 Using SQL to Query Your Database 02:10

Lesson-2

Conversion Functions, Group Functions, and Join

  Topic 2 Conversion Functions, Group Functions, and Join 02:00

Lesson-3

Subqueries, Set Operators, and Data Manipulation

  Topic 3 Subqueries, Set Operators, and Data Manipulation 01:55

Lesson-4

Using DDL, Views, Sequences, Indexes, and Synonyms

  Topic 4 Using DDL, Views, Sequences, Indexes, and Synonyms 01:45

Lesson-5

Controlling User Access and Managing Schema Objects

  Topic 5 Controlling User Access and Managing Schema Objects 01:55

Lesson-6

Data Dictionary Views and Large Data Sets

  Topic 6 Data Dictionary Views and Large Data Sets 01:40

Lesson-7

Managing Data in Different Time Zones

  Topic 7 Managing Data in Different Time Zones 01:20

Lesson-8

Using Subqueries and Regular Expressions

  Topic 8 Using Subqueries and Regular Expressions 01:50

Lesson-9

Getting Started With PL/SQL

  Topic 9 Getting Started With PL/SQL 01:55

Lesson-10

Using DML, DDL, Cursors, Loops, and Control Structures

  Topic 10 Using DML, DDL, Cursors, Loops, and Control Structures 01:20

Lesson-11

Using Data Types, INDEX BY Tables, and Cursors

  Topic 11 Using Data Types, INDEX BY Tables, and Cursors 01:40

Lesson-12

Using Exceptions, Subprograms, JDeveloper, and REF Cursors

  Topic 12 Using Exceptions, Subprograms, JDeveloper, and REF Cursors 02:00

Lesson-13

Subprograms, Packages, and Exception Handling

  Topic 13 Subprograms, Packages, and Exception Handling 02:20

Lesson-14

Packages, Dynamic SQL, and Coding Considerations

  Topic 14 Packages, Dynamic SQL, and Coding Considerations 02:20

Lesson-15

PL/SQL Code and Dependency Management

  Topic 15 PL/SQL Code and Dependency Management 01:20

Lesson-16

Using Triggers and the PL/SQL Compiler

  Topic 16 Using Triggers and the PL/SQL Compiler 02:00

img