The following articles mainly describe the Outline Model of the Oracle OCP certification course, starting with Oracle Database 10g: SQL Fundamentals, this section also introduces the basics of the 10 Gb SQL language of the Oracle database.
Select, DML, DDL syntax and skills
"Table" structure:
- (Select * from emp ));
Select structure and precautions (select 1, 'A', ename from emp)
Sort, distinct
Single-row functions (common skills and cases in Work)
Subquery and selection (the operating principles and differences of associated subqueries and non-associated subqueries; Optimization)
Table join (four types), external join
Not in | not exists | Differences and choices of equivalent links
Aggregate functions (running process)
Precautions for Using Aggregate functions and external connections
Group
Group filtering + subquery
Outline of the Oracle OCP Certification Course: Discusses the SQL Execution sequence below to prepare for understanding the execution plan
A select ....
B from...
C where...
D group
E having
F order
Lecture objectives:
This allows students to master the internal processes of select, dml, and ddl statements, laying a solid foundation for SQL optimization in the future.
The above content describes the outline of the Oracle OCP certification course, hoping to help you in this regard.