Welcome to SQL Demon Learning Center!

We present you simple and well-structured tutorials, which will help improving your knowledge.

Click to activate the topics and you may use UP / DOWN arrow keys to navigate through the knowledge areas, Make sure javascript is enabled on your browser to have a full featured navigation experience;

Introduction

Understanding the Database Concept

Understanding Structured Query Language (SQL)

Keywords used in SQL

Retrieving Data

The SELECT Statement

Retrieving Columns

Sorting Data with ORDER BY

Filtering Data

Using the WHERE Clause

Combining WHERE Clauses
Using the IN Operator
Using the NOT Operator
Using the LIKE Operator

Calculated Fields

Understanding Calculated Fields
Concatenating Fields
Performing Mathematical Calculations
Using Data Manipulation Functions

Summarizing Data

Using Aggregate Functions
Aggregates on Distinct Values
Combining Aggregate Functions

Grouping Data

Understanding Data Grouping
Creating Groups
Filtering Groups
Grouping and Sorting
SELECT Clause Ordering

Working with Subqueries

Understanding Subqueries
Filtering by Subquery
Using Subqueries As Calculated Fields

Joining Tables

Understanding Joins
Creating a Join
Using Table Aliases
Using Different Join Types
Using Joins with Aggregate Functions
Using Joins and Join Conditions

Combining Queries

Understanding Combined Queries
Creating Combined Queries

Inserting, Updating and Deleting Data

Understanding Data Insertion
Copying from One Table to Another
Updating Data
Deleting Data
Guidelines for Updating and Deleting Data

Creating and Manipulating Tables

Creating Tables
Updating Tables
Deleting Tables
Renaming Tables

Using Views

Understanding Views
Creating Views

Working with Stored Procedures

Understanding Stored Procedures
Executing Stored Procedures
Creating Stored Procedures

Advanced SQL Features

Understanding Constraints
Understanding Indexes
Understanding Triggers
Database Security