Data Transformation and Organization: Data Warehouses, Data Marts, and ETL

Industry-Specific
Digital Skills

Schedule

Duration

40 hours

PRESENTATION

In a context marked by the digitization and data analysis, our course provides an essential foundation for understanding and managing enterprise information architecture. We will delve into ETL processes—which are vital for data transformation and transfer—and into the effective organization of data, exploring different types of databases, including both relational and NoSQL databases. We will explore data organization models and techniques for database optimization, preparing participants to tackle current challenges in any sector. In addition, the section on data warehouses and data marts will provide an understanding of how they work and how to leverage the stored data, including an examination of leading platforms such as Amazon RedShift. This course Data Transformation and Organization: Data Warehouses, Data Marts, and Comprehensive ETL It is an essential step for those who want to stay up to date with the demands of managing large volumes of information and turning that information into strategic decisions, without the pressure of becoming a specialist Overnight.

Objectives

  • Understanding the Logic ETL and its key use.

  • Drive data using current ETL tools.

  • Discover Data warehouse and data marts.

  • Explore Database relational and NoSQL.

  • Learn about columnar databases and optimization.

  • Design and analyze data in Data Marts.

  • Evaluate Inmon and Kimball in DWH.

Syllabus

TEACHING UNIT 1. ETL PROCESSES Introduction to ETL ETL Tools Elements of the ETL Process Microsoft SSIS ETL Comparison of Tools TEACHING UNIT 2. DATA ORGANIZATION (I) Introduction to and Evolution of Data Relational Databases (I) Relational Databases (II) NoSQL Databases SQL vs. NoSQL Comparison TEACHING UNIT 3. DATA ORGANIZATION (II) Data Organization Models Columnar Databases Database Optimization (I) Database Optimization (II) Designing Relational Databases TEACHING UNIT 4. DATA WAREHOUSES AND DATA MARTS Data Warehouses Inmon vs. Kimbal Analyzing Data Warehouse Data Data Marts Amazon Redshift
Request for Information

Related MOOCs

Course
The Course on Workplace Risk Prevention, Ergonomics, and Mental Health addresses the growing need to ensure environments...
Course
In the age of remote work, hyperconnectivity has put companies under the scrutiny of the Labor Inspectorate....
Course
In a world of global digitization, hyperconnectivity has gone from being an advantage to becoming a challenge...

Are the Educa PHAROS courses eligible for credit?

Many courses can be credited toward the master's programs at Structuralia.

Facts about our area

+ 1.483

Hours

+88.999

Minutes

264

Courses

Educa PHAROS is a next-generation training model that places a company’s human capital at the forefront. Through a platform that adapts to each company’s corporate identity and offers a total of more than 900 courses, it provides tailored training for each organization. The unlimited flat-rate plan provides each company with the number of courses that best suits its needs, as well as the ability to determine which employees will have access.
Scroll to Top
Privacy Overview

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.