Data Warehouse Engineering

Data Warehouse Engineers and Business Analysts are in high demand as organizations become increasingly dependent on data to support their operations.

Data warehousing has transformed the way organizations perform business analysis and make strategic decisions. Massive amounts of data from multiple sources can be easily accessed using SQL and formatted for analysis, reporting and Business Intelligence for organizations to gain deeper business insights.

The Data Warehouse Engineer Professional Certificate provides you the skills and knowledge to design, deploy and manage Enterprise Data Warehouses (EDW) and utilize Business Intelligence tools to analyze and extract insights using reports and dashboards.

Upon completing this program, you’ll gain practical experience to work with Relational Database Management Systems (RDBMS), query data using SQL statements, utilize Linux/UNIX shell scripts to automate repetitive tasks, and build data pipelines using Apache Airflow and Kafka to Extract, Transform and Load (ETL) data. You’ll also acquire the skills to build and operationalize Data Warehouses and conduct data analysis.

Within each course you’ll practice your skills with numerous hands-on labs and multiple projects to add to your portfolio for launching your career.

To get started, all you need is basic computer literacy 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.