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.
Skills you will gain
About this Specialization
Applied Learning Project
Each course provides lots of practice using hands-on labs and projects on cloud-based environments with real tools. Hands-on exercises include: running Linux commands and pipes, in creating shell scripts, scheduling jobs using cron, building ETL and data pipelines, creating & monitoring Airflow DAGs, working with streaming data using Kafka, designing a data warehouses with star and snowflake schemas, verifying data quality, loading staging and production warehouses, writing SQL queries and joins with PostgreSQL, MySQL & DB2 databases, developing cubes, rollups and materialized views/tables, creating interactive reports & dashboards, and analyzing warehouse data using BI tools like Cognos Analytics.
How the Specialization Works
A Coursera Specialization is a series of courses that helps you master a skill. To begin, enroll in the Specialization directly, or review its courses and choose the one you'd like to start with. When you subscribe to a course that is part of a Specialization, you’re automatically subscribed to the full Specialization. It’s okay to complete just one course — you can pause your learning or end your subscription at any time. Visit your learner dashboard to track your course enrollments and your progress.
Every Specialization includes a hands-on project. You'll need to successfully finish the project(s) to complete the Specialization and earn your certificate. If the Specialization includes a separate course for the hands-on project, you'll need to finish each of the other courses before you can start it.
Earn a Certificate
When you finish every course and complete the hands-on project, you'll earn a Certificate that you can share with prospective employers and your professional network.
Frequently Asked Questions
What is the refund policy?
Can I just enroll in a single course?
Is financial aid available?
Can I take the course for free?
Is this course really 100% online? Do I need to attend any classes in person?
How long does it take to complete the Specialization?
What background knowledge is necessary?
Do I need to take the courses in a specific order?
Will I earn university credit for completing the Specialization?
What will I be able to do upon completing the Specialization?
More questions? Visit the Learner Help Center.