DataOps Tech Stack No Code Introduction to ELT and SQL

DataOps Tech Stack – No Code Introduction to ELT and SQL, available at Free, has an average rating of 3.5, with 13 lectures, based on 6 reviews, and has 378 subscribers.

Free Enroll Now

You will learn about Creating AWS Instances Introduction to Unix Command Line Installing Docker Images Loading CSV data to Postgres using Airbyte Introduction to SQL in Metabase This course is ideal for individuals who are Data Analysts on the path to becoming Data Engineers It is particularly useful for Data Analysts on the path to becoming Data Engineers.

Enroll now: DataOps Tech Stack – No Code Introduction to ELT and SQL

Summary

Title: DataOps Tech Stack – No Code Introduction to ELT and SQL

Price: Free

Average Rating: 3.5

Number of Lectures: 13

Number of Published Lectures: 13

Number of Curriculum Items: 13

Number of Published Curriculum Objects: 13

Original Price: Free

Quality Status: approved

Status: Live

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

Who Should Attend

Data Analysts on the path to becoming Data Engineers

Target Audiences

Data Analysts on the path to becoming Data Engineers

This course is a skills based approach to teaching Data Engineering.  Through these courses, the student will be introduced to progressively more complex concepts and exercises commonly encountered by Data Engineers.

Lectures series will cover:

Creating AWS Instances

Intro to Unix Command line

Installing Docker Images

Loading CSV into Postgres using Airbyte

Introduction to SQL in Metabase

The approach is built around:

Hands-on demos leveraging Medium Articles

Video walk-through of the Medium Articles

Background demos to be equipped to tackle demos

How to use Docker, EC2, SSH Keys, …

Leverage data to build the Demo

ELT data sources

Transform the data using SQL

Demonstrate your knowledge building a Data Project

Background on the Instructor:

Tom has been creating innovative products around HTTP-based distributed client architectures for 20+ years.  Recent experience involves AdTech and MarTech including Incentivized Mobile Apps, Real-Time Programmatic Bidding, and Customer Data Platforms.  Currently focused on tooling to simplify operation and management of large scale customer data platform projects.   My experience is the teams, processes, and tooling to iteratively solve complex Service problems. 

Currently, enjoying the challenges of creating tooling which combines end to end customer success insight, principles of DataOps, and managing product through continuous improvement. Proud to lead a team of Full Stack developers, Data Engineers, and UI Engineers constructing tooling using React UI, Java service layer, and Azure data stack. Problem space includes Analytics, Anomaly Detection with Statistical and ML, Data Lineage, and Streaming data (Pipelines, HTTP,).

Osvaldo Valedez was my daughter’s Python instructor who expressed interest in DataOps as a career.  He most recently graduated from University of California Berkeley and is getting started in his software career.  We are working together to explore the different Data Engineering products on the market and assembled these tutorials to help others on the same journey.

As with any new material, coaching and training can help overcome challenges. Tutoring is available for 1:1 help

Course Curriculum

Chapter 1: Introduction to Data Operations (Data Ops)

Lecture 1: Introduction

Chapter 2: Introduction to Cloud Computing

Lecture 1: Setting up your EC2 Instances

Chapter 3: Introduction to Unix Command Line

Lecture 1: Connecting to your EC2 Instance

Chapter 4: Installing Docker Images

Lecture 1: Installing Docker

Lecture 2: Installing Airbyte

Lecture 3: Create an EC2 Snapshot

Lecture 4: Secure the Airbyte Instance

Chapter 5: Loading CSV data to Postgres using Airbyte

Lecture 1: Adding a Source to Airbyte

Lecture 2: Creating a Destination to Airbyte

Lecture 3: Connecting a Source to a Destination in Airbyte

Chapter 6: Introduction to SQL in Metabase

Lecture 1: Elephant SQL Hello World

Lecture 2: Introduction to Metabase

Lecture 3: Data Exploration with Metabase

Instructors

Thomas W Silverstrim
Data Engineer

Rating Distribution

1 stars: 1 votes

2 stars: 1 votes

3 stars: 1 votes

4 stars: 1 votes

5 stars: 2 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!