課程大綱： Oracle SQL Intermediate培訓(xùn)
Create complex queries to databases
Use available operators
Queries with multiple conditions
Creating tables and references
DDL commands (create, alter, and drop)
Create referential integrity
Normalization of tables (up to 3 normal form)
anomalies and ways to avoid them
Changes in the structure of existing tables
ALTER clause
Manipulation of data
DML commands (insert, update, delete)
Creating new users and granting permissions
DCL commands (grant, revoke)
Linking Tables
Internal and external joins
Data Aggregation
Features of grouping functions
Use the GROUP BY clause and HAVING
Grouping multiple column
Subqueries
multi-column
correlated
WITH clause
加入高級會員獲得助教答疑
