Difference between revisions of "SQL Tutorial/zh"
Jump to navigation
Jump to search
Kobashi.kaz (talk | contribs) |
|||
| (5 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
__NOTOC__ | __NOTOC__ | ||
<p class=slogan><span> | <div style='position:absolute;right:5px'>{{Languages|SQL_Tutorial}}</div> | ||
<p class=slogan><span>学习 SQL:</span> SQL Server, Oracle, MySQL, DB2, <span>and</span> PostgreSQL.</p> | |||
<div class=tutblock> | <div class=tutblock> | ||
| Line 18: | Line 19: | ||
* [[Using_nested_SELECT/zh |如何使用子查詢]] | * [[Using_nested_SELECT/zh |如何使用子查詢]] | ||
* [[SELECT within SELECT Tutorial/zh|SELECT中的SELECT練習]] | * [[SELECT within SELECT Tutorial/zh|SELECT中的SELECT練習]] | ||
* [[The_nobel_table_can_be_used_to_practice_more_subquery./zh|諾貝爾獎:子查詢]] | |||
* [[Nested SELECT Quiz/zh|子查詢測驗]] | * [[Nested SELECT Quiz/zh|子查詢測驗]] | ||
; 5 群組函數: | ; 5 群組函數: | ||
| Line 25: | Line 27: | ||
* [[The JOIN operation/zh | 足球賽數據庫]] | * [[The JOIN operation/zh | 足球賽數據庫]] | ||
* [[Music_Tutorial/zh |音樂數據庫]] | * [[Music_Tutorial/zh |音樂數據庫]] | ||
; [[More JOIN operations| | ; 7 更多的合拼操作。 | ||
* [[More JOIN operations/zh|電影數據庫]]: | |||
; 8 NULL值 | ; 8 NULL值 | ||
* [[Using Null/zh|使用 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/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 04:24, 24 March 2020
学习 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
- 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