Accredited Expert-Level Oracle Database Advanced Video Course

Lesson 1: Introduction to Advanced Oracle Database Concepts
Overview of Oracle Database Architecture
Advanced SQL and PL/SQL Concepts
Oracle Database 19c/21c New Features
Performance Tuning Overview
Security and Compliance
High Availability Solutions
Data Guard and Disaster Recovery
Oracle Multitenant Architecture
In-Memory Database Options
Advanced Indexing Techniques
Lesson 2: Advanced SQL and PL/SQL
Complex Query Optimization
Advanced PL/SQL Programming
Dynamic SQL and PL/SQL
Using Collections and Records
Advanced Error Handling
PL/SQL Performance Tuning
Using Bulk Operations
Advanced Cursor Techniques
PL/SQL and JSON Integration
PL/SQL and XML Integration
Lesson 3: Performance Tuning
SQL Tuning Fundamentals
Using Execution Plans
Indexing Strategies
Optimizer Statistics
SQL Plan Management
Database Performance Metrics
Using AWR and ASH Reports
Tuning Memory Structures
I/O Performance Tuning
Real-Time SQL Monitoring
Lesson 4: Oracle Database Security
Advanced User Management
Role-Based Access Control
Data Encryption Techniques
Virtual Private Database (VPD)
Audit Vault and Database Firewall
Oracle Label Security
Data Masking and Subsetting
Secure External Password Store
Transparent Data Encryption (TDE)
Compliance and Regulatory Requirements
Lesson 5: High Availability and Disaster Recovery
Oracle Data Guard Overview
Configuring Data Guard
Switchovers and Failovers
Active Data Guard
Oracle GoldenGate Overview
Configuring GoldenGate
GoldenGate Performance Tuning
Disaster Recovery Planning
Backup and Recovery Strategies
Using RMAN for Disaster Recovery
Lesson 6: Oracle Multitenant Architecture
Introduction to Container Databases (CDB)
Pluggable Databases (PDB) Management
Resource Management in Multitenant
Cloning and Refreshing PDBs
Backup and Recovery in Multitenant
Performance Tuning in Multitenant
Security in Multitenant Environments
Upgrading Multitenant Databases
Migrating to Multitenant Architecture
Best Practices for Multitenant Deployment
Lesson 7: In-Memory Database Options
Oracle In-Memory Database Overview
Configuring In-Memory Column Store
In-Memory Aggregation
In-Memory Joins
In-Memory Performance Tuning
Using In-Memory with OLTP
Using In-Memory with Data Warehousing
In-Memory and Exadata Integration
Monitoring In-Memory Performance
Best Practices for In-Memory Deployment
Lesson 8: Advanced Indexing Techniques
B-Tree Indexes
Bitmap Indexes
Function-Based Indexes
Domain Indexes
Partitioned Indexes
Invisible Indexes
Index Compression
Index Monitoring and Usage
Indexing for Performance
Best Practices for Indexing
Lesson 9: Oracle Database and Big Data
Oracle Big Data Appliance Overview
Integrating Oracle with Hadoop
Using Oracle NoSQL Database
Oracle Big Data SQL
Oracle Big Data Connectors
Oracle Big Data Discovery
Oracle Big Data Spatial and Graph
Oracle Big Data and Machine Learning
Oracle Big Data and IoT
Best Practices for Big Data Integration
Lesson 10: Oracle Database and Cloud Integration
Oracle Cloud Infrastructure Overview
Migrating to Oracle Cloud
Oracle Database Cloud Service
Oracle Autonomous Database
Oracle Cloud Security
Oracle Cloud Performance Tuning
Oracle Cloud Backup and Recovery
Oracle Cloud and Hybrid Environments
Oracle Cloud and Multi-Cloud Strategies
Best Practices for Cloud Integration
Lesson 11: Advanced Data Modeling
Advanced Entity-Relationship Modeling
Dimensional Modeling
Data Vault Modeling
Normalization and Denormalization
Advanced Indexing Strategies
Partitioning Strategies
Data Modeling for Performance
Data Modeling for Security
Data Modeling for High Availability
Best Practices for Data Modeling
Lesson 12: Oracle Database and Machine Learning
Oracle Machine Learning Overview
Oracle Machine Learning for SQL
Oracle Machine Learning for R
Oracle Machine Learning for Python
Oracle Machine Learning Algorithms
Oracle Machine Learning Model Management
Oracle Machine Learning and Big Data
Oracle Machine Learning and Cloud
Oracle Machine Learning and IoT
Best Practices for Machine Learning Integration
Lesson 13: Oracle Database and Blockchain
Oracle Blockchain Platform Overview
Oracle Blockchain Tables
Oracle Blockchain and Smart Contracts
Oracle Blockchain and Supply Chain
Oracle Blockchain and Finance
Oracle Blockchain and Healthcare
Oracle Blockchain and Government
Oracle Blockchain and IoT
Oracle Blockchain and Security
Best Practices for Blockchain Integration
Lesson 14: Oracle Database and IoT
Oracle IoT Cloud Service Overview
Oracle IoT and Device Management
Oracle IoT and Data Ingestion
Oracle IoT and Data Processing
Oracle IoT and Data Storage
Oracle IoT and Data Analysis
Oracle IoT and Machine Learning
Oracle IoT and Blockchain
Oracle IoT and Security
Best Practices for IoT Integration
Lesson 15: Oracle Database and AI
Oracle AI Platform Overview
Oracle AI and Machine Learning
Oracle AI and Natural Language Processing
Oracle AI and Computer Vision
Oracle AI and Robotics
Oracle AI and Autonomous Systems
Oracle AI and Data Science
Oracle AI and Cloud
Oracle AI and Security
Best Practices for AI Integration
Lesson 16: Oracle Database and Data Science
Oracle Data Science Platform Overview
Oracle Data Science and Machine Learning
Oracle Data Science and Statistical Analysis
Oracle Data Science and Data Visualization
Oracle Data Science and Big Data
Oracle Data Science and Cloud
Oracle Data Science and IoT
Oracle Data Science and AI
Oracle Data Science and Security
Best Practices for Data Science Integration
Lesson 17: Oracle Database and Data Visualization
Oracle Data Visualization Overview
Oracle Data Visualization Desktop
Oracle Data Visualization Cloud Service
Oracle Data Visualization and Big Data
Oracle Data Visualization and Machine Learning
Oracle Data Visualization and IoT
Oracle Data Visualization and AI
Oracle Data Visualization and Security
Oracle Data Visualization and Cloud
Best Practices for Data Visualization Integration
Lesson 18: Oracle Database and Data Governance
Oracle Data Governance Overview
Oracle Data Governance and Data Quality
Oracle Data Governance and Data Lineage
Oracle Data Governance and Data Catalog
Oracle Data Governance and Data Security
Oracle Data Governance and Compliance
Oracle Data Governance and Risk Management
Oracle Data Governance and Data Privacy
Oracle Data Governance and Cloud
Best Practices for Data Governance Integration
Lesson 19: Oracle Database and Data Integration
Oracle Data Integration Overview
Oracle Data Integrator
Oracle GoldenGate
Oracle Data Integration and Big Data
Oracle Data Integration and Cloud
Oracle Data Integration and IoT
Oracle Data Integration and AI
Oracle Data Integration and Machine Learning
Oracle Data Integration and Security
Best Practices for Data Integration
Lesson 20: Oracle Database and Data Migration
Oracle Data Migration Overview
Oracle Data Migration and ETL
Oracle Data Migration and Cloud
Oracle Data Migration and Big Data
Oracle Data Migration and IoT
Oracle Data Migration and AI
Oracle Data Migration and Machine Learning
Oracle Data Migration and Security
Oracle Data Migration and Compliance
Best Practices for Data Migration
Lesson 21: Oracle Database and Data Replication
Oracle Data Replication Overview
Oracle GoldenGate for Data Replication
Oracle Data Replication and Cloud
Oracle Data Replication and Big Data
Oracle Data Replication and IoT
Oracle Data Replication and AI
Oracle Data Replication and Machine Learning
Oracle Data Replication and Security
Oracle Data Replication and Compliance
Best Practices for Data Replication
Lesson 22: Oracle Database and Data Warehousing
Oracle Data Warehousing Overview
Oracle Data Warehouse Architecture
Oracle Data Warehouse and Big Data
Oracle Data Warehouse and Cloud
Oracle Data Warehouse and IoT
Oracle Data Warehouse and AI
Oracle Data Warehouse and Machine Learning
Oracle Data Warehouse and Security
Oracle Data Warehouse and Compliance
Best Practices for Data Warehousing
Lesson 23: Oracle Database and Data Mining
Oracle Data Mining Overview
Oracle Data Mining Algorithms
Oracle Data Mining and Machine Learning
Oracle Data Mining and Big Data
Oracle Data Mining and Cloud
Oracle Data Mining and IoT
Oracle Data Mining and AI
Oracle Data Mining and Security
Oracle Data Mining and Compliance
Best Practices for Data Mining
Lesson 24: Oracle Database and Data Quality
Oracle Data Quality Overview
Oracle Data Quality and Data Cleansing
Oracle Data Quality and Data Profiling
Oracle Data Quality and Data Standardization
Oracle Data Quality and Data Enrichment
Oracle Data Quality and Data Matching
Oracle Data Quality and Data Monitoring
Oracle Data Quality and Data Governance
Oracle Data Quality and Compliance
Best Practices for Data Quality
Lesson 25: Oracle Database and Data Security
Oracle Data Security Overview
Oracle Data Security and Encryption
Oracle Data Security and Access Control
Oracle Data Security and Auditing
Oracle Data Security and Monitoring
Oracle Data Security and Compliance
Oracle Data Security and Risk Management
Oracle Data Security and Data Privacy
Oracle Data Security and Cloud
Best Practices for Data Security
Lesson 26: Oracle Database and Data Privacy
Oracle Data Privacy Overview
Oracle Data Privacy and GDPR
Oracle Data Privacy and CCPA
Oracle Data Privacy and Data Masking
Oracle Data Privacy and Data Anonymization
Oracle Data Privacy and Data Encryption
Oracle Data Privacy and Access Control
Oracle Data Privacy and Auditing
Oracle Data Privacy and Monitoring
Best Practices for Data Privacy
Lesson 27: Oracle Database and Data Compliance
Oracle Data Compliance Overview
Oracle Data Compliance and GDPR
Oracle Data Compliance and CCPA
Oracle Data Compliance and HIPAA
Oracle Data Compliance and SOX
Oracle Data Compliance and PCI DSS
Oracle Data Compliance and Data Governance
Oracle Data Compliance and Risk Management
Oracle Data Compliance and Auditing
Best Practices for Data Compliance
Lesson 28: Oracle Database and Data Risk Management
Oracle Data Risk Management Overview
Oracle Data Risk Management and Data Governance
Oracle Data Risk Management and Data Security
Oracle Data Risk Management and Data Privacy
Oracle Data Risk Management and Data Compliance
Oracle Data Risk Management and Data Quality
Oracle Data Risk Management and Data Integration
Oracle Data Risk Management and Data Migration
Oracle Data Risk Management and Data Replication
Best Practices for Data Risk Management
Lesson 29: Oracle Database and Data Auditing
Oracle Data Auditing Overview
Oracle Data Auditing and Data Governance
Oracle Data Auditing and Data Security
Oracle Data Auditing and Data Privacy
Oracle Data Auditing and Data Compliance
Oracle Data Auditing and Data Quality
Oracle Data Auditing and Data Integration
Oracle Data Auditing and Data Migration
Oracle Data Auditing and Data Replication
Best Practices for Data Auditing
Lesson 30: Oracle Database and Data Monitoring
Oracle Data Monitoring Overview
Oracle Data Monitoring and Data Governance
Oracle Data Monitoring and Data Security
Oracle Data Monitoring and Data Privacy
Oracle Data Monitoring and Data Compliance
Oracle Data Monitoring and Data Quality
Oracle Data Monitoring and Data Integration
Oracle Data Monitoring and Data Migration
Oracle Data Monitoring and Data Replication
Best Practices for Data Monitoring
Lesson 31: Oracle Database and Data Lineage
Oracle Data Lineage Overview
Oracle Data Lineage and Data Governance
Oracle Data Lineage and Data Security
Oracle Data Lineage and Data Privacy
Oracle Data Lineage and Data Compliance
Oracle Data Lineage and Data Quality
Oracle Data Lineage and Data Integration
Oracle Data Lineage and Data Migration
Oracle Data Lineage and Data Replication
Best Practices for Data Lineage
Lesson 32: Oracle Database and Data Catalog
Oracle Data Catalog Overview
Oracle Data Catalog and Data Governance
Oracle Data Catalog and Data Security
Oracle Data Catalog and Data Privacy
Oracle Data Catalog and Data Compliance
Oracle Data Catalog and Data Quality
Oracle Data Catalog and Data Integration
Oracle Data Catalog and Data Migration
Oracle Data Catalog and Data Replication
Best Practices for Data Catalog
Lesson 33: Oracle Database and Data Governance Tools
Oracle Data Governance Tools Overview
Oracle Enterprise Metadata Management
Oracle Data Relationship Management
Oracle Data Relationship Governance
Oracle Data Governance and Data Quality
Oracle Data Governance and Data Integration
Oracle Data Governance and Data Migration
Oracle Data Governance and Data Replication
Oracle Data Governance and Data Security
Best Practices for Data Governance Tools
Lesson 34: Oracle Database and Data Quality Tools
Oracle Data Quality Tools Overview
Oracle Enterprise Data Quality
Oracle Data Profiler
Oracle Data Quality and Data Governance
Oracle Data Quality and Data Integration
Oracle Data Quality and Data Migration
Oracle Data Quality and Data Replication
Oracle Data Quality and Data Security
Oracle Data Quality and Data Privacy
Best Practices for Data Quality Tools
Lesson 35: Oracle Database and Data Integration Tools
Oracle Data Integration Tools Overview
Oracle Data Integrator
Oracle GoldenGate
Oracle Data Integration and Data Governance
Oracle Data Integration and Data Quality
Oracle Data Integration and Data Migration
Oracle Data Integration and Data Replication
Oracle Data Integration and Data Security
Oracle Data Integration and Data Privacy
Best Practices for Data Integration Tools
Lesson 36: Oracle Database and Data Migration Tools
Oracle Data Migration Tools Overview
Oracle Data Pump
Oracle SQL Developer
Oracle Data Migration and Data Governance
Oracle Data Migration and Data Quality
Oracle Data Migration and Data Integration
Oracle Data Migration and Data Replication
Oracle Data Migration and Data Security
Oracle Data Migration and Data Privacy
Best Practices for Data Migration Tools
Lesson 37: Oracle Database and Data Replication Tools
Oracle Data Replication Tools Overview
Oracle GoldenGate
Oracle Streams
Oracle Data Replication and Data Governance
Oracle Data Replication and Data Quality
Oracle Data Replication and Data Integration
Oracle Data Replication and Data Migration
Oracle Data Replication and Data Security
Oracle Data Replication and Data Privacy
Best Practices for Data Replication Tools
Lesson 38: Oracle Database and Data Security Tools
Oracle Data Security Tools Overview
Oracle Advanced Security
Oracle Audit Vault and Database Firewall
Oracle Data Security and Data Governance
Oracle Data Security and Data Quality
Oracle Data Security and Data Integration
Oracle Data Security and Data Migration
Oracle Data Security and Data Replication
Oracle Data Security and Data Privacy
Best Practices for Data Security Tools
Lesson 39: Oracle Database and Data Privacy Tools
Oracle Data Privacy Tools Overview
Oracle Data Masking and Subsetting
Oracle Data Privacy and Data Governance
Oracle Data Privacy and Data Quality
Oracle Data Privacy and Data Integration
Oracle Data Privacy and Data Migration
Oracle Data Privacy and Data Replication
Oracle Data Privacy and Data Security
Oracle Data Privacy and Compliance
Best Practices for Data Privacy Tools
Lesson 40: Oracle Database and Data Compliance Tools
Oracle Data Compliance Tools Overview
Oracle Data Compliance and Data Governance
Oracle Data Compliance and Data Quality
Oracle Data Compliance and Data Integration
Oracle Data Compliance and Data Migration
Oracle Data Compliance and Data Replication
Oracle Data Compliance and Data Security
Oracle Data Compliance and Data Privacy
Oracle Data Compliance and Risk Management
Best Practices for Data Compliance Tools