Data Engineering from Design to Implementation

Data Engineering from Design to Implementation, available at $34.99, has an average rating of 4, with 25 lectures, based on 12 reviews, and has 52 subscribers.

You will learn about Learn how to design a data model. Learn how to set up and ETL process from source to database. Learn how to extract valuable information from your database. Learn how to present your information as business intelligence in insightful ways. Learn how to structure data. Learn how to create database views. Learn how to conduct calculations in SQL on your data. This course is ideal for individuals who are System Engineers or Data Scientists or Data Analysis or Business Analysts or Process Engineers or Solution Architects It is particularly useful for System Engineers or Data Scientists or Data Analysis or Business Analysts or Process Engineers or Solution Architects.

Enroll now: Data Engineering from Design to Implementation

Summary

Title: Data Engineering from Design to Implementation

Price: $34.99

Average Rating: 4

Number of Lectures: 25

Number of Published Lectures: 25

Number of Curriculum Items: 25

Number of Published Curriculum Objects: 25

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

Learn how to design a data model.
Learn how to set up and ETL process from source to database.
Learn how to extract valuable information from your database.
Learn how to present your information as business intelligence in insightful ways.
Learn how to structure data.
Learn how to create database views.
Learn how to conduct calculations in SQL on your data.

Who Should Attend

System Engineers
Data Scientists
Data Analysis
Business Analysts
Process Engineers
Solution Architects

Target Audiences

System Engineers
Data Scientists
Data Analysis
Business Analysts
Process Engineers
Solution Architects

This course will teach you data engineering from start to finish. This course covers all you need to know from the physical design of our data structures to implementation where we the course will provide you with step by step instructions to follow along.

We will be using unformatted source data and convert this data into usable and valuable information. This process entails everything you need to know, from data design, ETL, information access, data analysis, and lastly information presentation in the form of business intelligence.

This course will include data files that you can use to follow along in the step by step tutorials, to ensure that you have all the information that you need at your disposal to make this course a breeze.

We will be looking at the processes that I have found to work the best in a real live environment. These are methods that can be employed in any business and the teachings of this course will provide you with the required information to start your journey in data engineering.

We will be looking at the following main topics in this course:

Data Design
Data Structuring
Dimensional Modeling
UML (Unified Modeling Language)
ERDs (Entity Relational Models)
SQL (Structured Query Language)
Power BI
etc.

I look forward to seeing you in the course and sharing this learning experience with you!

Course Curriculum

Chapter 1: Introduction

Lecture 1: Welcome to the Course!

Lecture 2: Thank you!

Lecture 3: Installing PostgreSQL

Lecture 4: Installing an IDE (Dbeaver)

Lecture 5: Connecting to PostgreSQL

Chapter 2: Data Design

Lecture 1: What is an ERD?

Lecture 2: What is Normalization?

Lecture 3: What is Dimensional Moddeling?

Lecture 4: How to create a Star Schema

Lecture 5: Data Design Exercise

Chapter 3: Introduction to SQL (PostgreSQL)

Lecture 1: Database Basics

Lecture 2: Loading Data to PostgreSQL

Lecture 3: Structure of Select Statements

Lecture 4: Creating Basic Select Statements

Chapter 4: Implementing Data Design and ETL (Extraction, Transformation, and Loading)

Lecture 1: Resource Requirements

Lecture 2: Taking a look at our Data

Lecture 3: Creating information packages from our data

Lecture 4: Creating a Star Schema from our Information Packages

Lecture 5: Creating our Database tables in PostgreSQL

Lecture 6: Loading our Temp Tables

Lecture 7: Populating our Dimension Tables

Lecture 8: Populating our FACT Table

Lecture 9: Creating a View to Pull All Information

Chapter 5: Displaying our Information

Lecture 1: Loading Data to PowerBI

Lecture 2: Creating a Dashboard on PowerBI

Instructors

Henk van Zyl
Business Analyst

Rating Distribution

1 stars: 0 votes
2 stars: 0 votes
3 stars: 3 votes
4 stars: 5 votes
5 stars: 4 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu