Course Name: Oracle 11g Developer Duration: 168 Hrs. This course provides an exhaustive coverage of SQL, PL/SQL & Forms. Take Away: After completion of this course you will be able to Appear for OCA and OCP Certification Exams for Developer Track Target Audience Pre-requisites This course is valuable for those who are, or will be, working with Oracle 11g. Experience with relational databases and familiarity with basic programming concepts are helpful. Computer Fundamentals and Windows Operating System knowledge is an advantage. Any Programming Language, DBMS like Dbase or FoxPro are preferred and Oracle 11g SQL and PL/SQL Computer Fundamentals, Windows Operating System Objectives : You will learn Build robust and scalable Oracle 11g database applications Establish a data model and a storage framework Develop powerful and efficient SQL statements Write reusable structured PL/SQL code with cursors, procedures and triggers Improve application performance by utilizing indexes and optimizing PL/SQL

Topics Covered

Oracle 11g Developer Course Content Introduction to Oracle : SQL (Exam – IZ0– 051) (Duration: 56 Hrs.) Prerequisite Computer Fundamentals, Windows Operating System Take Aways Create database tables. Manage database objects. Access and manipulate data in the database using SQL statements. Control user access to data. Oracle 11g : SQL Certification exam readiness Course Contents SQL Select Statements Sorting Data Single-Row Functions Group Functions Sub-queries SET Operators Output with iSQL *Plus Manipulating Data DDL statements Schema objects Views Controlling user access Reports Hierarchical retrieval Regular expression support Oracle 11g : Program with PL/SQL (1Z0-144) Duration: 52 Hrs. Prerequisite Oracle Database 11g : SQL Take Aways Create programs to manage database Use exception handling Create triggers Manage dependencies Course Contents PL/SQL Variables & writing executable statements Oracle Server Control Structures Composite Data Types Explicit Cursors Advanced Explicit Cursor Concepts Exception Handling Procedures Functions Subprograms Packages Oracle Supplied Packages Large Objects Dependencies Recommended Next Course Oracle 11g: Oracle Forms : Build Internet Applications (1Z0-141) Oracle 11g : Forms Developer : Build Internet Applications (1Z0-141) Duration : 60 Hrs. Prerequisite Oracle Database 11g SQL & PL/SQL Take Aways Create an internet application using forms Course Contents Oracle Forms Developer Oracle Forms Services Forms Developer Application Forms Developer Environment Basic Form Module Data Blocks and Frames Text Items LOVs and Editors Additional Input Items Non-input Items Windows And Content Canvases Other Canvas Types Triggers Runtime Messages and Alerts Validation Navigation Transaction Processing Writing Flexible Code Sharing Objects and Code WebUtil to interact with client Multiple Form Applications

Who should attend

BE, BTech, Mtech, BSC, BCom, MCom, BCA, MCA, IT and Computer engineer

Pre-requisites

C programming

What you need to bring

Notepad

Key Takeaways

Student will be job ready to work with IT MNC as Oracle developer