BI Foundations with SQL ETL and Data Warehousing Specialization

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