基本的電腦技能。
這門SQL培訓課程適合希望掌握使用MicrosoftAccess提取和分析數據所需技能的人員。課程參與者將學習：
- 如何編寫SQL查詢
- 什麼是關聯式數據庫及其使用方法
- 什麼是關聯以及如何創建它們
- 數據的結構
- SQL方言之間的差異（Oracle、T-SQL、ANSI）
- 編寫查詢的實用技能
這門SQL課程涵蓋MicrosoftAccess方言的SQL。
RDBMS (關聯式資料庫Management系統)
關聯運算符
SQL作為宣告式語言
SQL語法
SQL子語言：DQL, DML, DDL, DCL
DQL (資料查詢語言) 詳解
- SELECT子句
- 欄位別名
- 表格別名
- 日期類型與日期函數
- 群組函數
- 表格聯結
- JOIN子句
- UNION運算符
- 嵌套查詢
- 關聯子查詢
DML (資料操作語言) 概述
- 插入資料列 (INSERT)
- 使用子查詢插入資料列
- 更新資料列 (UPDATE)
- 刪除資料列 (DELETE)
DDL (資料定義語言) 概述
- 建立、修改與刪除物件 (CREATE, ALTER, DROP)
- 使用子查詢建立表格 (CREATE TABLE .... AS SELECT...)
約束概述
- NULL與NOT NULL
- CONSTRAINT子句
- ENUM類型
- SET類型
- 主鍵 (PRIMARY KEY)
- 唯一鍵 (UNIQUE)
- 外鍵 (FOREIGN KEY)
- DEFAULT子句
交易概述
- COMMIT
- ROLLBACK
- SAVEPOINT
- 隱含與顯式回滾與提交
SQL方言概述
- MySQL
- Microsoft Access 與 SQL 伺服器
- Oracle 與 PostgreSQL
United Arab Emirates - SQL in Microsoft Access
Qatar - SQL in Microsoft Access
Egypt - SQL in Microsoft Access
Saudi Arabia - SQL in Microsoft Access
South Africa - SQL in Microsoft Access
Brasil - SQL in Microsoft Access
Canada - SQL in Microsoft Access
Österreich - SQL in Microsoft Access
Schweiz - SQL in Microsoft Access
Deutschland - SQL in Microsoft Access
Czech Republic - SQL in Microsoft Access
Denmark - SQL in Microsoft Access
Estonia - SQL in Microsoft Access
Finland - SQL in Microsoft Access
Greece - SQL in Microsoft Access
Magyarország - SQL in Microsoft Access
Ireland - SQL in Microsoft Access
Luxembourg - SQL in Microsoft Access
Latvia - SQL in Microsoft Access
España - SQL en Microsoft Access
Italia - SQL in Microsoft Access
Lithuania - SQL in Microsoft Access
Nederland - SQL in Microsoft Access
Norway - SQL in Microsoft Access
Portugal - SQL in Microsoft Access
România - SQL in Microsoft Access
Sverige - SQL in Microsoft Access
Türkiye - SQL in Microsoft Access
Malta - SQL in Microsoft Access
Belgique - SQL in Microsoft Access
France - SQL in Microsoft Access
Australia - SQL in Microsoft Access
Malaysia - SQL in Microsoft Access
New Zealand - SQL in Microsoft Access
Philippines - SQL in Microsoft Access
Singapore - SQL in Microsoft Access
Thailand - SQL in Microsoft Access
Vietnam - SQL in Microsoft Access
India - SQL in Microsoft Access
Argentina - SQL en Microsoft Access
Chile - SQL en Microsoft Access
Costa Rica - SQL en Microsoft Access
Ecuador - SQL en Microsoft Access
Guatemala - SQL en Microsoft Access
Colombia - SQL en Microsoft Access
México - SQL en Microsoft Access
Panama - SQL en Microsoft Access
Peru - SQL en Microsoft Access
Uruguay - SQL en Microsoft Access
Venezuela - SQL en Microsoft Access
Polska - SQL in Microsoft Access
United Kingdom - SQL in Microsoft Access
South Korea - SQL in Microsoft Access
Pakistan - SQL in Microsoft Access
Sri Lanka - SQL in Microsoft Access
Bulgaria - SQL in Microsoft Access
Bolivia - SQL en Microsoft Access
Indonesia - SQL in Microsoft Access
Kazakhstan - SQL in Microsoft Access
Moldova - SQL in Microsoft Access
Morocco - SQL in Microsoft Access
Tunisia - SQL in Microsoft Access
Kuwait - SQL in Microsoft Access
Oman - SQL in Microsoft Access
Slovakia - SQL in Microsoft Access
Kenya - SQL in Microsoft Access
Nigeria - SQL in Microsoft Access
Botswana - SQL in Microsoft Access
Slovenia - SQL in Microsoft Access
Croatia - SQL in Microsoft Access
Serbia - SQL in Microsoft Access
Bhutan - SQL in Microsoft Access