Computer SciencePrograms

Find Your Programs

Introduction to Oracle10g SQL, PL/SQL (Oracle Developer)

course code : IOSPS101

course hours : 40 hours


Course Description

This course offers an introduction to Oracle 10g Database Technology. Trainees learn the concepts of relational databases and the powerful SQL programming language. This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, create database objects, and query meta data. The course also introduces trainees to PL/SQL and helps them understand the benefits of this powerful programming language.

Learning Outcomes

By the end of the course, participants will be able to:

  • Use the ISQL*Plus web-based database interface and other traditional interfaces
  • Write simple SQL queries and moderately complex SQL queries
  • Summarize, group and sort data
  • Handle advanced query techniques such as correlated sub queries
  • Develop simple SQL*Plus reports
  • Create database tables
  • Maintain database tables
  • Take advantage of new features such as the use of regular expressions
  • Move beyond basic table definitions, consideration of defining the full range of database objects
  • Employ the basic database security and object privileges
  • Use the powerful set of built-in SQL functions
  • Protect the database
  • Extend the basic data model using declarative constraints
  • Perform advanced SQL queries such as grouping and cube operations and SQL99 join syntax
  • Develop complex SQL*Plus reports and using SQL*Plus scripts
  • Use the SQL99 joins syntax

Apply Area

© 2017 All Rights Reserved. Future University in Egypt (FUE)