Sumraaz Technologies
Home | About Sumraaz | Professionals Speak | Alliances and Partners | Careers | Contact Us 
  Sumraaz Kids
Facebook   Twitter   Linkedin   Blog
Individual Programs
+91- 9892005564
IT for 10th & 12th   Visual Basic 6.0   Oracle 9i Oracle 10g-DBA
C Programming   VB.NET 9.0   Java Oracle 10g-Developer
C++   ASP.NET 3.5   Adv. Java/J2EE  
Data Structures   C # 3.0   Struts  

Oracle10g Developer Track

You will be able to...
- Build robust and scalable Oracle9i 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
- Appear for OCA and OCP Certification Exams for Developer Track
Who should attend...
This course is valuable for those who are, or will be, working with Oracle9i. 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 9i SQL and PL/SQL
Introduction to Oracle 10g : SQL (Exam – IZ0– 007)
  Course Content
  Duration : 56 Hrs.
  Prerequisite: Computer Fundamentals, Windows Operating System
  Writing Basic SQL SELECT Statements
  Restricting and Sorting Data
  Single- Row Functions
  Displaying Data from Multiple Tables
  Aggregating Data Using GroupFunctions
  Producing Readable Output with iSQL *Plus
  Manipulating Data
  Creating and Managing Tables
  Including Constraints
  Creating Views
  Other Database Objects
  Controlling User Access
  SQL Workshop
  Using SET Operators
  Oracle 9i Datetime Functions
  Enhancements to the GROUP BY Clause
  Advanced Subqueries
  Hierarchical Retrival
  Oracle 10g Extensions to DML and DDL Statements
Oracle 10g : Program with PL/SQL (Exam – IZ0– 147)
  Course Content
  Duration : 52 Hrs.
  Prerequisite : Oracle 10g SQL
   Introduction to PL/SQL
  Declaring Variables Writing Executable Statements
   Interacting with Oracle Server
   Writing Control Structures
   Working with Composite Data Types
  Writing Explicit Cursors
  Advanced Explicit Cursor Concepts
   Handling Exceptions
   Creating Procedures
  Creating Functions
  Managing Subprograms
  Creating Packages
  More Package Concepts
  Oracle Supplied Packages
  Manipulating Large Objects
  Creating Database Triggers
  More Trigger Concepts
  Managing Dependencies
Oracle 10g Forms Developer: Build Internet Applications (Exam – IZ0– 141)
  Course Content
  Duration : 60 Hrs.
  Prerequisite: Oracle 10g SQL and PL/SQL
   Introduction to Oracle Forms Developer and Oracle Forms Services
   Running a Forms Developer Application
  Working in Forms Developer Environment
  Creating a Basic Form Module
   Working with Data Blocks and Frames
   Working with Text Items
  Creating LOVs and Editors
   Creating Additional Input Items
  Creating Non – Input Items
   Creating Windows And Content Canvases
   Working with Other Canvas Types
  Introduction to Triggers
   Producing Triggers
   Debugging Triggers
  Adding Functionality to Items
  Runtime Messages and Alerts
   Query Triggers
   Transaction Processing
   Writing Flexible Code
   Sharing Objects and Code
   Introducing Multiple Form Applications