Most popular
Oracle Database 19c Multitenant Architecture
24 hours
Intermediate
What you'll learn
Core concepts of regular PDBs
Creating a CDB, and then using different methods to create PDBs.
How to start and shut down a CDB and how to open and close a PDB.
Security aspects in CDBs and PDBs in various areas like privileges and roles, lockdown profiles, auditing, Database Vault, and encryption.
Availability through backup, duplicate, recovery, and flashback topics and then performance, monitoring, and resources allocation management in CDBs and PDBs.
How you can move data from a non-CDB environment to a PDB.
How to move data between PDBs by using utilities such as the export and import features of Oracle Data Pump, SQL*Loader, external tables, and Oracle Recovery Manager.
Developing SQL Data Models
40 Lessons
24 hours
Intermediate
What you'll learn
Components, architecture, and nature of a BI solution
Create a multidimensional database with analysis services
Implement dimensions in a cube
Implement measures and measure groups in a cube
Use MDX syntax
Customize a cube
Implement a tabular database
Use DAX to query a tabular model
Use data mining for predictive analysis
Oracle Enterprise Manager (OEM) 19c Cloud Control
24 hours
Intermediate
What you'll learn
Use Cloud Control to organize your managed enterprise
Describe roles and privileges
Monitor the overall performance and health of your managed system
Manage incidents and set up notifications
Use the Job System to automate commonly performed tasks
Patch and provision new systems
View, search, and compare configurations
Explain compliance policies and evaluate policy violations
Create and use Cloud Control reports
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
Oracle 19c SQL Fundamentals
24 hours
Intermediate
What you'll learn
Initially, you will learn about all the key elements of a database and the way Oracle systems facilitate their induction in the system. Then you will discover the tools you can use and the strategies you can implement to store, retrieve, compare and organize data according to your requirements.
You will also learn the process of creating simple to complex reports from existing data. By the end of this course, you will also have hands-on knowledge of SQL systems that are required to proceed to other advanced to professional programs.
55321: SQL Server Integration Services
87 Lessons
40 hours
Intermediate
What you'll learn
Create sophisticated SSIS packages for extracting, transforming, and loading data
Use containers to efficiently control repetitive tasks and transactions
Configure packages to dynamically adapt to environment changes
Use Data Quality Services to cleanse data
Successfully troubleshoot packages
Create and Manage the SSIS Catalog
Deploy, configure, and schedule packages
Secure the SSIS Catalog
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
Trending
Oracle Database 19c Multitenant Architecture
24 hours
Intermediate
What you'll learn
Core concepts of regular PDBs
Creating a CDB, and then using different methods to create PDBs.
How to start and shut down a CDB and how to open and close a PDB.
Security aspects in CDBs and PDBs in various areas like privileges and roles, lockdown profiles, auditing, Database Vault, and encryption.
Availability through backup, duplicate, recovery, and flashback topics and then performance, monitoring, and resources allocation management in CDBs and PDBs.
How you can move data from a non-CDB environment to a PDB.
How to move data between PDBs by using utilities such as the export and import features of Oracle Data Pump, SQL*Loader, external tables, and Oracle Recovery Manager.
Developing SQL Data Models
40 Lessons
24 hours
Intermediate
What you'll learn
Components, architecture, and nature of a BI solution
Create a multidimensional database with analysis services
Implement dimensions in a cube
Implement measures and measure groups in a cube
Use MDX syntax
Customize a cube
Implement a tabular database
Use DAX to query a tabular model
Use data mining for predictive analysis
Oracle Enterprise Manager (OEM) 19c Cloud Control
24 hours
Intermediate
What you'll learn
Use Cloud Control to organize your managed enterprise
Describe roles and privileges
Monitor the overall performance and health of your managed system
Manage incidents and set up notifications
Use the Job System to automate commonly performed tasks
Patch and provision new systems
View, search, and compare configurations
Explain compliance policies and evaluate policy violations
Create and use Cloud Control reports
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
Oracle 19c SQL Fundamentals
24 hours
Intermediate
What you'll learn
Initially, you will learn about all the key elements of a database and the way Oracle systems facilitate their induction in the system. Then you will discover the tools you can use and the strategies you can implement to store, retrieve, compare and organize data according to your requirements.
You will also learn the process of creating simple to complex reports from existing data. By the end of this course, you will also have hands-on knowledge of SQL systems that are required to proceed to other advanced to professional programs.
55321: SQL Server Integration Services
87 Lessons
40 hours
Intermediate
What you'll learn
Create sophisticated SSIS packages for extracting, transforming, and loading data
Use containers to efficiently control repetitive tasks and transactions
Configure packages to dynamically adapt to environment changes
Use Data Quality Services to cleanse data
Successfully troubleshoot packages
Create and Manage the SSIS Catalog
Deploy, configure, and schedule packages
Secure the SSIS Catalog
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
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
DP-080T00: Querying Data with Microsoft Transact-SQL
29 Lessons
16 hours
Intermediate
Course Description This course will teach you how to use …
$1,545.00
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