|
所在平台: Coursera |
课程主页: https://www.coursera.org/learn/sql-data-science-r
课程评论：没有评论
课程名称：使用 R 进行数据科学的 SQL 概述：世界上大部分数据存储在数据库中，而 SQL（结构化查询语言）是一种强大的语言，用于与数据库进行通信和提取数据。掌握数据库和 SQL 知识是成为数据科学家的必要步骤。本课程旨在介绍关系数据库概念，帮助学员学习和应用 SQL 和 R 语言的基础知识，并在数据科学环境中进行 SQL 访问。 本课程强调实践和动手学习。学员将使用真实的数据库、数据科学工具和真实世界的数据集，创建云端数据库实例。通过一系列实践实验，学员将练习构建和运行 SQL 查询，并学习如何从 Jupyter 笔记本使用 SQL 和 R 访问数据库。 本课程无需任何数据库、SQL、R 或编程背景，任何人都可以免费旁听。如果学员选择完成课程并获得 Coursera 课程证书，还可以在成功完成课程后获得 IBM 数字徽章。 课程大纲： 1. **入门 SQL** - 介绍结构化查询语言（SQL），学习基本 SQL 语句，并在在线视频中进行实际练习。 2. **关系数据库与表的介绍** - 探索数据库、表及其关系的基本概念，创建数据库实例，并学习如何创建和操作表。 3. **中级 SQL** - 学习使用字符串模式和范围搜索数据，排序和分组结果集，撰写嵌套查询，并从多个表访问数据。 4. **使用 R 入门数据库** - 学习 R 连接关系数据库的优势，持久化 R 数据库对象，比较 R 数据框和关系数据库的相似性，掌握不同的连接数据库的方法。 5. **使用 R 操作数据库对象** - 学习访问和查询数据库的完整流程，创建数据库的逻辑和物理模型，并实现这些模型。 6. **课程项目** - 使用真实的加拿大作物数据和汇率数据集进行项目，回答与数据相关的问题，评估 SQL 查询和结果的准确性。 该课程旨在为学员提供扎实的 SQL 和 R 基础，帮助他们在数据科学领域建立有力的数据分析能力。
Name:Getting Started with SQL
Description:Structured Query Language, or SQL, provides a standard language for selecting and manipulating data in a relational database. Understanding SQL is a foundational skill that you must have when applying data science principles in R because SQL is the key to helping you unlock insights about the information stored deep inside relational databases. In this module, you will learn some basic SQL statements and practice them hands-on on a live database.
Name:Introduction to Relational Databases and Tables
Description:In this module, you will explore the fundamental concepts behind databases, tables, and the relationships between them. You will then create an instance of a database, discover SQL statements that allow you to create and manipulate tables, and then practice them on your own live database.
Name:Intermediate SQL
Description:In this module, you will 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:Getting Started with Databases using R
Description:In this module, you will learn the benefits of using R to connect to relational databases and how to persist R database objects in files. You’ll also learn some of the similarities between R data frames and relational databases, including how data types compare and when you must convert from one type to another to improve the effectiveness of your data analysis. Finally, you’ll learn different methods for connecting to a database from R.
Name:Working with Database Objects using R
Description:In this module, you will learn the full process of accessing and querying databases using R. You’ll learn how to create the logical and physical model of the database and then implement the model by creating the physical database objects and loading them with data. Finally, you’ll examine an example of accessing and querying the database.
Name:Course Project
Description:In this assignment, you will be working with multiple real-world datasets for the Canadian Crop Data and Exchange Rates. 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.
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 and R languages. 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 R. No prior knowledge of databases, SQL, R, 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.
