Call: 913 488 5447
Email: info@pranceit.com

PL/SQL

PL/SQL

Course Description:

This course is designed to give users an understanding of Oracle SQL and Oracle PL/SQL languages using Oracle’s SQL*Plus and iSQL*Plus tools. The course covers SQL commands for DML, DDL, Query, and Transaction Control operations. Students are also introduced to procedural programming using PL/SQL. The course topics are applicable to all versions of Oracle through Oracle 10g.

Course Outline:

  • Chapter 1: Database Design
  • Chapter 2: Oracle Standard Interfaces
  • Chapter 3: The Sample Database
  • Chapter 4: Data Definition Language
  • Chapter 5: Data Manipulation Language
  • Chapter 6: Transaction Control
  • Chapter 7: SQL Operators
  • Chapter 8: SQL FUNCTIONS
  • Chapter 9: Joining Tables
  • Chapter 10: Set Operators
  • Chapter 11: SQL Subqueries
  • Chapter 12: Groups
  • Chapter 13: More Database Objects
  • Chapter 14: Reports
  • Chapter 15: Introduction
  • Chapter 16: Declarations and Data Types
  • Chapter 17: Language Components
  • Chapter 18: Cursors
  • Chapter 19: Exceptions
  • Chapter 20: Functions and Procedures
 
mail-icon