Difference between revisions of "Main Page"

From SQLZOO
Jump to: navigation, search
(Tutorial Section)
(7 intermediate revisions by one user not shown)
Line 4: Line 4:
 
==Tutorial Section==
 
==Tutorial Section==
 
; [[SELECT basics|1 SELECT basics]]:Some simple queries to get you started
 
; [[SELECT basics|1 SELECT basics]]:Some simple queries to get you started
; [[SELECT from BBC Tutorial|2 SELECT from BBC]]:In which we query the BBC country profile table.
+
; [[SELECT from WORLD Tutorial|2 SELECT from World]]:In which we query the World country profile table.
 
; [[SELECT from Nobel Tutorial|3 SELECT from Nobel]]:Additional practice of the basic features using a table of Nobel Prize winners.
 
; [[SELECT from Nobel Tutorial|3 SELECT from Nobel]]:Additional practice of the basic features using a table of Nobel Prize winners.
 
; [[SELECT within SELECT Tutorial|4 SELECT within SELECT]]:    In which we form queries using other queries.
 
; [[SELECT within SELECT Tutorial|4 SELECT within SELECT]]:    In which we form queries using other queries.
Line 53: Line 53:
 
     border-radius:2em;
 
     border-radius:2em;
 
     padding: 0.5em 2em;
 
     padding: 0.5em 2em;
     display: inline-block;
+
     display: block;
     margin: 2em 1em 2em 1.5em;
+
     margin: 2em 1em 1em -.5em;
     clear:both;">
+
     clear:both;
 +
    width:52em;">
 
<p>'''What do you think of the new layout of SQLZoo?'''
 
<p>'''What do you think of the new layout of SQLZoo?'''
 
Please share your opinion with us: [mailto:sqlzoo.qa@gmail.com sqlzoo.qa@gmail.com]<br />
 
Please share your opinion with us: [mailto:sqlzoo.qa@gmail.com sqlzoo.qa@gmail.com]<br />
Line 61: Line 62:
 
</div>
 
</div>
  
 +
<div style="margin-left:1em">
 
[[To do list]]
 
[[To do list]]
 
+
</div>
 +
<!--
 
{{Languages}}
 
{{Languages}}
 +
-->

Revision as of 22:07, 8 December 2012

Learn about: SQL Server, Oracle, MySQL, DB2, and PostgreSQL.

Tutorial Section

1 SELECT basics
Some simple queries to get you started
2 SELECT from World
In which we query the World country profile table.
3 SELECT from Nobel
Additional practice of the basic features using a table of Nobel Prize winners.
4 SELECT within SELECT
In which we form queries using other queries.
5 SUM and COUNT
In which we apply aggregate functions. more the same
6 JOIN
In which we join two tables; game and goals. previously music tutorial
7 More JOIN operations
In which we join actors to movies in the Movie Database.
8 Using Null
In which we look at teachers in departments. previously Scottish Parliament
9 Self join
In which we join Edinburgh bus routes to Edinburgh bus routes.
10 Tutorial Quizzes
Test your knowledge with multiple choice quizzes

Reference Section: how to...

1 SELECT
How to read the data from a database.
2 CREATE and DROP
How to create tables, indexes, views and other things. How to get rid of them.
3 INSERT and DELETE
How to put records into a table, change them and how to take them out again.
4 DATE and TIME
How to work with dates; adding, subtracting and formatting.
5 Functions
How to use string functions, logical functions and mathematical functions.
6 Users
How to create users, GRANT and DENY access, get at other peoples tables. How to find processes and kill them.
7 Meta Data
How to find out what tables and columns exist. How to count and limit the rows return.
8 SQL Hacks

SQL Resources

SQL User Manuals
[ Mimer | MySQL | Oracle | SQL Server | Access | DB2 | Sybase | Postgres | SQLite ]
Online copies of implementation specific user manuals.
Starting SQL
[ MySQL | Oracle | SQL Server | DB2 | Postgres | Ingres ]
How to connect to the server and execute SQL statements.
Programming with SQL
[ SQL in perl on the Web | SQL from Java ]
SQL standard
[ SQL92 BNF ]
Error Messages
Some error messages from SQL engines
Temporary Assessment section, before the main menu is finished.
Assessment Temp

What do you think of the new layout of SQLZoo? Please share your opinion with us: sqlzoo.qa@gmail.com
The original site is still available at http://old.sqlzoo.net

To do list

Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense