Oracle Developer

Oracle Database: SQL Expert

Learn from Oracle Certified professional with 19 years of experience in software development using Oracle products.

Start Date: ,
Frequency: Every Sunday
Timing: 12:00 P.M. to 8:00 P.M.
Duration: 40 Hours

Prepares for Certification Path: 1Z0-047 Oracle Database SQL Expert Exam
Contact: , for details

Important: Max 35 students, qualified students First Come First Server

Brief: Oracle Database SQL Expert course prepares to demonstrate the complete set of skills required for working with the powerful SQL programming language and have mastered the key concepts of a relational database. SQL Experts understand how to use the advanced features of SQL in order to query and manipulate data within the database, control privileges at the object and system level, and use advanced querying and reporting techniques. They are able to manipulate large data sets and understand storing and retrieving dates according to different time zones. They are also knowledgeable about the concepts of controlling access and privileges for schema objects.

Audience: Brothers and Sisters with Knowledge of Microsoft Windows, Microsoft word and excel
Reference Book: OCA Oracle Database SQL Certified Expert Exam Guide, Oracle Press


Oracle Database: Program with PL/SQL

This course starts with an introduction to PL/SQL and proceeds to list the benefits of this powerful programming language. Participants are made aware of how to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. In addition, creation of anonymous PL/SQL blocks as well as stored procedures and functions are covered in this course.

Participants enhance their developer skills by learning to develop, execute, and manage PL\SQL stored program units such as procedures, functions, packages, and database triggers. Understanding the basic functionality of how to debug functions and procedures using the SQL Developer Debugger gives way to refined lines of code. Participants also learn to manage PL/SQL subprograms, triggers, declaring identifiers, and trapping exceptions. The utilization of some of the Oracle-supplied packages is also in the course. Additionally participants learn to use Dynamic SQL, understand design considerations when coding using PL/SQL, understand and influence the PL/SQL compiler, and manage dependencies.

Learn from Oracle Certified professional with 19 years of experience in software development using Oracle products.

Required Prerequisites:
Oracle Database: SQL 
Laptop with Oracle 10g/11g Express and SQL Developer installed

Start Date: Jan-04-2015,
Frequency: Every Sunday for 5 weeks
Timing: 12:00 P.M. to 8:00 P.M.
Duration: 40 Hours

Contact: , for details
Prepares for Certification PathOracle PL/SQL Developer Certified Associate (OCA), 1Z0-147,Program with PL/SQL.

Reference Book: OCP Developer PL/SQL Program Units Exam Guide