Difference between revisions of "SQL Tutorial/zh"

From SQLZOO
Jump to: navigation, search
(教程: 由淺入深 學習 SQL)
 
(9 intermediate revisions by one other user not shown)
Line 1: Line 1:
 
__NOTOC__
 
__NOTOC__
<p class=slogan><span>學習 SQL:</span> SQL Server, Oracle, MySQL, DB2, <span>and</span> PostgreSQL.</p>
+
<p class=slogan><span>学习 SQL:</span> SQL Server, Oracle, MySQL, DB2, <span>and</span> PostgreSQL.</p>
  
 
<div class=tutblock>
 
<div class=tutblock>
Line 15: Line 15:
 
* [[SELECT from Nobel Tutorial/zh|利用諾貝爾獎的表格,再練習基本SQL功能。]]
 
* [[SELECT from Nobel Tutorial/zh|利用諾貝爾獎的表格,再練習基本SQL功能。]]
 
* [[Nobel Quiz/zh|測驗:諾貝爾獎]]
 
* [[Nobel Quiz/zh|測驗:諾貝爾獎]]
; [[SELECT within SELECT Tutorial|4 SELECT within SELECT]]:   In which we form queries using other queries.
+
; 4 子查詢:
; [[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]]
+
* [[Using_nested_SELECT/zh |如何使用子查詢]]
; [[The JOIN operation/zh|6 JOIN]]:    合拼兩個表格 [[Music_Tutorial/zh |音樂數據庫]]
+
* [[SELECT within SELECT Tutorial/zh|SELECT中的SELECT練習]]
; [[More JOIN operations|7 More JOIN operations]]:   In which we join actors to movies in the Movie Database.
+
* [[The_nobel_table_can_be_used_to_practice_more_subquery./zh|諾貝爾獎:子查詢]]
; [[Using Null|8 Using Null]]:    In which we look at teachers in departments. [[Scottish_Parliament |previously Scottish Parliament]]
+
* [[Nested SELECT Quiz/zh|子查詢測驗]]
 +
; 5 群組函數:
 +
* [[SUM and COUNT/zh|總和SUM 及 總計COUNT]]
 +
* [[The_nobel_table_can_be_used_to_practice_more_SUM_and_COUNT_functions./zh|諾貝爾獎的更多練習]]
 +
; 6 合拼兩個表格
 +
* [[The JOIN operation/zh | 足球賽數據庫]]
 +
* [[Music_Tutorial/zh |音樂數據庫]]
 +
; 7 更多的合拼操作。
 +
* [[More JOIN operations/zh|電影數據庫]]:  
 +
; 8 NULL值
 +
* [[Using Null/zh|使用 Null(老師和學系)]]
 +
* [[Scottish_Parliament/zh |蘇格蘭議會]]
 
; [[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.
+
; 9 自我合拼
 +
* [[Self join/zh|巴士路線]]
 
; [[Tutorial_Quizzes|10 Tutorial Quizzes]]:    Test your knowledge with multiple choice quizzes
 
; [[Tutorial_Quizzes|10 Tutorial Quizzes]]:    Test your knowledge with multiple choice quizzes
  

Latest revision as of 02:16, 29 May 2017

学习 SQL: SQL Server, Oracle, MySQL, DB2, and PostgreSQL.

教程: 由淺入深 學習 SQL

0 SELECT 基礎
1 SELECT name
2 SELECT from World
3 SELECT from Nobel
4 子查詢
5 群組函數
6 合拼兩個表格
7 更多的合拼操作。
8 NULL值
8+ Numeric Examples
In which we look at a survey and deal with some more complex calculations.
9 自我合拼
10 Tutorial Quizzes
Test your knowledge with multiple choice quizzes

Reference: 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

Assessments: More involved examples for confident users

Each assessment includes 15 questions graded easy, medium and hard.

Adventure Works
An example based on a wholesaler (based on MicroSoft's sample database)
University Timetables
Schedules for lectures and tutorials
Musicians
Bands, Concerts, Performances
Dressmaker
Making and ordering dresses
Congestion Charging
Monitoring and charging cars going in and out of London

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