Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
课程大纲
关系数据库模型
- 关系数据库的结构
- 表的连接类型
- 规范化和非规范化数据库
- 数据库 Management 系统 (RDBMS)
关系运算符
声明式 SQL 语言的特征 SQL 语法划分 语言 DQL、DML、DDL、DCL 语言 DQL(数据查询语言)
- SELECT 查询
- 别名列、表
- 服务日期(DATE 类型、显示功能、格式)
- 集团特色
- 合并内部表和外部表
- UNION 运算符
- 嵌套子查询(WHERE 子句、表名、列名)
- 相关子查询
数据修改语言
- 插入行(INSERT 子句)
- 通过查询插入
- 更新行 (UPDATE)
- 删除行 (DELETE)
数据定义语言
- 创建、更改所有权、删除表(CREATE、ALTER、DROP) 通过询问创建表 (CREATE TABLE ....选择...
约束
- 选项 NULL 和 NOT NULL
- CONSTRAINT 子句
- 条件 PRIMARY KEY
- 条件 UNIQUE
- 条件 FOREIGN KEY
- DEFAULT 子句
交易
- 命令 COMMIT, ROLLBACK, SAVEPOINT
语言 DCL
- 授予和撤消权限(GRANT、REVOKE)
- 角色
- 创建用户
- 序列
- 同义词
- 视图(透视图)
要求
- Computer 技能
- 了解任何操作系统
14 小时
客户评论 (5)
Luke was opened to answer any question and explain multiple times until everyone understood the exercises.
Alexandra Popa - OTP BANK ROMANIA S.A.
课程 - Oracle SQL Language
The exercises and the trainer :)
Eliza Ciobanu - OTP BANK ROMANIA S.A.
课程 - Oracle SQL Language
The training was applied, with many exercises, exactly as we wanted.
Lorena Anton - OTP BANK ROMANIA S.A.
课程 - Oracle SQL Language
Exercises from the day 2
Amelia Bontu - OTP BANK ROMANIA S.A.
课程 - Oracle SQL Language
the trainer was very helpful , the pace of the training was really good and the exercises weren't too hard, also not too easy. whenever I got stuck he helped me out very well and made sure I understood everything.