Oracle Database 12c : PL/SQL Developer Certified Associate (OCA)

Become an Oracle Database SQL Certified Associate and demonstrate understanding of fundamental SQL concepts needed to undertake any database project. Passing the exam illustrates depth of knowledge of SQL and its use when working with the Oracle Database server. Gain a working knowledge of queries , insert, update and delete SQL statements as well as some Data Definition language and Data Control Language, the optimizer, tales and indexes, data modeling and normalization. By passing this exam, a consulting individual proves fluency in and a solid understanding of SQL language . data modeling and using SQL to create amd manipulate tables in an Oracle Database. Qualified candidates have knowledge of general computing  concepts,  knowledge of command line interfaces and experience working in command line

Certification by : Oracle

Program # Program Contents Exam # Exam Regular Track
(days)

1Z0-061

Oracle Database: Introduction to SQL 1Z0-071 Oracle Database 12c SQL 5

1Z0-144

Oracle Database: Program with PL/SQL 1Z0-144 Oracle Database 11g: Program with PL/SQL 5
  Total 10
  • Understand the basic concepts of relational databases ensure refined code by developers.
  • Create reports of sorted and restricted data.
  • Run data manipulation statements (DML).
  • Control database access to specific objects.
  • Manage schema objects.
  • Manage objects with data dictionary views.
  • Retrieve row and column data from tables.
  • Control privileges at the object and system level.
  • Create indexes and constraints; alter existing schema objects.
  • Create and query external tables.
  • Conditionally control code flow (loops, control structures).
  • Create stored procedures and functions.
  • Use PL/SQL packages to group and contain related constructs.
  • Create triggers to solve business challenges.
  • Use some of the Oracle supplied PL/SQL packages to generate screen output and file output.
  • Create custom packages for applications.
  • Write Dynamic SQL code for applications.
  • Application Developers
  • System Analysts
  • Business Analysts
  • Forms Developer
  • Developer
  • Data Warehouse Administrator
  • PL/SQL Develope