Skip to main content
HomeSQL

track

Associate Data Engineer in SQL

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

Included withPremium or Teams

SQLData Engineering30 hours33,123

Create Your Free Account

GoogleLinkedInFacebook

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.
Group

Training 2 or more people?

Try DataCamp for Business

Loved by learners at thousands of companies

Certification badge

Certification Available

By

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

Included with Premium
Included with PremiumLearn more

Track Description

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!

Prerequisites

There are no prerequisites for this 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.

  • Course

    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

    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

    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 courses
Track
Complete

Earn Statement of Accomplishment

Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance review

Included withPremium or Teams

Enroll now

Join over 15 million learners and start Associate Data Engineer in SQL today!

Create Your Free Account

GoogleLinkedInFacebook

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.