Xiao Wenji Oracle video tutorial

• Chapter1 Oracle Video Tutorial
• 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