SQL, ETL and BI Fundamentals

Overview

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 SQL, ETL and BI Fundamentals Professional Certificate in collaboration with IBMx 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.

Job Outlook

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