IBM
IBM Data Warehouse Engineer Professional Certificate
IBM

IBM Data Warehouse Engineer Professional Certificate

Kickstart your Career in BI Engineering. Develop job-ready skills for an entry level role in Data Warehousing.

Taught in English

Some content may not be translated

IBM Skills Network Team
Shubhra Das
Rav Ahuja

Instructors: IBM Skills Network Team

Included with Coursera Plus

Professional Certificate - 9 course series

Earn a career credential that demonstrates your expertise

4.7

(584 reviews)

Beginner level

Recommended experience

3 months at 10 hours a week
Flexible schedule
Learn at your own pace

What you'll learn

  • 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

Details to know

Shareable certificate

Add to your LinkedIn profile

Recently updated!

June 2024

Professional Certificate - 9 course series

Earn a career credential that demonstrates your expertise

4.7

(584 reviews)

Beginner level

Recommended experience

3 months at 10 hours a week
Flexible schedule
Learn at your own pace

See how employees at top companies are mastering in-demand skills

Placeholder

Advance your career with in-demand skills

  • Receive professional-level training from IBM
  • Demonstrate your technical proficiency
  • Earn an employer-recognized certificate from IBM
Placeholder
$76,000+
median U.S. salary for Data Warehousing
¹
33,000+
U.S. job openings in Data Warehousing
¹

Get exclusive access to career resources upon completion

  • Resume review

    Improve your resume and LinkedIn with personalized feedback

  • Interview prep

    Practice your skills with interactive tools and mock interviews

  • Career support

    Plan your career move with Coursera's job search guide

¹Lightcast™ Job Postings Report, United States, 7/1/22-6/30/23. ²Based on program graduate survey responses, United States 2021.

Placeholder

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

Placeholder

Professional Certificate - 9 course series

Introduction to Data Engineering

Course 112 hours4.7 (2,469 ratings)

What you'll learn

  • List basic skills required for an entry-level data engineering role.

  • Discuss various stages and concepts in the data engineering lifecycle.

  • Describe data engineering technologies such as Relational Databases, NoSQL Data Stores, and Big Data Engines.

  • Summarize concepts in data security, governance, and compliance.

Skills you'll gain

Category: Shell Script
Category: Bash (Unix Shell)
Category: Extract Transform and Load (ETL)
Category: Linux
Category: Linux Commands

Introduction to Relational Databases (RDBMS)

Course 215 hours4.6 (536 ratings)

What you'll learn

  • Describe data, databases, relational databases, and cloud databases.

  • Describe information and data models, relational databases, and relational model concepts (including schemas and tables). 

  • Explain an Entity Relationship Diagram and design a relational database for a specific use case.

  • Develop a working knowledge of popular DBMSes including MySQL, PostgreSQL, and IBM DB2

Skills you'll gain

Category: Extract Transform and Load (ETL)
Category: Data Engineer
Category: Apache Kafka
Category: Apache Airflow
Category: Data Pipelines

SQL: A Practical Introduction for Querying Databases

Course 321 hours4.6 (290 ratings)

What you'll learn

  • Analyze data within a database using SQL.

  • Create a relational database on Cloud and work with tables.

  • Write SQL statements including SELECT, INSERT, UPDATE, and DELETE.

  • Build more powerful queries with advanced SQL techniques like views, transactions, stored procedures and joins.

Skills you'll gain

Category: Extraction, Transformation And Loading (ETL)
Category: Data Warehousing
Category: OLTP Databases
Category: Relational Database
Category: Data Pipelines

Hands-on Introduction to Linux Commands and Shell Scripting

Course 414 hours4.7 (1,171 ratings)

What you'll learn

  • Describe the Linux architecture and common Linux distributions and update and install software on a Linux system.

  • Perform common informational, file, content, navigational, compression, and networking commands in Bash shell.

  • Develop shell scripts using Linux commands, environment variables, pipes, and filters.

  • Schedule cron jobs in Linux with crontab and explain the cron syntax. 

Skills you'll gain

Category: Database Security
Category: Database (DBMS)
Category: Database Servers
Category: database administration
Category: Relational Database

Relational Database Administration (DBA)

Course 521 hours4.4 (180 ratings)

What you'll learn

  • Create, query, and configure databases and access and build system objects such as tables.

  • Perform basic database management including backing up and restoring databases as well as managing user roles and permissions. 

  • Monitor and optimize important aspects of database performance. 

  • Troubleshoot database issues such as connectivity, login, and configuration and automate functions such as reports, notifications, and alerts. 

Skills you'll gain

Category: Data Science
Category: Database (DBMS)
Category: Information Engineering
Category: SQL
Category: NoSQL

ETL and Data Pipelines with Shell, Airflow and Kafka

Course 617 hours4.5 (312 ratings)

What you'll learn

  • Describe and contrast Extract, Transform, Load (ETL) processes and Extract, Load, Transform (ELT) processes.

  • Explain batch vs concurrent modes of execution.

  • Implement ETL workflow through bash and Python functions.

  • Describe data pipeline components, processes, tools, and technologies.

Skills you'll gain

Category: Business Intelligence
Category: Data Visualization
Category: IBM Cognos Analytics
Category: Google Looker Studio
Category: Dashboards

Data Warehouse Fundamentals

Course 715 hours4.4 (159 ratings)

What you'll learn

  • Job-ready data warehousing skills in just 6 weeks, supported by practical experience and an IBM credential.

  • Design and populate a data warehouse, and model and query data using CUBE, ROLLUP, and materialized views.

  • Identify popular data analytics and business intelligence tools and vendors and create data visualizations using IBM Cognos Analytics.

  • How to design and load data into a data warehouse, write aggregation queries, create materialized query tables, and create an analytics dashboard.

Skills you'll gain

Category: Database (DB) Design
Category: Postgresql
Category: Relational Database Management System (RDBMS)
Category: Database Architecture
Category: MySQL

What you'll learn

  • Explore the purpose of analytics and Business Intelligence (BI) tools

  • Discover the capabilities of IBM Cognos Analytics and Google Looker Studio

  • Showcase your proficiency in analyzing DB2 data with IBM Cognos Analytics

  • Create and share interactive dashboards using IBM Cognos Analytics and Google Looker Studio

Skills you'll gain

Category: Cubes
Category: Data Warehousing
Category: Snowflake Schemas
Category: Data Lakes
Category: Rollups
Category: Data Marts
Category: Star Schemas

What you'll learn

  • Demonstrate proficiency in skills required for an entry-level data warehouse engineering role.

  • Design and implement various concepts and components in the data warehouse engineering lifecycle such as data repositories.

  • Showcase working knowledge with relational databases, data warehouses, and data pipelines.

  • You can use your expertise in Linux shell scripting, SQL, and business intelligence Cognos dashboard design, to tackle data warehousing problems.

Skills you'll gain

Category: Data Analysis
Category: Relational Database Management System (RDBMS)
Category: SQL
Category: Create, Read, Update And Delete
Category: MySQL

Instructors

IBM Skills Network Team
IBM
58 Courses803,622 learners
Shubhra Das
3 Courses1,250 learners
Rav Ahuja
IBM
52 Courses2,560,705 learners

Offered by

IBM

Why people choose Coursera for their career

Felipe M.
Learner since 2018
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."
Jennifer J.
Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."
Larry W.
Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."
Chaitanya A.
"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

New to Data Management? Start here.

Placeholder

Open new doors with Coursera Plus

Unlimited access to 7,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy

Frequently asked questions