This course explores the fundamentals of relational databases and how to seamlessly map Python data structures to robust database tables using object-relational mappers (ORMs). You'll gain practical experience in building efficient ETL (Extract, Transform, Load) pipelines, ensuring your data is not only accessible but also reliable and persistent. You'll learn about data validation and quality control, leveraging powerful tools like Pandas to explore, clean, and analyze your datasets. By the end of the course, you’ll be equipped to uncover insights, identify biases, and apply best practices in data management.

Data Science Fundamentals Part 1: Unit 3
本课程是 Data Science Fundamentals, Part 1 专项课程 的一部分


位教师:Pearson
访问权限由 New York State Department of Labor 提供
您将学到什么
Master the fundamentals of relational databases and persistent data storage.
Build and optimize ETL pipelines using Python and object-relational mappers.
Apply data validation techniques to ensure data quality and integrity.
Utilize Pandas for effective data exploration, transformation, and statistical analysis.
您将获得的技能
- Data Processing
- Extract, Transform, Load
- Exploratory Data Analysis
- Database Management
- Data Persistence
- Object-Relational Mapping
- Data Cleansing
- Data Transformation
- Data Analysis
- Databases
- Relational Databases
- Data Validation
- Data Manipulation
- Data Integrity
- SQL
- Data Quality
- Pandas (Python Package)
- Descriptive Statistics
- Data Pipelines
- 技能部分已折叠。显示 10 项技能,共 19 项。
要了解的详细信息

添加到您的领英档案
3 项作业
August 2025
了解顶级公司的员工如何掌握热门技能

积累特定领域的专业知识
- 向行业专家学习新概念
- 获得对主题或工具的基础理解
- 通过实践项目培养工作相关技能
- 获得可共享的职业证书

该课程共有1个模块
This module guides learners through essential data handling skills, from storing and persisting data using relational databases and object-relational mappers, to validating, exploring, and transforming data for analysis. Emphasizing practical techniques with tools like Pandas, the lessons cover best practices for querying, managing missing values, and using descriptive statistics and visualizations to understand data quality and distribution. The module provides a systematic approach to the ETL process, equipping students to efficiently prepare data for deeper analytical modeling.
涵盖的内容
28个视频3个作业
获得职业证书
将此证书添加到您的 LinkedIn 个人资料、简历或履历中。在社交媒体和绩效考核中分享。
人们为什么选择 Coursera 来帮助自己实现职业发展

Felipe M.

Jennifer J.

Larry W.






