Tags
Language
Tags
<<
June 2025
Su Mo Tu We Th Fr Sa
1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
29 30 1 2 3 4 5
    Attention❗ To save your time, in order to download anything on this site, you must be registered 👉 HERE. If you do not have a registration yet, it is better to do it right away. ✌

    ( • )( • ) ( ͡⚆ ͜ʖ ͡⚆ ) (‿ˠ‿)
    SpicyMags.xyz
    1. Home
    2. eBooks & eLearning
    3. Essential Data Science: Database and ETL With Python

    Essential Data Science: Database and ETL With Python

    Posted By: lucky_aut
    Date: 11 Apr 2021 17:25:13
    Essential Data Science: Database and ETL With Python

    Essential Data Science: Database and ETL With Python
    Duration: 1h 34m | .MP4 1280x720, 30 fps(r) | AAC, 44100 Hz, 2ch | 814 MB
    Genre: eLearning | Language: English

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

    What you'll 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

    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 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.

    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

    More Info
    UPWARDS