Most popular
Oracle 19C PL/SQL FUNDAMENTALS | Introduction to PL/SQL
24 hours
Intermediate
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.
Optimize query performance in Azure SQL
18 Lessons
32 hours
Intermediate
Oracle 19c Database Administration I
40 hours
Intermediate
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
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)
Oracle Data Integrator (ODI) 19c
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
55353: Administering A SQL Database Infrastructure
104 Lessons
40 hours
Intermediate
What you'll learn
Authenticate and authorize users
Assign server and database roles
Authorize users to access resources
Protect data with encryption and auditing
Describe recovery models and backup strategies
Backup SQL Server databases
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 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
Trending
Oracle 19C PL/SQL FUNDAMENTALS | Introduction to PL/SQL
24 hours
Intermediate
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.
Optimize query performance in Azure SQL
18 Lessons
32 hours
Intermediate
Oracle 19c Database Administration I
40 hours
Intermediate
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
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)
Oracle Data Integrator (ODI) 19c
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
55353: Administering A SQL Database Infrastructure
104 Lessons
40 hours
Intermediate
What you'll learn
Authenticate and authorize users
Assign server and database roles
Authorize users to access resources
Protect data with encryption and auditing
Describe recovery models and backup strategies
Backup SQL Server databases
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 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
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