Oracle 12c Developer

All courses are available for online training as well as instructor-led training!

CareerStart's Oracle 12c Developer career track is a career builder for aspiring application developers. This course is designed to prepare students to handle the responsibilities of an Oracle Developer effectively. The objective of this track is to provide students a strong conceptual knowledge and lots of hands-on exercises to help understand the Oracle 12c Forms Builder and Reports Builder better and to appreciate the best practices used in the industry.

This is a rigorous program and you must be willing to devote a substantial amount of time and effort to complete it. Your gains will be in direct proportion to the amount of effort you put into it. The following are just few of the exercises that students actually perform in class as part of their lab exercises:

Design and build a variety of standard and custom Web and paper reports

Retrieve data from any data source, display it in any format, and publish the output to any destination

Customize forms through user input items

Control data access by creating event-related triggers

Test and debug your Web applications through the Forms environment

What is Oracle 12c Developer Suite ?

Oracle Developer Suite is the most complete and integrated development environment, combining the power of application development and business intelligence tools in a single suite that is based on the latest industry standards.

Oracle Developer Suite lets developers quickly build high-quality transactional applications, which can be deployed to multiple channels - including portals, Web services, and wireless devices, and which can be extended with business intelligence capabilities - including ad hoc query and analysis, high-quality Web reporting, and advanced analysis.

Course Details

This Oracle Database 12c: Introduction to SQL training helps you write subqueries, combine multiple queries into a single query using SET operators and report aggregated data using group functions. Learn this and more through hands-on exercises.

This course will help you understand the advanced features of SQL. Learning these features will help you query and manipulate data within the database, use the dictionary views to retrieve metadata and create reports about their schema objects. Some of the date-time functions available in the Oracle Database are also covered. This course also discusses how to use the regular expression support in SQL through expert instruction.

Use Development Tools

The main development tool used in this training is Oracle SQL Developer. SQL*Plus is available as an optional development tool. This is appropriate for a 10g, 11g and 12c audience.

Course Bundle

Note: This course is a combination of Oracle Database 12c: SQL Workshop I and Oracle Database12c: SQL Workshop II courses.

Application Developers

System Analysts

Business Analysts

Forms Developer

Developer

Data Warehouse Administrator

PL/SQL Developer

Introduction

Course Objectives, Course Agenda and Appendixes Used in this Course

Overview of Oracle Database 12c and Related Products

Overview of relational database management concepts and terminologies

Introduction to SQL and its development environments

What is Oracle SQL Developer?

Starting SQL*Plus from Oracle SQL Developer

The Human Resource (HR) Schema

Tables used in the Course

Working with Oracle Cloud Exadata Express Cloud Service

Introduction to Oracle Database Exadata Express Cloud Service

Accessing Cloud Database using SQL Workshop

Connecting to Exadata Express Database using Database Clients

Retrieving Data using the SQL SELECT Statement

Capabilities of the SELECT statement

Arithmetic expressions and NULL values in the SELECT statement

Column aliases

Use of concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword

Use of the DESCRIBE command

Restricting and Sorting Data

Limiting the Rows

Rules of precedence for operators in an expression

Substitution Variables

Using the DEFINE and VERIFY command

Using Single-Row Functions to Customize Output

Describe the differences between single row and multiple row functions

Manipulate strings with character function in the SELECT and WHERE clauses

This Oracle Database: Program with PL/SQL training starts with an introduction to PL/SQL and then explores the benefits of this powerful programming language. Through hands-on instruction from expert Oracle instructors, you'll learn to develop stored procedures, functions, packages and more.

Learn To:

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