All Courses Python Courses

Essential Data Science: Database and ETL With Python

Essential Data Science: Database and ETL With Python
Essential Data Science: Database and ETL With Python

Essential Data Science: Database and ETL With Python

Mastering database programming and ETL with Python. Data Processing and Manipulation.

What you’ll learn

Essential Data Science: Database and ETL With Python

  • Getting started with Python application development and database
  • Working on with file I/O, Text, CSV, Excel, JSON, and XML
  • Reading Files from HTTP Website ( Included Web Authentication)
  • Reading Files from Server-Based S3 Protocol
  • Accessing Python applications to Multiple Databases such as SQLite, MySQL, SQL Server, and PostgreSQL
  • Accessing Python applications to Multiple NoSQL Databases such as MongoDB, Redis, and Apache Cassandra
  • Building ETL applications with various scenario

Requirements

  • Having a basic knowledge of Python programming
  • A computer with internet accesses

Description

Extract, Transform, Load (ETL) is a process to process various data sources to be targeted data sources. ETL is one of the required skills in data science to implement pre-processing and/or post-processing. This workshop is designed for anyone who wants to improve ETL skills.

The workshop will focus on the following data sources

  • Files
  • RDBMS databases
  • NoSQL databases

We start to learn basic I/O files and directories. We can copy and delete files or directories. Next, we explore how to access various file types such as Text, CSV, JSON, and XML. In addition, we access remote data sources over the website and server-based S3 protocol.

learn how to work with the RDBMS database with Python. We use RBDMS database engines such as SQLite, MySQL, SQL Server, and PostgreSQL. We perform CRUD (Create, Read, Update, Delete). Learn also to access the database table from Python Pandas. Then, we can convert Python Pandas Dataframe into a database table.

We can leverage ETL with NoSQL database engines. Will work with MongoDB, Redis, and Apache Cassandra. We perform CRUD (Create, Read, Update, Delete) on these NoSQL database engines. Learn also to access the NoSQL database from Python Pandas. Then, we can convert Python Pandas Dataframe into a NoSQL database.

Last, we implement the ETL Python program. We have three case studies to show how ETL works with Python.

This workshop needs basic Python programming to follow all hands-on labs. Internet access is needed when we’re installing additional Python libraries.

Who this course is for:

  • Student and professional developers
  • Any developer who wants to learn Python and database
  • Any developer who wants to learn ETL with Database
  • Last updated 4/2021

Learn Python 3 programming Course
Content From: https://www.udemy.com/course/etlpython/
Download Now

Friendly Website



Advertisement




Categories

Advertisement