Welcome to Interactive SQL Tutorial!
SQL is an ANSI (American National Standards Institute) standard for accessing database systems.
SQL statements are used to retrieve and update data in a database.
This interactive SQL tutorial not only provides easy-to-understand basic SQL
instructions, but it allows you to practice what you learn using the on-line SQL
interpreter. You will receive immediate results after submitting your SQL commands.
If you're already familar with the basics of SQL, you can still use this as a
refresher, and practice some SQL statements.
- SQL (Structured Query Language) introduction
- Basics of the SELECT statement
- Conditional selection
- In & Between
- Using LIKE
- Performing a join
- DISTINCT and Eliminating Duplicates
- Aliases & Subqueries
- Miscellaneous SQL statements
- Adding deleting updating data
- GROUP BY & HAVING
- More subqueries
- UNION and outer joins
|