BI Foundations with SQL, ETL and Data Warehousing

开始时间: 12/21/2023 持续时间: Approximately 5 months to complete Suggested pace of 4 hours/week

课程主页: https://www.coursera.org/specializations/bi-foundations-sql-etl-data-warehouse

课程评论：没有评论

第一个写评论        关注课程

课程详情

What 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 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 will gain
Shell Script
Bash (Unix Shell)
Linux
Cloud Databases
Python Programming
Ipython
Relational Database Management System (RDBMS)
SQL
Extraction, Transformation And Loading (ETL)
Apache Kafka
Apache Airflow
Data Pipelines
About this Specialization
10,002
recent views
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.
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.
Shareable Certificate
Shareable Certificate
Earn a Certificate upon completion
100% online courses
100% online courses
Start instantly and learn at your own schedule.
Flexible Schedule
Flexible Schedule
Set and maintain flexible deadlines.
Beginner Level
Beginner Level
No prior experience required.
Hours to complete
Approximately 5 months to complete
Suggested pace of 4 hours/week
Available languages
English
Subtitles: English, Arabic, Persian
Shareable Certificate
Shareable Certificate
Earn a Certificate upon completion
100% online courses
100% online courses
Start instantly and learn at your own schedule.
Flexible Schedule
Flexible Schedule
Set and maintain flexible deadlines.
Beginner Level
Beginner Level
No prior experience required.
Hours to complete
Approximately 5 months to complete
Suggested pace of 4 hours/week
Available languages
English
Subtitles: English, Arabic, Persian

课程大纲

Course Link: https://www.coursera.org/learn/hands-on-introduction-to-linux-commands-and-shell-scripting

Name:Hands-on Introduction to Linux Commands and Shell Scripting

Description:Offered by IBM. This course provides a practical understanding of common Linux / UNIX shell commands. In this beginner friendly course, you ... Enroll for free.

Course Link: https://www.coursera.org/learn/sql-data-science

Name:Databases and SQL for Data Science with Python

Description:Offered by IBM. Working knowledge of SQL (or Structured Query Language) is a must for data professionals like Data Scientists, Data Analysts ... Enroll for free.

Course Link: https://www.coursera.org/learn/etl-and-data-pipelines-shell-airflow-kafka

Name:ETL and Data Pipelines with Shell, Airflow and Kafka

Description:Offered by IBM. Delve into the two different approaches to converting raw data into analytics-ready data. One approach is the Extract, ... Enroll for free.

Course Link: https://www.coursera.org/learn/getting-started-with-data-warehousing-and-bi-analytics

Name:Getting Started with Data Warehousing and BI Analytics

Description:Offered by IBM. Kickstart your Data Warehousing and Business Intelligence (BI) Analytics journey with this self-paced course. You will learn ... Enroll for free.

课程评论(0条)