HOT

Essential Data Science: Database and ETL With Python

Development

Rating3.4
Enroll Now

Essential Data Science: Database and ETL With Python, available at $49.99, has an average rating of 3.4, with 26 lectures, based on 22 reviews, and has 111 subscribers.

You will learn about 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 This course is ideal for individuals who are Student and professional developers or Any developer who wants to learn Python and database or Any developer who wants to learn ETL with Database It is particularly useful for Student and professional developers or Any developer who wants to learn Python and database or Any developer who wants to learn ETL with Database.

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

Summary

Title: Essential Data Science: Database and ETL With Python

Price: $49.99

Average Rating: 3.4

Number of Lectures: 26

Number of Published Lectures: 25

Number of Curriculum Items: 26

Number of Published Curriculum Objects: 25

Original Price: $22.99

Quality Status: approved

Status: Live

What You Will Learn

  • 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

Who Should Attend

  • Student and professional developers
  • Any developer who wants to learn Python and database
  • Any developer who wants to learn ETL with Database

Target Audiences

  • Student and professional developers
  • Any developer who wants to learn Python and database
  • Any developer who wants to learn ETL with Database

Extract, Transform, Load (ETL) is a process to process various data sources to be targeted data sources. ETL is one of required skill 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 for 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 source over website and server-based S3 protocol.

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

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

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

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

Updated Contents

  • These contents will updated and maintained

  • New contents will be available for specific cases

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: Preparation

Chapter 2: Files

Lecture 1: Overview

Lecture 2: Basic I/O Files and Directories

Lecture 3: Text Files

Lecture 4: CSV Files

Lecture 5: Excel Files

Lecture 6: JSON

Lecture 7: XML

Lecture 8: Reading Files from HTTP Website ( Included Web Authentication)

Lecture 9: Reading Files from Server-Based S3 Protocol

Lecture 10: Source Codes – Files

Chapter 3: RDBMS Databases

Lecture 1: Overview

Lecture 2: SQLite

Lecture 3: MySQL

Lecture 4: SQL Server

Lecture 5: PostgreSQL

Chapter 4: NoSQL Databases

Lecture 1: Overview

Lecture 2: MongoDB

Lecture 3: Redis

Lecture 4: Apache Cassandra

Chapter 5: Real-World ETL Application Samples

Lecture 1: Overview

Lecture 2: [Case 1] Sources: Multiple Files / Target: Database

Lecture 3: [Case 2] Source: Multiple Files and A Database / Target: Database

Lecture 4: [Case 3] Source: Email / Target: Database and File

Instructors

Rating Distribution

  • 1 stars: 2 votes
  • 2 stars: 3 votes
  • 3 stars: 5 votes
  • 4 stars: 5 votes
  • 5 stars: 7 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!

You may also like

Podcast: The top 8 ways to monetize by Podcasting

The Art of Storytelling: How to Connect with Audiences

Unbounce for Beginners: Build a Landing Page with Unbounce