We may earn an affiliate commission when you visit our partners.
Big Data LDN
This course is no longer available. Find something similar by browsing:
ETL
ELT
SQL
Big Data
Data Warehousing
Data Engineering
Data Integration
Register for this course and see more details by visiting:
OpenCourser.com/course/oupy20/from
Traffic lights
Traffic lights
Read about what's good
what should give you pause and
possible dealbreakers
Examines ETL and ELT, which are in demand in industry
Develops knowledge and skills in building a scalable data stack with SQL
Led by an instructor recognized for work in the field
Taught by Big Data LDN, an organization recognized for their work in Big Data
May require significant prior knowledge and experience
Save this course
Create your own learning path.
Save this course to your list so you can find it easily later.
Save
Save
Activities
Coming soon
We're preparing activities for
From ETL to ELT: Building a Scalable Data Stack with SQL.
These are activities you can do either before, during, or after a course.
Career center
Learners who complete From ETL to ELT: Building a Scalable Data Stack with SQL will develop knowledge and skills
that may be useful to these careers:
Data Integration Specialist
Data Integration Specialist
Data Integration Specialists build and maintain the systems that move data from one system to another. Learning how to design and implement an ELT process with SQL will be essential to your success. This course will enable you to be a more effective Data Integration Specialist. You will learn the key differences between ETL and ELT. You will also be able to describe a case in which you would use ETL over ELT.
Data Analyst
Data Analyst
Data Analysts need to be able to transform data from various sources. Learning how to design and implement an ELT process with SQL will be essential to your success. This course will enable you to be a more effective Data Analyst. You will learn the key differences between ETL and ELT. You will also be able to describe a case in which you would use ETL over ELT.
ETL Developer
ETL Developer
ETL Developers build and maintain the pipelines that transform data. Learning how to design and implement an ELT process with SQL will be essential to your success. This course will enable you to be a more effective ETL Developer. You will learn the key differences between ETL and ELT. You will also be able to describe a case in which you would use ETL over ELT.
Data Engineer
Data Engineer
Data Engineers build and maintain the pipelines that transform data. Learning how to design and implement an ELT process with SQL will be essential to your success. This course will enable you to be a more effective Data Engineer. You will learn the key differences between ETL and ELT. You will also be able to describe a case in which you would use ETL over ELT.
Data Warehouse Architect
Data Warehouse Architect
As a Data Warehouse Architect, you will be designing and building scalable data stacks. This course will give you the foundation you need to apply SQL. You will learn about the key differences between ETL and ELT. You will also be able to describe a case in which you would use ETL over ELT. This course gives you a practical skillset that will help you succeed in this role.
Big Data Engineer
Big Data Engineer
Big Data Engineers work with very large datasets. Learning how to design and implement an ELT process with SQL will be essential to your success. This course will enable you to be a more effective Big Data Engineer. You will learn the key differences between ETL and ELT. You will also be able to describe a case in which you would use ETL over ELT.
Data Architect
Data Architect
Data Architects work with other technical professionals to design the databases that will underpin various systems. Learning how to design and implement a scalable data stack with SQL will be essential to your success. This course will enable you to be a more effective Database Architect. You will learn the key differences between ETL and ELT. You will also be able to describe a case in which you would use ETL over ELT.
ETL Architect
ETL Architect
ETL Architects design and build the pipelines that transform data. Learning how to design and implement an ELT process with SQL will be essential to your success. This course will enable you to be a more effective ETL Architect. You will learn the key differences between ETL and ELT. You will also be able to describe a case in which you would use ETL over ELT.
Database Architect
Database Architect
Database Architects work with other technical professionals to design the databases that will underpin various systems. Learning how to design and implement a scalable data stack with SQL will be essential to your success. This course will enable you to be a more effective Database Architect. You will learn the key differences between ETL and ELT. You will also be able to describe a case in which you would use ETL over ELT.
Database Administrator
Database Administrator
Database Administrators may need to be able to design and implement an ELT process. Learning how to do this with SQL will be essential to your success. This course will enable you to be a more effective Database Administrator. You will learn the key differences between ETL and ELT. You will also be able to describe a case in which you would use ETL over ELT.
Information Architect
Information Architect
Information Architects can benefit from learning how to implement an ELT process with SQL. This course will enable you to be a more effective Information Architect. You will learn the key differences between ETL and ELT. You will also be able to describe a case in which you would use ETL over ELT.
Enterprise Architect
Enterprise Architect
Enterprise Architects may need to be able to design and implement an ELT process. Learning how to do this with SQL will be essential to your success. This course will enable you to be a more effective Enterprise Architect. You will learn the key differences between ETL and ELT. You will also be able to describe a case in which you would use ETL over ELT.
Data Scientist
Data Scientist
Data Scientists often must analyze data from various sources. Learning how to design and implement an ELT process with SQL may be useful in your work. This course will enable you to be a more effective Data Scientist. You will learn the key differences between ETL and ELT. You will also be able to describe a case in which you would use ETL over ELT.
Business Analyst
Business Analyst
Business Analysts often must analyze data from various sources. Learning how to design and implement an ELT process with SQL may be useful in your work. This course will enable you to be a more effective Business Analyst. You will learn the key differences between ETL and ELT. You will also be able to describe a case in which you would use ETL over ELT.
Software Developer
Software Developer
Software Developers who work with data may need to be able to transform data from various sources. Learning how to design and implement an ELT process with SQL may be useful in your work. This course will enable you to be a more effective Software Developer. You will learn the key differences between ETL and ELT. You will also be able to describe a case in which you would use ETL over ELT.
For more career information including salaries, visit:
OpenCourser.com/course/oupy20/from
Reading list
We've selected seven books
that we think will supplement your
learning. Use these to
develop background knowledge, enrich your coursework, and gain a
deeper understanding of the topics covered in
From ETL to ELT: Building a Scalable Data Stack with SQL.
Provides a deep dive into the architectural patterns and design principles for building data-intensive applications at scale.
Provides a comprehensive guide to the data warehouse lifecycle, including planning, design, implementation, and maintenance.
Introduces agile principles and practices to data warehousing, providing guidance on delivering data solutions more effectively.
Provides practical techniques for implementing ETL processes, making it a valuable resource for those new to data integration.
Provides hands-on experience with building scalable data pipelines, covering data streaming, pipeline design, and monitoring.
Provides practical guidance on optimizing SQL Server performance for both OLTP and data warehousing scenarios.
Provides a practical guide to data integration, covering techniques and tools for combining data from multiple sources.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/oupy20/from
Share
Similar courses
Similar courses are unavailable at this time. Please try again later.
Via
Pluralsight
Instructor
Big Data LDN
This course belongs to a
collection
called
Big Data LDN 2019 . It's comprised of 101 courses:
- The Database Is Only Half Done
- Your AI Is Wrong! Lessons from Decision-making with Imperfect AI
- Multiparadigm Data Science: The Next Frontier in Decision Making
- Achieving 100% Adoption of Analytics in the Enterprise
- Data Skills: How Mondi Does Digital
- Building a Modern Data Architecture for the Data Driven Enterprise
- Harnessing the Power of Data to Improve Public Health
- Real-time Data Analytics at Scale Using Cloud Services
- Quick and Easy Access to Data through a Logical Data Warehouse Environment
- The Promise of Data Mastering at Scale
- Research vs. Reality in AI: Would You Trust Your Model with Your Life?
- Modernise Your IT Infrastructure for AI
- Scaling Machine Learning at Holiday Extras
- Why Do Some Machine Learning Models Fail?
- AI: Lessons Learned from the Front Line
- Machine Learning in Real-time: Predicting Taxi Fare in NYC
- How AI and Automated Machine Learning Will Disrupt the Organisational Alignment of Businesses
- Multi-model Powered Machine Learning
- ML in Production: Serverless and Painless
- Leveraging Data Virtualization to Maximize Advanced Analytics and Machine Learning Potential in Your Data Architecture
- Bring the Power of Watson to AWS and Azure: Watson Anywhere Powered by Cloud Pak for Data
- Modern Data Warehousing at Scale Using Azure Data Factory
- Balancing Performance, Scalability, and High Availability in Your Database Environment
- Enabling Microservices for Big Data On-demand in the Cloud
- From ETL to ELT: Building a Scalable Data Stack with SQL (viewing)
- Data, Governance, and Freedom
- How to Get the Technology Stack Right for Your Business
- Data Modelling with Apache Cassandra
- How to Orchestrate Your ML Pipelines in Hybrid Cloud
- Full Stack Metadata Driven Thinking to Drive Business Agility
- Enhance Developer Experience Using OpenShift on Azure
- Fast Data for Faster Business
- Driving Faster, Smarter Actions on IoT Data with New Real-time Analytics Capabilities
- Introduction to Adept and How Big Data and Analytics Is Transforming the Connected Car Ecosystem
- Bridge to Cloud
- How to Train Your AI Models at Scale
- 99% of Your IoT Data Is Worthless, but Which 99%?
- Data Engineering in MagicLab: The Birth and Life of an Event
- RNA - Event Stream Processing Made Simple
- When Data Leads, Transformation Follows - A Look at Qlik's Data Integration Portfolio
- Saving Energy in Homes with a Unified Approach to Data and AI
- Building Stream Processing Applications with Apache Kafka Using KSQL
- Real-world, Real-time Digital Transformation
- Machine Data in Industry 4.0: How to Handle It Better
- Why CockroachDB in the Kindred Platform?
- The Hardest Part of AI & Analytics Is Not AI, It Is Data Management
- Effective Cloud Migration Strategies for Your Modern Data Applications
- Snowflake? Why Should I Care?
- The Future of Business Intelligence Isn't a Tool
- AI-driven Retail for the 21st Century
- The Next Generation of Data Architecture
- Modern Enterprise Data Engineering
- Taking Control of User Analytics with Snowplow
- Flex Your Data(Ops) Muscles
- You Love Big Data, so Does R
- Building Predictive Maintenance Solutions
- Quickly, Codelessly Connect Any Application to Any REST API
- Rethinking Data Warehouse Modernization in the Age of Hybrid Cloud/On-premise Data Warehouses
- From Waterfall to Agile – A Data Warehouse Modernisation Story
- Freeing up Engineering and Infrastructure Resources to Scale with DataOps
- Unit Testing with pytest
- Credit Card Fraud – Why the Database Matters
- Data Science at SEGA
- British Telecom: Data-driven Digital Transformation
- Using Cloud Solution Platforms to Drive Business Value and Cost Optimization
- Data Analytics & IoT Innovations at Bosch
- Converting the CDO to a Profit Centre
- Why Self-service Data Analytics Usually Fails & Ideas for Succeeding
- Governed Data Discovery
- Journey to Create a Great Analytic Culture
- Something Amazing for Everyone: Embracing Inclusive Design to Deliver Accessible Experiences
- Democratising Data – How We Built a Self-serve Data Platform
- Discover the “Why” You Didn't Know Existed
- Selecting Your Fantasy Premier League Team with Advanced Analytics
- Decouple Storage from Compute
- Data Skills: Building a Data Team Fit for a Data-driven Enterprise
- Consent, Compliance, and the Impact on Customer Experience
- AI & Communication: Meaningful Data from New Sources
- Real-time Personalised Customer Interaction at Scale
- Data: The Musical, with LW Theatres
- Self-service and Tableau Community at Lloyds Banking Group
- The Digital Hero’s Journey: Using Big Data to Uncover Business Value and Meaning at Work
- Using Location Intelligence to Place Solar Panels in Rwanda
- Embedding Intelligence into the Heart of Customer Operations
- The Art of Customer Conversations
- How to Build a Fully Autonomous Card Fraud Detection System
- At Last! The Real-time Customer Experience
- Data Privacy Mythbusting
- Demystifying Data – What They Don’t Tell You at Data School
- Optimizing Your Data Value Chain with Agile Data Management
- Data at SEGA Europe
- Keep Your Data Lake from Getting Hadooped
- Top 10 Privacy Tips & Tricks in Big Data
- Data Governance as a Customer Service
- 7 AI Quick Win Projects
- Delivering Value with Intelligent Data Governance
- The Culture Competition – Personalisation vs. Privacy
- DataOps for AI and Digital Transformation
- Big Data LDN: A GDPR Retrospective
- GDPR: A Sword Not a Shield
- Drive Business Growth While Satisfying GDPR and CCPA
Our mission
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
Affiliate disclosure
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.
© 2016 - 2025 OpenCourser