Module 1: Database Administration
- Intro to Oracle
- Database Administration
- Installing Oracle – Part 1
- Installing Oracle – Part 2
- Post Setup Overview – Part 1
- Post Setup Overview – Part 2
- – Part 1
- SQLplus – Part 2
- SQLplus Demo – Part 1
- SQLplus Demo – Part 2
- SQLplus Demo – Part 3
- Startup and Shutdown – Part 1
- Startup and Shutdown – Part 2
Module 2: Oracle Architecture
- Oracle Architecture
- Schema Objects
- Data Access
- Architecture
Module 3: Database Schema
- Database Schema
- Create Table & Tablespace – Part 1
- Create Table & Tablespace – Part 2
- Create View
- Create Index
- Create a Sequence
Module 4: Recovery Manager
- Recovery Manager
- What is RMAN
- RMAN Demo
- Restore – Part 1
- Restore – Part 2
Module 5: Introduction to SQL
- SQL – Part 1
- SQL – Part 2
- Parts of SQL Statement
- Select Statemen
Module 6: Filtering and Sorting Data
- Build ERD – Part 1
- Build ERD – Part 2
- Build ERD – Part 3
Module 7: Functions
- Functions
- More Functions
- Group Functions
- Custom Functions
Module 8: SET Operators and Subqueries
- SET Operations
- Subqueries
Module 9: Regular Expressions and SQL Loader
- Regular Expressions
- SQL Loader