Career Academy

Professional Diploma in IBM Data Warehouse Engineer

 

This Professional Diploma 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).

 

Skills you will gain: Relational Database, Business Intelligence, Enterprise Data Warehouse, SQL, Extract Transform Load, Data Science, Database, NoSQL, Database Design

 

A Programme Offered by

IBM

Starts On
Duration 4 months
Fees

About this Professional Diploma

 

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.

Programme Highlights

When you subscribed to this programme, you will get

Videos

187 Videos

Readings

55 Reading Articles

Quizzez

155 Quizzes

Challenge

3 Assignments,    3 Exams

Programme Modules

 

Module 1: Introduction to Data Engineering

(What is Data Engineering?, The Data Engineering Ecosystem, Data Engineering Lifecycle, Career Opportunities and Data Engineering in Action)

 

Module 2: Introduction to Relational Databases (RDBMS)

(Relational Database Concepts, Using Relational Databases, MySQL and PostgreSQL, Course Assignment)

 

Module 3: Databases and SQL for Data Science with Python

(Getting Started with SQL, Introduction to Relational Databases and Tables, Intermediate SQL, Accessing Databases using Python, Course Assignment, Bonus Module: Advanced SQL for Data Engineering (Honors))

 

Module 4: Hands-on Introduction to Linux Commands and Shell Scripting

(Introduction to Linux, Introduction to Linux Commands, Introduction to Shell Scripting, Final Project and Final Exam)

 

Module 5: Relational Database Administration (DBA)

(Introduction to Database Management, Managing Databases, Monitoring and Optimization, Troubleshooting & Automation, Final Assignment and Final Exam)

 

Module 6: ETL and Data Pipelines with Shell, Airflow and Kafka

(Data Processing Techniques, ETL & Data Pipelines: Tools and Techniques, Building Data Pipelines using Airflow, Building Streaming Pipelines using Kafka, Final Assignment)

 

Module 7: Getting Started with Data Warehousing and BI Analytics

(Data Warehouses, Data Marts, and Data Lakes, Designing, Modeling and Implementing Data Warehouses, Data Warehouse Analytics, Final Assignment and Final Quiz)

Why Enroll for IBM Data Warehouse Engineer?

 

  • 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
Why Enrol on the Programme (1)

$102,400

median entry-level salary¹

¹Burning Glass Labor Insight Report data (median with 0-2 years experience), United States, 4/1/21-3/31/22.

56,727

in-demand job openings in data science¹

 

Certificate

Upon successful completion of IBM Data Warehouse Engineer, participants will be awarded a verified

i) Professional Diploma in Data Warehouse Engineer by Mantissa College Career Academy

ii) Digital certificate by IBM

Sample Certificate