Oracle SQL

Definition of RDBMS

What is SQL?

What we can do with SQL?

Advantages of SQL

Basic Select statements (Introduction to SQL)

Defining column alias

Arithmetic expressions

Selection all columns, specific columns

Concatenation operator

Duplicate and distinct rows

BETWEEN condition

AND, OR, NOT operators

LIKE condition

ORDER BY clause for sorting columns

Using WHERE clause

General functions

Number functions

Character functions

Type conversion

Date functions

Nesting functions

What is equijoin and non-equijoin

OUTER, SELF joins and others

Types of joins - INNER, LEFT and RIGHT

AVG, SUM, MIN, MAX, COUNT functions and etc.

What are group functions

GROUP BY clause, HAVING clause

Single-row and multiple-row subqueries

Subquery syntax

Using ANY and ALL operator

Types of subqueries

INSERT, UPDATE, DELETE, MERGE

COMMIT and ROLLBACK

MINUS

UNION

INTERSECT

UNION ALL

TRUNCATE table

DROP TABLE statements and others

CREATE TABLE statement

ALTER TABLE statement

FOREIGN KEY

DEFAULT

PRIMARY KEY

NOT NULL

Primary and Foreign Key

Table Constraints

CHECK

UNIQUE

CREATE INDEX

What is View?

Creating view

Updating and dropping view

What are SQL Sequences

How sequences work