Difference between revisions of "Main Page"

From SQLZOO
Jump to: navigation, search
(Undo revision 1954 by Marek (talk))
m (Reverted edits by Marcin (talk) to last revision by Marek)
Line 32: Line 32:
 
<div class='resblock'>
 
<div class='resblock'>
 
==SQL Resources==
 
==SQL Resources==
;SQL User Manuals:    [ [http://developer.mimer.com/documentation/html_92/Mimer_SQL_Engine_DocSet/Mimer_SQL_Engine.htm Mimer] | [http://dev.mysql.com/doc/refman/5.1/en/select.html MySQL] | [http://docs.oracle.com/cd/B28359_01/server.111/b28286/toc.htm Oracle] | [http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sa-ses_9sfo.asp SQL Server] | [http://office.microsoft.com/en-us/assistance/CH062526881033.aspx Access] | [http://pic.dhe.ibm.com/infocenter/db2luw/v9r7/index.jsp DB2] | [http://sybooks.sybase.com/sybooks/sybooks.xhtml Sybase] | [http://www.postgresql.org/docs/current/static/index.html Postgres] | [http://www.sqlite.org/lang.html SQLite] ]
+
;SQL User Manuals:    [ [http://developer.mimer.com/documentation/html_92/Mimer_SQL_Engine_DocSet/Mimer_SQL_Engine.htm Mimer] | [http://dev.mysql.com/doc/refman/5.1/en/select.html MySQL] | [http://docs.oracle.com/cd/B28359_01/server.111/b28286/toc.htm Oracle] | [http://msdn.microsoft.com/en-us/library/ms189826%28v=sql.90%29.aspx SQL Server] | [http://office.microsoft.com/en-us/assistance/CH062526881033.aspx Access] | [http://pic.dhe.ibm.com/infocenter/db2luw/v9r7/index.jsp DB2] | [http://sybooks.sybase.com/sybooks/sybooks.xhtml Sybase] | [http://www.postgresql.org/docs/current/static/index.html Postgres] | [http://www.sqlite.org/lang.html SQLite] ]
 
:Online copies of implementation specific user manuals.
 
:Online copies of implementation specific user manuals.
 
;Starting SQL:    [ [[Starting MySQL|MySQL]] | [[Starting Oracle|Oracle]] | [[Starting SQL Server|SQL Server]] | [[Starting DB2|DB2]] | [[Starting Postgres|Postgres]] | [[Starting Ingres|Ingres]] ]
 
;Starting SQL:    [ [[Starting MySQL|MySQL]] | [[Starting Oracle|Oracle]] | [[Starting SQL Server|SQL Server]] | [[Starting DB2|DB2]] | [[Starting Postgres|Postgres]] | [[Starting Ingres|Ingres]] ]

Revision as of 21:23, 23 July 2012

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

Tutorial Section

1 SELECT basics
Some simple queries to get you started
2 SELECT from BBC
In which we query the BBC 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; ttms and country. 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.

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.

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
Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense