Difference between revisions of "SQL Tutorial"
(39 intermediate revisions by 5 users not shown) | |||
Line 1: | Line 1: | ||
− | <p class=slogan><span>Learn about:</span> SQL Server, Oracle, MySQL, DB2, | + | <p class=slogan><span>Learn about:</span> SQL Server, Oracle, MySQL, DB2, <span>and</span> PostgreSQL.</p> |
+ | |||
<div class=tutblock> | <div class=tutblock> | ||
==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 | + | ; [[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. | ||
; [[SUM and COUNT|5 SUM and COUNT]]: In which we apply aggregate functions. [[The_nobel_table_can_be_used_to_practice_more_SUM_and_COUNT_functions.|more the same]] | ; [[SUM and COUNT|5 SUM and COUNT]]: In which we apply aggregate functions. [[The_nobel_table_can_be_used_to_practice_more_SUM_and_COUNT_functions.|more the same]] | ||
− | ; [[The JOIN operation|6 JOIN]]: In which we join two tables; | + | ; [[The JOIN operation|6 JOIN]]: In which we join two tables; game and goals. [[Music_Tutorial |previously music tutorial]] |
; [[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. | ||
; [[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 | ||
</div> | </div> | ||
<div class='refblock'> | <div class='refblock'> | ||
Line 30: | Line 33: | ||
: How to find out what tables and columns exist. How to count and limit the rows return. | : How to find out what tables and columns exist. How to count and limit the rows return. | ||
;8 [[Hacks Reference|SQL Hacks]] | ;8 [[Hacks Reference|SQL Hacks]] | ||
− | : | + | : |
</div> | </div> | ||
− | <div class='resblock'> | + | <div class='resblock' style='clear:left'> |
+ | <div style='clear:left'></div> | ||
==SQL Resources== | ==SQL Resources== | ||
− | ;SQL User Manuals: | + | *[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] | ||
: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]] ] | ||
: How to connect to the server and execute SQL statements. | : How to connect to the server and execute SQL statements. | ||
;Programming with SQL: [ [[SQL in perl on the Web]] | [[SQL from Java]] ] | ;Programming with SQL: [ [[SQL in perl on the Web]] | [[SQL from Java]] ] | ||
− | |||
;Error Messages | ;Error Messages | ||
: [[SQL Error Messages|Some error messages from SQL engines]] | : [[SQL Error Messages|Some error messages from SQL engines]] | ||
Line 45: | Line 51: | ||
:[[Assessment Temp]] | :[[Assessment Temp]] | ||
</div> | </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 style="margin-left:1em"> | ||
+ | [[To do list]] | ||
+ | </div> | ||
+ | <!-- | ||
+ | {{Languages}} | ||
+ | --> |
Revision as of 20:32, 28 February 2013
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
- Select Basics - Answers
- Select from World - Answers
- See if you can spot the pattern
- 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
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