Data Engineering For Beginners With Python And Sql
Published 9/2023
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 945.02 MB | Duration: 2h 46m
Published 9/2023
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 945.02 MB | Duration: 2h 46m
From Novice to Data Engineer: Master Python and SQL for Data Processing
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
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.
Overview
Section 1: Python Basics For Data Engineers
Lecture 1 Welcome!
Lecture 2 Getting Started
Lecture 3 Data Types
Lecture 4 Strings
Lecture 5 Integers
Lecture 6 Conditional Statements
Lecture 7 Lists
Lecture 8 Exploring Lists in Python
Lecture 9 Functions
Lecture 10 Loops
Lecture 11 Tuples
Lecture 12 Sets
Lecture 13 OOP Basics
Lecture 14 Introduction to Object-Oriented Programming (OOP)
Lecture 15 Jupyter Notebook
Lecture 16 Pandas Introduction
Section 2: SQL and Databases
Lecture 17 Install Postgres
Lecture 18 Relational Database Management Systems (RDBMS)
Lecture 19 SQL Fundamentals
Lecture 20 SELECT and WHERE
Lecture 21 WITH statement
Lecture 22 UNION and UNION ALL
Lecture 23 NoSQL Databases
Section 3: API Usage
Lecture 24 What is an API
Lecture 25 GET Request
Lecture 26 POST Request
Lecture 27 Postman
Lecture 28 Extract Data
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