About this Professional Certificate
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.
What you'll 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.
| From | IBM via edX |
|---|---|
| Hours | 85 |
| Instructors | Rav Ahuja, Lin Joyner, Rose Malcolm, Ramesh Sannareddy, Yan Luo, Jeff Grossman |
| Language | English |
| Subjects | Data Science Programming |
Similar Courses
Sorted by relevance
Careers
An overview of related careers and their average salaries in the US. Bars indicate income percentile (33rd - 99th).
Warehouse Data Specialist $58k
Data Warehouse Marketing $81k
Specialist - Data Warehouse $87k
Data Warehouse Analyst 3 $107k
Data Warehouse Consultant $115k
Data Integration Engineer| Data Warehouse $116k
Data Warehouse Analyst 2 $121k
Data Warehouse - Architecture $147k
Data Warehouse Validation $152k
Data Architect Data Warehouse $167k
Data Warehouse Architect u2013 for Enterprise Data Warehouse $187k
Data Warehouse Development $249k
Courses in this Professional Certificate
Listed in the order in which they should be taken
| Starts | Course Information | |
|---|---|---|
|
On Demand |
SQL Concepts for Data Engineers Please Note: Learners who successfully complete this IBM course can earn a skill badge — a detailed, verifiable and digital credential that profiles the knowledge and skills... edX | IBM |
Save
|
|
On Demand |
Please Note: Learners who successfully complete this IBM course can earn a skill badge — a detailed, verifiable and digital credential that profiles the knowledge and skills... edX | IBM |
Save
|
|
On Demand |
Data Engineering Basics for Everyone Please Note: Learners who successfully complete this IBM course can earn a skill badge — a detailed, verifiable and digital credential that profiles the knowledge and skills... edX | IBM |
Save
|
|
On Demand |
Linux Commands & Shell Scripting This mini-course provides a practical introduction to commonly used Linux / UNIX shell commands and teaches you basics of Bash shell scripting to automate a variety of tasks. The... edX | IBM |
Save
|
|
On Demand |
Building ETL and Data Pipelines with Bash, Airflow and Kafka Well-designed and automated data pipelines and ETL processes are the foundation of a successful Business Intelligence platform. Defining your data workflows, pipelines and... edX | IBM |
Save
|
|
On Demand |
Relational Database Administration (DBA) Managing databases is a critical skill for Data Engineers and Database Administrators to ensure data is reliable, protected and easily accessible for organizations to make better... edX | IBM |
Save
|
|
On Demand |
Data Warehousing and BI Analytics Today’s businesses are investing significantly in capabilities to harness the massive amounts of data that fuel Business Intelligence (BI). Working knowledge of Data Warehouses... edX | IBM |
Save
|
&
| From | IBM via edX |
|---|---|
| Hours | 85 |
| Instructors | Rav Ahuja, Lin Joyner, Rose Malcolm, Ramesh Sannareddy, Yan Luo, Jeff Grossman |
| Language | English |
| Subjects | Data Science Programming |
Careers
An overview of related careers and their average salaries in the US. Bars indicate income percentile (33rd - 99th).
Warehouse Data Specialist $58k
Data Warehouse Marketing $81k
Specialist - Data Warehouse $87k
Data Warehouse Analyst 3 $107k
Data Warehouse Consultant $115k
Data Integration Engineer| Data Warehouse $116k
Data Warehouse Analyst 2 $121k
Data Warehouse - Architecture $147k
Data Warehouse Validation $152k
Data Architect Data Warehouse $167k
Data Warehouse Architect u2013 for Enterprise Data Warehouse $187k
Data Warehouse Development $249k
Similar Courses
Sorted by relevance
