| File Name: | Mastering Data Infrastructure with Python & SQL for Engineer |
| Content Source: | https://www.udemy.com/course/python-sql-mfg-en/ |
| Genre / Category: | Programming |
| File Size : | 1.9 GB |
| Publisher: | Maruchin Tech |
| Updated and Published: | December 30, 2025 |
Turn raw manufacturing data into actionable insights with the power of Python and SQL. This is a practical, hands-on course designed to teach you how to build a data infrastructure from scratch, specifically tailored for Manufacturing and Supply Chain Management (SCM) scenarios.
Most programming courses teach basic syntax using “clean data.” But in the real world, data is rarely clean. Engineers face distinct supplier data formats, inconsistent units (full-width/half-width characters), and complex hierarchical structures like Bills of Materials (BOM). This course focuses on tackling these “messy,” real-world data challenges.
Using Google Colab (a browser-based development environment), you will learn not just how to write code, but why specific engineering designs are necessary. You will go from database design all the way to production deployment on the AWS Cloud.
【What You Will Learn】:
- Database Design Beyond Excel:
- Design schemas using “Composite Primary Keys” and “Normalization” to prevent data duplication and errors.
- Intermediate to Advanced SQL Techniques:
- Recursive Queries (Recursive CTE): Explode hierarchical BOM structures.
- Window Functions: Extract only the latest unit prices from historical data.
- Inventory Allocation: Calculate shortages by comparing required quantities against current stock.
- Implementing Business Logic with Python:
- Data Cleansing: Convert non-computable string data into numbers using Regular Expressions (Regex).
- Order Calculation: Automate rounding based on MOQ (Minimum Order Quantity) and calculate delivery dates considering lead times.
- Cloud Architecture (AWS):
- Migrate a local system to Amazon RDS.
- Understand the architecture strategy of separating “Writer” (Primary) and “Reader” (Replica) instances.
【Curriculum Overview】:
- Section 1: Introduction & Data Architecture Overview
- Section 2: Environment Setup (Google Colab & SQLite)
- Section 3: Practical Database Design (DDL / Normalization)
- Section 4: Advanced SQL for Complex Extraction (Recursive Queries / Joins)
- Section 5: ETL & Business Logic with Python (Pandas / Numpy)
- Section 6: [Practical] Deployment to AWS Cloud & Architecture Strategy
Stop writing code that “just works.” Join this course to acquire practical, field-ready skills that you can apply immediately to your job.
DOWNLOAD LINK: Mastering Data Infrastructure with Python & SQL for Engineer
Mastering_Data_Infrastructure_with_Python_SQL_for_Engineer.part1.rar – 1000.0 MB
Mastering_Data_Infrastructure_with_Python_SQL_for_Engineer.part2.rar – 982.7 MB
FILEAXA.COM – is our main file storage service. We host all files there. You can join the FILEAXA.COM premium service to access our all files without any limation and fast download speed.
