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:
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.
The CareerStart's Oracle 12c Developer track prepares students for the Oracle Developer OCP Certification.
The following modules make up the CareerStart's Oracle 12c Developer career track:
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.
Learn To:
Benefits to You
Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.
Learn Advanced Features of SQL
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.
Introduction
Working with Oracle Cloud Exadata Express Cloud Service
Retrieving Data using the SQL SELECT Statement
Restricting and Sorting Data
Using Single-Row Functions to Customize Output
Using Conversion Functions and Conditional Expressions
Reporting Aggregated Data Using the Group Functions
Displaying Data from Multiple Tables Using Joins
Using Subqueries to Solve Queries
Using the SET Operators
Managing Tables using DML statements
Introduction to Data Definition Language
Introduction to Data Dictionary Views
Creating Sequences, Synonyms, Indexes
Creating Views
Managing Schema Objects
Retrieving Data by Using Subqueries
Manipulating Data by Using Subqueries
Controlling User Access
Manipulating Data
Managing Data in Different Time Zones
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:
Benefits to You
Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.
Use Oracle SQL Developer
You will use Oracle SQL Developer to develop these program units. SQL*Plus is introduced in this course as optional tools.
Course Bundle
Note: This course is a combination of Oracle Database: PL/SQL Fundamentals and Oracle Database: Develop PL/SQL Program Units courses.
Introduction
Working with Oracle Cloud Exadata Express Cloud Service
Introduction to PL/SQL
Declare PL/SQL Variables
Write Anonymous PL/SQL Blocks
SQL Statements in a PL/SQL block
Control Structures
Composite Data Types
Explicit Cursors
Exception Handling
Stored Procedures
Stored Functions
Debugging Subprograms
Packages
Deploying Packages
Implement Oracle-Supplied Packages in Application Development
Dynamic SQL
Design Considerations for PL/SQL Code
Triggers
Creating Compound, DDL, and Event Database Triggers
PL/SQL Compiler
Manage Dependencies