Moocable is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

IBM Data Warehouse Engineer

Description

Prepare for a career in the field of data warehousing. In this program, you’ll learn in-demand skills like SQL, Linux, and database architecture to get job-ready in less than 3 months.Data warehouse engineers design and build large databases called data warehouses, used for data and business analytics. They work closely with data analysts, data scientists, and project management to power analysis that enable insights and inform decision-making. This program will teach you the foundational data warehousing skills employers are seeking for entry level data warehouse roles. This program will not only help you start your career in data warehousing, but also provides a strong foundation for future career development in other paths such as Business Intelligence (BI) roles.You’ll learn the latest tools used by professional data warehouse engineers including Relational Database Management Systems (RDBMS), PostgreSql, and MySQL. Alongside these tools, learn how to use Linux/UNIX shell scripts to automate repetitive tasks and build data pipelines and Extract, Transform and Load (ETL) data. You’ll also work with data warehouses and query them using SQL and BI tools.When you complete the full program, you’ll have a portfolio of projects and a Professional Certificate from IBM to showcase your expertise. You’ll also earn an IBM Digital badge and will gain access to career resources to help you in your job search, including mock interviews and resume support. Applied Learning ProjectEach course includes numerous hands-on labs and a project to hone and apply the concepts and skills you learn. By the end of the program, you will have designed, implemented, configured, queried, and maintained numerous databases and created data pipelines using real-world tools and data repositories to build a portfolio of job-ready skills.You will start by provisioning a database instance on Cloud. Next, you will design databases using Entity-Relationship Diagrams (ERD) and create database objects like tables and keys using MySQL, PostgreSQL and IBM Db2. You will then become proficient with querying databases with SQL using SELECT, INSERT, UPDATE and DELETE statements, and learn to filter, sort & aggregate result sets. Next, you will become familiar with common Linux/Unix shell commands and use them to build Bash scripts. You will create Data Pipelines for batch and streaming ETL jobs using Apache Airflow and Kafka. Finally, implement data warehouses & create BI dashboards.

Microcredentials

Coursera

Free to Audit

3 months at 10 hours a week

Beginner

Paid Certificate

IBM Data Warehouse Engineer

IBM
Affiliate notice

  • Type
    Microcredentials
  • Provider
    Coursera
  • Pricing
    Free to Audit
  • Duration
    3 months at 10 hours a week
  • Difficulty
    Beginner
  • Certificate
    Paid Certificate

Prepare for a career in the field of data warehousing. In this program, you’ll learn in-demand skills like SQL, Linux, and database architecture to get job-ready in less than 3 months.Data warehouse engineers design and build large databases called data warehouses, used for data and business analytics. They work closely with data analysts, data scientists, and project management to power analysis that enable insights and inform decision-making. This program will teach you the foundational data warehousing skills employers are seeking for entry level data warehouse roles. This program will not only help you start your career in data warehousing, but also provides a strong foundation for future career development in other paths such as Business Intelligence (BI) roles.You’ll learn the latest tools used by professional data warehouse engineers including Relational Database Management Systems (RDBMS), PostgreSql, and MySQL. Alongside these tools, learn how to use Linux/UNIX shell scripts to automate repetitive tasks and build data pipelines and Extract, Transform and Load (ETL) data. You’ll also work with data warehouses and query them using SQL and BI tools.When you complete the full program, you’ll have a portfolio of projects and a Professional Certificate from IBM to showcase your expertise. You’ll also earn an IBM Digital badge and will gain access to career resources to help you in your job search, including mock interviews and resume support. Applied Learning ProjectEach course includes numerous hands-on labs and a project to hone and apply the concepts and skills you learn. By the end of the program, you will have designed, implemented, configured, queried, and maintained numerous databases and created data pipelines using real-world tools and data repositories to build a portfolio of job-ready skills.You will start by provisioning a database instance on Cloud. Next, you will design databases using Entity-Relationship Diagrams (ERD) and create database objects like tables and keys using MySQL, PostgreSQL and IBM Db2. You will then become proficient with querying databases with SQL using SELECT, INSERT, UPDATE and DELETE statements, and learn to filter, sort & aggregate result sets. Next, you will become familiar with common Linux/Unix shell commands and use them to build Bash scripts. You will create Data Pipelines for batch and streaming ETL jobs using Apache Airflow and Kafka. Finally, implement data warehouses & create BI dashboards.