Oracle Database 11g: Introduction to SQL

5 Day Course
Hands On
Official Oracle Curriculum
Code OC11GDBSQL

This course has been retired. Please view currently available Oracle 11G Training Courses.

Modules

Introduction to SQL (16 topics)

  • Retrieve row and column data from tables with the SELECT statement
  • Create reports of sorted and restricted data
  • Employ SQL functions to generate and retrieve customized data
  • Display data from multiple tables using the ANSI SQL 99 JOIN syntax
  • Identify the major structural components of the Oracle Database 11g
  • Create reports of aggregated data
  • Write SELECT statements that include queries
  • Run data manipulation statements (DML) to update data in the Oracle Database 11g
  • Create tables to store data
  • Utilize views to display and retrieve data
  • Control database access to specific objects
  • Manage schema objects
  • Manage objects with data dictionary views
  • Write multiple-column sub-queries
  • Use scalar and correlated sub-queries
  • Use the regular expression support in SQL

Prerequisites

Familiarity with data processing concepts and techniques Data processing

Relevant Certifications

Course PDF

Print

Sections