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.
Learn More- Explore Careers
- Agriculture, Sustainability and Natural Sciences
- Arts, Communications and Marketing
- Business, Management and Administration
- Computer Science and Information Technology
- Education
- Engineering and Manufacturing
- Finance
- Government, Law and Public Administration
- Health and Wellness
- Hospitality and Tourism
- Human Services
- Sciences
- Find Jobs
- Get Experience
- Discover Resources
- Labor Market Insights