Oracle server installation
21 minutes05 secondsOracle remote connection
18 minutes44 secondsOracle architecture
27 minutes56 secondsData dictionary and creating tablespace
24 minutes07 secondsUser creation and permission granting
25 minutes18 secondsCreate table
20 minutes03 secondsMaintenance table
20 minutes01 secondsDML statement
30 minutes41 secondsColumn-level constraints and table-level constraints
41 minutes46 secondsConstraint maintenance
16 minutes24 secondsThree paradigms of data modeling
18 minutes34 secondsData modeling entity relationships
25 minutes10 secondsCrazy shopping platform modeling
16 minutes46 secondsSimple query statement
42 minutes51 secondsCommonly used functions
31 minutes43 secondsMultiple table join
18 minutes00 secondsgroup function
30 minutes26 secondsCollection query
02 minutes57 secondssubquery
23 minutes24 secondsrownum and rowid
15 minutes25 secondspath to maturity
53 minutes10 secondsdecode function
05 minutes13 secondssequence sequence
12 minutes04 secondssynonyms
06 minutes23 secondsindex
08 minutes19 secondsview
05 minutes56 secondsDefine variables
17 minutes06 secondsOperation data
10 minutes01 secondsComposite data type
22 minutes08 secondsprocess control
16 minutes53 secondsException handling
12 minutes51 secondscursor
18 minutes33 secondsstored procedure
48 minutes16 seconds