CLASSROOM
TENTATIVE

SCHEDULES


Dec 18, 2017 9:00 am 18:00 pm
Dec 19, 2017 9:00 am 18:00 pm
Dec 20, 2017 9:00 am 18:00 pm
Dec 21, 2017 9:00 am 18:00 pm
Dec 22, 2017 9:00 am 18:00 pm
REGISTER NOW

ORACLE

ORACLE INTRO TO SQL

DESCRIPTION
This training teaches you how to write subqueries, combine multiple queries into a single query using SET operators and report aggregated data using group functions.
COURSE CONTENT
  • Introduction to Oracle Database
  • Retrieve Data using the SQL SELECT Statement
  • Learn to Restrict and Sort Data
  • Usage of Single-Row Functions to Customize Output
  • Invoke Conversion Functions and Conditional Expressions
  • Aggregate Data Using the Group Functions
  • Display Data From Multiple Tables Using Joins
  • Use Sub-queries to Solve Queries
  • The SET Operators
  • Data Manipulation Statements
  • Use of DDL Statements to Create and Manage Tables
  • Other Schema Objects
  • Control User Access
  • Management of Schema Objects
  • Manage Objects with Data Dictionary Views
  • Manipulate Large Data Sets
  • Data Management in different Time Zones
  • Retrieve Data Using Sub-queries
  • Regular Expression Support