Class2: Database Object Creation and Data Load

User creation
Password file creation
Role grant
Table creation with optimal storage setting.
Index creation
Primary key/foreign key
Synonym
View
Sequence creation and sequence number getting
Trigger with various types
Table population
Various insert methods
SQLLOADER with different paths and different data file formats
Data warehouse introduction
Table partition
Index partition (local, global)

Class3: PL/SQL programming and application implementation

Package
Package body
Procedure
Function
Cursor
Dynamic SQL
Build-in functions
Backend implementation of stock trading project with PL/SQL programming.
Front-end implementation of stock trading project using Oracle Forms.

next page >> page: 1 page 2 page 3