login

Subscribe to SQL Tutorial websiteRSS Feed
 » SQL Tutorial

SQL Tutorial

SQL TutorialWelcome to the SQL Tutorial website! Our website provides you clear, concise and easy to understand SQL tutorial. If you are looking for a comprehensive SQL tutorial, you are at the right place. At our website, you will learn how to write SQL query step by step with practical examples.

What is SQL?

  • SQL stands for Structured Query Language
  • SQL is pronounced as /ˌɛs.kjuːˈɛl/
  • SQL is designed for manipulate data in relational database management system

What can you do with SQL?

  • SQL can retrieve and update data from relational database management system by using data manipulation language.
  • SQL can create and modify database schema and database objects such as tables, views, indexes... via data definition language.
  • SQL can grant or revoke authorization to user through data control language.

SQL Data Manipulation Language (DML)

SQL data manipulation language (DML) is a main part of SQL statements. SQL DML allows you to query and change data from the database tables in relational database management system (RDBMS).

Here are the most common SQL statements related to the SQL data manipulation language:

  1. SQL SELECT

  2. SQL WHERE

  3. SQL Alias

  4. SQL DISTINCT

  5. SQL ORDER BY

  6. SQL IN

  7. SQ IS

  8. SQL EXISTS

  1. SQL BETWEEN

  2. SQL LIKE

  3. SQL GROUP BY

  4. SQL HAVING

  5. SQL INNER JOIN

  6. SQL OUTER JOIN

  7. SQL Self-join

  8. SQL Subquery

  1. Correlated Subquery

  2. SQL UNION

  3. SQL INSERT

  4. SQL UPDATE

  5. SQL DELETE

  6. SQL TRUNCATE TABLE

SQL Data Definition Language (DDL)

SQL data definition language is a subset of SQL statements. SQL database definition language allows you to create, alter or remove different kind database objects such as tables, views, indexes.

  1. SQL CREATE DATABASE

  2. SQL DROP DATABASE

  3. SQL CREATE TABLE

  1. SQL ALTER TABLE

  2. SQL DROP TABLE

SQL Tutorial References

Beside each SQL Tutorial, we also provide you a SQL sample database so you can download it and practice with SQL queries in each tutorial in your own computer. The sample database is available in almost common RDMBS systems such as MySQL and Microsoft SQL Server. If you do not have database manage system installed in your local PC, you can use Microsoft Access as well.

If you want to have a quick reference of SQL statements, you can download our printable SQL Cheat Sheet from SQL Cheat Sheet section.

Other useful SQL Tutorial's websites

MySQL is the world's most popular open source relational database management system. MySQL is scalable, reliable and secure. If you want to master MySQL check it out MySQL tutorial website for more information.