|
所在平台: Coursera |
课程主页: https://www.coursera.org/learn/scripting-with-python-sql-for-data-engineering-duke
课程评论：没有评论
课程名称：使用Python和SQL进行数据工程脚本编写 课程概述：这是“数据工程的Python、Bash和SQL基础”专项中的第三门课程，您将探索有效使用Python和SQL的技术。课程将深入讲解Python脚本中的有用数据结构，并连接到MySQL等数据库。此外，您还将学习如何使用现代文本编辑器连接并运行SQL查询，对真实数据库进行数据加载和提取操作。最后，您将使用爬虫技术从网站提取数据。这些技能将使您在数据不易获取或需要空间查询以从数据库中提取有用信息时，能够高效工作。 课程大纲： 1. **在Python中处理数据** - 这一周，您将学习如何有效使用Python的数据结构来加载、持久化和迭代数据。您将应用这些数据结构来解决处理如JSON等流行数据格式时的不同问题。 2. **Python脚本编写与SQL** - 这一周，您将学习如何使用Python脚本技巧与SQL进行交互。您将创建一个数据库，存储数据，并通过Python使用SQL查询该数据。 3. **使用Python进行网络爬虫** - 这一周，您将学习如何高效地从网络中提取数据。您将学习如何使用爬虫库读取网站数据，并识别和提取特定值。 4. **与MySQL的交互** - 这一周，您将学习如何使用现代开发环境和编辑器连接到MySQL数据库服务器，执行查询并进行数据库操作。
Name:Working with Data in Python
Description:This week, you will learn how to effectively use Python’s data structures to load, persist, and iterate over data. You will apply these data structures to solve different problems when working with popular data formats like JSON.
Name:Python Scripting and SQL
Description:This week, you will learn how to use Python scripting techniques to work with SQL. You will create a database, store data, and query that data with SQL from Python.
Name:Web Scraping using Python
Description:This week, you will learn how to efficiently extract data from the web. You will learn how to use a scraping library to read data from websites and identify and extract specific values from it.
Name:Working with MySQL
Description:This week, you will learn how to use a modern development environment and editor to connect to a MySQL database server, execute queries and perform database operations.
In this third course of the Python, Bash and SQL Essentials for Data Engineering Specialization, you will explore techniques to work effectively with Python and SQL. We will go through useful data structures in Python scripting and connect to databases like MySQL. Additionally, you will learn how to use a modern text editor to connect and run SQL queries against a real database, performing operations to load and extract data. Finally, you will use extracted data from websites using scraping techniques. These skills will allow you to work effectively when data is not readily available, or when spatial queries are required to extract useful information from databases.
