Basic SQL Tutorial

SQL – Overview

SQL – RDBMS Concepts

SQL – RDBMS Databases

SQL – Syntax

SQL – Data Types

SQL – Operators

SQL – Expressions

SQL – CREATE Database

SQL – DROP or DELETE Database

SQL – SELECT Database, USE Statement

SQL – CREATE Table

SQL – DROP or DELETE Table

SQL – INSERT Query

SQL – SELECT Query

SQL – WHERE Clause

SQL – AND and OR Conjunctive Operators

SQL – UPDATE Query

SQL – DELETE Query

SQL – LIKE Clause

SQL – TOP, LIMIT or ROWNUM Clause

SQL – ORDER BY Clause

SQL – Group By Clause

SQL – Distinct Query

SQL – SORTING Results

Advance SQL Tutorial

SQL – Constraints

SQL – Using Joins

SQL – UNIONS CLAUSE

SQL – NULL Values

SQL – Alias Syntax

SQL – Indexes

SQL – ALTER TABLE Command

SQL – TRUNCATE TABLE Command

SQL – Using Views

SQL – Having Clause

SQL – Transactions

SQL – Wildcard Operators

SQL – Date Functions

SQL – Temporary Tables

SQL – Clone Tables

SQL – Sub Queries

SQL – Using Sequences

SQL – Handling Duplicates

SQL – Injection