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.

IBM Skills Network Team
Shubhra Das
Rav Ahuja

Instructors: IBM Skills Network Team

Access provided by Coursera Learning Team

18,909 already enrolled

Earn a career credential that demonstrates your expertise
4.7

(753 reviews)

Beginner level

Recommended experience

4 months
at 10 hours a week
Flexible schedule
Learn at your own pace
Earn a career credential that demonstrates your expertise
4.7

(753 reviews)

Beginner level

Recommended experience

4 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

Taught in English

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
¹
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 113 hours4.7 (3,043 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: Data Pipelines
Category: Data Warehousing
Category: Extract, Transform, Load
Category: Data Architecture
Category: Data Governance
Category: Big Data
Category: SQL
Category: Relational Databases
Category: Data Mart
Category: Apache Spark
Category: Data Security
Category: Apache Hadoop
Category: Data Storage Technologies
Category: Data Lakes
Category: Databases

Introduction to Relational Databases (RDBMS)

Course 215 hours4.6 (657 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: Relational Databases
Category: Database Design
Category: SQL
Category: MySQL
Category: PostgreSQL
Category: Data Manipulation
Category: Database Architecture and Administration
Category: Data Modeling
Category: Database Management
Category: IBM DB2
Category: Data Integrity
Category: Data Structures
Category: Databases

SQL: A Practical Introduction for Querying Databases

Course 321 hours4.7 (515 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: SQL
Category: Stored Procedure
Category: Relational Databases
Category: Transaction Processing
Category: Microsoft SQL Servers
Category: Cloud Management
Category: Data Analysis
Category: Database Management
Category: Databases
Category: Data Manipulation
Category: IBM DB2
Category: MySQL
Category: Query Languages

Hands-on Introduction to Linux Commands and Shell Scripting

Course 414 hours4.6 (1,505 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: Linux Commands
Category: File Management
Category: Shell Script
Category: Linux
Category: Unix Commands
Category: Bash (Scripting Language)
Category: Unix
Category: Automation
Category: OS Process Management
Category: Linux Servers
Category: Network Protocols
Category: Operating Systems
Category: Unix Shell
Category: Scripting Languages
Category: Command-Line Interface
Category: Linux Administration

Relational Database Administration (DBA)

Course 521 hours4.4 (227 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: Database Management
Category: Relational Databases
Category: Database Architecture and Administration
Category: Database Systems
Category: Disaster Recovery
Category: Authorization (Computing)
Category: Authentications
Category: Stored Procedure
Category: MySQL
Category: User Accounts
Category: Database Software
Category: PostgreSQL
Category: Performance Tuning
Category: System Monitoring
Category: Data Storage Technologies
Category: IBM DB2

ETL and Data Pipelines with Shell, Airflow and Kafka

Course 617 hours4.5 (392 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: Data Pipelines
Category: Extract, Transform, Load
Category: Apache Airflow
Category: Apache Kafka
Category: Scalability
Category: Performance Tuning
Category: Databases
Category: Data Migration
Category: Data Transformation
Category: Data Integration
Category: Data Mart
Category: Shell Script
Category: Big Data
Category: Real Time Data
Category: Data Warehousing
Category: Web Scraping

Data Warehouse Fundamentals

Course 715 hours4.4 (217 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: Data Warehousing
Category: Data Mart
Category: Snowflake Schema
Category: Star Schema
Category: Data Lakes
Category: Data Architecture
Category: Data Integration
Category: IBM DB2
Category: Data Cleansing
Category: Query Languages
Category: Database Design
Category: Extract, Transform, Load
Category: PostgreSQL
Category: Data Validation
Category: SQL
Category: Data Quality
Category: Data Modeling

BI Dashboards with IBM Cognos Analytics and Google Looker

Course 811 hours4.8 (25 ratings)

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: Looker (Software)
Category: IBM Cognos Analytics
Category: Data Visualization
Category: Interactive Data Visualization
Category: Dashboard
Category: Business Intelligence
Category: Analytics
Category: Data Presentation
Category: Data Visualization Software
Category: Business Intelligence Software
Category: Data Analysis

Data Warehousing Capstone Project

Course 914 hours4.6 (14 ratings)

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: MySQL
Category: Extract, Transform, Load
Category: Database Design
Category: Data Warehousing
Category: Dashboard
Category: Shell Script
Category: SQL
Category: Data Transformation
Category: PostgreSQL
Category: Star Schema
Category: Data Modeling
Category: Data Architecture
Category: IBM Cognos Analytics

Instructors

IBM Skills Network Team
IBM
64 Courses1,179,461 learners
Shubhra Das
6 Courses18,015 learners
Rav Ahuja
IBM
54 Courses3,420,432 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."
Placeholder

Open new doors with Coursera Plus

Unlimited access to 10,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

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