Difference between revisions of "SQL Tutorial"

From SQLZOO
Jump to: navigation, search
(Tutorial Section)
(5 intermediate revisions by the same user not shown)
Line 11: Line 11:
 
; [[More JOIN operations|7 More JOIN operations]]:    In which we join actors to movies in the Movie Database.
 
; [[More JOIN operations|7 More JOIN operations]]:    In which we join actors to movies in the Movie Database.
 
; [[Using Null|8 Using Null]]:    In which we look at teachers in departments. [[Scottish_Parliament |previously Scottish Parliament]]
 
; [[Using Null|8 Using Null]]:    In which we look at teachers in departments. [[Scottish_Parliament |previously Scottish Parliament]]
; [[NSS Tutorial|8 Numeric Examples]]:    In which we look at a survey and deal with some more complex calculations.
+
; [[NSS Tutorial|8+ Numeric Examples]]:    In which we look at a survey and deal with some more complex calculations.
 
; [[Self join|9 Self join]]:    In which we join Edinburgh bus routes to Edinburgh bus routes.
 
; [[Self join|9 Self join]]:    In which we join Edinburgh bus routes to Edinburgh bus routes.
 
; [[Tutorial_Quizzes|10 Tutorial Quizzes]]:    Test your knowledge with multiple choice quizzes
 
; [[Tutorial_Quizzes|10 Tutorial Quizzes]]:    Test your knowledge with multiple choice quizzes
Line 35: Line 35:
 
:   
 
:   
 
</div>
 
</div>
<div class='resblock'>
+
<div class='resblock' style='clear:left'>
 +
<div style='clear:left'></div>
 
==SQL Resources==
 
==SQL Resources==
 +
*[http://sqlzoo.net/wiki/SELECT_basics?answer=1 Select Basics - Answers]
 +
*[http://sqlzoo.net/wiki/SELECT_from_WORLD_Tutorial?answer=1 Select from World - Answers]
 +
*See if you can spot the pattern
 
;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]
 
;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.
Line 46: Line 50:
 
;Temporary Assessment section, before the main menu is finished.
 
;Temporary Assessment section, before the main menu is finished.
 
:[[Assessment Temp]]
 
:[[Assessment Temp]]
</div>
 
<div style= "    background:#FFC694;
 
    border: 1px solid #EE8301;
 
    -moz-border-radius:2em;
 
    -webkit-border-radius:2em;
 
    border-radius:2em;
 
    padding: 0.5em 2em;
 
    display: block;
 
    margin: 2em 1em 1em -.5em;
 
    clear:both;
 
    width:52em;">
 
<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 />
 
The  original site is still available at http://old.sqlzoo.net</p>
 
 
</div>
 
</div>
 
<div style="margin-left:1em">
 
<div style="margin-left:1em">

Revision as of 22:09, 14 February 2014

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
8+ Numeric Examples
In which we look at a survey and deal with some more complex calculations.
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
MimerMySQL 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 ]
Error Messages
Some error messages from SQL engines
Temporary Assessment section, before the main menu is finished.
Assessment Temp

To do list