Tutorials: Learn SQL step by step 0 SELECT basics Some simple queries to get you started 1 SELECT name Some pattern matching queries 2 SELECT from World In which we query the World country …

What do you think of the new layout of SQLZoo? Please share your opinion with us: [email protected] The original site is still available at http://old.sqlzoo.net

2. Checking a list The word IN allows us to check if an item is in a list. The example shows the name and population for the countries 'Brazil', 'Russia', 'India' and 'China'.

This tutorial looks at how we can use SELECT statements within SELECT statements to perform more complex queries.

The inmates of SQLzoo are the SQL engines (MySQL, Oracle, SQL Server and others). They have been tamed, caged and defanged so that members of the public can pet them or poke them or gawk at them.

JOIN and UEFA EURO 2012 This tutorial introduces JOIN which allows you to use data from two or more tables. The tables contain all matches and goals from UEFA EURO 2012 Football …

Interactive SQL tutorial, learn about: SQL Server, Oracle, MySQL, DB2, Mimer, PostgreSQL, SQLite and Access.

Assessments: More involved examples for confident users Each assessment includes 15 questions graded easy, medium and hard. Adventure Works An example based on a wholesaler (based on …

SELECT name, population FROM world WHERE population BETWEEN 1000000 AND 1250000

A SELECT statement gets data from a table. Each table contains rows and columns - you can SELECT some columns and ignore others The column names on the select line control which columns you …