Difference between revisions of "SQL Tutorial"
(13 intermediate revisions by 3 users not shown) | |||
Line 12: | Line 12: | ||
; [[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]] | ||
; [[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|10 Tutorial Quizzes]]: Test your knowledge with multiple choice quizzes |
</div> | </div> | ||
<div class='refblock'> | <div class='refblock'> | ||
Line 53: | Line 53: | ||
border-radius:2em; | border-radius:2em; | ||
padding: 0.5em 2em; | padding: 0.5em 2em; | ||
− | clear:both;"> | + | display: block; |
+ | margin: 2em 1em 1em -.5em; | ||
+ | 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 59: | Line 62: | ||
</div> | </div> | ||
+ | <div style="margin-left:1em"> | ||
+ | [[To do list]] | ||
+ | </div> | ||
+ | <!-- | ||
{{Languages}} | {{Languages}} | ||
+ | --> |
Revision as of 15:28, 19 September 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 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; 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