In this course you will apply a variety of data warehouse engineering skills and techniques you have learned as part of the previous courses in the IBM Data Warehouse Engineer Professional Certificate. You will assume the role of a Junior Data Engineer who has recently joined the organization and be presented with a real-world use case that requires a data warehouse engineering solution.
In this module, you will design a data platform that uses MySQL as an OLTP database. You will be using MySQL to store the OLTP data.
In this module you will design and implement a data warehouse and you will then generate reports from the data in the data warehouse.
In this module, you will assume the role of a data engineer at an e-commerce company. Your company has finished setting up a data warehouse. Now you are assigned the responsibility to design a reporting dashboard that reflects the key metrics of the business.
In this module, you will set up an ETL process using a Shell script to extract new transactional data for each day from the MySQL database and load it into the staging data warehouse in PostgreSQL. Later you will perform the transformation on the table in the staging warehouse to load the data in a…
In this final module, you will submit the outcomes from your hands-on labs for evaluation. Your submission will be assessed either by an AI-based evaluation tool or through a peer-graded assessment,
Some points apply to every course of this kind; see how we rank.
IBM is in Tier 2: excellent universities and the companies that build the technology of our institution ranking (84/100).
Instructor: Dennis Freeman, Kendra Pugh This course provides an integrated introduction to electrical engineering and computer science, including modern software engineering, linear systems analysis, electronic circuits, and decision-making. The lecture videos provide an overview of each topic, whi…
Harvard University
Focusing on the basics of machine learning and embedded systems, such as smartphones, this course will introduce you to the “language” of TinyML.
Harvard University
Learn the concepts and techniques that make up the foundation of data science and machine learning.
Harvard University
An introduction to the intellectual enterprises of computer science and the art of programming.
Harvard University
Build a movie recommendation system and learn the science behind one of the most popular and successful data science techniques.
Harvard University
An introduction to programming using Python, a popular language for general-purpose programming, data science, web programming, and more.
