Oracle PL/SQL

This course is designed to aim at imparting a basic level Oracle database. After completing the course the incumbent is able to the write, execute and understand sql statement and basic PL/SQL programming.

Course Outline:

• Overview of Oracle:
  • Overview of Oracle Database and architecture
  • Overview of Transactions
  • Commit and Undo Transactions
  • Savepoints
  • Overview of Oracle SQL
• Overview of SQL:
  • Use of DDL Statements to Create and Manage Tables
  • Overview of Datatypes
  • Overview of Data Integrity, Integrity Constraints & Keys
  • Data Manipulation Statements
  • DCL - Data Control Language. Some examples:
  • TCL - Transaction Control:
  • Retrieve Data using the SQL SELECT Statement
  • Learn to Restrict and Sort Data
  • Usage of Single-Row Functions to Customize Output
  • Invoke Conversion Functions and Conditional Expressions
  • Aggregate Data Using the Group Functions
  • Display Data From Multiple Tables Using Joins
  • Use Sub-queries to Solve Queries
  • The SET Operators
  • Function
  • Expressions
  • Other Schema Objects
  • Pseudocolumns
• Overview of PL/SQL:
  • Understanding the basic Features of PL/SQL
  • Block Structure
  • Variables, Assignment and Operators
  • Writing Control Structures
  • Cursors
  • Cursor FOR Loops
  • Cursor Variables Attributes
  • Procedures
  • Functions
  • Packages
  • Triggers
  • Error Handling