SQL Tutorial - SQLZoo
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 …
Sql - SQLZoo
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
SQL Zoo - SQLZoo
SQL Zoo Interactive SQL tutorial, learn about: SQL Server, Oracle, MySQL, DB2, Mimer, PostgreSQL, SQLite and Access.
SELECT basics - SQLZoo
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'.
SQL Tutorial/zh - SQLZoo
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 within SELECT Tutorial - SQLZoo
This tutorial looks at how we can use SELECT statements within SELECT statements to perform more complex queries.
The JOIN operation - SQLZoo
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 …
SELECT - SQLZoo
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 …
Tutorial Quizzes - SQLZoo
There are multiple choice quizzes associated with each of the tutorials. Use these to test your understanding of the material you have been studying. 1. SELECT Quiz 2. BBC QUIZ 3. Nobel Quiz …
SQLZoo:About - SQLZoo
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.