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: Data Sampling Basics

2.1SQL query syntax

2.2Conditional WHERE operator

2.3Sorting, ORDER BY operator

2.4Grouping, aggregate functions

2.5Multi-table queries

2.6Sampling constraint, LIMIT operator

2.7Nested queries

2.8UNION operator

Chapter 3: Data manipulation basics

3.1Syntax of INSERT operator

3.2Syntax of UPDATE operator

3.3Syntax of DELETE operator

Chapter 4: Databases and tables

4.1Creating and deleting databases

4.2Creating and deleting tables

Chapter 5: Data type

5.1String data type