• Overview
• Outline
• Schedule

About This Course

This course offers students an introduction to Oracle Database 11g database technology. In this class students learn the concepts of relational databases and the 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 needed to query and manipulate data within the database are taught. 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.

Audience Profile

This course is designed for the following audiences:

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

Prerequites

Before attending this course, students must have:

• Familiarity with data processing concepts and techniques.
• Ability to use a graphical user interface (GUI).

At Course Completion

After completing this course students will be able to:

• 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 11g.
• Control user access and manage schema objects
• Search data using advanced sub queries