Difference between revisions of "Main Page"

Jump to: navigation, search
(Redirected page to SQL Tutorial)
Line 1: Line 1:
<p class=slogan><span>Learn SQL using:</span> SQL Server, Oracle, MySQL, DB2, <span>and</span> PostgreSQL.</p>
#REDIRECT [[SQL_Tutorial]]
<div class=tutblock>
==Tutorial Section==
; [[SELECT basics|0 SELECT basics]]:Some simple queries to get you started
; [[SELECT names|1 SELECT name]]:Some pattern matching queries
; [[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 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]]
; [[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.
; [[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.
; [[Tutorial_Quizzes|10 Tutorial Quizzes]]:    Test your knowledge with multiple choice quizzes
<div class='refblock'>
==Reference Section: how to...==
;1 [[SELECT Reference|SELECT]]
:    How to read the data from a database.
;2 [[CREATE and DROP Reference|CREATE and DROP]]
:    How to create tables, indexes, views and other things. How to get rid of them.
;3 [[INSERT and DELETE Reference|INSERT and DELETE]]
:    How to put records into a table, change them and how to take them out again.
;4 [[DATE and TIME Reference|DATE and TIME]]
:    How to work with dates; adding, subtracting and formatting.
;5 [[Functions Reference|Functions]]
:    How to use string functions, logical functions and mathematical functions.
;6 [[Users Reference|Users]]
:    How to create users, GRANT and DENY access, get at other peoples tables. How to find processes and kill them.
;7 [[Meta Data Reference|Meta Data]]
:    How to find out what tables and columns exist. How to count and limit the rows return.
;8 [[Hacks Reference|SQL Hacks]]
<div class='resblock' style='clear:left'>
<div style='clear:left'></div>
==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]
: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]] ]
:    How to connect to the server and execute SQL statements.
;Programming with SQL:    [ [[SQL in perl on the Web]] | [[SQL from Java]] ]
;Error Messages
:    [[SQL Error Messages|Some error messages from SQL engines]]
;Temporary Assessment section, before the main menu is finished.
:[[Assessment Temp]]
<div style="margin-left:1em;clear:both">
[[To do list]]

Latest revision as of 15:58, 24 April 2015

Redirect to: