Oracle SQL Tutorials For Beginners

Topic Introduction: I will give basic to advanced-level SQL tutorials in this tutorial. It will start with the oracle database working environment setup then the basics of SQL Query. gradually we will enter the deep of the SQL query.

Retrieving Data Using the SQL SELECT Statement

SQL Query Basic & Root Concept at a Glance 

Capabilities of SQL SELECT Statements

Basic SELECT statement

• SELECT Statement
• Arithmetic Expressions
• Null Value
• Column Alias
• Concatenation Operator
• Literal Character Strings
• Duplicate Rows
• Displaying the Table Structure

Restricting and Sorting Data

• Using the WHERE Clause
• Comparison Operators
• Range Conditions Using the BETWEEN Operator
• Membership Condition Using the IN Operator
• Pattern Matching Using the LIKE Operator
• Combining Wildcard Characters
• Using the NULL Conditions
• Defining Conditions Using the Logical Operators
• Rules of Precedence In Oracle SQL
• Sorting by Using the ORDER BY Clause
• Substitution Variables
• Using the DEFINE Command
• Using the VERIFY Command

Using Single-Row Functions to Customize Output

• SQL Functions
• Character Functions
• Number Functions
• Working with Date 
• Date-Manipulation Functions
• General Functions

Using Conversion Functions and Conditional Expressions

• Conversion Functions
• Implicit Data Type Conversion
• Explicit Data Type Conversion
• Nesting Functions
• General Functions: NVL, NVL2, NULLIF, COALESCE
• CASE Expression
• DECODE Function

Reporting Aggregated Data Using the Group Functions

• Group Functions
• Using the GROUP BY Clause
• Using the HAVING Clause
• Nesting Group Functions

Displaying Data from Multiple Tables Using Joins

In this lesson, you should have learned how to use joins to display data from multiple tables by using:

Equijoins, Nonequijoins, OUTER joins, Self-joins, Cross joins, Natural joins, Full (or two-sided) OUTER joins.

• Join Concept
• Natural Joins
• Self-Joins
• Nonequijoins
• INNER Joins
• OUTER Joins: 1. LEFT OUTER JOIN 2. RIGHT OUTER JOIN 3. FULL OUTER JOIN
• Cartesian Products: Cross Joins

Using Subqueries to Solve Queries

Types of Subqueries : 1. Single-Row Subqueries 2. Multiple-row subquery

Using the Set Operators

UNION Operator

UNION ALL Operator

INTERSECT Operator

MINUS Operator

Table & View Creation

Create Table                 :

Create Table As           :

Alter Table                    :

Drop Table                    :

Create View                  :