1-1 Oracle server installation

1-2 Oracle remote connection

1-3 Oracle architecture

1-4 Data dictionary and creating tablespace

1-5 User creation and permission granting

1-6 Create table

1-7 Maintenance table

1-8 DML statement

1-9 Column-level constraints and table-level constraints

1-10 Constraint maintenance

1-11 Three paradigms of data modeling

1-12 Data modeling entity relationships

1-13 Crazy shopping platform modeling

1-14 Simple query statement

1-15 Commonly used functions

1-16 Multiple table join

1-17 group function

1-18 Collection query

1-19 subquery

1-20 rownum and rowid

1-21 path to maturity

1-22 decode function

1-23 sequence sequence

1-24 synonyms

1-25 index

1-26 view

1-27 Define variables

1-28 Operation data

1-29 Composite data type

1-30 process control

1-31 Exception handling

1-32 cursor

1-33 stored procedure