Computer Courses

Oracle SQL/PL-SQL

Oracle Reports is a tool for developing reports against data stored in an Oracle database. Oracle Reports consists of Oracle Reports Developer (a component of the Oracle Developer Suite) and Oracle Application Server Reports Services (a component of the Oracle Application Server).

Duration:
Programs Hours
ORACLE DBA 10g/11g 40

Oracle Database Programming SQL/PL-SQL

SQL
  • Introduction to RDBMS
  • Data types
  • Sql Languages
  • Constraints
  • Single row and multirow functions
  • Conversion functions
  • Conditional expressions
  • Operators
  • SET operators
  • Joins
  • Sub Queries
  • Co-related Sub Queries
  • Views
  • Sequence
  • Synonyms
  • Indexes
  • User Access
  • Rollup and Cube
  • Time Zone
  • External Tables
  • Multiple Table Inserts
  • Exercise
PL/SQL
  • Introduction to PLSQL Environment
  • Variables and Data Types
  • Languages
  • Control Structures
  • Cursors
  • Exceptions Procedures
  • Functions
  • Triggers
  • Packages
  • Oracle inbuilt Packages
  • Dynamic SQL
  • REF Cursors
  • PLSQL Tables