At Prospects IT, we provide a complete set of PL/SQL Services to drive your company's digital growth. In addition, we have services tailored to individual needs, from comprehensive Sql to large based application.

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.

dummy-image

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

Copyright © Prospects IT Solutions - All Rights Reserved. Powered by  OpenPixel