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.
Course - Oracle SQL Language
The exercises and the trainer :)
Eliza Ciobanu - OTP BANK ROMANIA S.A.
Course - Oracle SQL Language
The training was applied, with many exercises, exactly as we wanted.
Lorena Anton - OTP BANK ROMANIA S.A.
Course - Oracle SQL Language
Exercises from the day 2
Amelia Bontu - OTP BANK ROMANIA S.A.
Course - 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.