Free tutorials for Java, Eclipse and Web programming



Follow me on twitter

SQL - Tutorial

Lars Vogel

Version 0.5

20.04.2010

Revision History
Revision 0.113.09.2009Lars Vogel
Removed from the MySQL Tutorial
Revision 0.214.09.2009Lars Vogel
Corrected, added links
Revision 0.306.10.2009Lars Vogel
Added update, restructured description
Revision 0.426.01.2010Lars Vogel
Small rework
Revision 0.520.04.2010Lars Vogel
Fixed link

SQL

This article describes the most important SQL statements.


Table of Contents

1. SQL - Structured Query Language
1.1. Overview
1.2. Additional material
2. Database setup
2.1. Database schema
2.2. User Maintenance
3. Table
4. Data maintenance - Select, Insert, Delete, Update
4.1. Select
4.2. Insert
4.3. Update
4.4. Delete
5. Thank you
6. Questions and Discussion
7. Links and Literature

1. SQL - Structured Query Language

1.1. Overview

SQL is a query language for relational databases. This article covers the most important SQL statements and can be used to look up example for standard SQL queries.

1.2. Additional material

Please use the following resources to learn about the usage of SQL with Java and Eclipse.