Online Course – IBM Certified Professional Certificate in Data Warehouse Engineering

Start your career in BI engineering. Develop job-ready skills for an entry-level role in data warehousing.

Suggested by: Coursera (What is Coursera?)

Start your Coursera.com free trial today
קורס אונליין - תעודה מקצועית מוסמכת במהנדסת מחסני נתונים של IBM

Professional Certificate

Beginners

No prior knowledge required

Time to complete the course

7-day free trial

No unnecessary risks

Skills you will acquire in the course

  • Developing work skills in the field of information systems engineering (BI) and data warehouse engineering
  • Working with relational database management systems (RDBMS)
  • Querying data using SQL commands
  • Automate tasks using Linux/UNIX shell scripts
  • Building data pipelines with Apache Airflow and Kafka
  • Experience managing databases and data warehouses
  • Design and populate data warehouse systems
  • Using BI tools for analysis and insight generation
  • Design, implementation, configuration, querying, and maintenance of databases
  • Creating real-world data pipelines
  • Database design using entity-relationship diagrams (ERD)
  • Creating database objects such as tables and keys
  • Querying databases with SELECT, INSERT, UPDATE, and DELETE commands
  • Filtering, sorting, and summarizing result sets
  • Knowledge of common Linux/Unix commands and building scripts in Bash
  • Creating dashboards for BI

What you will learn in the course

Courses for which the course is suitable

  • Information Systems Engineer (BI)
  • Data Warehouse Engineer
  • Data Analyst
  • SQL key
  • Database Administrator
  • ETL Specialist
  • Data Pipeline Developer
  • Business Analyst
  • BI developer
  • Linux/Unix programmer

Professional Certificate – 9 Course Series

This professional certificate is designed to help you develop the work skills and portfolio required for a position in Information Systems Engineering (BI) or Data Warehouse Engineering. Through the online courses in this program, you will specialize in the role in question and acquire the foundational skills needed to work with a variety of tools and databases to design, deploy, and manage enterprise data warehouses (EDW).

By the end of the program, you will be able to perform the key tasks required in a data warehouse engineering role. You will work with relational database management systems (RDBMS) and query data using SQL commands.

You will use Linux/UNIX shell scripts to automate repetitive tasks, and build data pipelines with tools like Apache Airflow and Kafka to extract, transport, and load (ETL) data. You will gain experience in database management and data warehousing.

Finally, you will design and populate data warehouse systems and use BI tools to analyze and generate insights through reports and dashboards.

This program is suitable for anyone with a passion for learning, and is suitable whether or not you have a college degree, and does not require prior experience in data engineering or programming.

Hands-on Learning Project

Each course includes extensive labs and project work to hone and apply the concepts and skills you learn. By the end of the program, you will be able to design, implement, configure, query, and maintain multiple databases and create data pipelines using real-world tools and repositories to build a portfolio of job-ready skills.

You’ll start by setting up a database instance in the cloud. Then, you’ll design databases using entity-relationship diagrams (ERDs) and create database objects such as tables and keys using MySQL, PostgreSQL, and IBM Db2.

Later, you will become proficient in querying databases using SQL using SELECT, INSERT, UPDATE, and DELETE commands, and you will learn to filter, sort, and summarize result sets. Then, you will become familiar with common Linux/Unix commands and use them to build scripts in Bash.

You will create data pipelines for batch and streaming ETL jobs using Apache Airflow and Kafka. Finally, you will implement data warehouses and create dashboards for BI.

Details of the courses that make up the specialization

Introduction to Data Engineering

Course 1

  • 12 hours
  • 4.7 (2,623 ratings)

Course Details

What you’ll learn

  • Understand the basic skills required for an entry-level data engineering role.
  • You will discuss different stages and concepts in the data engineering lifecycle.
  • Describe data engineering technologies such as relational databases, NoSQL data stores, and big data engines.
  • Summarize concepts related to data security, government, and compliance.

Skills you will gain

  • Category: Shell Script
  • Category: Bash (Unix Shell)
  • Category: Extract, Transform, and Load (ETL)
  • Category: Linux
  • Category: Linux commands

Introduction to Relational Databases (RDBMS)

Course 2

  • 15 hours
  • 4.6 (568 ratings)

Course Details

What you’ll learn

  • Describe data, databases, relational databases, and cloud databases.
  • You will understand information and data models, relational databases, and concepts in relational models (including schemas and tables).
  • You will explain an entity relationship diagram and design a relational database for a specific use case.
  • You will develop basic knowledge of popular database management systems such as MySQL, PostgreSQL, and IBM DB2.

Skills you will gain

  • Category: Extract, Transform, and Load (ETL)
  • Category: Data Engineer
  • Category: Apache Kafka
  • Category: Apache Airflow
  • Category: Data Pipes

