Oracle Database: Introduction to SQL

Course DateLocationDaysPriceRegister
Oct 2, 2017Ottawa5 $4,825Register
Oct 16, 2017Quebec5 $4,825Register
Oct 2, 2017Toronto5 $4,825Register
Oct 2, 2017Toronto5 $4,825Register
Dec 11, 2017Toronto5 $4,825Register
Mar 19, 2018Toronto5 $4,825Register
May 7, 2018Toronto5 $4,825Register


Course DateLocationDaysPriceRegister
Sep 18, 2017Live Virtual - 10:00 am Eastern5 $4,600Register
Nov 27, 2017Live Virtual - 10:00 am Eastern5 $4,600Register
Oct 9, 2017Live Virtual - 11:00 am Eastern5 $4,600Register
Nov 6, 2017Live Virtual - 11:30 am Eastern5 $4,600Register
Oct 9, 2017Live Virtual - 4:00 am Eastern5 $4,600Register
Nov 26, 2017Live Virtual - 8:30 pm Eastern5 $4,600Register
Sep 24, 2017Live Virtual - 9:00 pm Eastern5 $4,600Register
Oct 29, 2017Live Virtual - 9:00 pm Eastern5 $4,600Register
Oct 8, 2017Live Virtual - 9:30 pm Eastern5 $4,600Register


Course DateLocationDaysPriceRegister
Self-Paced Learning5 $4,250Register


Oracle Database: Introduction to SQL

Description: This Oracle Database: Introduction to SQL training helps you write subqueries, combine multiple queries into a single query using SET operators and report aggregated data using group functions. Learn this and more through hands-on exercises.

Duration: 5 Days

Learn to:

  • Understand the basic concepts of relational databases ensure refined code by developers.
  • Create reports of sorted and restricted data.
  • Run data manipulation statements (DML).
  • Control database access to specific objects.
  • Manage schema objects.
  • Manage objects with data dictionary views.
  • Retrieve row and column data from tables.
  • Control privileges at the object and system level.
  • Create indexes and constraints; alter existing schema objects.
  • Create and query external tables.

Audience:

  • Application Developers
  • System Analysts
  • Business Analysts
  • Data Warehouse Administrator
  • Forms Developer
  • Developer
  • PL/SQL Developer

Course Objectives:

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

Required Prerequisites:

  • Data processing
  • Familiarity with data processing concepts and techniques

Topics:

  • Understand the basic concepts of relational databases ensure refined code by developers.
  • Create reports of sorted and restricted data.
  • Run data manipulation statements (DML).
  • Control database access to specific objects.
  • Manage schema objects.
  • Manage objects with data dictionary views.
  • Retrieve row and column data from tables.
  • Control privileges at the object and system level.
  • Create indexes and constraints; alter existing schema objects.
  • Create and query external tables.
Course DateLocationDaysPriceRegister
Oct 2, 2017Ottawa5 $4,825Register
Oct 16, 2017Quebec5 $4,825Register
Oct 2, 2017Toronto5 $4,825Register
Oct 2, 2017Toronto5 $4,825Register
Dec 11, 2017Toronto5 $4,825Register
Mar 19, 2018Toronto5 $4,825Register
May 7, 2018Toronto5 $4,825Register


Course DateLocationDaysPriceRegister
Sep 18, 2017Live Virtual - 10:00 am Eastern5 $4,600Register
Nov 27, 2017Live Virtual - 10:00 am Eastern5 $4,600Register
Oct 9, 2017Live Virtual - 11:00 am Eastern5 $4,600Register
Nov 6, 2017Live Virtual - 11:30 am Eastern5 $4,600Register
Oct 9, 2017Live Virtual - 4:00 am Eastern5 $4,600Register
Nov 26, 2017Live Virtual - 8:30 pm Eastern5 $4,600Register
Sep 24, 2017Live Virtual - 9:00 pm Eastern5 $4,600Register
Oct 29, 2017Live Virtual - 9:00 pm Eastern5 $4,600Register
Oct 8, 2017Live Virtual - 9:30 pm Eastern5 $4,600Register


Course DateLocationDaysPriceRegister
Self-Paced Learning5 $4,250Register