Skip to main content
Program Subscription

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.

A program subscription gives you full verified access to all courses and materials within the program you’ve enrolled in, for as long as your subscription is active. Monthly subscription pricing can help you manage your enrollment costs — instead of paying more up front, you pay a smaller amount per month for only as long as you need access. You can cancel your subscription at any time for no additional fee.

Expert instruction
8 skill-building courses
Self-paced
Progress at your own speed
9 months
3 - 4 hours per week
$39/month
USD
After 7-day free trial

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

Experts from IBM committed to teaching online learning

Grow your career. Start your program subscription today.

$39/month USD

After a 7-day full access free trial. Cancel at any time.
This program subscription includes:
  • Immediate access to all 8 courses in this program
  • Course videos, lectures, and readings
  • Practice problems and assessments
  • Graded assignments and exams
  • edX learner support
  • Shareable verified certificates after successfully completing a course or program
Enroll now
Learn morein a new tab
about program subscriptions.

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