What's Included
- 0 Lectures
- Access on tablet and phone
- Certificate of completion
Description
Outline of Contents
- Oracle: SQL and PL/SQL
- Creating Views in Oracle Database: 2 Hr.
- PL/SQL Syntax and Logic: 1:30 Hr.
- 30 min assignment : Lab assignment : logic, statement and breaking the statement
- Stored Procedures and Functions: 1:30 Hr.
- Exception Handling: 2 Hr.
- Cursors: 1 Hr
- Maintaining Data Integrity : 2 Hr.
- Query Processing: 2:30 Hr.
- When to Use Specific Constructs: 2:00 Hr.
- Avoid Unnecessary Parsing: 45 min.
- Using Bind Variables
- Using Table Aliases
- SQL Transformations : 3:00
- Heuristic query transformations: 2 Hr.
- Cost-based query transformations: 2 Hr.
- Access path selection: 4 Hrs.
- Cost Model and Statistics : 3 Hrs.
- Optimizer statistics
- Statistics management
- Optimization cost modes.
- Dynamic Runtime Optimizations : 2 Hr.
- Ranking Functions: 3 Hrs.