Description
IBM Data Warehouse Engineer Professional Certificate is a professional certification course published by Udemy Academy. This professional certificate is designed to help you develop the skills and portfolio for a career in business intelligence (BI) or data warehouse engineering at the entry level. During the online courses in this program, you will immerse yourself in the in-demand role of a data warehouse engineer and gain the essential skills to work with a wide range of tools and databases to design, deploy, operate, and manage enterprise data warehouses (EDW). Upon completion of this professional certificate, you will be able to perform key tasks required in the data warehouse engineering role. You will work with relational database management systems (RDBMS) and query data using SQL commands. You will use Linux/Unix shell scripts to automate repetitive tasks and create data pipelines with tools such as Apache Airflow and Kafka for data extraction, transformation, and loading (ETL). You will gain experience with managing databases and data warehouses. Finally, you will design and populate data warehouse systems and use business intelligence tools to analyze and extract insights using reports and dashboards. This program is suitable for anyone who is interested in learning and is suitable for you, whether you have a college degree or not, and does not require any prior data engineering or programming experience.
What you will learn
- Write and execute various types of SQL statements and queries to access and manipulate data in the database.
- Deploy, manage, secure, operationalize, monitor, and optimize relational database systems such as MySQL, PostgreSQL, and DB2.
- Create data pipelines to extract, transform, and load data stores using shell scripts and tools like Apache Airflow and Kafka
- Design and populate data warehouses and analyze their data with business intelligence (BI) tools such as Cognos Analytics
IBM Data Warehouse Engineer Professional Certificate Course Details
- Publisher: Coursera
- Instructor: IBM Skills Network Team
- Language: English
- Education level: Elementary
- Number of lessons: 9
- Training duration: 4 months, including 10 hours of work per week
IBM Data Warehouse Engineer Professional Certificate Course Topics
Course prerequisites
- This program is suitable for those with or without college degrees. No prior programming or data engineering background required
Pictures
Sample video
Installation Guide
After Extract, view with your favorite player.
Subtitles: English
Quality: 720p
Download link
Course 1 – Introduction to Data Engineering
Course 2 – Introduction to Relational Databases (RDBMS)
Course 3 – SQL: A Practical Introduction for Querying Databases
Course 4 – Hands-on Introduction to Linux Commands and Shell Scripting
Course 5 – Relational Database Administration (DBA)
Course 6 – ETL and Data Pipelines with Shell, Airflow and Kafka
Course 7 – Data Warehouse Fundamentals
Course 8 – BI Dashboards with IBM Cognos Analytics and Google Looker
Course 9 – Data Warehousing Capstone Project
File size
2.09 GB