Skip to main content

Drive your career forward

Professional Certificate in
Data Warehouse Engineering
IBM

What you will learn

  • Create shell scripts using common Linux/UNIX shell commands.
  • Describe relational database concepts, create a relational database on cloud, execute SQL statements, and access databases using SQL.
  • Build batch and streaming ETL and ELT Data Pipelines using Bash, Apache Airflow and Kafka.
  • Design, model, and implement a data warehouse and analyze its data using Business Intelligence tools like IBM Cognos.

Data Warehouse Engineers and Business Analysts are in high demand as organizations become increasingly dependent on data to support their operations.

Data warehousing has transformed the way organizations perform business analysis and make strategic decisions. Massive amounts of data from multiple sources can be easily accessed using SQL and formatted for analysis, reporting and Business Intelligence for organizations to gain deeper business insights.

The Data Warehouse Engineer Professional Certificate provides you the skills and knowledge to design, deploy and manage Enterprise Data Warehouses (EDW) and utilize Business Intelligence tools to analyze and extract insights using reports and dashboards.

Upon completing this program, you’ll gain practical experience to work with Relational Database Management Systems (RDBMS), query data using SQL statements, utilize Linux/UNIX shell scripts to automate repetitive tasks, and build data pipelines using Apache Airflow and Kafka to Extract, Transform and Load (ETL) data. You’ll also acquire the skills to build and operationalize Data Warehouses and conduct data analysis.

Within each course you’ll practice your skills with numerous hands-on labs and multiple projects to add to your portfolio for launching your career.

To get started, all you need is basic computer literacy and the desire to learn and practice new skills.

Expert instruction
8 skill-building courses
Self-paced
Progress at your own speed
9 months
3 - 4 hours per week
$722
USD
For the full program experience

Courses in this program

  1. IBM's Data Warehouse Engineering Professional Certificate

  2. 9–10 hours per week, for 4 weeks

    Learn about data engineering concepts, ecosystem, and lifecycle. Also learn about the systems, processes, and tools you need as a Data Engineer in order to gather, transform, load, process, query, and manage data so that it can be leveraged by data consumers for operations, and decision-making.

  3. 2–3 hours per week, for 4 weeks

    This course teaches you the fundamental concepts of relational databases and Relational Database Management Systems (RDBMS) such as MySQL, PostgreSQL, and IBM Db2.

  4. 2–4 hours per week, for 5 weeks

    Learn how to use and apply the powerful language of SQL to better communicate and extract data from databases - a must for anyone working in Data Engineering, Data Analytics or Data Science.

  5. 4–5 hours per week, for 1 weeks

    In this short course you will learn additional SQL concepts such as views, stored procedures, transactions and joins.

  6. 3–4 hours per week, for 1 weeks

    This mini-course describes shell commands and how to use the advanced features of the Bash shell to automate complicated database tasks. For those not familiar with shell scripting, this course provides an overview of common Linux Shell Commands and shell scripting basics.

  7. 2–3 hours per week, for 8 weeks

    This course helps you develop the foundational skills required to perform the role of a Database Administrator (DBA) including designing, implementing, securing, maintaining, troubleshooting and automating databases such as MySQL, PostgreSQL and Db2.

  8. 2–4 hours per week, for 5 weeks

    This course provides you with practical skills to build and manage data pipelines and Extract, Transform, Load (ETL) processes using shell scripts, Airflow and Kafka.

  9. 2–3 hours per week, for 6 weeks

    This course introduces you to designing, implementing and populating a data warehouse and analyzing its data using SQL & Business Intelligence (BI) tools.

    • Average annual salary for a Data Warehouse Engineer in the U.S. is $103,000 according to Glassdoor.
    • According to salary.com the median salary for a Data Warehouse Specialist in the US is $110,168.
    • Research and Markets estimates the global market for the data warehouse as a service (DWaaS) is estimated to grow at a compound annual growth rate (CAGR) of 21.7% through 2026.

Meet your instructors
from IBM

Rav Ahuja
Global Program Director
IBM Skills Network
Jeff Grossman
Data Science and Engineering SME
Skillup Technologies
Ramesh Sannareddy
Content Developer
Skillup
Lin Joyner
Senior Instructional Designer & Content Developer
Skill-Up Technologies
Rose Malcolm
Senior Instructional Designer & Content Developer
Skill-Up Technologies
Yan Luo
Ph.D., Data Scientist and Developer
IBM

Experts from IBM committed to teaching online learning

Enrolling Now

$722
USD
8 courses in 9 months
Pursue the Program

Propelling

Drive your career forward with university-backed credit programs and verified certificates

Convenient

Study and demonstrate knowledge on your schedule

Flexible

Try a course before you pay

Supportive

Learn with university partners and peers from around the world