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.
Courses in this program
IBM's Data Warehouse Engineering Professional Certificate
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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