Skip to main content
HomeSQLAssociate Data Engineer
career track

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!

SQLClock30 hoursLearn9 coursesApply2 projectsTrophyStatement of Accomplishment

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.
GroupTraining 2 or more people?Try DataCamp For Business

Loved by learners at thousands of companies


1
Theory
Understanding Data Engineering

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

2 hours

Hadrien Lacroix Headshot

Hadrien Lacroix

Curriculum Manager at DataCamp

Sparkles AI ASSISTANTSign up to use the AI AssistantOur AI assistant is free to use for all registered users. Sign up or login to access the assistant and boost your learning experience.
Discover
For Business

GroupTraining 2 or more people?

Get your team access to the full DataCamp library, with centralized reporting, assignments, projects and more
Try DataCamp for BusinessFor a bespoke solution book a demo.

Instructors

  • Hadrien Lacroix Headshot
    Hadrien LacroixCurriculum Manager at DataCampSee Hadrien Lacroix's Portfolio
  • Izzy Weber Headshot
  • Jasmin Ludolf Headshot
  • Maham Khan Headshot

Join over 13,890,000 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.