Oracle Database: Introduction to SQL

Technology : Oracle

Course Brief

This Oracle Database: Introduction to SQL training helps you write sub queries, 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.

  • 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 Duration - Full Time: The course lasts 5 days.

Course Duration - Part Time: The course lasts 1 month.

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
Start Date End Date Timing Duration

Full Name

Email

Phone

Course Name

Select Schedule

Select Program