|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/using-sql-for-data-science/
课程评论：没有评论
**课程名称：** 使用SQL进行数据科学 **课程概述：** 本课程旨在为有志成为数据科学家的人士提供SQL基础知识和数据处理技能。数据科学家需要将原始数据转化为有价值的洞察，而许多数据都存储在关系型数据库中。SQL（Structured Query Language）是与数据库交互的标准语言。随着数据量的爆炸式增长，掌握SQL对于数据获取、分析和提供商业洞察至关重要。该课程适合SQL零基础的学习者，将从最基础的部分开始，逐步教授如何下载和安装必要的工具（Oracle Database, TOAD, SQL Developer），连接数据库，以及进行各类数据查询操作，包括： * 从单个或多个列中查询数据 * 去除查询结果中的重复记录 * 使用WHERE子句过滤记录 * 在WHERE子句中使用各种运算符 * 限制查询结果的数量 * 使用聚合函数 * 对数据进行排序和分组 * 从多个表中提取数据 通过本课程的学习，学员将能够提出正确的数据问题，获得有价值的答案，并为组织提供可行的商业洞察。
The role of a data scientist is to turn raw data into actionable insights. Much of the world's raw data-from electronic medical records to customer e-commerce transaction histories-lives in organized collections of tables called relational databases. Therefore, to be an effective data scientist, you must know how to wrangle and extract data from these databases using a language called SQL (pronounced ess-que-ell, or sequel). As data collection has increased exponentially, so has the need for people skilled at using and interacting with data; to be able to think critically, and provide insights to make better decisions and optimise their businesses. This is where the data scientist comes in. According to Glassdoor, being a data scientist is the best job in America; with a median base salary of $110,000 and thousands of job openings at a time. The skills necessary to be a good data scientist include being able to retrieve and work with data, and to do that you need to be well versed in SQL, the standard language for communicating with database systems. This course is designed to give you a primer in the fundamentals of SQL and working with data so that you can begin analyzing it for data science purposes. You will begin to ask the right questions and come up with good answers to deliver valuable insights for your organization. This course starts with the basics and assumes you have little or no knowledge or skills in SQL. What you will learn includes: Downloading and installing Oracle DatabaseDownloading and installing TOADDownload and installing SQL DeveloperConnecting to Oracle databaseQuerying data from single and multiple columnsRemoving duplicate records from query outputFiltering records with WHERE clauseUsing various operators with the WHERE clauseLimiting dataUsing aggregate functionsSorting and Grouping dataExtracting data from multiple tables
