Ga naar de hoofdinhoud
ThuisSQL

Leerpad

Associate Data Engineer in SQL

Bijgewerkt 01-2025
Learn the fundamentals of data engineering: database design and data warehousing, working with technologies including PostgreSQL and Snowflake!
Start Track Gratis

Inbegrepen bijPremium or Teams

SQLData Engineering30 Hr100K+

Maak je gratis account aan

of

Door verder te gaan, ga je akkoord met onze Gebruiksvoorwaarden, ons Privacybeleid en dat je gegevens in de VS worden opgeslagen.
Group

Wil je 2 of meer mensen trainen?

Proberen DataCamp for Business

Populair bij mensen die bij duizenden bedrijven leren

Certificeringsbadge

Certificering beschikbaar

Door

Met certificaten die door de industrie worden erkend, val je op en laat je zien wat je kunt. Bereid je voor op certificering door deze track te volgen.

Inbegrepen bij Premium
Inbegrepen bij PremiumMeer Info

Trackbeschrijving

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!

Wat je nodig hebt

Er zijn geen vereisten voor deze track.

  • Course

    1

    Understanding Data Engineering

    Discover how data engineers lay the groundwork that makes data science possible. No coding involved!

  • Course

    2

    Introduction to SQL

    Learn how to create and query relational databases using SQL in just two hours.

  • Project

    bonus

    Analyzing Students' Mental Health

    Use your data manipulation skills to perform exploratory data analysis on a dataset around student mental health.

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

Associate Data Engineer in SQL
9 Cursussen
Track
voltooid

Verklaring van voltooiing verdienen

Voeg deze kwalificatie toe aan je LinkedIn-profiel, cv of sollicitatiebrief.
Deel het op social media en in je prestatiebeoordeling.

Inbegrepen bijPremium or Teams

Schrijf Je Nu in

Doe mee 18 miljoen leerlingen en begin Associate Data Engineer in SQL Vandaag!

Maak je gratis account aan

of

Door verder te gaan, ga je akkoord met onze Gebruiksvoorwaarden, ons Privacybeleid en dat je gegevens in de VS worden opgeslagen.