Associate Data Engineer in SQL

Zaktualizowano 03.2026

Learn the fundamentals of data engineering: database design and data warehousing, working with technologies including PostgreSQL and Snowflake!

Utwórz bezpłatne konto

Lub

Kontynuując, akceptujesz nasze Warunki korzystania, naszą Politykę prywatności oraz fakt, że Twoje dane są przechowywane w USA.

Certification Available

Przez

Industry recognized certifications help you stand out and prove your skills. Prepare for certification by completing this track.

Included with Premium

Included with PremiumDowiedz Się Więcej

Opis utworu

Associate Data Engineer in SQL

In this track, you'll learn the fundamental concepts of data engineering, including the Extract-Transform-Load (ETL) and Extract-Load-Transform (ELT) workflows. You'll discover how to interact with relational databases such as PostgreSQL to store, modify, and query data. Moving through the track, you'll pick up techniques for querying structured data using SQL, including joining multiple tables, calculating aggregated statistics, filtering, grouping, and writing subqueries. Switching gears, you'll go on to discover database design principles such as star and snowflake schemas, and normalization. You'll use this knowledge to perform typical data engineering tasks such as creating, altering, and deleting tables, and enforcing data consistency by casting data to different data types. The track also shows how you can download PostgreSQL to your operating system, along with setting up and modifying users.Conclude by learning about data warehouse technologies and familiarizing with Snowflake, a popular cloud technology for data engineering!

Wymagania wstępne

Nie ma żadnych wymagań wstępnych dla tego toru

Course
1
Understanding Data Engineering
Discover how data engineers lay the groundwork that makes data science possible. No coding involved!
Course
AI Native
2
Introduction to SQL
Learn how to create and query relational databases using SQL in just two hours.
Course
AI Native
3
Intermediate SQL
Accompanied at every step with hands-on practice queries, this course teaches you everything you need to know to analyze data using your own SQL code today!
Course
4
Joining Data in SQL
Level up your SQL knowledge and learn to join tables together, apply relational set theory, and work with subqueries.
Project
premia
Analyzing Students' Mental Health
Use your data manipulation skills to perform exploratory data analysis on a dataset around student mental health.
Course
6
Introduction to Relational Databases in SQL
Learn how to create one of the most efficient ways of storing data - relational databases!
Course
7
Database Design
Learn to design databases in SQL to process, store, and organize data in a more efficient way.
Course
8
Data Warehousing Concepts
This introductory and conceptual course will help you understand the fundamentals of data warehousing.
Course
9
Introduction to Snowflake SQL
This course will take you from Snowflake's foundational architecture to mastering advanced SnowSQL techniques.
Course
10
Understanding Data Visualization
An introduction to data visualization with no coding involved.
Project
premia
Exploring London's Travel Network
Use SQL to analyze a database containing information about Transport for London journeys over 12 years!
Resource
premia
How to Install PostgreSQL on Windows and Mac OS X
In this tutorial, you will learn how to install PostgreSQL on two different operating systems - Windows and Mac.
Skill Assessment
premia
Data Management Theory

Associate Data Engineer in SQL

9 courses

Utwór
ukończony

Zdobądź oświadczenie o osiągnięciach

Dodaj te dane uwierzytelniające do swojego profilu na LinkedIn, CV lub życiorysu
Udostępnij w mediach społecznościowych i w swojej ocenie okresowej

W zestawiePremia or Zespoły

Zapisz Się Teraz

Dołącz do nas 19 milionów uczniów i zacznij Associate Data Engineer in SQL już dziś!

Utwórz bezpłatne konto

Lub

Kontynuując, akceptujesz nasze Warunki korzystania, naszą Politykę prywatności oraz fakt, że Twoje dane są przechowywane w USA.

Certification Available

Opis utworu

Associate Data Engineer in SQL

Zdobądź oświadczenie o osiągnięciach

Dołącz do nas .css-nklxlk{color:var(--wf-brand--main, #03EF62);} 19 milionów uczniów i zacznij Associate Data Engineer in SQL już dziś!

Utwórz bezpłatne konto

Dołącz do nas 19 milionów uczniów i zacznij Associate Data Engineer in SQL już dziś!