Live Instructor-Led Training
The course Building a Data Warehouse (Oracle Training) focuses on the art, functionality and application of Data Mining and Data Warehousing with Oracle. Beginning with the definitions of facts and dimensions, the course discusses every aspect of the Data Warehouse creation process from data loading to data mining. Implementing a data warehouse has never been this intuitive.
Jan 14 - 17, 2025$3,750.00Feb 11 - 14, 2025$3,750.00Mar 11 - 14, 2025$3,750.00Apr 15 - 18, 2025$3,750.00May 13 - 16, 2025$3,750.00Jun 10 - 13, 2025$3,750.00Jul 15 - 18, 2025$3,750.00
Data Warehousing
What is a Data Warehouse?
Oracle Data Warehouse Features
Challenges of Building a Data Warehouse
Essential Data Warehouse Concepts
Data Warehouse versus Data Mart
Where is Data Warehouse Going?
About the Oracle Warehouse Builder
Designing a Data Warehouse
About Dimensional Modeling
Dimension Tables and Fact Tables
Warehouse Keys
Data Warehouses and Normalization
Management and Performance Considerations
Implementing the Data Warehouse
The Topology of the Design
The Database Configuration Assistant
Data Files, Tablespaces and Schemas
Creating the Fact and Dimension Tables
Indexing and Partitioning
Testing the Design
Architecture
The Hardware Configuration
Hardware Components
Automatic Storage Management
File Management
The Physical Design
Data Partitioning
Indexing
IOTs
Data Compression
Loading Data
Extracting Data from the OLTP System
Transforming Data
Loading the Warehouse
Oracle Database Transformations
Postload Operations
Commonly Used Tools
Querying
The Query Optimizer
Parallel Execution
Data Warehouse Specific SQL
Summary Management
About Summary Tables
Planning the Physical Storage
Creating a Materialized View
Refreshing the Materialized View
Partitioning and Indexing
The EXPLAIN_MVIEW Utility
Dimensions
About Dimensions
Creating a Dimension
Single and Multiple Hierarchies
Adding Attributes
Dimensions and Normalized Tables
Dimension Validation
Query Rewrite
What is Query Rewrite
Overview of Rewrite Types
SQL Text Match
Join Back
Adding Aggregations
Filtered Data
Dimensions
Constraints
Integrity Modes
Partitioning Change Tracking
Advanced Query Rewrite Options
Tuning Query Performance
Monitoring Performance
Advisor Central
SQL Access Advisor
SQL Tuning Advisor
Memory Advisor
OLAP
Overview of Oracle OLAP
ROLAP and MOLAP
OLAP Architecture
Analytic Workspaces
The OLAP Catalog
The Analytic Workspace Manager
Querying Analytic Workspaces
Oracle Data Mining
Overview of Oracle Data Mining
Association Rules
Clustering
Feature Extraction
Classification
Regression
The PMML Standard
Final Case Study : The ChoquetteTech Data Warehouse
Oracle Training: Mastering Oracle Database Administration
The course Mastering Oracle Database Administration (Oracle Training) is a complete study of Oracle database administration. We learn all about Oracle installation, configuration, databases, tablespaces, control files, data files, log files and more. The course discusses Oracle troubleshooting and diagnostics, fault tolerance, security, partitioning, and flashback management. The training also includes a discussion on performance tuning through an introduction to the use of indexes and statistics in Oracle database operations.
Training course titled Oracle Training: Mastering Oracle Database Administration that will allow you to hone your professional skills.
Jan 21 - 24, 2025$3,750.00Feb 4 - 7, 2025$3,750.00Mar 4 - 7, 2025$3,750.00Apr 8 - 11, 2025$3,750.00May 6 - 9, 2025$3,750.00Jun 3 - 6, 2025$3,750.00Jul 8 - 11, 2025$3,750.00
PLSQL Training: Mastering Database Programming with PL/SQL
The course Mastering Database Programming with PL/SQL (PLSQL Training) covers the essential elements of the PL/SQL language. The training includes the creation and deletion of tables and the use of SQL to display, insert, delete and modify relational data. The course also covers blocks, data types, variables, program flows, stored procedures & functions and PL/SQL packages.
Training course titled PLSQL Training: Mastering Database Programming with PL/SQL that will allow you to hone your professional skills.
Jan 21 - 24, 2025$3,750.00Feb 18 - 21, 2025$3,750.00Mar 18 - 21, 2025$3,750.00Apr 22 - 25, 2025$3,750.00May 20 - 23, 2025$3,750.00Jun 17 - 20, 2025$3,750.00Jul 22 - 25, 2025$3,750.00
PLSQL Training: The Complete PL/SQL Programming Course
The course The Complete PL/SQL Programming Course (PLSQL Training) is a detailed exploration of the PL/SQL language and it many nooks and crannies. The course covers basic & advanced SQL techniques and PL/SQL programming fundamentals. The training also includes cursors, triggers, stored procedures & functions, sequences and packages. Finally, the course discusses object oriented programming, Java integration, XML processing & performance tuning with indexes. This PL/SQL course will teach you how to write great PL/SQL code.
Training course titled PLSQL Training: The Complete PL/SQL Programming Course that will allow you to hone your professional skills.
Jan 14 - 17, 2025$3,750.00Feb 11 - 14, 2025$3,750.00Mar 11 - 14, 2025$3,750.00Apr 15 - 18, 2025$3,750.00May 13 - 16, 2025$3,750.00Jun 10 - 13, 2025$3,750.00Jul 15 - 18, 2025$3,750.00
Oracle Training: A Complete Introduction to Forms & Reports
The course A Complete Introduction to Forms & Reports (Oracle Training) covers the essentials skills that are necessary to design. implement & troubleshoot Oracle Forms and Reports. Whether you need to build a report that highlights sales in the last quarter or build a form that allows sales to be entered into an Oracle database, this is the training course for you.
Training course titled Oracle Training: A Complete Introduction to Forms & Reports that will allow you to hone your professional skills.
Jan 14 - 17, 2025$3,750.00Jan 21 - 24, 2025$3,750.00Feb 18 - 21, 2025$3,750.00Mar 18 - 21, 2025$3,750.00Apr 22 - 25, 2025$3,750.00May 20 - 23, 2025$3,750.00Jun 17 - 20, 2025$3,750.00Jul 22 - 25, 2025$3,750.00
Oracle Training: Database Administration A to Z
The course Database Administration A to Z (Oracle Training) targets database management systems such as MySQL, Oracle, SQL Server, PostgreSQL. This course is designed to be a practical study into the management of a multi-platform database work environment. Though the focus will be on the Oracle platform, the content will be discussed in a platform generic way to allow practical application to SQL Server, MySQL and PostgreSQL environments. Part II of the course focusses on the components of a production environment that allow database professionals to excel in their mission critical responsibilities.
Training course titled Oracle Training: Database Administration A to Z that will allow you to hone your professional skills.
Jan 14 - 17, 2025$3,750.00Feb 11 - 14, 2025$3,750.00Mar 11 - 14, 2025$3,750.00Apr 15 - 18, 2025$3,750.00May 13 - 16, 2025$3,750.00Jun 10 - 13, 2025$3,750.00Jul 15 - 18, 2025$3,750.00
Oracle Training: MySQL Core Administration
The course MySQL Core Administration (Oracle Training) :: database course introduces the MySQL Relational Database Management System. Every aspect of MySQL database administration is covered from the creation of relational databases and their tables to the development of powerful SQL scripts to automate primary administrative tasks. This complete course discusses the various security mechanisms that are provided by the MySQL database engine. This course also includes coverage of performance optimization, backup and recovery and indexing amongst others. If you want to implement a MySQL database in your organization, this is the course for you.
Training course titled Oracle Training: MySQL Core Administration that will allow you to hone your professional skills.
Jan 21 - 24, 2025$3,750.00Feb 18 - 21, 2025$3,750.00Mar 18 - 21, 2025$3,750.00Apr 22 - 25, 2025$3,750.00May 20 - 23, 2025$3,750.00Jun 17 - 20, 2025$3,750.00Jul 22 - 25, 2025$3,750.00
Oracle Training: Oracle Core Administration
The course Oracle Core Administration (Oracle Training) is an exploration of the installation, configuration and maintenance of Oracle servers on Linux. The training includes an architecture overview, performance optimization through caching/tuning, backup & recovery and security. This comprehensive course discusses every aspect of Oracle database administration.
Training course titled Oracle Training: Oracle Core Administration that will allow you to hone your professional skills.
Jan 28 - 31, 2025$3,750.00Feb 25 - 28, 2025$3,750.00Mar 25 - 28, 2025$3,750.00Apr 29 - May 2, 2025$3,750.00May 27 - 30, 2025$3,750.00Jun 24 - 27, 2025$3,750.00Jul 29 - Aug 1, 2025$3,750.00
Oracle Training: Professional Database Tuning & Optimization
The course Professional Database Tuning & Optimization (Oracle Training) is a detailed exploration of Oracle database performance tuning and optimization. The training includes a discussion of the tools of the performance tuning trade and quickly proceeds to coverage of structural SQL optimization techniques and PL/SQL code optimization. The course covers database indexing and server & memory optimization techniques. Fine tune your Oracle database to make them lightning fast.
Training course titled Oracle Training: Professional Database Tuning & Optimization that will allow you to hone your professional skills.
Jan 21 - 24, 2025$3,750.00Feb 18 - 21, 2025$3,750.00Mar 18 - 21, 2025$3,750.00Apr 22 - 25, 2025$3,750.00May 20 - 23, 2025$3,750.00Jun 17 - 20, 2025$3,750.00Jul 22 - 25, 2025$3,750.00
Oracle Training: SQL for Data Definition & Extraction
The course SQL for Data Definition & Extraction (Oracle Training) targets database management systems such as MySQL, Oracle, SQL Server, PostgreSQL. This course is designed to be a practical study into the management of a multi-platform database work environment. Though the focus will be on the Oracle platform, the content will be discussed in a platform generic way to allow practical application to SQL Server, MySQL and PostgreSQL environments. Part I of the course focusses on the essentials of the SQL language as it is applied to a variety of database platforms. This course will provide you with a comprehensive overview of the SQL language as it is defined by the ANSI standard.
Training course titled Oracle Training: SQL for Data Definition & Extraction that will allow you to hone your professional skills.
Jan 7 - 10, 2025$3,750.00Feb 4 - 7, 2025$3,750.00Mar 4 - 7, 2025$3,750.00Apr 8 - 11, 2025$3,750.00May 6 - 9, 2025$3,750.00Jun 3 - 6, 2025$3,750.00Jul 8 - 11, 2025$3,750.00
PLSQL Training: Introduction to Data Design & Manipulation
The course Introduction to Data Design & Manipulation (PLSQL Training) is an introduction to PL/SQL programming. Beginning with the creation of database tables, the course presents a variety of PL/SQL language features in a logical and sequential order beginning with SQL syntax and ending with packages and functions. If you need to work with PL/SQL, this course will get you started in the right direction.
Training course titled PLSQL Training: Introduction to Data Design & Manipulation that will allow you to hone your professional skills.
Jan 15 - 17, 2025$3,350.00Feb 12 - 14, 2025$3,350.00Mar 12 - 14, 2025$3,350.00Apr 16 - 18, 2025$3,350.00May 14 - 16, 2025$3,350.00Jun 11 - 13, 2025$3,350.00Jul 16 - 18, 2025$3,350.00
PLSQL Training: Objects, Librairies, XML, Java & More
The course Objects, Libraries, XML, Java & More (PLSQL Training) covers the advanced elements of PL/SQL. Beginning with stored procedures & functions, the training discusses database triggers, PL/SQL records, PL/SQL collections, PL/SQL error handling & object oriented programming in PL/SQL. The course concludes with XML processing, Java integration and performance tuning & optimization in Oracle.
Training course titled PLSQL Training: Objects, Librairies, XML, Java & More that will allow you to hone your professional skills.
Jan 29 - 31, 2025$2,750.00Feb 26 - 28, 2025$2,750.00Mar 26 - 28, 2025$2,750.00Apr 30 - May 2, 2025$2,750.00May 28 - 30, 2025$2,750.00Jun 25 - 27, 2025$2,750.00Jul 30 - Aug 1, 2025$2,750.00
SQL Server Training: Core Administration Skills
The course Core Administration Skills (SQL Server Training) is an exploration of database administration with SQL Server. Every aspect of SQL Server database administration is covered from the creation of relational databases & tables to the development of powerful TSQL scripts to automate primary administrative tasks. The training includes SQL Server database security & monitoring , performance tuning, backup & recovery, security and indexing to name a few.
Training course titled SQL Server Training: Core Administration Skills that will allow you to hone your professional skills.
Jan 14 - 17, 2025$3,750.00Feb 11 - 14, 2025$3,750.00Mar 11 - 14, 2025$3,750.00Apr 15 - 18, 2025$3,750.00May 13 - 16, 2025$3,750.00Jun 10 - 13, 2025$3,750.00Jul 15 - 18, 2025$3,750.00