Learn Oracle – Beginner to Advanced SQL Course – Step by Step

Course Content

Duration: 6 weeks           Hours: 35

Database Concepts

What is the database?

What is relation database?

Introduction to RDBMS

What is a table?

Database Languages

DDL – Data Definition Language

DCL – Data Control Language

DML – Data Manipulation Language

Running Simple Query

Select Statement

Using multiple table in select

Using aliases with tables and columns

Describing a table

Using different SQL Operations

                DISTINCT

                IS NULL

                IS NOT NULL

                BETWEEN

                LIKE / NOT LIKE

                EXISTS

                NOT EXISTS

                IN

                NOT IN

Using Logical Operators

                AND

                OR

                NOT

Group Operations

                Group By

                Group by with having

Sorting / Ordering the results

                Sort by

                Order by

Manipulating the Data – DML

                Inserting data (INSERT Command)

                Updating existing data (Update Command)

                Deleting existing data (Delete Command)

                Commit and Rollback Statements

Working with DDL

                Creating / Renaming a table

                Altering a table

                Dropping a table

                Adding a column

                Dropping or modifying a column

Working with Joins

                Inner or Simple Join

                Right and Left outer join

                Full Outer Join

                Cross Join

Working with Conversion and Conditional Functions

                TO_CHAR

                TO_DATE

                String conversion functions

                DECODE

                CASE

Working with Group / Aggregate Functions

                MIN

MAX

SUM

AVG

COUNT

Working with String Functions

                LPAD/RPAD

                LTRIM / RTRIM

                SUBSTR

                REPLACE

                UPPER & LOWER

                LENGTH

                INITCAP

                CONVERT

                CONCAT

                ASCII

                INSTR

                NVL

                NVL2

                NULLIF

Working with Subqueries

                Single Row

                Multiple Row

Combining the Queries

                UNION/ UNION ALL

                MINUS

                INTERSECT