SQL: A Practical Introduction to Querying Databases

Course 3

  • 21 hours
  • 4.7 (364 ratings)

Course Details

What you’ll learn

  • Analyze data within a database using SQL.
  • You will create a relational database in the cloud and work with tables.
  • Write SQL commands including SELECT, INSERT, UPDATE, and DELETE.
  • Build more powerful queries with advanced SQL techniques like views, transactions, stored procedures, and joins.

Skills you will gain

  • Category: Extract, Transform, and Load (ETL)
  • Category: Data warehouses
  • Category: OLTP databases
  • Category: Relational databases
  • Category: Data Pipes

A practical introduction to Linux commands and shell scripting

Course 4

  • 14 hours
  • 4.6 (1,253 ratings)

Course Details

What you’ll learn

  • Describe the architecture of Linux and common Linux distributions, and update and install software on a Linux system.
  • Execute common commands in information, files, content, navigation, compression, and networking in the Bash shell.
  • Develop shell scripts using Linux commands, environment variables, pipes, and filters.
  • You will schedule cron tasks in Linux with crontab and explain the cron syntax.

Skills you will gain

  • Category: Database Security
  • Category: Database Management System (DBMS)
  • Category: Database Servers
  • Category: Database Management

Relational Database Administration (DBA)

Course 5

  • 21 hours
  • 4.4 (196 ratings)

Course Details

What you’ll learn

  • You will create, query, and deploy databases and build objects in the system such as tables.
  • You will perform basic database management including backup and recovery, as well as managing user roles and permissions.
  • You will synchronize and improve important aspects of database performance.
  • You will solve database system problems such as connection, login, configuration, and implement functions such as reports, alerts, and assurance.

Skills you will gain

  • Category: Data Science
  • Category: Database Management System (DBMS)
  • Category: Information Engineering
  • Category: SQL
  • Category: NoSQL

ETL and data pipelines with Shell, Airflow, and Kafka

Course 6

  • 17 hours
  • 4.5 (335 ratings)

Course Details

What you’ll learn

  • Describe and compare extract, transform, and load (ETL) processes with extract, load, and transform (ELT) processes.
  • Explain the models of hitting against a parallel execution mode.
  • Implement the ETL process using Bash and Python functions.
  • Describe data pipeline components, processes, tools, and technologies.

Skills you will gain

  • Category: Business Intelligence
  • Category: Data visualization
  • Category: IBM Cognos Analytics
  • Category: Google Looker Studio
  • Category: Dashboards

Data Warehouse Fundamentals

Course 7

  • 15 hours
  • 4.4 (173 ratings)

Course Details

What you’ll learn

  • Job-ready data warehouse skills in 6 weeks, supported by hands-on experiences and IBM certification.
  • You will design and populate a data warehouse, and how to model and query data using CUBE, ROLLUP, and structured charts.
  • You will identify popular tools and vendors for data analysis and business intelligence and create data visualizations using IBM Cognos Analytics.
  • How to design and load data into a data warehouse, write aggregation queries, create functional query tables, and create an analytical dashboard.

Skills you will gain

  • Category: Database Design (DB)
  • Category: PostgreSQL
  • Category: Relational Database Management System (RDBMS)
  • Category: Database Architecture
  • Category: MySQL

BI dashboards with IBM Cognos Analytics and Google Looker

Course 8

  • 11 hours

Course Details

What you’ll learn

  • You will discover the purpose of analytics and business intelligence (BI) tools.
  • Discover the capabilities of IBM Cognos Analytics and Google Looker Studio.
  • You will demonstrate your proficiency in analyzing DB2 data using IBM Cognos Analytics.
  • Create and share interactive dashboards using IBM Cognos Analytics and Google Looker Studio.

Skills you will gain

  • Category: Dice
  • Category: Data warehouses
  • Category: Snowflake Schemas
  • Category: Data pools
  • Category: Rollups
  • Category: Data Marts
  • Category: Star Schemas

Capstone Project in Data Warehousing

Course 9

  • 13 hours
  • 4.9 (11 ratings)

Course Details

What you’ll learn

  • You will demonstrate proficiency in the skills required for an entry-level data warehouse engineering role.
  • You will design and implement various concepts and components in the data warehouse engineering lifecycle such as databases.
  • You will demonstrate practical knowledge with relational databases, data warehouses, and data pipelines.
  • You will use your expertise in Linux shell scripting, SQL, and designing interactive Cognos dashboards to tackle data warehouse problems.

Skills you will gain

  • Category: Data Analysis
  • Category: Relational Database Management System (RDBMS)
  • Category: SQL
  • Category: Create, Read, Update, and Delete
  • Category: MySQL

Related products