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.
Read more
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.
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.
What you'll learn
- Create shell scripts using common Linux/UNIX shell commands.
- Describe relational database concepts, create a relational database on cloud, execute SQL statements, and access databases using SQL.
- Build batch and streaming ETL and ELT Data Pipelines using Bash, Apache Airflow and Kafka.
- Design, model, and implement a data warehouse and analyze its data using Business Intelligence tools like IBM Cognos.
What's inside
Three courses
Linux Commands & Shell Scripting
(3 hours)
Linux Commands & Shell Scripting
(3 hours)
Building ETL and Data Pipelines with Bash, Airflow and Kafka
(15 hours)
Building ETL and Data Pipelines with Bash, Airflow and Kafka
(15 hours)
Data Warehousing and BI Analytics
(15 hours)
Data Warehousing and BI Analytics
(15 hours)Save this collection
Save
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.
