Most popular
ETL Design Techniques
25 hours
Intermediate
Oracle 19c New Features
24 hours
Intermediate
What you'll learn
New Features Overview
Multitenant New Features
Security Features
Cloud Services
Networking
Globalization
Big Data Support
Database Installation and Configuration
Database Tuning
Backup and Recovery
Implementing A SQL Data Warehouse
40 hours
Intermediate
What you'll learn
Describe the key elements of a data warehouse solution
Considerations for building a data warehouse
Implementing a logical design for a data warehouse
Implement a physical design for a data warehouse
Create Columnstore indexes
Implementing an Azure SQL Data Warehouse
Describe the key features of SSIS
Implement a data flow by using SSIS
Implement control flow by using tasks and precedence constraints
Create dynamic packages that include variables and parameters
Debug SSIS packages
Describe the considerations of implement an ETL Solution
Implement Data Quality Services
Implement a Master Data Service model
Describe how you can use custom components to extend SSIS
Deploy SSI projects
Describe BI and common BI scenarios
Database Design (OLTP) Techniques
30 hours
Intermediate
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
Oracle 19c Backup, Recovery, & Tuning
24 hours
Intermediate
What you'll learn
mplement backup and recovery settings and perform backup operations to the media of your choice.
Move data between databases and files
Use Oracle Database recovery processes to recover from media and other failures.
Diagnose and repair data failures
Use flashback technologies and data duplication to complement backup and recovery procedures
Secure the availability of their database using backup and recovery strategies
Data Warehouse (OLAP) Design Techniques
25 hours
Intermediate
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
Oracle 19c Database Administration II
76 Lessons
40 hours
Intermediate
What you'll learn
Creating CDBs and Regular PDBs
Managing CDBs and PDBs
Backup and Duplicate
Upgrading and Transporting CDBs and Regular PDBs
Backup Strategies and Terminology
Restore and Recovery Concepts
Using Flashback Technologies
Duplicating a Database
Installing Grid Infrastructure and Oracle Database
Patching Grid Infrastructure and Oracle Database
Upgrading to Oracle Grid Infrastructure
Oracle Database 18c: New Features
Using General Overall Database Enhancements
Monitoring and Tuning Database Performance
Managing Application PDBs
Managing Security in Multitenant databases
Recovery and Flashback
Configuring and Using RMAN
Diagnosing Failures
Performing Recovery
Transporting Data
RMAN Troubleshooting and Tuning
Creating an Oracle Database by using DBCA
Oracle Restart
Upgrading the Oracle Database
Installing Grid Infrastructure for a Standalone server
Using Availability Enhancements
Tuning SQL Statements
Oracle Data Integrator 19c Configuration and Administration
80 Lessons
24 hours
Intermediate
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
55316: Administering A SQL Database
107 Lessons
40 hours
Intermediate
What you'll learn
Authenticate and authorize users
Assign server and database roles
Authorize users to access resources
Use encryption and auditing features to protect data
Describe recovery models and backup strategies
Backup and Restore SQL Server databases
Automate database management
Configure security for the SQL Server agent
Manage alerts and notifications
Managing SQL Server using PowerShell
Trace access to SQL Server
Monitor a SQL Server infrastructure
Troubleshoot a SQL Server infrastructure
Import and export data
Oracle 19c Database Tuning
40 hours
Intermediate
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
Trending
ETL Design Techniques
25 hours
Intermediate
Oracle 19c New Features
24 hours
Intermediate
What you'll learn
New Features Overview
Multitenant New Features
Security Features
Cloud Services
Networking
Globalization
Big Data Support
Database Installation and Configuration
Database Tuning
Backup and Recovery
Implementing A SQL Data Warehouse
40 hours
Intermediate
What you'll learn
Describe the key elements of a data warehouse solution
Considerations for building a data warehouse
Implementing a logical design for a data warehouse
Implement a physical design for a data warehouse
Create Columnstore indexes
Implementing an Azure SQL Data Warehouse
Describe the key features of SSIS
Implement a data flow by using SSIS
Implement control flow by using tasks and precedence constraints
Create dynamic packages that include variables and parameters
Debug SSIS packages
Describe the considerations of implement an ETL Solution
Implement Data Quality Services
Implement a Master Data Service model
Describe how you can use custom components to extend SSIS
Deploy SSI projects
Describe BI and common BI scenarios
Database Design (OLTP) Techniques
30 hours
Intermediate
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
Oracle 19c Backup, Recovery, & Tuning
24 hours
Intermediate
What you'll learn
mplement backup and recovery settings and perform backup operations to the media of your choice.
Move data between databases and files
Use Oracle Database recovery processes to recover from media and other failures.
Diagnose and repair data failures
Use flashback technologies and data duplication to complement backup and recovery procedures
Secure the availability of their database using backup and recovery strategies
Data Warehouse (OLAP) Design Techniques
25 hours
Intermediate
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
Oracle 19c Database Administration II
76 Lessons
40 hours
Intermediate
What you'll learn
Creating CDBs and Regular PDBs
Managing CDBs and PDBs
Backup and Duplicate
Upgrading and Transporting CDBs and Regular PDBs
Backup Strategies and Terminology
Restore and Recovery Concepts
Using Flashback Technologies
Duplicating a Database
Installing Grid Infrastructure and Oracle Database
Patching Grid Infrastructure and Oracle Database
Upgrading to Oracle Grid Infrastructure
Oracle Database 18c: New Features
Using General Overall Database Enhancements
Monitoring and Tuning Database Performance
Managing Application PDBs
Managing Security in Multitenant databases
Recovery and Flashback
Configuring and Using RMAN
Diagnosing Failures
Performing Recovery
Transporting Data
RMAN Troubleshooting and Tuning
Creating an Oracle Database by using DBCA
Oracle Restart
Upgrading the Oracle Database
Installing Grid Infrastructure for a Standalone server
Using Availability Enhancements
Tuning SQL Statements
Oracle Data Integrator 19c Configuration and Administration
80 Lessons
24 hours
Intermediate
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
55316: Administering A SQL Database
107 Lessons
40 hours
Intermediate
What you'll learn
Authenticate and authorize users
Assign server and database roles
Authorize users to access resources
Use encryption and auditing features to protect data
Describe recovery models and backup strategies
Backup and Restore SQL Server databases
Automate database management
Configure security for the SQL Server agent
Manage alerts and notifications
Managing SQL Server using PowerShell
Trace access to SQL Server
Monitor a SQL Server infrastructure
Troubleshoot a SQL Server infrastructure
Import and export data
Oracle 19c Database Tuning
40 hours
Intermediate
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
Featured Courses
55315: Introduction To SQL Databases
27 Lessons
24 hours
Beginner
Course Description This three-day instructor-led course is aimed at people …
$2,095.00
55315: Introduction To SQL Databases
27 Lessons
24 hours
Beginner
What you'll learn
Describe key database concepts in the context of SQL Server
Describe database languages used in SQL Server
Describe data modelling techniques
Describe normalization and denormalization techniques
Describe relationship types and effects in database design
Describe the effects of database design on performance
Describe commonly used database objects
55316: Administering A SQL Database
107 Lessons
40 hours
Intermediate
Course Description This instructor-led course provides students who manage SQL …
$2,995.00
55316: Administering A SQL Database
107 Lessons
40 hours
Intermediate
What you'll learn
Authenticate and authorize users
Assign server and database roles
Authorize users to access resources
Use encryption and auditing features to protect data
Describe recovery models and backup strategies
Backup and Restore SQL Server databases
Automate database management
Configure security for the SQL Server agent
Manage alerts and notifications
Managing SQL Server using PowerShell
Trace access to SQL Server
Monitor a SQL Server infrastructure
Troubleshoot a SQL Server infrastructure
Import and export data
All Database & ERP Courses
Database & ERP Online Training Courses - Live
ERP provides an integrated and continuously updated view of core business processes using common databases maintained by a database management system. It’s an effective yet specialized skill set. We help you educate your team with an extensive selection of courses in this area. From basics to advanced, explore our training and certification courses for Oracle Database, MS SQL, and more.
Filter by category
Filter by Vendor
We found 1 course available for you
55315: Introduction To SQL Databases
27 Lessons
24 hours
Beginner
Course Description This three-day instructor-led course is aimed at people …
$2,095.00
What you'll learn
Describe key database concepts in the context of SQL Server
Describe database languages used in SQL Server
Describe data modelling techniques
Describe normalization and denormalization techniques
Describe relationship types and effects in database design
Describe the effects of database design on performance
Describe commonly used database objects