Professionals with SQL, ETL, Enterprise Data Warehousing (EDW), Business Intelligence (BI) and Data Analysis skills are in great demand. This Specialization is designed to provide career relevant knowledge and skills for anyone wanting to pursue a job role in domains such as Data Engineering, Data Management, BI or Data Analytics. 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. Note that 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 to self-learn online.
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.
Instructors: Rav Ahuja
Included with 
(408 reviews)
(408 reviews)
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
Overview
Skills you'll gain
What’s included
Add to your LinkedIn profile
Specialization - 4 course series
What you'll learn
Describe the Linux architecture and common Linux distributions and update and install software on a Linux system.
Perform common informational, file, content, navigational, compression, and networking commands in Bash shell.
Develop shell scripts using Linux commands, environment variables, pipes, and filters.
Schedule cron jobs in Linux with crontab and explain the cron syntax.
Skills you'll gain
What you'll learn
Analyze data within a database using SQL and Python.
Create a relational database and work with multiple tables using DDL commands.
Construct basic to intermediate level SQL queries using DML commands.
Compose more powerful queries with advanced SQL techniques like views, transactions, stored procedures, and joins.
Skills you'll gain
What you'll learn
Describe and contrast Extract, Transform, Load (ETL) processes and Extract, Load, Transform (ELT) processes.
Explain batch vs concurrent modes of execution.
Implement ETL workflow through bash and Python functions.
Describe data pipeline components, processes, tools, and technologies.
Skills you'll gain
What you'll learn
Job-ready data warehousing skills in just 6 weeks, supported by practical experience and an IBM credential.
Design and populate a data warehouse, and model and query data using CUBE, ROLLUP, and materialized views.
Identify popular data analytics and business intelligence tools and vendors and create data visualizations using IBM Cognos Analytics.
How to design and load data into a data warehouse, write aggregation queries, create materialized query tables, and create an analytics dashboard.
Skills you'll gain
Earn a career certificate
Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.
Instructors
Offered by
Compare with similar products
| Rating | ||||
|---|---|---|---|---|
| Level | ||||
| Skills | ||||
| Tools | ||||
| Last updated | ||||
| Number of practice exercises | ||||
| Degree eligibility | ||||
| Part of Coursera Plus |
You might also like
Why people choose Coursera for their career
Open new doors with Coursera Plus
Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription
Advance your career with an online degree
Earn a degree from world-class universities - 100% online
Join over 3,400 global companies that choose Coursera for Business
Upskill your employees to excel in the digital economy
Frequently asked questions
The specialization is self-paced and requires 36-48 hours of effort to complete. Learners taking the course part-time e.g. 3-4 hours per week can complete in 3-4 months. Learners taking the courses full-time can complete considerably faster.
Basic computer literacy, some data literacy, and a passion to self-learn online are the only pre-requisites. No prior database or data warehouse skills required although some learners may benefit from a little programming experience.
It is highly recommended the courses be taken in the order they are listed as later courses build on concepts taught in previous ones.
More questions
Financial aid available,
¹ Median salary and job opening data are sourced from Lightcast™ Job Postings Report. Content Creator, Machine Learning Engineer and Salesforce Development Representative (1/1/2024 - 12/31/2024) All other job roles (10/1/2024 - 10/1/2025)