Data Warehouse Developer   

Welcome to the Data Warehouse Developer Career Academy, your comprehensive gateway to learning data warehouse engineering and launching a successful career in this dynamic field. This course is designed for aspiring data engineers, and data analysts looking to upskill, and anyone interested in understanding the intricacies of SQL, Relational Database Management Systems (RDBMS) and basic Shell scripting.

Throughout this program, you will gain hands-on experience with the fundamental concepts and technologies that drive modern networking. From foundational knowledge to advanced techniques, the Data Warehouse Developer Career Academy includes the IBM Data Warehouse Engineer Professional Certificate and 6 Guided Projects:

• Shell Scripting with Bash: Basics
• Advanced Relational Database and SQL
• Create a Database with the Modeling Toolin MySQL Workbench
• Linux: Introduction to Shell Scripting for DevOps
• Creating Azure Serverless Functions in a Real-World Scenario
• Using MySQL Database with PHP

The course combines video lectures, interactive labs, and real-world projects to ensure you not only learn but apply your knowledge effectively. With guided assessments and feedback, you will build a robust portfolio that showcases your skills to potential employers.

Powered by Coursera

This Professional Certificate is intended to help you develop the job-ready skills and portfolio for an entry-level Business Intelligence (BI) or Data Warehousing Engineering position. Throughout the online courses in this program, you will immerse yourself in the in-demand role of a Data Warehouse Engineer and acquire the essential skills you need to work with a range of tools and databases to design, deploy, operationalize and manage Enterprise Data Warehouses (EDW).

By the end of this Professional Certificate, you will be able to perform the key tasks required in a data warehouse engineering role. You will work with Relational Database Management Systems (RDBMS) and query data using SQL statements.

You will use Linux/UNIX shell scripts to automate repetitive tasks, and build data pipelines with tools like Apache Airflow and Kafka to Extract, Transform and Load (ETL) data. You will gain experience with managing databases and data warehouses.

Finally, you will design and populate data warehouse systems and utilize Business Intelligence tools to analyze and extract insights using reports and dashboards.

This program is suitable for anyone with a passion for 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.

Powered by Coursera

In this project, you will learn how to use Bash for creating basic shell scripts. After completing the 1-hour hands-on guided project, you'll know how to automatically rename a collection of files, read the contents of a file line by line and use all basic constructs of Bash.

Note: It's recommended that you have some experience with the command line before starting this project. Consider looking into the project 'Practical introduction to the Command Line' first - https://www.coursera.org/projects/practical-introduction-to-the-command-line.

Powered by Coursera

In this 1-hour long project-based course, you will gain hands-on experience and learn about advanced SQL topics such as stored procedures, tiggers, functions, common table expressions and recursion. If you have intermediate level of experience with SQL and want to learn more, this course is for you!

Note: This is an advanced level course. Taking my course "Introduction to Relational Database and SQL" and "Intermediate Relational Database and SQL" before taking this course is highly recommended. Especially if you do not have any previous experience with relational database and SQL.

Powered by Coursera

In this project you will use the Modeling and Design Tool in MySQL Workbench to design and create a multiple-table relational database. As a DBMS (database management system), MySQL is used by many organizations for managing a variety of types and sizes of databases. MySQL Workbench acts as an integrated development environment allowing users to work with relational databases using a visual user interface rather than the command line. Hands-on activities include using the Modeling and Design Tool to draw a database design diagram, generating the database from that diagram, and then using MySQL Workbench features to load data into the database tables. You will also find an optional Challenge Task and an optional Capstone task for extra practice.

Powered by Coursera

In this 1-hour long project-based course on Linux: Introduction to Shell Scripting for DevOps, you will be writing your own Bash/Shell scripts for scratch.You will be going through all of the key components that make up the bash script, from exit statuses, the test command, if/else statements, loops and file archiving. You will no longer be completely confused when looking at Bash scripts, and will have a working knowledge which allows you to start working with scripts yourself.

This course is designed for any person working or who intends to work with Linux, from Linux system administrators to developers and DevOps practitioners. Or even if you are a student who is curious to get comfortable with Linux this course is for you also.

This is an intermediate level course and is designed for an individual who has a beginner's knowledge of the Linux/Unix command line and Unix crud practices in computer science.

Powered by Coursera

Serverless computing and Microservices development have become a robust technology and methodology to decoupling monolithic and legacy systems, creating new services, and increasing digital transformation and innovation. In this project, you will learn how to develop some Serverless Microservices using Microsoft Azure Functions that are part of the Microsoft Cloud Platform in a Real-World Scenario example. Once you’re done with this project, you will be able to develop Azure Functions using Visual Studio Code and deploy them to Azure Cloud and create some HTML pages to be the front-end that will call and use the microservices functions, just with a few steps.

Powered by Coursera

In this 1.5 hour project, you will combine your knowledge of HTML, object-oriented PHP, SQL, and MySQL to make a dynamic website that uses MySQL database on the web server. You will learn two different methods, one applies to 12 other SQL databases and one specific to MySQL. Basic HTML, object-oriented PHP, relational database, and SQL required as prerequisites. Completing my courses "Build an Automobile Listing Website with PHP" and "Learn Object-Oriented Programming with PHP" first is highly recommended.

Powered by Coursera