Datacamp – Associate Data Engineer in SQL 2024-8

Published on: 2024-08-29 21:52:40

Categories: 28

Descriptions

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!

What you’ll learn

Discover how data engineers lay the groundwork that makes data science possible. No coding involved!
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!
Level up your SQL knowledge and learn to join tables together, apply relational set theory, and work with subqueries.
Learn how to create one of the most efficient ways of storing data – relational databases!