Oracle 10g(Developer)                                                                                                            

Paper 1
Oracle 10g Database SQL Fundamentals I

• Introduction

  • Retrieving Data Using the SQL Select Statement
  • Restricting and Sorting Data
  • Using Single Row Functions to Customize Output
  • Reporting Aggregated Data Using the Group Functions
  • Displaying Data from Multiple Tables
  • Using Subqueries to solve queries
  • Using the Set Operators
  • Manipulating Data
  • Using DDL Statements to Create & Manage Tables
  • Creating Other Schema Objects
  • Managing Objects with Data Dictionary Views

Oracle 10g Database SQL Fundamentals II

• Introduction

  • Controlling User Access
  • Managing Schema Objects
  • Manipulating Large Data Sets
  • Generating Reports by Grouping related Data
  • Managing Data in Different Time Zones
  • Retrieving Data using Subqueries
  • Hierarchical Retrieval
  • Regular Expression Support

 

 PAPER-II

 

Oracle 10g database PL/SQL fundamentals1

• Introduction to PL/SQL
• Declaring PL/SQL Variables
• Writing Executable Statements
• Interacting with the Oracle Server
• Writing Control Structures
• Working with Composite Data Types
• Using Explicit Cursors
• Handling Exception
• Creating Stored Procedures and Functions

Oracle 10g Database Develop PL/SQL Program Units
Introduction

• Creating Stored Procedures
• Creating Stored Functions
• Creating Packages
• Using More Package Concepts
• Using Oracle Supplied Packages in Application Development
• Dynamic SQL and Metadata
• Design Consideration for PL/SQL Code
• Managing Dependencies
• Manipulating Large Objects
• Creating Triggers
• Applications for Triggers
• Understanding and Influencing the PL/SQL Compiler

Facilities:  1.24 Hrs Lab with Internet Facility 2.Students can do Lab till they pass Online Examination without any extra cost.

Batch Timings:  7 - 9 am / 10 - 1 pm / 2 - 5 pm / 6 - 8 pm / Sat & Sun Only / Sunday Only.