Udemy - Mastering Data Infrastructure with Python and SQL for Eng...
- Category Other
- Type Tutorials
- Language English
- Total size 1.9 GB
- Uploaded By freecoursewb
- Downloads 63
- Last checked 3 hours ago
- Date uploaded 13 hours ago
- Seeders 1
- Leechers 47
Infohash : 4A06DB66A95ECC998B2C6C28DD43D9728E895FE7
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).
Files:
[ WebToolTip.com ] Udemy - Mastering Data Infrastructure with Python and SQL for Engineer- Get Bonus Downloads Here.url (0.2 KB) ~Get Your Files Here ! 1 - Introduction
- 1. Introduction.mp4 (50.4 MB)
- 2. Course Materials.html (0.9 KB)
- 2. Course Materials_Resource_SQL RobotX v1 0 0 pdf.pdf (8.2 MB)
- 3. Course Introduction.mp4 (58.8 MB)
- 4. The Limitations of Excel.mp4 (56.1 MB)
- 5. Fundamentals of Database.mp4 (47.9 MB)
- 10. [Hands on] Google Colab and Initial Settings.mp4 (53.6 MB)
- 10. [Hands on] Google Colab and Initial Settings_Resource_Section2 manual md.md (2.4 KB)
- 10. [Hands on] Google Colab and Initial Settings_Resource_m bom csv.csv (0.2 KB)
- 10. [Hands on] Google Colab and Initial Settings_Resource_m item csv.csv (0.3 KB)
- 10. [Hands on] Google Colab and Initial Settings_Resource_m purchase price csv.csv (0.3 KB)
- 10. [Hands on] Google Colab and Initial Settings_Resource_t inventory csv.csv (0.1 KB)
- 6. Google Colab.mp4 (28.4 MB)
- 7. SQLite.mp4 (25.0 MB)
- 8. ROBOT X.mp4 (51.1 MB)
- 9. Python Libraries.mp4 (43.7 MB)
- 11. ER Diagrams.mp4 (19.0 MB)
- 12. [Hands on] ER Diagrams.mp4 (20.6 MB)
- 12. [Hands on] ER Diagrams_Resource_Section3 manual md.md (8.0 KB)
- 13. Normalization.mp4 (35.9 MB)
- 14. [Hands on] Normalization.mp4 (22.3 MB)
- 15. SQL and DDL.mp4 (32.3 MB)
- 16. Composite Primary Keys.mp4 (16.0 MB)
- 17. Foreign Keys.mp4 (11.8 MB)
- 18. Python Libraries.mp4 (11.4 MB)
- 19. [Hands on] DDL Primary Keys and Foreign Keys.mp4 (116.7 MB)
- 20. DML.mp4 (64.9 MB)
- 21. [Hands on] DML.mp4 (42.1 MB)
- 21. [Hands on] DML_Resource_Section4 manual md.md (7.5 KB)
- 22. JOIN.mp4 (35.7 MB)
- 23. [Hands on] JOIN.mp4 (40.0 MB)
- 24. Recursive Queries.mp4 (47.6 MB)
- 25. [Hands on] Recursive Queries.mp4 (34.9 MB)
- 26. Aggregation.mp4 (23.5 MB)
- 27. [Hands on] Aggregation.mp4 (77.2 MB)
- 28. Inventory Calculations.mp4 (33.1 MB)
- 29. [Hands on] Inventory Calculations.mp4 (58.8 MB)
- 30. Window Functions.mp4 (47.9 MB)
- 31. [Hands on] Window Functions.mp4 (38.9 MB)
- 32. Extract.mp4 (19.8 MB)
- 33. [Hands on] Extract.mp4 (32.1 MB)
- 33. [Hands on] Extract_Resource_Section5 manual md.md (6.2 KB)
- 34. Transform.mp4 (24.2 MB)
- 35. [Hands on] Transform.mp4 (33.1 MB)
- 36. Business Logic.mp4 (21.1 MB)
- 37. [Hands on] Business Logic.mp4 (47.8 MB)
- 38. Load.mp4 (6.1 MB)
- 39. [Hands on] Load.mp4 (24.4 MB)
- 40. DBaaS.mp4 (41.4 MB)
- 41. Basics of the Cloud.mp4 (77.6 MB)
- 42. Amazon RDS.mp4 (29.2 MB)
- 43. AWS Account Creation.mp4 (162.6 MB)
- 44. Hands on.mp4 (209.3 MB)
- 44. Hands on_Resource_Section6 manual md.md (4.9 KB)
- Bonus Resources.txt (0.1 KB)
There are currently no comments. Feel free to leave one :)
Code:
- udp://tracker.torrent.eu.org:451/announce
- udp://tracker.tiny-vps.com:6969/announce
- http://tracker.foreverpirates.co:80/announce
- udp://tracker.cyberia.is:6969/announce
- udp://exodus.desync.com:6969/announce
- udp://explodie.org:6969/announce
- udp://tracker.opentrackr.org:1337/announce
- udp://9.rarbg.to:2780/announce
- udp://tracker.internetwarriors.net:1337/announce
- udp://ipv4.tracker.harry.lu:80/announce
- udp://open.stealth.si:80/announce
- udp://9.rarbg.to:2900/announce
- udp://9.rarbg.me:2720/announce
- udp://opentor.org:2710/announce