SQL Interactive Tutorial

SQL language

This section of the tutorial used the most common approaches to writing SQL queries. Features of specific DBMSs will be described in other sections.

Chapter 1: Introduction

1.1

Database Concepts

Chapter 2: Language structure

2.1

Chapter 3: Data Sampling Basics

3.1SQL query syntax

3.2Conditional WHERE operator

3.3Sorting, ORDER BY operator

3.4Grouping, aggregate functions

3.5Multi-table queries

3.6Sampling constraint, LIMIT operator

3.7Nested queries

3.8Common Table Expressions, operator WITH

3.9UNION operator

Chapter 4: Data manipulation basics

4.1Syntax of INSERT operator

4.2Syntax of UPDATE operator

4.3Syntax of DELETE operator

Chapter 5: Databases and tables

5.1Creating and deleting databases

5.2Creating and deleting tables

Chapter 6: Data type

6.1String data type

6.2Numeric data type

6.3Date and Time data types