OUR VISION

To be the premier Information and Communications Technology (ICT) training and consulting services provider in the caribbean.

OUR MISSION

To improve the quality of knowledge and skills base of ICT professionals within the caribbean through the provision of competitive world-class ICT training and consulting services on current and emerging platforms.

Oracle Database 10g: Introduction to SQL

Duration: 5 Days

This course offers students an introduction to Oracle Database 10g database technology. In this class students 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.
In addition, the advanced features of SQL in order to query and manipulate data within the database are taught. Advanced querying and reporting techniques are explained. Schema objects that are useful for data warehousing and other application areas are discussed in detail. Students learn about manipulating large data sets and storing and retrieving dates according to different time zones.

Target Audience
• Application Developers
• Business Intelligence Developer
• Database Administrators
• End Users
• Forms Developer
• PL/SQL Developer
• Portal Developer

Prerequisites
• Familiarity with Data Processing Concepts and Techniques
• Ability to use a graphical user interface (GUI)

Course Objectives
• Retrieve row and column data from tables with the SELECT statement.
• Employ SQL functions to generate and retrieve customized data.
• Run data manipulation statements (DML) to update data in the Oracle Database 10g.
• Control user access and manage schema objects
• Search data using advanced sub queries

Course Outline

  • Introduction
  • Writing SQL SELECT Statements
  • Restricting and Sorting Data
  • Using Single-Row Functions to Customize Output
  • Reporting Aggregated Data Using the Group Functions
  • Displaying Data from Multiple Tables
  • Using Sub queries to Solve Queries
  • Using the SET Operators
  • Manipulating Data
  • Using DDL Statements to Create and Manage Tables
  • Creating Other Schema Objects
  • Managing Objects with Data Dictionary Views
  • Controlling User Access
  • Manage Schema Objects
  • Manipulating Large Data Sets
  • Generating Reports by Grouping Related Data
  • Managing Data in Different Time Zones
  • Searching Data Using Advanced Sub queries
  • Hierarchical Retrieval
  • Regular Expression Support

Suggested Follow-Up Course
Oracle Database 10g: Program with PL/SQL [NEW]