sq23

Congratulations — you've reached the end!

This SQL tutorial has provided you with a quick and easy way to learn SQL.

We began by learning that SQL stands for Structured Query Language, and is an ANSI standard. We then learned the basic SQL syntax, before continuing on to the SELECT statement - probably the most commonly used statement.

We learned that there are various keywords and aggregate functions that can be included into SQL statements such as WHERE, COUNT, DISTINCT etc. These are all part of the DML (Data Manipulation Language).

Then, after covering the INSERT, UPDATE, and DELETE statements, we learned that there are various commands for performing administration tasks against a database. For example, there are commands for creating database objects (CREATE DATABASE, CREATE TABLE etc), and there are commands for modifying (or altering) database objects (ALTER DATABASE, ALTER TABLE etc). These commands are part of the DDL (Data Definition Language).