Skip to main content

Courses

Below you can consult different courses, and their contents, for which I provide training, with the accumulated experience of more than ten years dedicated mainly to training and almost thirty years in various heterogeneous activities.

Databases

Oracle BI 12c: Creating Repositories

This course focuses on creating the OBI 12c repository (modeling source data so that the tool can generate reports).

Oracle Data Integrator 12c

This course focuses on installing and using the core features of Oracle Data Integrator 12c.

PL/SQL

This course is focused on the installation and use of the main functionalities of PL/SQL

Business Intelligence and Data Analytics

Pentaho (Community Edition)

This course focuses on the use of Pentaho components to perform data transformation processes, data source modeling and data visualization using classic reports, on-demand reports and dashboards.

Oracle Analytics Server: Analytics and P.C.

This course focuses on creating reports (analysis) and dashboards in Oracle Analytics Server

Pentaho Data Integration – Kettle (CE)

This course focuses on using Pentaho’s ETL component: Pentaho Data Integration.

QlikView: Designer

This course focuses on the basic analysis part of the QlikView tool.

Tableau

This course focuses on the analysis part of the Tableau tool.

PowerBI – Data Analytics Sheet Design

This course is focused on the installation and use of the main functionalities of PowerBi

Data Visualization and Storytelling (with Power BI and Tableau)

This course is focused on the installation and use of the main functionalities of Power BI and Tableau

Operating systems

Linux Operating System Administration (Basic)

This course is focused on the installation and use of the main functionalities of Linux

Development

Advanced SQL

This course develops advanced SQL methods both with database functions (views and indexes) and specific syntax (analytics, advanced groupings, hierarchical tables, etc.).

Basic SQL (MySQL)

This course is focused on the installation and use of the main functionalities of MySQL

SQL Optimization

This course is focused on SQL optimization

SQL (Oracle)

The course is aimed at creating queries in SQL language in an Oracle environment (19c).

© Juan de Juan.