Will I earn university credit for completing the Specialization?

No academic credit is available for these courses at this time.

What will I be able to do upon completing the Specialization?

You will have developed hands-on skills for an entry-level Data Warehousing role including the ability to work with relational databases, perform SQL queries, create data pipelines, design and load data warehouses, and prepare interactive dashboards.

Is this course really 100% online? Do I need to attend any classes in person?

This course is completely online, so there’s no need to show up to a classroom in person. You can access your lectures, readings and assignments anytime and anywhere via the web or your mobile device.

Can I just enroll in a single course?

Yes! To get started, click the course card that interests you and enroll. You can enroll and complete the course to earn a shareable certificate. When you subscribe to a course that is part of a Certificate, you’re automatically subscribed to the full Certificate. Visit your learner dashboard to track your progress.

IBM Data Warehouse Engineer Professional Certificate

IBM Data Warehouse Engineer Professional Certificate

Kickstart your Career in BI Engineering. Develop job-ready skills for an entry level role in Data Warehousing.

Instructors: IBM Skills Network Team

Included with Coursera Plus

Learn more

9 course series

Earn a career credential that demonstrates your expertise

4.7

(826 reviews)

Beginner level

Recommended experience

4 months at 10 hours a week

Flexible schedule

Earn a career credential

Share your expertise with employers

9 course series

Earn a career credential that demonstrates your expertise

4.7

(826 reviews)

Beginner level

Recommended experience

4 months at 10 hours a week

Flexible schedule

Earn a career credential

Share your expertise with employers

What you'll learn

Compose and execute various types of SQL statements and queries to access and manipulate data in databases
Deploy, Manage, Secure, Operationalize, Monitor and Optimize relational database systems like MySQL, PostgreSQL, and DB2
Create Data Pipelines to extract, transform and load data repositories using shell scripts, and tools such as Apache Airflow & Kafka
Design and populate Data Warehouses and analyze their data with Business Intelligence (BI) tools like Cognos Analytics

Overview

This Professional Certificate is intended to help you develop the job-ready skills and portfolio for an entry-level Business Intelligence (BI) or Data Warehousing Engineering position. Throughout the online courses in this program, you will immerse yourself in the in-demand role of a Data Warehouse Engineer and acquire the essential skills you need to work with a range of tools and databases to design, deploy, operationalize and manage Enterprise Data Warehouses (EDW).

By the end of this Professional Certificate, 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 statements.

You will use Linux/UNIX shell scripts to automate repetitive tasks, and build data pipelines with tools like Apache Airflow and Kafka to Extract, Transform and Load (ETL) data. You will gain experience with managing databases and data warehouses.

Finally, you will design and populate data warehouse systems and utilize Business Intelligence tools to analyze and extract insights using reports and dashboards.

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

What’s included

Shareable certificate

Add to your LinkedIn profile

Taught in English

100 practice exercises

Professional Certificate - 9 course series

Each course includes numerous hands-on labs and a project to hone and apply the concepts and skills you learn. By the end of the program, you will have designed, implemented, configured, queried, and maintained numerous databases and created data pipelines using real-world tools and data repositories to build a portfolio of job-ready skills.

You will start by provisioning a database instance on Cloud. Next, you will design databases using Entity-Relationship Diagrams (ERD) and create database objects like tables and keys using MySQL, PostgreSQL and IBM Db2.

You will then become proficient with querying databases with SQL using SELECT, INSERT, UPDATE and DELETE statements, and learn to filter, sort & aggregate result sets. Next, you will become familiar with common Linux/Unix shell commands and use them to build Bash scripts.

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

Introduction to Data Engineering

Course 113 hours4.7 (3,424 ratings)View course

What you'll learn

List basic skills required for an entry-level data engineering role.
Discuss various 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 in data security, governance, and compliance.

Skills you'll gain

Data Pipelines, Data Warehousing, Extract, Transform, Load, Data Architecture, Data Security, Apache Spark, NoSQL, Data Governance, Big Data, SQL, Data Store, Relational Databases, Data Lakes, Data Science, Databases, and Apache Hadoop

Introduction to Relational Databases (RDBMS)

Course 215 hours4.6 (747 ratings)View course

What you'll learn

Describe data, databases, relational databases, and cloud databases.
Describe information and data models, relational databases, and relational model concepts (including schemas and tables).
Explain an Entity Relationship Diagram and design a relational database for a specific use case.
Develop a working knowledge of popular DBMSes including MySQL, PostgreSQL, and IBM DB2

Skills you'll gain

Relational Databases, Database Design, SQL, PostgreSQL, MySQL, Data Manipulation, Database Architecture and Administration, Data Management, IBM DB2, Data Integrity, Database Management Systems, Data Modeling, Databases, and Command-Line Interface

SQL: A Practical Introduction for Querying Databases

Course 320 hours4.7 (645 ratings)View course

What you'll learn

