Course Content of SQL

Oracle Database: Introduction to SQL                                                      Home

Course Topics

  • 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