Specialisation BI Foundations with SQL, ETL and Data Warehousing
Specialisation BI Foundations with SQL, ETL and Data Warehousing is among the best online Extract, Transform, Load courses. The program consists of four online courses. In the first course, you learn the basics of SQL and how to query relational databases with this powerful language. Next, you learn to use essential Linux commands and create basic shell scripts. You continue your journey by learning to build and automate ETL, ELT, and data pipelines using BASH scripts, Apache Airflow and Apache Kafka. In the final course, you learn about Data Lakes, Data Marts as well as work with Data Warehouses. You also create interactive reports and dashboards to derive insights from data in your warehouse.
This specialization has a significant emphasis on hands-on practice employing real tools used by data professionals. Every course has numerous hands-on labs as well as a course project. While you will benefit from some prior programming experience, it is not absolutely necessary for this course. The only pre-requisites for this specialization are basic computer and data literacy, and a passion for self-learn online.
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 verifying 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
This course offers:
- Flexible deadlines: Reset deadlines based on your availability.
- 100% online
- Get a Certificate when you finish
- Beginner level
- Approximately 5 months to complete
- Subtitles: English, Arabic, Persian
Rating: 4.6/5
Participants: 2,055
Enroll here: https://www.coursera.org/specializations/bi-foundations-sql-etl-data-warehouse