Oracle SQL Tutorials For Beginners – Learn Oracle SQL from scratch with Oracle SQL Online Course

Mehmet Salih Deveci

4 years ago

Hi,

I will share with you Step by Step Oracle SQL Tutorials For Beginners.

Oracle SQL Tutorials

If you don’t know Oracle SQL and want to learn, you are at the right adress.

You can learn Oracle SQL step by step with following steps. I have started Oracle SQL Tutorials from beginning, so read each article in order.

SQL Tutorials

Lesson -1: Introduction to Oracle SQL in Oracle SQL

Introduction to Oracle SQL | Oracle SQL Tutorials -1

Lesson -2: SQL SELECT Statement and DESC Command in Oracle SQL

SQL SELECT Statement and DESC Command in Oracle SQL | Oracle SQL Tutorials -2

Lesson -3: SELECT DISTINCT Statement in Oracle SQL

SELECT DISTINCT Statement in Oracle SQL | Oracle SQL Tutorials -3

Learn Oracle SQL

Lesson -4: SQL WHERE Clause and Comparison Operator in Oracle SQL

SQL WHERE Clause and Comparison Operator in Oracle SQL | Oracle SQL Tutorials -4

Lesson -5: AND, OR and NOT Operators in Oracle SQL

AND, OR and NOT Operators in Oracle SQL | Oracle SQL Tutorials -5

Lesson -6: ORDER BY in Oracle SQL

ORDER BY in Oracle SQL | Oracle SQL Tutorials -6

Lesson -7: Insert Into in Oracle SQL

Insert Into in Oracle SQL | Oracle SQL Tutorials -7

Lesson -8: Insert Into Select Statement in Oracle SQL

Insert Into Select Statement in Oracle SQL | Oracle SQL Tutorials -8

Lesson -9: NULL Values in Oracle SQL

NULL Values And Is Null or Is Not Null in Oracle SQL | Oracle SQL Tutorials -9

Lesson -10: UPDATE Statement in Oracle SQL

UPDATE Statement in Oracle SQL | Oracle SQL Tutorials -10

Lesson -11: DELETE Statement in Oracle SQL

DELETE Statement in Oracle SQL | Oracle SQL Tutorials -11

Lesson -12: SQL Like Operator in Oracle SQL

SQL Like Operator in Oracle SQL | Oracle SQL Tutorials -12

Lesson -13: MIN() and MAX() Functions in Oracle SQL

MIN() and MAX() Functions in Oracle SQL | Oracle SQL Tutorials -13

Lesson -14: COUNT(), AVG() and SUM() Functions in Oracle SQL

COUNT(), AVG() and SUM() Functions in Oracle SQL | Oracle SQL Tutorials -14

Lesson -15: IN and BETWEEN Operator in Oracle SQL

IN and BETWEEN Operator in Oracle SQL | Oracle SQL Tutorials -15

Lesson -16: GROUP BY Statement in Oracle SQL

GROUP BY Statement in Oracle SQL | Oracle SQL Tutorials -16

Lesson -17: HAVING Clause in Oracle SQL

HAVING Clause in Oracle SQL | Oracle SQL Tutorials -17

Lesson -18: EXISTS and NOT EXISTS Operator in Oracle SQL

EXISTS and NOT EXISTS Operator in Oracle SQL | Oracle SQL Tutorials -18

Lesson -19: Datetime Functions in Oracle SQL

PL/SQL Datetime Functions

Lesson -20: Number Functions in Oracle SQL

PL/SQL – Number Functions

Lesson -21: Character / String Functions in Oracle SQL

PL/SQL – Character/String Functions

Lesson -22: SQL Join and Join Types in Oracle SQL

SQL Join and Join Types in Oracle SQL | Oracle SQL Tutorials -19

SQL Inner Join in Oracle SQL | Oracle SQL Tutorials -20

SQL Left Outer Join in Oracle SQL | Oracle SQL Tutorials -21

SQL Right Outer Join in Oracle SQL | Oracle SQL Tutorials -22

SQL Full Outer Join in Oracle SQL | Oracle SQL Tutorials -23

Lesson -23: Union and Union All in Oracle SQL

Union and Union All in Oracle SQL | Oracle SQL Tutorials -24

Lesson -24: Intersect and Minus in Oracle SQL

Intersect and Minus in Oracle SQL | Oracle SQL Tutorials -25

Lesson -25: SQL Subquery, Nested Queries and In Any All Operator in Subquery in Oracle SQL

SQL Subquery, Nested Queries and In Any All Operator in Subquery in Oracle SQL | Oracle SQL Tutorials -26

Lesson -26: Create Table ( CTAS ) and Data Types, LOB Data Types in Oracle SQL

Create Table ( CTAS ) and Data Types, LOB Data Types in Oracle SQL | Oracle SQL Tutorials -27

Lesson -27: SQL Data Types, LOB Data Types in Oracle SQL

SQL Data Types, LOB Data Types in Oracle SQL | Oracle SQL Tutorials -28

Lesson -28: Alter Table and Alter Table Add or Drop Column in Oracle SQL

https://ittutorial.org/alter-table-and-alter-table-add-or-drop-column-in-oracle-sql-oracle-sql-tutorials-29/

Do you want to learn Oracle Database for Beginners, then read the following articles.

Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )