What is Data, Field, Record and database?

Limitations of File Management System

Basic Concepts of Advantages of DBMS

Exploring Relational DBMS

Installing SQL

Basics of SQL Types of SQL Statements

DDL, DML, DQL, DCL and TCL

Create Database

Datatypes in SQL

Exploring DDL Statements on Table

Create, Alter and Drop Table

Insert, Update and Delete Statement

Truncate Statement

Understanding Select Statement

Usage of Top, Distinct, Null etc…Keyword

Using String and Arithmetic Expressions

Exploring Where Clause with Operators

Sorting data using Order By clause

Working with basic of Sub Queries

Using functions in Queries

Count, Sum, Min, Max, Avg Group By and Having Clause

Introduction to Joins

Inner Join

Self Join

Outer Join

Cross Join

Set Operations using Unions, Intersect

Introduction & Advantages of Views

Creating, Altering, Dropping Views

Creating Users

Granting & revoking of privileges

Managing users

Introduction

Creating and Dropping Indexes

Transactions process

Working with commit, rollback and savepoint

Introduction to stored procedures

Benefits of Stored Procedures

Creating, Executing Modifying, Dropping Stored Procedure

Introduction to triggers

Creating, Altering, Dropping triggers

Before and after triggers

Working with character, date and number functions

Backing up database

Restoring databases

Migrating Databases

PL/SQL Overview

Generate Output from a PL/SQL Block

PL/SQL OverviewConditional and Sequential Control IF Statements

CASE Statements and Expressions

The GOTO Statement

The Simple Loop

The WHILE Loop

The FOR Loop

Exception-Handling Concepts and Terminology

Defining Exceptions

Handling Exceptions

Cursor Basics

Working with Implicit Cursors

Working with Explicit Cursors

Procedure

Functions and parameters

DML Triggers

DDL Triggers

Database Event Triggers

Creating Package

Managing Package Concepts

Debugging PL/SQL Programs