Udemy - Mastering Data Infrastructure with Python and SQL for Engineer

Mastering Data Infrastructure with Python & SQL for Engineer

https://WebToolTip.com

Published 12/2025
Created by Maruchin Tech,Maruchin Tech
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz, 2 Ch
Level: Beginner | Genre: eLearning | Language: English | Duration: 44 Lectures ( 3h 0m ) | Size: 1.93 GB

Build a Manufacturing Data Platform: Master Advanced SQL (Recursive/Window), Python (Pandas), and AWS RDS Deployment.

What you'll learn
Design robust databases using normalization and composite primary keys to prevent data duplication and inconsistencies.
Master advanced SQL techniques like Recursive CTEs for BOM explosion and Window Functions for retrieving the latest unit prices.
Implement practical business logic with Python (Pandas), including data cleansing, MOQ rounding, and lead-time calculation.
Deploy a local database system to the cloud using Amazon RDS and understand the architecture of separating Writer and Reader instances.

Requirements
A Google account (to use Google Colab).
A computer with internet access (No local environment setup is required).
No prior experience with SQL or Python is necessary; we will start from the basics.
An AWS account is required only for the final section (optional, but recommended for the full experience).