DATA ENGINEERING · 4 WEEKS · 100 LESSONS
Scripting with Python and SQL for Data Engineering
Learn essential data engineering skills through practical Python scripting and SQL database management. Master web scraping, data processing, and database operations while building real-world data engineering solutions.
Master data engineering fundamentals through hands-on experience with Python and SQL. This comprehensive course covers essential topics including data structures, web scraping, database management with SQLite and MySQL, and efficient data processing techniques. Students will learn to write production-ready scripts, work with various data formats, and build automated data pipelines while implementing industry best practices for data engineering workflows.
01 — What learners say
Real feedback from real learners.
“The Rust Fundamentals course was fantastic for formalizing my base Rust knowledge. It was well-paced for both beginner and experienced developers.”
“The course was incredibly informative and well-structured. I gained practical skills that immediately applied in my work, making it a highly valuable learning experience.”
“The course on AI Fundamentals is not only engaging but also practical. Having worked with AWS before, the way it explained Azure cncepts made switching seamless and easy to grasp.”
“I can say that it's a great series of courses for those who are looking to practical MLOps knowledge.”
“This course got clear videos, exercises, and questions, and there are extra resources too. When you're done, you'll have a solid foundation to dive into topics like DevOps or ML.”
02 — Why this course
What you'll walk away with.
Master data engineering fundamentals through hands-on experience with Python and SQL. This comprehensive course covers essential topics including data structures, web scraping, database management with SQLite and MySQL, and efficient data processing techniques. Students will learn to write production-ready scripts, work with various data formats, and build automated data pipelines while implementing industry best practices for data engineering workflows.
Master Python data structures and implement efficient data processing workflows
Develop automated web scraping solutions using Python libraries and best practices
Build and manage databases using SQLite and MySQL with Python integration
Create production-ready scripts for data extraction, transformation, and loading (ETL)
03 — Syllabus
4 weeks, 100 lessons total.
- Welcome to scripting with python and SQL for data engineering
- Meet your course instructor Alfredo DEZA
- Connect with your instructor
- Meet your supporting instructors kennedy Behrman and NOAH gift
- Course structure and discussion Etiquette
- Overview of key concepts
- Key terms
- Introduction to python scripting and SQL
- Introduction to scripting in python
- Creating a script as a module in python
- Traversing the file system with a script in python
- Minimal python chapter 2 learn to store data
- Key terms
- Introduction to web Scraping using python
- Introduction to Extracting data from Unstructured HTML
- Challenges with web data
- Parsing techniques with Htmlparser
- Parsing HTML with Htmlparser in python
- Key terms
- Introduction to working with mysql
- Introduction to Vscode with mysql
- Connecting to a mysql server
- Recap of Vscode with mysql
- Key terms
04 — For teams
Custom training for your company.
We're ready to deliver this and other courses to your team. We accommodate different requirements and are flexible with seat count.
- +Bulk pricing available
- +Customizable content
- +Ready to start on your schedule
05 — Individual access
Simple, straightforward pricing.
Full platform access — every current and future course — priced so cost isn't what decides whether you learn.
No commitment required. Cancel anytime.