Apache Airflow on Linux - VM: Oracle Cloud Infrastructure

Apche Airflow on Linux (VM) using Oracle Cloud Infrastructure includes task trigger on Autonomous Oracle DB task extract

3.00 (3 reviews)
Udemy
platform
English
language
Software Engineering
category
Apache Airflow on Linux - VM: Oracle Cloud Infrastructure
20
students
4 hours
content
Nov 2022
last update
$44.99
regular price

What you will learn

Provisioning Oracle Linux Virtual Machine - environment though Oracle Cloud infrastructure

Apache Airflow Installation on Oracle Linux and operating the task scheduling through DAG

Provisioning Autonomous Oracle Database on OCI

Accessing Autonomous Oracle Database though Client (sqlplus) on Linux

DAG - Directed Acyclic Graph programs

DAG program for Data extract from Autonomous Database with Linux / Unix Shell scripting.

Enabling and Provisioning GUI environment in Oracle Linux - Oracle Cloud Infrastructure.

Why take this course?

This course covers three different niche topics on which one can build their technical expertise:

             1. Apache Airflow - Installation and DAG basics & scheduling DAG programs

            2. Linux -VM on Oracle cloud Infrastructure (Provisioning of Oracle Linux - cloud & install Apache airflow & operating it)

            3. Oracle Autonomous Database on Cloud ( Provisioning the DB and understand Data extract through Apache airflow task scheduling).

Note : Since Oracle is offering always free tier option - you can provision Linux VM and Oracle Autonomous DB even after expiry of 30 days free trial and make your learning more effective at any point of time.

Apache Airflow is an open-source  platform to programmatically author, schedule and monitor workflows.

Apache Airflow  is a fully managed workflow orchestration service that empowers you to author, schedule, and monitor pipelines that span across clouds and on-premises data centers.  Apache Airflow open source project and operated using the Python programming language.

Apache Airflow pipelines are configured as directed acyclic graphs (DAGs) using Python, making it easy for users of any experience level to author and schedule a workflow.

With Cloud Computing gaining significance – Virtualization (Virual Machine)  are gaining momentum and re-defining & optimizing Hardware and Software solutions. In this course you would learn about building a cloud virtual environement through Oracle Linux using Oracle cloud - free tier. This course will present you with sequence of steps towards installation of Apache Airflow on Oracle Cloud Infrastructure and then view them through VNC viewer.

Finally, as we would be using Oracle Cloud Infrastructure, one can create Oracle Autonomous Database quite easily and work towards creating a DAG file, which will be scheduled from Apache airflow towards data extract from Oracle Database, through Linux shell scripting task. This is one of the most common use case for Apache Airflow.

Happy Learning!!


Content

Introduction

Course Overview

What is Virtualization in Cloud computing?

What is Virtualization in Cloud computing?

Introduction on Apache Airflow

What is task and why Orchestration is required?
Use case for Apache Airflow
Introduction on Apache Airflow
Quiz 1

Getting Oracle Cloud Free Tier Access

Getting Oracle Cloud free tier access - Part 1
Getting Oracle Cloud free tier access - Part 2

Oracle Cloud - Linux (VM) creation and accessing through SSH

Steps involved in creating Oracle Linux cloud instance and access - Overview
Creating Private and Public key using Putty Gen
Creating compartment and VCN in Oracle Cloud Infra(OCI)
Creating Oracle Linux - Virtual Machine Instance
Connecting to Oracle Linux Virtual instance through SSH - Putty
Using SFTP to transfer files to cloud Linux (VM) instance
Quiz 2

Some Basic command line commands

Basic command line command - Part 1
Basic command line command - Part 2

Apache Airflow Architecture Overiew

Apache Airflow Architecture Overiew
Single Node Vs Multi Node

Installation of Apache Airflow on Oracle Cloud Linux(VM)

Installation of Dependencies
Installation of Apache Airflow
Intiating creation of Apache Airflow DB
Starting Apache Airflow Scheduler and Webserver

Creation of Linux GUI environment and accessing Apache Airflow through VNC

The Need for GUI envirroment
Accessing Oracle Cloud Linux (VM) GUI Overiew
Steps involved in creating Oracle Linux cloud instance and access - Overview
Installation of server GUI and tiger VNC server
Setting VNC access password and configuring VNC service file
Starting VNC server and firewall entries for VNC server
Dowloading tigerVNC client -viewer
SSH client -Putty configuration and port entry
Accessing Oracle Cloud Linux (VM) GUI
Accessing Apache Airflow via VNC viewer
Quiz 3

What's Directed Acyclic Graph (DAG) in Apache Airflow & navigation overiew

What is Directed Acyclic Graph?
DAG Program Structure
Understanding DAG Menu and Navigation

Creating a DAG program with two tasks

Creating DAG program
First Airflow Program Execution
Quiz 4

Data Extract Approach through Autonomous Oracle Database

Data Extract from Database Overview
What is Autonomous Database?

Creating Autonomous Database on Oracle Cloud Infrastrucure

Creating Autonomous Database on Oracle Cloud Infrastrucure - Part 1
Creating Autonomous Database on Oracle Cloud Infrastrucure - Part 2
Accessing Autonomous Database through SQL webclient

Configuring SQL client on Linux instance to access Oracle Autonomous DB

SQL plus client install on Oracle Linux instance
Downloading DB wallet file and accessing autonomous DB
Quiz 5

Modify the DAG script to extract from Database

Extract Program Review
Executing the DAG program

Concluding Remarks

Bonus Lecture

Screenshots

Apache Airflow on Linux - VM: Oracle Cloud Infrastructure - Screenshot_01Apache Airflow on Linux - VM: Oracle Cloud Infrastructure - Screenshot_02Apache Airflow on Linux - VM: Oracle Cloud Infrastructure - Screenshot_03Apache Airflow on Linux - VM: Oracle Cloud Infrastructure - Screenshot_04

Reviews

Kevin
January 27, 2022
I completed this class in 1 week and completed all the labs. Myself: I am having a strong Oracle background (using various of Oracle products for 20 yrs: EBS, APEX, Oracle Big Data; strong Unix background); also already had enough knowledge of Oracle OCI (having free tier account with 2 autonomous db) my main goal for this class: - determine if Apache airflow can be leverage in our Oracle Big Data ecosystem to manage scheduled jobs what I like this course: - learn more about OCI - software installation and configuration under Linux env Things to improve for this class: - quality of the class: you can tell some lectures are cut and pasted from other video into this class: the voice and slide are all different. This is a signal of quality of this class - For anyone who doesn't have a strong Oracle background + Linux/Unix background, you will give up/quit this course in very early beginning. You will stop if you can't get a free tier account of OCI. This class demands lots of skill set: Oracle, Python, Linux, OCI etc - I wish the course has more practical example. Indeed, it teach far less DAG; more focus is on OCI; install Airflow under Linux: more for DBA or DevOps people. I learned quite some good knowledge due to my strong background; if you don't have enough technical background, don't bother to try this class.

Charts

Price

Apache Airflow on Linux - VM: Oracle Cloud Infrastructure - Price chart

Rating

Apache Airflow on Linux - VM: Oracle Cloud Infrastructure - Ratings chart

Enrollment distribution

Apache Airflow on Linux - VM: Oracle Cloud Infrastructure - Distribution chart
3684628
udemy ID
12/6/2020
course created date
12/18/2020
course indexed date
Bot
course submited by