Python and SQL for Data Engineering
This course is part of Data Engineering Foundations.
Master data manipulation techniques using Python and SQL in this comprehensive data engineering course. You'll learn to leverage Python's powerful data structures, create automated scripts for data processing, and work with both SQLite and MySQL databases. The course covers essential web scraping techniques, database management, and practical applications in VSCode. Through hands-on projects and real-world scenarios, you'll develop the skills to efficiently extract, transform, and load data while building a strong foundation in modern data engineering practices.
4.5
Instructors:
English
English
Powered by
What you'll learn
Develop proficiency in manipulating data using Python's built-in data structures
Create automated Python scripts for efficient data processing tasks
Master SQLite database operations including creation, connection, and querying
Implement web scraping techniques to extract and store data from websites
Gain practical experience with MySQL database operations in VSCode
Learn to import and export data across different database systems
Skills you'll gain
This course includes:
PreRecorded video
Graded assignments, exams
Access on Mobile, Tablet, Desktop
Limited Access access
Shareable certificate
Closed caption
Get a Completion Certificate
Share your certificate with prospective employers and your professional network on LinkedIn.
Created by
Provided by
Top companies offer this course to their employees
Top companies provide this course to enhance their employees' skills, ensuring they excel in handling complex projects and drive organizational success.
There are 4 modules in this course
In this comprehensive course, students will master essential data engineering skills using Python and SQL. The curriculum covers fundamental data structures in Python, creating automated scripts for data processing, and working with various database systems including SQLite and MySQL. Students will learn web scraping techniques to extract data from websites and understand how to persist this data in different formats. The course emphasizes practical skills through hands-on exercises in VSCode, teaching students to execute queries, manage databases, and implement efficient data processing workflows. Special attention is given to real-world applications and best practices in data engineering.
Working with Data in Python
Module 1
Python Scripting and SQL
Module 2
Web Scraping using Python
Module 3
Working with MySQL
Module 4
Fee Structure
Individual course purchase is not available - to enroll in this course with a certificate, you need to purchase the complete Professional Certificate Course. For enrollment and detailed fee structure, visit the following: Data Engineering Foundations
Instructor
Adjunct Assistant Professor at Duke University
Dr. Alfredo Deza is an Adjunct Assistant Professor in the Pratt School of Engineering at Duke University, where he teaches courses on machine learning, programming, and data engineering. He has been involved in academia for several years, focusing on innovative teaching methods and practical applications of technology. Dr. Deza co-authored the book Practical MLOps and has published several other works related to Python and machine learning. His teaching includes courses such as Python Bootcamp and advanced data engineering topics, and he actively develops online courses available on platforms like Coursera. In addition to his academic role, Dr. Deza works in developer relations at Microsoft, leveraging his extensive experience in software engineering and cloud computing to enhance educational content and support for students and faculty. He collaborates with various universities worldwide, including Georgia Tech and Carnegie Mellon University, to promote knowledge sharing in the field of technology and data science.
Testimonials
Testimonials and success stories are a testament to the quality of this program and its impact on your career and learning journey. Be the first to help others make an informed decision by sharing your review of the course.
Frequently asked questions
Below are some of the most commonly asked questions about this course. We aim to provide clear and concise answers to help you better understand the course content, structure, and any other relevant information. If you have any additional questions or if your question is not listed here, please don't hesitate to reach out to our support team for further assistance.