基本的电脑技能。
这门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