ETL process | Data ingestion #dataanalysis #education #python #interview #pandas #sql #job

In this video we are doing data ingestion from file to database table.
File present in local system and using python we are ingesting file data into Oracle SQL table.
Here data ingestion divided into 4 steps.
1. Loading data into data frame - 2:18
2. Establishing Database connection - 3:45
3. Creating Table - 6:35
4. Inserting data from Data frame to Database table. - 8:06

Data ingestion also known as ETL process where we Extract, Transform and Load data.

In data ingestion we transporting data from different sources to database so that we can use or analyse that data for further decision making.

// Subscribe MyLearningBook

// For other videos please find below links

# Mathematical Aptitude Lessons

#All about NTA UGC NET June2020

# 5 tricks to solve Time and Distance questions in competitive exam - Part 1

# Super 10 tricks to solve Time and Distance questions in competitive exam - Part 2.

// MyLearningBook

MyLearningBook is an educational platform and here are some benefits to subscribe MyLearningBook.
1. MyLearningBook provides career guidance time to time, which help you to take right decision at right time.
2. MyLearningBook provides study materials for Mathematical aptitudes, UGC NET paper - 1 and Paper - 2 Computer Science Application.
3. MyLearningBook provides old competitive exam papers solutions which help to understand the concept and boost your preparation.

// LALIMA
I'm Lalima and I am passionate about teaching since my college time. Starting an educational YouTube channel is much more than what it seem. It takes time, hard work and lot of learning along the way. Here with the help of MyLearningBook I am just trying to share my knowledge for those who really need it. Hope MyLearningBook is able to provide you right guidance at right time.
:) cheers

[My-Learning-Book]

Hello :)
Hope you would like to know full Data Ingestion (ETL) process, then please watch full video using below link.