Overview
This BI Foundations with SQL, ETL and Data Warehousing program course is offered by Coursera in partnership with IBM.
What you'll 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
Skills you'll gain
- Python Programming
- Cloud Databases
- Relational Database Management System (RDBMS)
- SQL
- Jupyter notebooks
- Data Warehousing
- Business Intelligence (BI)
- cognos analytics
- Cube and Rollup
- Star and Snowflake Schema
- Shell Script
- Bash (Unix Shell)
- Extract Transform and Load (ETL)
- Linux
- Linux Commands
- Data Engineer
- Apache Kafka
- Apache Airflow
- Data Pipelines
- View less skills
You can choose from hundreds of free courses, or get a degree or certificate at a breakthrough price. You can now select Coursera Plus, an annual subscription that provides unlimited access
Get more details
Visit programme websiteProgramme Structure
Courses included:
- Hands-on Introduction to Linux Commands and Shell Scripting
- Databases and SQL for Data Science with Python
- ETL and Data Pipelines with Shell, Airflow and Kafka
- Getting Started with Data Warehousing and BI Analytics
Check out the full curriculum
Visit programme websiteKey information
Duration
- Part-time
- 2 months
- 10 hrs/week
Start dates & application deadlines
Language
Delivered
Disciplines
Data Science & Big Data Data Analytics View 178 other Short Courses in Data Analytics in United StatesExplore more key information
Visit programme websiteWhat students do after studying
Academic requirements
We are not aware of any specific GRE, GMAT or GPA grading score requirements for this programme.
English requirements
We are not aware of any English requirements for this programme.
Other requirements
General requirements
- Beginner level
- No prior experience required
Make sure you meet all requirements
Visit programme websiteTuition Fee
-
International
FreeTuition FeeBased on the tuition of 0 USD for the full programme during 2 months. -
National
FreeTuition FeeBased on the tuition of 0 USD for the full programme during 2 months.
You can choose from hundreds of free courses, or get a degree or certificate at a breakthrough price. You can now select Coursera Plus and have unlimited access
Funding
Coursera provides financial aid to learners who cannot afford the fee. Apply for it by clicking on the Financial Aid link beneath the "Enroll" button on the left. You'll be prompted to complete an application and will be notified if you are approved. You'll need to complete this step for each course in the Specialization, including the Capstone Project.