Training

Oracle Database: Introduction to SQL Ed 2

Description: 

Prerequisites

Required Prerequisites:

  • Data processing
  • Familiarity with data processing concepts and techniques

Course Brief

This Oracle Database 12c: 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.

 Course Outline

Identify the major structural components of the Oracle Database 12c

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

Recommended Related Training Courses:

 

 


 


 


 

 

 

 

Training Type: 
Oracle

  Subsidiaries of Totheburn Trading