Free tutorials for Java, Eclipse and Web programming



Follow me on twitter

SQL Statements - Overview

Lars Vogel

Version 0.6

04.01.2011

Revision History
Revision 0.113.09.2009Lars Vogel
created
Revision 0.2 -0.614.09.2009Lars Vogel
bugfixes and enhancements

SQL Statements

This tutorial lists important SQL statements which you need to use to create, update and read from database tables.


Table of Contents

1. SQL - Structured Query Language
1.1. Overview
2. Table
3. Data maintenance - Select, Insert, Delete, Update
3.1. Select
3.2. Insert
3.3. Update
3.4. Delete
4. Database setup
4.1. Database schema
4.2. User Maintenance
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.