|
所在平台: Coursera |
课程主页: https://www.coursera.org/learn/sql-data-science
课程评论：没有评论
课程名称：使用Python进行数据科学的数据库与SQL 课程概述：当今世界的数据大多存储于数据库中。SQL（结构化查询语言）是一种强大的工具，用于与数据库进行交互和提取数据。掌握数据库和SQL的基本知识是成为数据科学家的必要条件。该课程旨在介绍关系数据库的概念，并帮助您学习和应用SQL语言的基础知识，同时在数据科学环境中进行SQL访问。 本课程强调实践和动手学习。您将使用真实的数据库、数据科学工具和真实世界的数据集。您将创建云中的数据库实例，并通过一系列实践实验室来练习构建和运行SQL查询。您还将学习如何使用SQL和Python从Jupyter笔记本访问数据库。 本课程无需先前的数据库、SQL、Python或编程知识。任何人都可以免费旁听本课程。如果您决定注册并获得Coursera课程证书，还可以在成功完成课程后获得IBM数字徽章。 限时优惠：订阅费用仅为每月39美元，包含对评分材料和证书的访问。 课程大纲： 1. **开始使用SQL**：介绍数据库，学习基本SQL语句（SELECT、INSERT、UPDATE和DELETE）及其查询结果的提炼方法。 2. **关系数据库与表的介绍**：深入了解关系数据库概念及其重要性，学习在MySQL中使用图形界面和SQL脚本创建和修改表。 3. **中级SQL**：学习如何使用字符串模式和范围搜索数据，以及排序和分组结果集，练习嵌套查询。 4. **使用Python访问数据库**：了解如何在Jupyter Notebook中使用Python连接数据库，创建表、加载数据和查询数据。 5. **课程作业**：使用芝加哥市的多个真实数据集，通过实际问题理解数据，并评估SQL查询和结果的正确性。 6. **附加模块：数据工程师的高级SQL**：学习一些高级SQL技术，如视图、事务、存储过程和联接，适合数据工程师，但非数据科学或数据分析轨道的学员可选完成。 本课程为希望进入数据科学领域的学习者提供了全面的数据库和SQL知识，使您在实际工作中具备必要的技能。
Name:Getting Started with SQL
Description:In this module, you will be introduced to databases. You will learn how to use basic SQL statements like SELECT, INSERT, UPDATE and DELETE. You will also get an understanding of how to refine your query results with the WHERE clause as well as using COUNT, LIMIT and DISTINCT.
Name:Introduction to Relational Databases and Tables
Description:In this module, you’ll learn more about relational database concepts and their importance. This module helps you to understand the process of creating a table in your database on MySQL using the graphical interface and SQL scripts. Further, you will also learn how to alter the entries or delete the entries for any table in the database, or even delete the table itself.
Name:Intermediate SQL
Description:This module helps you learn how to use string patterns and ranges to search data and how to sort and group data in result sets. You will also practice composing nested queries and execute select statements to access data from multiple tables.
Name:Accessing Databases using Python
Description:In this module you will learn the basic concepts of using Python to connect to databases. In a Jupyter Notebook, you will create tables, load data, query data using SQL magic and SQLite python library. You will also learn how to analyze data using Python.
Name:Course Assignment
Description:In this module, you will be working with multiple real-world datasets for the city of Chicago. You will be asked questions that will help you understand the data just as you would in the real world. You will be assessed on the correctness of your SQL queries and results.
Name:Bonus Module: Advanced SQL for Data Engineers
Description:This module covers some advanced SQL techniques that will be useful for Data Engineers. In this module, you will learn how to build more powerful queries with advanced SQL techniques like views, transactions, stored procedures, and joins. If you are following the Data Engineering track, you must complete this module. Completion of this module is not required for those completing the Data Science or Data Analyst tracks.
Much of the world's data resides in databases. SQL (or Structured Query Language) is a powerful language which is used for communicating with and extracting data from databases. A working knowledge of databases and SQL is a must if you want to become a data scientist. The purpose of this course is to introduce relational database concepts and help you learn and apply foundational knowledge of the SQL language. It is also intended to get you started with performing SQL access in a data science environment. The emphasis in this course is on hands-on and practical learning . As such, you will work with real databases, real data science tools, and real-world datasets. You will create a database instance in the cloud. Through a series of hands-on labs you will practice building and running SQL queries. You will also learn how to access databases from Jupyter notebooks using SQL and Python. No prior knowledge of databases, SQL, Python, or programming is required. Anyone can audit this course at no-charge. If you choose to take this course and earn the Coursera course certificate, you can also earn an IBM digital badge upon successful completion of the course. LIMITED TIME OFFER: Subscription is only $39 USD per month for access to graded materials and a certificate.
