ETL and ELT in PostgreSQL
With Sarah Conway Schnurr
Liked by 282 users
Duration: 38m
Skill level: Beginner
Released: 9/26/2022
Course details
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.
Skills you’ll gain
Earn a sharable certificate
Share what you’ve learned, and be a standout professional in your desired industry with a certificate showcasing your knowledge gained from the course.
LinkedIn Learning
Certificate of Completion
-
Showcase on your LinkedIn profile under “Licenses and Certificate” section
-
Download or print out as PDF to share with others
-
Share as image online to demonstrate your skill
Meet the instructor
Learner reviews
-
-
-
Hansley Tah
Hansley Tah
Senior PostgreSQL / Oracle & SQL Server DBA: AWS Certified SAA | Performance Tuning | Database Design, Security, Optimization & Automation | Data…
Contents
What’s included
- Practice while you learn 1 exercise file
- Test your knowledge 4 quizzes
- Learn on the go Access on tablet and phone