Oracle Database Tutorials

SQL Tutorials for Beginners

Oracle Database/SQL Tutorial list



How to become an Oracle Certified DBA

Details on How to become an Oracle Certified DBA .


sluggish windows start-up after installing your oracle database

Facing problems of sluggish windows start-up after installing your oracle database ?


Differences between Views and Materialized Views

Definition and key differences between Views and Materialized views explained in detail.


SYSDATE Function In Oracle Database

Learn How To retrieve System Current Date and Time Using SYSDATE function With Examples


Oracle Database Tutorial 74:- COALESCE SQL NULL Function

Learn how to use COALESCE() SQL Null function. All Interview Points explained


Oracle Database Tutorial 73:- NVL 2 SQL NULL Function

Learn how to use NVL2() SQL Null function. All Interview Points explained


Oracle Database Tutorial 72:- NVL SQL NULL Function

Learn how to use NVL() SQL Null function. All Interview Points explained


Oracle Database Tutorial 71:- LPAD & RPAD SQL Functions

Learn how to use LPAD & RPAD SQL Functions with easy examples


Oracle Database Tutorial 70:- The network adapter could not establish the connection

How to solve SQL Developer Error-"The network adapter could not establish the connection."


Oracle Database Tutorial 69:- Intersect and Minus Set Operators

Learn Intersect and Minus Set Operators in oracle database


Oracle Database Tutorial 68:- Union & Union All Set Operators

Learn Union and Union All set Operators in oracle database


Oracle Database Tutorial 67:- Create Tablespace using SQL Developer

Learn How to create tablespace using SQL Developer in oracle database


Oracle Database Tutorial 66:- How To Create Undo Tablespace

Learn How to create undo tablespace in oracle database


Oracle Database Tutorial 64:- Permanent Tablespace In Oracle database

Learn How to create big file and small file Permanent tablespace in oracle database


Oracle Database Tutorial 63:- The Introduction to Tablespace In Oracle database

First video in the series of Tablespaces In Oracle database "The Introduction."


Oracle Database Tutorial 61:- SQL SEQUENCES in Oracle Database

Learn the concept of SQL Sequences in oracle Database with Example queries.


Oracle Database Tutorial 60:- SQL VIEW in Oracle Database

Learn the concept of SQL View in oracle Database with Example queries.


Oracle Database Tutorial 59:- Data Pump Import SQLFILE

Learn how to Learn the concept of SQLFILE parameter in Data pump .


Oracle Database Tutorial 58:- Import Schema using impdp Data pump

Learn how to import schemas in oracle database also how to make a copy schema using impdp data pump .


Oracle Database Tutorial 57:- Import table in different schema using REMAP_SCHEMA parameter of impdp Data pump import

Learn how to import tables in different schema or in different user using REMAP_SCHEMA parameter of IMPDP data pump import.


Oracle Database Tutorial 56:- Import and Duplicate table using impdp Data pump import

Learn how to import table and the concept of REMAP_TABLE in impdp Data Pump import.


Oracle Database Tutorial 55:- Export Table using PARFILE in expdp Data Pump

Learn how to export tables using PARFILE parameter of expdp export data pump in oracle database.


Oracle Database Tutorial 54:- Schemas Export using expdp utility

Learn how to export Schemas using expdp data pump utility in oracle database.


Oracle Database Tutorial 53:- Tablespace Export using expdp utility

Learn how to export tablespace using expdp data pump utility in oracle database.


Oracle Database Tutorial 52:- Full Database Export using expdp utility

Learn how to export full database using expdp data pump utility in oracle database.


Oracle Database Tutorial 49:- Simple Case Expression in Oracle Database

Learn all about case expressions explained in theory & with queries by Manish Sharma.


Oracle Database Tutorial 48:- User Role in Oracle Database

Understand the concept of Roles in Database explained by Manish Sharma using queries & examples.


Oracle Database Tutorial 47:- Object Privileges and With Grant Option clause explained in Detail

Understand the concept of System Privileges and With GRANT Option clause explained by Manish Sharma using queries & examples.


Oracle Database Tutorial 46:- System Privileges and With Admin Option clause Explained in Detail

Understand the concept of System Privileges and With ADMIN Option clause explained by Manish Sharma using queries & examples.


Oracle Database Tutorial 45:- Introduction to User Privilege in Oracle Database

Learn about different kinds of User Privileges and their definition along with some basic security guidelines.


Oracle Database Tutorial 43:- How To create an external user account in oracle

DBA Tips & Trick. Learn How to create an external user account in oracle


Oracle Database Tutorial 42:- How To Unlock User Using In Oracle Database SQL Developer

Learn How to Unlock a user or schema in oracle database Using SQL Developer.


Oracle Database Tutorial 41:- How To Unlock User In Oracle Database

Learn How to Unlock a user or schema in oracle database .


Oracle Database Tutorial 40:- How To Drop a User (Restricted Startup Option)

DBA Tips & Trick. Learn the concepts of RESTRICTED STARTUP option with the example of How to drop a user when it is connected with database and disconnected with database.


Oracle Database Tutorial 39:- How to Create new user account in oracle Using Enterprise manager

In this tutorial you will learn how to create a new user account using Enterprise Manager.