Analyze data within a database using SQL.
Create a relational database on Cloud and work with tables.
Write SQL statements including SELECT, INSERT, UPDATE, and DELETE.
Build more powerful queries with advanced SQL techniques like views, transactions, stored procedures and joins.

Skills you'll gain

SQL, Stored Procedure, Transaction Processing, Data Manipulation, Data Analysis, Relational Databases, Database Systems, MySQL, Query Languages, IBM DB2, Databases, Database Management, and Microsoft SQL Servers

Hands-on Introduction to Linux Commands and Shell Scripting

Course 414 hours4.6 (1,653 ratings)View course

What you'll learn

Describe the Linux architecture and common Linux distributions and update and install software on a Linux system.
Perform common informational, file, content, navigational, compression, and networking commands in Bash shell.
Develop shell scripts using Linux commands, environment variables, pipes, and filters.
Schedule cron jobs in Linux with crontab and explain the cron syntax.

Skills you'll gain

Linux Commands, Shell Script, Linux, File Management, Unix, Scripting, Unix Commands, Linux Servers, Scripting Languages, Automation, Operating Systems, Bash (Scripting Language), Command-Line Interface, Network Protocols, Software Installation, and Ubuntu

Relational Database Administration (DBA)

Course 521 hours4.5 (251 ratings)View course

What you'll learn

Create, query, and configure databases and access and build system objects such as tables.
Perform basic database management including backing up and restoring databases as well as managing user roles and permissions.
Monitor and optimize important aspects of database performance.
Troubleshoot database issues such as connectivity, login, and configuration and automate functions such as reports, notifications, and alerts.

Skills you'll gain

Database Management, Database Architecture and Administration, MySQL, Disaster Recovery, Relational Databases, Database Systems, Database Design, Encryption, Database Administration, Data Storage Technologies, Operational Databases, System Monitoring, PostgreSQL, User Accounts, IBM DB2, Performance Tuning, and Role-Based Access Control (RBAC)

ETL and Data Pipelines with Shell, Airflow and Kafka

Course 617 hours4.5 (431 ratings)View course

What you'll learn

Describe and contrast Extract, Transform, Load (ETL) processes and Extract, Load, Transform (ELT) processes.
Explain batch vs concurrent modes of execution.
Implement ETL workflow through bash and Python functions.
Describe data pipeline components, processes, tools, and technologies.

Skills you'll gain

Data Pipelines, Extract, Transform, Load, Apache Airflow, Apache Kafka, Shell Script, Data Mart, Data Migration, Data Processing, Data Transformation, Performance Tuning, Scalability, Command-Line Interface, Web Scraping, Data Warehousing, Data Integration, Big Data, and Unix Shell

Data Warehouse Fundamentals

Course 715 hours4.5 (242 ratings)View course

What you'll learn

Job-ready data warehousing skills in just 6 weeks, supported by practical experience and an IBM credential.
Design and populate a data warehouse, and model and query data using CUBE, ROLLUP, and materialized views.
Identify popular data analytics and business intelligence tools and vendors and create data visualizations using IBM Cognos Analytics.
How to design and load data into a data warehouse, write aggregation queries, create materialized query tables, and create an analytics dashboard.

Skills you'll gain

Data Warehousing, Snowflake Schema, Data Mart, Data Lakes, Star Schema, IBM DB2, SQL, Query Languages, PostgreSQL, Database Systems, Data Quality, Database Design, Data Modeling, Data Cleansing, Data Validation, Data Architecture, Extract, Transform, Load, and Data Integration

BI Dashboards with IBM Cognos Analytics and Google Looker

Course 811 hours4.6 (33 ratings)View course

What you'll learn

Explore the purpose of analytics and Business Intelligence (BI) tools
Discover the capabilities of IBM Cognos Analytics and Google Looker Studio
Showcase your proficiency in analyzing DB2 data with IBM Cognos Analytics
Create and share interactive dashboards using IBM Cognos Analytics and Google Looker Studio

Skills you'll gain

Looker (Software), Data Visualization Software, IBM Cognos Analytics, Dashboard, Interactive Data Visualization, Business Intelligence Software, Analytics, Business Intelligence, Data Presentation, and Data Visualization

Data Warehousing Capstone Project

Course 914 hours4.8 (22 ratings)View course

What you'll learn

Demonstrate proficiency in skills required for an entry-level data warehouse engineering role.
Design and implement various concepts and components in the data warehouse engineering lifecycle such as data repositories.
Showcase working knowledge with relational databases, data warehouses, and data pipelines.
You can use your expertise in Linux shell scripting, SQL, and business intelligence Cognos dashboard design, to tackle data warehousing problems.

Skills you'll gain

Database Design, SQL, Data Warehousing, MySQL, Extract, Transform, Load, Dashboard, PostgreSQL, Data Modeling, Star Schema, Data Pipelines, Data Architecture, Statistical Reporting, IBM Cognos Analytics, Data Mart, IT Automation, and Data Transformation