Leverage AWS, Airbyte, ElephantSQL, and Metabase for the ELT of CSV into Postgres than explore data with SQL
What you will learn
Creating AWS Instances
Introduction to Unix Command Line
Installing Docker Images
Loading CSV data to Postgres using Airbyte
Introduction to SQL in Metabase
Why take this course?
π Master DataOps with the ELT Stack: No Code Introduction π
Course Overview:
This course is designed to equip you with hands-on experience in the realm of Data Engineering. DataOps Tech Stack – No Code Introduction to ELT and SQL will guide you through an array of concepts and tools that are essential for any aspiring or practicing Data Engineer. With a focus on AWS, Airbyte, ElephantSQL, and Metabase, you’ll learn how to transform CSV files into actionable insights in Postgres.
What You’ll Learn:
- π« AWS Basics: Create and manage AWS instances with confidence.
- π Unix Command Line Introduction: Navigate and manipulate your system like a pro.
- π¨ Docker Installation: Master the setup of Docker images for robust environments.
- βοΈ Data Import with Airbyte: Learn to load CSV data into Postgres using this powerful ELT tool.
- π SQL in Metabase: Discover how to query and visualize your data effortlessly.
Course Highlights:
- π₯ Hands-On Demos with Medium Articles: Follow along with step-by-step walkthroughs of detailed guides.
- π Background Demos: Get equipped to handle demos by understanding the tools and processes, including Docker, EC2, SSH Keys, etc.
- π ELT Data Sources: Transform data using SQL to build meaningful datasets.
- π Build a Data Project: Put your knowledge into practice with a hands-on project that showcases your new skills.
Instructor’s Background:
Tom Silverstrim brings over 20 years of experience in creating innovative products, particularly in HTTP-based distributed client architectures. His recent work has been centered around AdTech and MarTech, including incentivized mobile apps, real-time programmatic bidding, and customer data platforms. Currently, Tom is focused on simplifying the operation and management of large-scale customer data platform projects through tooling that combines end-to-end customer success insight, DataOps principles, and continuous improvement.
As a leader, Tom has guided a team of Full Stack developers, Data Engineers, and UI Engineers in building tooling using React, Java service layer, and Azure data stack. His expertise spans analytics, anomaly detection with statistical and machine learning, data lineage, and streaming data (pipelines, HTTP, etc.).
Collaborative Journey:
Osvaldo Valedez, my daughter’s Python instructor, shared an interest in DataOps and has recently graduated from UC Berkeley. Together, we are exploring various Data Engineering products and have assembled these tutorials to support others on their journey into the world of DataOps.
Additional Support:
To ensure you get the most out of this course, personalized coaching and training sessions are available for 1:1 help. Whether you’re a beginner or looking to refine your skills, we’ve got you covered.
Embark on your DataOps journey today and transform data into actionable insights with the DataOps Tech Stack – No Code Introduction to ELT and SQL course. Let’s turn complex datasets into clear, understandable information that can drive decision-making and strategy in real-time! π