About this course
Set up your Oracle environment and learn RDBMS fundamentals.
Before We Begin
1 Parts
- 0:05 Hr
Global Implementations
5 Min
Prerequisites & Readiness Check
2 Parts
- 1:00 Hr
Prerequisites for Mastering Data Management with Oracle SQL & PL/SQL
45 Min
Oracle SQL & PL/SQL Environment Setup Guide
15 Min
Chapter 1: Basic SQL Queries
3 Parts
- 2:00 Hr
SELECT and Filtering
45 Min
Functions and Operators
30 Min
Exercise: Write Basic Queries
45 Min
Chapter 2: Table Management and Constraints
3 Parts
- 2:15 Hr
Table Creation
45 Min
Constraints and Indexes
30 Min
Exercise: Design a Relational Table Structure
60 Min
Chapter 3: Data Manipulation and Joins
3 Parts
- 2:00 Hr
Data Manipulation
45 Min
Joins
30 Min
Exercise: Combine and Modify Related Data
45 Min
Assignment 1
2 Parts
- 0:45 Hr
Build a Normalized Employee-Department Data Model
45 Min
Submit your Assignment here
Submit your Assignment here
Min Grade: 40
Chapter 4: Grouping, Subqueries, and Views
4 Parts
- 2:30 Hr
Grouping Data
30 Min
Subqueries
30 Min
Views and Sequences
30 Min
Exercise: Group, Query, and Simplify Data
60 Min
Chapter 5: Introduction to SQL
3 Parts
- 2:00 Hr
SQL Basics
45 Min
Control Structures
30 Min
Exercise: Write a SQL Program
45 Min
Chapter 6 Intermediate SQL
4 Parts
- 2:30 Hr
Cursors
30 Min
Exception Handling
30 Min
Stored Procedures and Functions
30 Min
Exercise: Automate Data Processing with SQL
60 Min
Assignment 2
2 Parts
- 0:45 Hr
Advanced Querying with Subqueries and Views
45 Min
Submit your Assignment here
Submit your Assignment here
Min Grade: 40
Chapter 7: Advanced SQL Queries
3 Parts
- 1:45 Hr
Advanced Subqueries
30 Min
Analytical Functions
30 Min
Exercise: Rank Data with Analytical Functions
45 Min
Chapter 8: Transactions and Triggers
3 Parts
- 1:45 Hr
Transactions
30 Min
Triggers
30 Min
Exercise: Implement an Audit Trigger
45 Min
Chapter 9: Packages and Version Control
3 Parts
- 2:00 Hr
SQL Packages
30 Min
Version Control
30 Min
Exercise: Create a Package and Use Git
60 Min
Assignment 3
2 Parts
- 0:45 Hr
Transactional Integrity and Indexing
45 Min
Submir your Project here
Submir your Project here
Min Grade: 40
Chapter 10: Advanced Indexing and Partitioning
3 Parts
- 2:00 Hr
Advanced Indexing
30 Min
Partitioning
30 Min
Exercise: Partition a Table for Performance
60 Min
Chapter 11: Advanced SQL and Performance Tuning
3 Parts
- 2:15 Hr
Dynamic SQL and Bulk Operations
45 Min
Performance Tuning
30 Min
Exercise: Optimize SQL Operations
60 Min
Chapter 12: Materialized Views and Advanced Analytics
3 Parts
- 1:45 Hr
Materialized Views
30 Min
Advanced Analytics
30 Min
Exercise: Create a Materialized View for Summaries
45 Min
Assignment 4
2 Parts
- 0:45 Hr
Modular PL/SQL with Procedures and Triggers
45 Min
Submit your Assignment here
Submit your Assignment here
Min Grade: 40
Chapter 13 JSON, XML, and Integration
3 Parts
- 2:00 Hr
JSON and XML
30 Min
External Integration
30 Min
Exercise: Integrate and Process Data
60 Min
Chapter 14: Security, Parallel Processing, and Backup
4 Parts
- 3:00 Hr
Advanced Security
30 Min
Parallel Processing
30 Min
Backup and Recovery
30 Min
Exercise: Secure and Optimize Database
90 Min
Capstone Projects
2 Parts
- 50:00 Hr
Inventory Management with PL/SQL Automation
3000 Min
Submit your Project here
Submit your Project here
Min Grade: 40
Capstone Project 2
2 Parts
- 50:00 Hr
Employee Performance Analytics System
3000 Min
Submit your Project here
Submit your Project here
Min Grade: 40
No Reviews Yet