Udemybeginneren

Essential Data Science: Database and ETL With Python

Learn Python for database programming & ETL. Master data processing and manipulation techniques. Boost your data skills!

3.5(25)
128students
1h 34m
Certificate
Agus Kurniawan
Agus KurniawanResearcher, Trainer, Consultant and Author

Course Content

Essential Data Science: Database and ETL With Python is a beginner-level Udemy course taught by Agus Kurniawan. It runs 1h 34m, is taught in English, and includes a certificate of completion. Learners rate it 3.5 out of 5 from 25 reviews, with 128 students enrolled. It is a paid course, last updated September 2022.

Extract, Transform, Load (ETL) is a fundamental process in data science for preparing data from diverse sources for analysis. Mastering ETL is a crucial skill for both pre-processing and post-processing data. This workshop is designed to help you enhance your ETL skills and become proficient in data pipeline development.

Here's a detailed look at what you'll learn:

  • Data Source Handling: We'll cover extracting data from a variety of sources, including:

    • Files: Learn to work with local files and directories. You'll gain practical experience in copying, deleting, and accessing various file types like Text, CSV, JSON, and XML. We'll also explore accessing remote data from websites and server-based S3 protocols.
    • RDBMS Databases: Discover how to interact with relational database management systems (RDBMS) using Python. We'll work with popular engines like SQLite, MySQL, SQL Server, and PostgreSQL, performing essential CRUD operations (Create, Read, Update, Delete). You'll also learn to access database tables directly from Python Pandas and convert Pandas DataFrames into database tables.
    • NoSQL Databases: Explore ETL techniques for NoSQL databases, including MongoDB, Redis, and Apache Cassandra. You'll perform CRUD operations on these databases and learn to access them using Python Pandas, with the ability to convert Pandas DataFrames into NoSQL database structures.
  • Practical ETL Implementation: The workshop culminates in building a complete ETL Python program. You'll gain hands-on experience through three comprehensive case studies demonstrating real-world ETL applications with Python.

Prerequisites: A basic understanding of Python programming is required to fully participate in the hands-on labs. Internet access is necessary for installing required Python libraries.

Note: This content is regularly updated and maintained. New content and case studies will be added to address specific data scenarios.

$ whoami — the devs behind tutorialsearch.io

Want AI in your product? Hire the team behind TutorialSearch.io

LLM features, RAG, agents and automation wired into a real product — built by the devs who shipped this site.

5.0
53m
beginner
pluralsight
5.0(1,333)
2h 34m
beginner
skillshare
5.0
1h 29m
beginner
pluralsight