Oracle Database Tutorial 38:- How to Create new user account in oracle Using SQL Developer

In this tutorial you will learn how to create a new user account using SQL Developeralong with how to create new connection using SYS user andhow to grant mandatory system privileges to your account


Oracle Database Tutorial 37:- How to Create new user account in oracle

In this tutorial you will learn how to create a new user account using Create User statement along with how to grant mandatory system privileges to your account


Oracle Database Tutorial 36:- How to Create Database using database configuration assistant DBCA in Oracle

What is database configuration assistant( DBCA )?, How To create a general purpose database using DBCA?


Oracle Database Tutorial 35:- How to delete data of a table By Manish Sharma

How to delete data from a table using SQL Delete and Truncate. Learn the difference between Delete and Truncate


Oracle Database Tutorial 34:- How to copy or insert data from one table to another By Manish Sharma

Insert data into from another table using INSERT INTO SELECT DML statement


Oracle Database Tutorial 33:- How to Insert data into a table using INSERT INTO statement by manish sharma rebellionrider

Insert data into a table using INSERT INTO DML statement


Oracle Database Tutorial 32:- How to insert data into a table using SQL developer GUI

Insert data into a table using SQL developer


Oracle Database Tutorial 31:- Cross Joins In SQL

Cross Joins in SQL with Where and ORDER BY Clause


Oracle Database Tutorial 30:- Inner Joins In SQL

Inner Joins in SQL with ON clause, USING clause, WHERE and ORDER BY Clause


Oracle Database Tutorial 29:- Full Outer Joins In SQL

Full Outer Joins in SQL with ON clause, Where Clause and USING clause


Oracle Database Tutorial 28:- Left Outer Joins In SQL

Left Outer Joins in SQL with ON clause, Where Clause and USING clause


Oracle Database Tutorial 27:- Right Outer Joins In SQL

Right Outer Joins in SQL with ON clause, Where Clause and USING clause


Oracle Database Tutorial 26:- Joins In SQL

Introduction to Joins in SQL. Interview Questions Covered.


Oracle Database Tutorial 25:- How To Install Oracle Database 11g Express Edition Release 2 / Oracle XE.

Quick Installation of Oracle Database 11g Express Edition Release 2 / Oracle XE


Oracle Database Tutorial 24:- Natural Join In SQL.

What is Natural Join. How to use natural Join, Natural Join with USING clause and Natural Join with ON clause.


Oracle Database Tutorial 23:- Rename and Modify column Using SQL Alter Table Statement.

How To Rename and Modify column of a table Using SQL Alter Table Statement..


Oracle Database Tutorial 22:- Add Column To An Existing Table Using SQL Alter Table Statement.

How To Add Column To An Existing Table Using SQL Alter Table Statement.


Oracle Database Tutorial 21:- How To Rename Table Using SQL Alter Table Statement.

Rename table using SQL Alter Table Statement explained in detail.


Oracle Database Tutorial 20:- ON DELETE CASCADE Foreign Key Clause.

ON DELETE CASCADE Foreign Key Clause explained in detail.


Oracle Database Tutorial 19:- ON DELETE SET NULL Foreign Key Clause.

ON DELETE SET NULL Foreign Key Clause explained in detail.


Oracle Database Tutorial 18:- SQL Foreign Key.

Foreign key explained in detail. Everything you should know about Oracle Foreign key


Oracle Database Tutorial 17:- SQL Primary Key.

Primary key explained in detail. Everything you should know about Oracle primary key


Oracle Database Tutorial 16:- How to uninstall oracle database 11g from Windows 7.

Tutorial on proper uninstallation of Oracle 11g from windows 7.


Oracle Database Tutorial 15:- How to create table using Enterprise manager 11g.

Third way of creating table using Enterprise manager 11g.


Oracle Database tutorial 14:- SQL Create Table

This is a short and quick SQL tutorial on How To Create a table


Oracle Database tutorial 13:- SQL Substr Functions

This is a short and quick SQL tutorial on Second Charachter Manipulation Function SQL Substr() Function.


Oracle Database tutorial 12:- SQL Concat Functions

This is a short and quick SQL tutorial on First Charachter Manipulation Function SQL Concat() Function.


Oracle Database tutorial 10:- SQL Functions

This is a short and quick intro about SQL functions. With brief SQL functions hierarchy explaination


Oracle Database tutorial 9:- What is archiving and archive log mode

what is archiving? what is archive log mode and no archive log mode and how to enable archive log mode


Oracle Database tutorial 4:- How To Make New Database Connection In SQL Developer

Learn how to make new database connection in SQL developer using SYS and HR user


Oracle Database tutorial 2:- How To Install SQL Developer on Windows10

Since Microsoft has decided to upgrade all the window’s user to Windows10 so keeping this fact in mind we have also added an updated tutorial to our list. You can take a look at the updated blog on How to Install SQL Developer on Windows10.


  • Manish Sharma Oracle Rebellion Rider
  • Manish Sharma Oracle certified SQL expert
  • Manish Sharma oracle certified associate
  • Manish Sharma oracle certified professional
  • View Manish Sharma's profile on LinkedIn

         View Manish Sharma's profile on LinkedIn