Database Management Systems

5.

SQL (Structured Query Language)

5.1.

SQL Fundamentals

5.1.1.

History and Evolution of SQL

5.1.2.

5.1.2.1.

ANSI SQL Standards

5.1.2.2.

ISO SQL Standards

5.1.2.3.

Vendor-Specific Extensions

5.1.3.

SQL Components Overview

5.2.

Data Definition Language

5.2.1.

Database Creation and Management

5.2.1.1.

CREATE DATABASE

5.2.1.2.

5.2.1.3.

5.2.2.

Table Definition and Management

5.2.2.1.

5.2.2.1.1.

Column Definitions

5.2.2.1.2.

5.2.2.1.3.

5.2.2.2.

5.2.2.2.1.

5.2.2.2.2.

Modifying Columns

5.2.2.2.3.

Dropping Columns

5.2.2.2.4.

Adding Constraints

5.2.2.2.5.

Dropping Constraints

5.2.2.3.

5.2.2.4.

5.2.3.

Index Management

5.2.3.1.

5.2.3.2.

5.2.3.3.

5.2.4.

View Management

5.2.4.1.

5.2.4.2.

5.2.4.3.

5.2.5.

5.2.5.1.

5.2.5.2.

Character Types

5.2.5.3.

Date and Time Types

5.2.5.4.

5.2.5.5.

5.2.6.

5.2.6.1.

5.2.6.2.

5.2.6.3.

5.2.6.4.

5.2.6.5.

5.2.6.6.

5.3.

Data Manipulation Language

5.3.1.

INSERT Operations

5.3.1.1.

Single Row Insertion

5.3.1.2.

Multiple Row Insertion

5.3.1.3.

INSERT with SELECT

5.3.2.

UPDATE Operations

5.3.2.1.

5.3.2.2.

Conditional Updates

5.3.2.3.

Correlated Updates

5.3.3.

DELETE Operations

5.3.3.1.

Simple Deletions

5.3.3.2.

Conditional Deletions

5.3.3.3.

Cascading Deletions

5.4.

Data Query Language

5.4.1.

Basic SELECT Structure

5.4.1.1.

5.4.1.2.

5.4.1.3.

5.4.2.

Filtering and Sorting

5.4.2.1.

WHERE Conditions

5.4.2.2.

Comparison Operators

5.4.2.3.

Logical Operators

5.4.2.4.

Pattern Matching with LIKE

5.4.2.5.

NULL Value Handling

5.4.2.6.

ORDER BY Clause

5.4.3.

Aggregate Functions

5.4.3.1.

5.4.3.2.

5.4.3.3.

5.4.3.4.

5.4.3.5.

5.4.3.6.

GROUP BY Clause

5.4.3.7.

5.4.4.

Join Operations

5.4.4.1.

5.4.4.2.

LEFT OUTER JOIN

5.4.4.3.

RIGHT OUTER JOIN

5.4.4.4.

FULL OUTER JOIN

5.4.4.5.

5.4.4.6.

5.4.4.7.

5.4.5.

5.4.5.1.

Scalar Subqueries

5.4.5.2.

5.4.5.3.

Table Subqueries

5.4.5.4.

Correlated Subqueries

5.4.5.5.

EXISTS and NOT EXISTS

5.4.5.6.

5.4.6.

5.4.6.1.

5.4.6.2.

5.4.6.3.

5.4.6.4.

5.4.7.

Advanced Query Features

5.4.7.1.

Window Functions

5.4.7.2.

Common Table Expressions

5.4.7.3.

Recursive Queries

5.5.

5.5.1.

5.5.2.

View Modification

5.5.3.

5.5.4.

Updatable Views

5.5.5.

View Limitations

5.5.6.

Materialized Views

5.6.

Data Control Language

5.6.1.

User Management

5.6.1.1.

5.6.1.2.

5.6.1.3.

5.6.2.

Privilege Management

5.6.2.1.

GRANT Statement

5.6.2.2.

REVOKE Statement

5.6.2.3.

Privilege Types

5.6.3.

Role Management

5.6.3.1.

5.6.3.2.

5.6.3.3.

5.7.

Transaction Control Language

5.7.1.

Transaction Boundaries

5.7.1.1.

BEGIN TRANSACTION

5.7.1.2.

5.7.1.3.

5.7.2.

5.7.2.1.

5.7.2.2.

ROLLBACK TO SAVEPOINT

5.7.3.

Transaction Isolation Levels

5.7.4.

Autocommit Mode

Previous

4. Database Design

Go to top

Next

6. Storage and File Structure