All Database & ERP Courses
Filter by Topic
Filter by Vendor
Oracle 19c Database Administration I
Course Description: Oracle 19c Database Administration I is a comprehensive, …
What you'll learn
Describe Oracle Database architecture
Describe Oracle Database Cloud Service (DBCS) architecture and features
Create and manage DBCS database deployments
Configure the database to support your applications
Manage database security and implement auditing
Implement basic backup and recovery procedures
Move data between databases and files
Employ basic monitoring procedures and manage performance
Oracle 19C PL/SQL FUNDAMENTALS | Introduction to PL/SQL
Course Description: Oracle 19C PL/SQL Fundamentals provides a complete, hands-on, …
What you'll learn
Oracle 19C PL/SQL Fundamentals provides a complete, hands-on, comprehensive introduction to PL/SQL including the use of both SQL Developer and SQL Plus.
Oracle 19c Database Tuning
Course Description: Oracle 19C Database Tuning is an intermediate level …
What you'll learn
Overview Oracle Database Architecture
Query Optimizer
Tuning Container Databases and Pluggable Databases
Oracle 12c Tuning features
Evaluating Execution Plans
Oracle Tuning Tools
Using Automatic Workload Repository
Join Types
AWR Using Baselines
Additional AWR performance tools
Optimizer Statistics
Monitoring a Service
Bind Variables and database parameters
Oracle’s Real Application Testing (RAT)
SQL Tuning Advisor
Automatic Sql Tuning
Sql Plan Management
Shared Pool Tuning
Tuning the database buffer cache
Tuning the PGA (Program Global Area)
Automatic Memory Management (AMM)
Tuning Segment Space Utilization (ASSM)
Automatic Storage Management
Oracle Data Integrator 19c Configuration and Administration
Course Description: Oracle Data Integrator 19c Administration and Configuration. Explore …
What you'll learn
Administer ODI resources and setup security with ODI
Apply ODI Topology concepts for data integration
Describe ODI Model concepts
Describe architecture of Oracle Data Integrator 12c
Design ODI Mappings, Procedures, Packages, and Load Plans to perform ELT data transformations
Explore, audit data, and enforce data quality with ODI
Implement Changed Data Capture with ODI
Data Warehouse (OLAP) Design Techniques
Course Description Students will learn basic concepts, such as the …
What you'll learn
Develop and implement data warehouse designs
Perform requirements gathering
Analyze requirements
Identify star, snowflake, and galaxy schema
Manage dimensions and facts
Database Design (OLTP) Techniques
Course Description In this course, students are introduced to various …
What you'll learn
Gather business requirements
Analyze business requirements
Create logical and physical data models
Learn Erwin modeling tools
Forward and reverse engineering techniques
ETL Design Techniques
Course Description This course focuses on extract, transform, and load …