SQL, ETL and BI Fundamentals

0
Join & Subscribe
edX
$326.00
English
Certificate Available
17 weeks long, 2-3 hours a week

Overview

Organizations understand that data creates enormous value when transformed into Business Intelligence (BI). Data Warehousing Engineers, Data Analysts, and BI professionals play a critical role in enabling organizations to derive value out of data and therefore are in high demand.

This Professional Certificate is designed to provide you the skill set and hands-on experience for working with data warehouses and BI tools.

You’ll gain proficiency with Linux Commands and Bash shell scripting, create data pipelines to perform ETL (extract, transform, load), design and populate data warehouses and analyze data using SQL queries and business intelligence tools.

Each course within this Professional Certificate provides hands-on experience with practice labs and real-world projects to add to your portfolio. Skills you will gain include SQL, Python, ETL Pipelines, Bash Shell Scripting, Linux/UNIX shell commands and scripting, Cron, Crontab, Apache Airflow, Apache Kafka,IBM DB2, MySQL, PostgreSQL, and Cognos Analytics.

To get started, all you need is basic computer and data literacy, familiarity with either Linux, Unix, Windows, or MacOS, and the desire to learn and practice new skills.

Syllabus

Courses under this program:
Course 1: Linux Commands & Shell Scripting

This mini-course describes shell commands and how to use the advanced features of the Bash shell to automate complicated database tasks. For those not familiar with shell scripting, this course provides an overview of common Linux Shell Commands and shell scripting basics.



Course 2: Introduction to SQL

Learn how to use and apply the powerful language of SQL to better communicate and extract data from databases - a must for anyone working in Data Engineering, Data Analytics or Data Science.



Course 3: Building ETL and Data Pipelines with Bash, Airflow and Kafka

This course provides you with practical skills to build and manage data pipelines and Extract, Transform, Load (ETL) processes using shell scripts, Airflow and Kafka.



Course 4: Data Warehousing and BI Analytics

This course introduces you to designing, implementing and populating a data warehouse and analyzing its data using SQL & Business Intelligence (BI) tools.



Taught by

Ramesh Sannareddy, Rav Ahuja, Jeff Grossman and Yan Luo