When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.
BI Foundations with SQL, ETL and Data Warehousing Specialization
Springboard for BI Analytics success. Develop hands-on skills for building data pipelines, warehouses, reports and dashboards.
Free
This Course Includes
coursera
4.6 (281 reviews )
2 months at 10 hours a week 
english
Online - Self Paced
specialization
IBM
About BI Foundations with SQL, ETL and Data Warehousing Specialization
Learn in-demand skills from university and industry experts
Master a subject or tool with hands-on projects
Develop a deep understanding of key concepts
Earn a career certificate from IBM
What You Will Learn?
- Write SQL queries to work with relational databases including CREATE TABLE, SELECT, INSERT, UPDATE, DELETE, ORDER, JOIN, Functions, etc..
- Execute commonly used Linux commands; Automate Extract, Transform and Load (ETL) jobs and data pipelines using BASH scripts, Apache Airflow & Kafka.
- Design Data Warehouses using star and snowflake schemas, loading and verify data in staging areas, build cubes, rollups and materialized views/tables.
- Analyze data in warehouses using interactive reports and dashboards using BI tools such as Cognos Analytics.