Most popular
Oracle 19C Database Multitenant Architecture (TTOR20719)
24 hours
Beginner
What you'll learn
<b>CDB Management Skills</b>: Gain expertise in managing Container Databases (CDBs), including setup, configuration, and maintenance.
<b>PDB Operations Proficiency</b>: Develop the ability to efficiently handle Pluggable Database (PDB) operations like creation, cloning, and management.
<b>Database Security Measures</b>: Learn to implement and manage security protocols in both CDBs and PDBs, ensuring data integrity and compliance.
<b>Backup and Recovery Techniques</b>: Master the techniques for performing backups and recoveries of CDBs and PDBs, ensuring data safety and continuity.
<b>Performance Optimization</b>: Acquire skills to optimize the performance of databases within the Oracle Multitenant environment, including tuning and resource allocation.
<b>Data Movement and Storage Management</b>: Understand and apply methods for effective data movement and storage management in a Multitenant architecture.
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
Oracle Database 19c Backup and Recovery (TTOR21619)
24 hours
Intermediate
What you'll learn
Implement 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
Oracle 19c Database Administration II (Oracle DBA II) (TTOR20619)
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
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
DP-080T00: Querying Data with Microsoft Transact-SQL
29 Lessons
16 hours
Intermediate
What you'll learn
Introduction to Transact-SQL
Sort and filter results in T-SQL
Combine multiple tables with JOINs in T-SQL
Write Subqueries in T-SQL
Use built-in functions and GROUP BY in Transact-SQL
Modify data with T-SQL
ETL Design Techniques
25 hours
Intermediate
Optimize query performance in Azure SQL
18 Lessons
32 hours
Intermediate
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
M55144: SQL Server Performance Tuning And Optimization
73 Lessons
40 hours
Intermediate
What you'll learn
SQL 2014 Architecture including the new Cardinality Estimator
Memory-optimized tables
Startup stored procedures
Database structures
Instant File Allocation
Table internals and valued parameters
Concurrency, transactions, and isolation levels
SQL Server locking architecture
Partitioned tables and indexes
Resource Governor, Activity Monitor, Transact-SQL, and performance data management views (DMVs)
Performance Monitor Tool, execution plans, Data Access Operators, MDW and viewing reports
Create, utilize, manage and monitor indexes
Cardinality Estimator, incremental statistics, computed column statistics, filtered statics, and maintenance
In-Memory OLTP engine, restrictions, the Analyze Migrate Report tool, and in-memory (DMVs)
Trending
Oracle 19C Database Multitenant Architecture (TTOR20719)
24 hours
Beginner
What you'll learn
<b>CDB Management Skills</b>: Gain expertise in managing Container Databases (CDBs), including setup, configuration, and maintenance.
<b>PDB Operations Proficiency</b>: Develop the ability to efficiently handle Pluggable Database (PDB) operations like creation, cloning, and management.
<b>Database Security Measures</b>: Learn to implement and manage security protocols in both CDBs and PDBs, ensuring data integrity and compliance.
<b>Backup and Recovery Techniques</b>: Master the techniques for performing backups and recoveries of CDBs and PDBs, ensuring data safety and continuity.
<b>Performance Optimization</b>: Acquire skills to optimize the performance of databases within the Oracle Multitenant environment, including tuning and resource allocation.
<b>Data Movement and Storage Management</b>: Understand and apply methods for effective data movement and storage management in a Multitenant architecture.
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
Oracle Database 19c Backup and Recovery (TTOR21619)
24 hours
Intermediate
What you'll learn
Implement 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
Oracle 19c Database Administration II (Oracle DBA II) (TTOR20619)
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
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
DP-080T00: Querying Data with Microsoft Transact-SQL
29 Lessons
16 hours
Intermediate
What you'll learn
Introduction to Transact-SQL
Sort and filter results in T-SQL
Combine multiple tables with JOINs in T-SQL
Write Subqueries in T-SQL
Use built-in functions and GROUP BY in Transact-SQL
Modify data with T-SQL
ETL Design Techniques
25 hours
Intermediate
Optimize query performance in Azure SQL
18 Lessons
32 hours
Intermediate
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
M55144: SQL Server Performance Tuning And Optimization
73 Lessons
40 hours
Intermediate
What you'll learn
SQL 2014 Architecture including the new Cardinality Estimator
Memory-optimized tables
Startup stored procedures
Database structures
Instant File Allocation
Table internals and valued parameters
Concurrency, transactions, and isolation levels
SQL Server locking architecture
Partitioned tables and indexes
Resource Governor, Activity Monitor, Transact-SQL, and performance data management views (DMVs)
Performance Monitor Tool, execution plans, Data Access Operators, MDW and viewing reports
Create, utilize, manage and monitor indexes
Cardinality Estimator, incremental statistics, computed column statistics, filtered statics, and maintenance
In-Memory OLTP engine, restrictions, the Analyze Migrate Report tool, and in-memory (DMVs)
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 Vendor
We found 18 courses available for you
Database Design (OLTP) Techniques
30 hours
Intermediate
Course Description In this course, students are introduced to various …
Free
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
25 hours
Intermediate
Course Description This course focuses on extract, transform, and load …
Free