Skip to main content
Program Subscription

Drive your career forward

Professional Certificate in
SQL, ETL and BI Fundamentals
IBM

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.

Organizations understand that data creates enormous value when transformed into Business Intelligence (BI). Data Warehousing Engineers, Data Analysts, and BI professionals play a critical role in enabling organizations to derive value out of data and therefore are in high demand.

This Professional Certificate is designed to provide you the skill set and hands-on experience for working with data warehouses and BI tools.

You’ll gain proficiency with Linux Commands and Bash shell scripting, create data pipelines to perform ETL (extract, transform, load), design and populate data warehouses and analyze data using SQL queries and business intelligence tools.

Each course within this Professional Certificate provides hands-on experience with practice labs and real-world projects to add to your portfolio. Skills you will gain include SQL, Python, ETL Pipelines, Bash Shell Scripting, Linux/UNIX shell commands and scripting, Cron, Crontab, Apache Airflow, Apache Kafka, IBM DB2, MySQL, PostgreSQL, and Cognos Analytics.

To get started, all you need is basic computer and data literacy, familiarity with either Linux, Unix, Windows, or MacOS, and the desire to learn and practice new skills.

A program subscription gives you full verified access to all courses and materials within the program you’ve enrolled in, for as long as your subscription is active. Monthly subscription pricing can help you manage your enrollment costs — instead of paying more up front, you pay a smaller amount per month for only as long as you need access. You can cancel your subscription at any time for no additional fee.

Expert instruction
4 skill-building courses
Self-paced
Progress at your own speed
4 months
2 - 4 hours per week
$39/month
USD
After 7-day free trial

Courses in this program

  1. IBM's SQL, ETL and BI Fundamentals Professional Certificate

  2. 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.

  3. 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. 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.

  5. 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.

    • According to Glassdoor, the average annual salary for a Data Warehouse Engineer in the U.S. is $103,000.
    • The average base salary in the U.S. for a Business Intelligence Analyst is $88,221 according to Indeed.
    • Research and Markets estimates the global market for the data warehouse as a service (DWaaS) is estimated to grow from $1.7 billion in 2021 to $4.5 billion by 2026, at a compound annual growth rate (CAGR) of 21.7% from 2021-2026.

Meet your instructors
from IBM

Ramesh Sannareddy
Content Developer
Skillup
Rav Ahuja
Global Program Director
IBM Skills Network
Jeff Grossman
Data Science and Engineering SME
Skillup Technologies
Yan Luo
Ph.D., Data Scientist and Developer
IBM

Experts from IBM committed to teaching online learning

Grow your career. Start your program subscription today.

$39/month USD

After a 7-day full access free trial. Cancel at any time.
This program subscription includes:
  • Immediate access to all 4 courses in this program
  • Course videos, lectures, and readings
  • Practice problems and assessments
  • Graded assignments and exams
  • edX learner support
  • Shareable verified certificates after successfully completing a course or program
Enroll now
Learn morein a new tab
about program subscriptions.

Propelling

Drive your career forward with university-backed credit programs and verified certificates

Convenient

Study and demonstrate knowledge on your schedule

Flexible

Try a course before you pay

Supportive

Learn with university partners and peers from around the world