Tutorialspoint

Mid-Year Savings Flat 10% OFF, Use Code: MID10

Complete Oracle SQL Online Training Course

person icon Benjamin

3.9

Complete Oracle SQL Online Training Course

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

updated on icon Updated on Jul, 2024

language icon Language - English

person icon Benjamin

English [CC]

category icon Development,Databases,Oracle SQL

Lectures -81

Resources -10

Duration -9.5 hours

3.9

price-loader

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