SQL is Structured Query Language, which is a computer language for storing, manipulating and retrieving data stored in a relational database. Also, they are using different dialects, such as −MS SQL Server using T-SQL,Oracle using PL/SQL,MS Access version of SQL is called JET SQL (native format) etc.

Course Overview

SQL – Home
SQL – Overview
SQL – RDBMS Concepts
SQL – Databases
SQL – Syntax
SQL – Data Types
SQL – Operators
SQL – Expressions
SQL – Create Database
SQL – Drop Database
SQL – Select Database
SQL – Create Table
SQL – Drop Table
SQL – Insert Query
SQL – Select Query
SQL – Where Clause
SQL – AND & OR Clauses
SQL – Update Query
SQL – Delete Query
SQL – Like Clause
SQL – Top Clause
SQL – Order By
SQL – Group By
SQL – Distinct Keyword
SQL – Sorting Results

Advanced SQL

SQL – Constraints
SQL – Using Joins
SQL – Unions Clause
SQL – NULL Values
SQL – Alias Syntax
SQL – Indexes
SQL – Alter Command
SQL – Truncate Table
SQL – Using Views
SQL – Having Clause
SQL – Transactions
SQL – Wildcards
SQL – Date Functions
SQL – Temporary Tables
SQL – Clone Tables
SQL – Sub Queries
SQL – Using Sequences
SQL – Handling Duplicates
SQL – Injection