Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Data Engineering for Beginners with Python and SQL
Rating: 4.1 out of 5(1,429 ratings)
12,911 students

Data Engineering for Beginners with Python and SQL

From Novice to Data Engineer: Master Python and SQL for Data Processing
Created byKiril Spiridonov
Last updated 3/2025
English

What you'll learn

  • Python Fundamentals
  • Variables, data types, and operators
  • Control flow (if statements, loops, etc...)
  • SQL Queries
  • Working with JSON and CSV data
  • Reading and writing files
  • Using libraries like requests to make HTTP requests
  • How to build functions and think like engineers
  • Data Cleaning and Transformation
  • Database Fundamentals (PostgreSQL)
  • Creating and managing databases and tables
  • Introduction to Postman
  • Testing RESTful APIs
  • Understanding what an API is
  • Retrieving data from an API

Coding Exercises

This course includes our updated coding exercises so you can practice your skills as you learn.

See a demo
Image of coding exercise example

Course content

3 sections • 39 lectures • 3h 16m total length

  • Welcome!4:48
  • Course Structure2:33
  • Course Structure (Quick Reading)0:39
  • Getting Started17:10

    This lecture will help you get started and understand programming as a concept.

  • Data Types11:04

    Here you will learn about basic data types in Python

  • Strings (Quick Reading)2:03
  • Integers (Quick Reading)1:39
  • Conditional Statements15:54
  • Lists11:10
  • Exploring Lists in Python (Quick Reading)4:40
  • Functions7:46
  • How to complete a coding exercise?5:22
  • Find the Maximum
  • Basic String Manipulation
  • Even or Odd
  • Calculate the Factorial
  • Loops8:05
  • Tuples2:37
  • Sets (Quick Reading)1:48
  • Find Unique Elements
  • Reverse a String
  • Calculate Sum of Digits
  • Check Palindrome
  • Fibonacci Series
  • Find the Nth Fibonacci Number
  • Check for Prime Numbers
  • Count Primes
  • Calculate Average
  • Count Occurrences in a List
  • Find the Missing Number
  • Find Common Elements in Two Lists
  • Remove Duplicates from a List
  • Count Occurrences of a Word
  • Check Balanced Parentheses
  • OOP Basics7:44
  • Introduction to Object-Oriented Programming (OOP)1:42
  • Find the Maximum Class Edition
  • Implement a Stack
  • Implement a Queue
  • Find The Closest Number
  • Find the Longest Consecutive Subsequence
  • Merge Sorted Lists
  • Jupyter Notebook7:23
  • Pandas Introduction10:44
  • DataFrame and Series in Pandas1:46
  • Filtering in Pandas1:37
  • Pandas GroupBy and Aggregation1:57
  • Moving Averages in Pandas1:43
  • Data Manipulation
  • Interview Prep: Data Manipulation (Hard)
  • Article: Integrating Pandas with Matplotlib1:39

Requirements

  • No prerequisites except high motivation!

Description

Are you ready to embark on a journey into the world of data engineering? Welcome to "Data Engineering for Beginners with Python and SQL" – the course that will empower you to build a strong foundation in data engineering, regardless of your prior experience.


In today's data-driven world, the demand for skilled data engineers is soaring, and this course is designed to help you seize the opportunities this field has to offer. Whether you're an aspiring data professional, a business analyst, or simply curious about the intricacies of data processing, this course is your gateway to acquiring the essential skills.


What You'll Learn:

  • SQL Mastery: Dive headfirst into SQL (Structured Query Language), the cornerstone of data management. You'll learn how to manipulate and query data effectively, ensuring you have a solid grasp of this fundamental skill.

  • Python: Explore the power of Python for data engineering and not only. We'll cover the basics and take you on a journey through Python possibilities.

  • ETL (Extract, Transform, Load) Processes: Gain insights into ETL processes, a critical component of data engineering. Discover how to efficiently extract data from various sources, transform it to meet your needs, and load it into target systems.


Course Highlights:

  • Materials and Exercises: This course focuses on practical learning. We believe in the "learn by doing" philosophy, so you'll find a wealth of materials and hands-on exercises to reinforce your knowledge.

  • Comprehensive Resources: Access a comprehensive collection of resources, including coding examples and reference materials to aid your learning journey.

  • Minimal Video, Maximum Learning: We understand the value of your time. While there will be instructional videos, engaging exercises and resources will be emphasized, allowing you to learn at your own pace.


Important: In this engineering course, it's all about how you think and problem-solve. Instead of just watching videos and copying them, the focus is on finding the right information and using it to tackle tasks. Learning how to think is a crucial part of the process. Feel free to ask questions under each exercise or message the instructor directly. Expect a response within 24 hours.

Who this course is for:

  • Aspiring Data Engineers
  • Data Enthusiasts
  • Programming Novices
  • SQL Beginners
  • Career Switchers
  • Students and Recent Graduates
  • Business Analysts
  • Entrepreneurs and Start-up Founders
  • Self-Learners
  • Professionals Seeking Data Skills

Report abuse