Database

Oracle SQL Tutorial

Oracle SQL tutorial: schemas, tables, joins, functions, PL/SQL blocks, procedures, and performance basics for enterprise apps.

12 lessons 12 views Intermediate Free

Start lesson 1

Oracle SQL Tutorial tutorial

Course contents

Oracle SQL Basics

1 Introduction to Oracle Database 5 min 2 Oracle SQL Developer and Connection 5 min 3 CREATE TABLE and Oracle Data Types 5 min 4 SELECT, WHERE, and ORDER BY in Oracle 5 min 5 Joins: INNER, LEFT, RIGHT, FULL 5 min 6 INSERT, UPDATE, DELETE and MERGE 5 min

PL/SQL

7 Introduction to PL/SQL 5 min 8 Variables, Conditions, and Loops in PL/SQL 5 min 9 Procedures and Functions 5 min 10 Cursors and Exception Handling 5 min 11 Packages in Oracle 5 min 12 Oracle SQL Interview Questions 5 min

How this course is organized

Each lesson includes overview, steps, code, and interview tips
Use the sidebar on lesson pages to navigate
Content is original to Toolliyo—not copied from other sites

Begin first lesson Interview Q&A

Course quizzes

SQL Server — Practice Quiz PostgreSQL — Practice Quiz Oracle SQL — Practice Quiz

Test your knowledge

Quizzes linked to this course—pass to earn certificates.

SQL Server — Practice Quiz

Test your understanding of SQL Server Tutorial. T-SQL, schema design, indexes, and stored …

Intermediate 15 min

PostgreSQL — Practice Quiz

Test your understanding of PostgreSQL Tutorial. Open-source relational database with advan…

Intermediate 15 min

Oracle SQL — Practice Quiz

Test your understanding of Oracle SQL Tutorial. SQL and PL/SQL for Oracle Database develop…

Intermediate 15 min Course quiz

MySQL — Practice Quiz

Test your understanding of MySQL Tutorial. Install MySQL, write queries, and connect from …

Intermediate 15 min

MongoDB — Practice Quiz

Test your understanding of MongoDB Tutorial. Document databases, BSON, and the MongoDB C# …

Intermediate 15 min

Browse all quizzes