Mô tả

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:

  1. 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.

  2. 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.

  3. 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.

Bạn sẽ học được gì

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

Yêu cầu

  • No prerequisites except high motivation!

Nội dung khoá học

3 sections

Python Basics For Data Engineers

50 lectures
Welcome!
04:48
Course Structure
02:33
Course Structure
00:39
Getting Started
17:10
Data Types
11:04
Strings
02:03
Integers
01:39
Conditional Statements
15:54
Lists
11:10
Exploring Lists in Python
04:40
Functions
07:46
Find the Maximum
1 question
Basic String Manipulation
1 question
Even or Odd
1 question
Calculate the Factorial
1 question
Loops
08:05
Tuples
02:37
Sets
01:48
Find Unique Elements
1 question
Reverse a String
1 question
Calculate Sum of Digits
1 question
Check Palindrome
1 question
Fibonacci Series
1 question
Find the Nth Fibonacci Number
1 question
Check for Prime Numbers
1 question
Count Primes
1 question
Calculate Average
1 question
Count Occurrences in a List
1 question
Find the Missing Number
1 question
Find Common Elements in Two Lists
1 question
Remove Duplicates from a List
1 question
Count Occurrences of a Word
1 question
Check Balanced Parentheses
1 question
OOP Basics
07:44
Introduction to Object-Oriented Programming (OOP)
01:42
Find the Maximum Class Edition
1 question
Implement a Stack
1 question
Implement a Queue
1 question
Find The Closest Number
1 question
Find the Longest Consecutive Subsequence
1 question
Merge Sorted Lists
1 question
Jupyter Notebook
07:23
Pandas Introduction
10:44
DataFrame and Series in Pandas
01:46
Filtering in Pandas
01:37
Pandas GroupBy and Aggregation
01:57
Moving Averages in Pandas
01:43
Data Manipulation
3 questions
Interview Prep: Data Manipulation (Hard)
6 questions
Article: Integrating Pandas with Matplotlib
01:39

SQL and Databases

20 lectures
Install Postgres
05:03
Relational Database Management Systems (RDBMS)
03:17
SQL Fundamentals
08:45
SELECT and WHERE
01:41
User Count Above 50
1 question
Order Analysis
1 question
Employee Database Query
1 question
Sales Analysis
1 question
WITH statement
02:09
Employee Salary Analysis
1 question
UNION and UNION ALL
01:53
Product Inventory Analysis
1 question
Customer Purchase Analysis
1 question
Order Analysis
1 question
Student Grades Analysis
1 question
Product Category Analysis
1 question
Order Date Analysis
1 question
Launch Date Analysis
1 question
NoSQL Databases
02:42
Streaming Data Introduction
04:11

API Usage

6 lectures
What is an API
02:33
GET Request
01:26
POST Request
01:31
Postman
04:27
Extract Data
13:57
Interview Prep: ETL
4 questions

Đánh giá của học viên

Chưa có đánh giá
Course Rating
5
0%
4
0%
3
0%
2
0%
1
0%

Bình luận khách hàng

Viết Bình Luận

Bạn đánh giá khoá học này thế nào?

image

Đăng ký get khoá học Udemy - Unica - Gitiho giá chỉ 50k!

Get khoá học giá rẻ ngay trước khi bị fix.