ETL and ELT in PostgreSQL

Focused View

Sarah Conway Schnurr

38:37

123 View

01 - Introduction

01 - Introduction to ETL and ELT in PostgreSQL.mp4

01:10

02 - What you should know.mp4

00:59

02 - 1. Data Pipelines

01 - Extract, transform, load (ETL).mp4

03:00

02 - Extract, load, transform (ELT).mp4

02:21

03 - 2. Extract

01 - Extraction methods.mp4

03:31

02 - Extraction tooling.mp4

07:44

04 - 3. Transform

01 - Data transformations.mp4

04:51

02 - SQL transformations.mp4

04:37

05 - 4. Load

01 - Loading methods.mp4

04:00

02 - Load tooling.mp4

02:56

06 - Conclusion

01 - Next steps.mp4

03:28

Description

If you’ve done any work at all with data, you’ve likely encountered many different situations where data needs to be transferred to another location or changed in some way before it can be used. Whether you need to meet security and compliance requirements, provide data insights, or make calculations or translations, some combination of ETL and ELT can be used to get the desired end result. In this course, Sarah Conway provides a high-level overview of ETL (extract, transform, load) and ELT (extract, load, transform) processes. Sarah discusses fundamental differences between ETL and ELT, and describes each step of the processes separately. She also shows demos of various processes in PostgreSQL that would be common for real-world use cases and provides advice on how to decide how to structure your data pipeline for success.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

PostgreSQL

Sarah Conway Schnurr

Instructor's Courses

Senior software engineer, frontend web developer, project manager, technology consultant, IT administrator, technical support engineer, developer advocate, conference organizer, diversity committee chair, program organizer, social media manager, and copy editor are just some of the technical hats I've worn in 10+ years of professional experience working solo as well as in collaboration with hybrid/remote, distributed, & global teams. I have specific extensive experience working in the world of open source and enterprise PostgreSQL in almost all of these roles. Always interactive and engaged externally in developer communities, I've been recognized as being in the top 100 most influential in the database community in 2022 by the Redgate 100. https://www.red-gate.com/hub/redgate-100/ For a personal look into who I am and my involvement in the open source community, check out my interview featured in #PostgresFriends “PostgreSQL Person of the Week”. https://postgresql.life/post/sarah_conway_schnurr/

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.