Tutorialspoint

Celebrating 11 Years of Learning Excellence! Use: TP11

Complete Oracle SQL Online Training Course

person icon Benjamin

4.4

Complete Oracle SQL Online Training Course

Master Oracle SQL and Oracle 12c with this comprehensive online course

updated on icon Updated on Jun, 2025

language icon Language - English

person icon Benjamin

English [CC]

category icon Development ,Database and Design Development,SQL

Lectures -81

Resources -10

Duration -9.5 hours

Lifetime Access

4.4

price-loader

Lifetime Access

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course Description

Oracle SQL is one of the most popular database query languages in the world. It is used to manage and manipulate data in Oracle databases, which are used by businesses of all sizes.

This online video course will teach you everything you need to know to learn Oracle SQL from scratch. You will learn about the basics of SQL, such as data types, operators, and clauses. You will also learn about more advanced topics, such as joins, subqueries, and functions.

Course Overview

This course offers you an introduction to Oracle Database technology.

Upon completing this course, you'll have the necessary SQL knowledge. These abilities allow you to perform a variety of operations, such as querying single and many tables, adding data into tables, making tables, and querying metadata.

Your knowledge of RDBMS will increase. As development environments for SQL statement execution, formatting, and reporting, Oracle SQL Developer and SQL*Plus are also introduced.

By the end of this course, you will be able to use SQL to create, read, update, and delete data in Oracle databases. You will learn to use SQL to perform complex queries on data, build reports and dashboards, and automate tasks.

Goals

  • Prepare for Oracle Database SQL Certified Associate

  • 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.

  • Retrieve row and column data from tables.

Prerequisites

  • No prerequisites are required only your interest in Coding

Complete Oracle SQL Online Training Course

Curriculum

Check out the detailed breakdown of what’s inside the course

Introduction

1 Lectures
  • play icon SQL Introduction 01:15 01:15

Environment Setup

3 Lectures
Tutorialspoint

Retrieving Data Using the SQL SELECT Statement

10 Lectures
Tutorialspoint

Restricting and Sorting Data

14 Lectures
Tutorialspoint

Using Single-Row Functions

11 Lectures
Tutorialspoint

Using Conversion Functions and Conditional Expressions

11 Lectures
Tutorialspoint

Aggregated Data Using the Group Functions

7 Lectures
Tutorialspoint

Displaying Data from Multiple Tables Using Joins

9 Lectures
Tutorialspoint

Using Subqueries to Solve Queries

4 Lectures
Tutorialspoint

Using Set Operators

2 Lectures
Tutorialspoint

Managing Tables Using DML Statements

4 Lectures
Tutorialspoint

Introduction to Data Definition Language

4 Lectures
Tutorialspoint

Instructor Details

Benjamin

Benjamin

Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515