SQL for Data Science

所在平台: CourseraArchive

课程类别: 其他类别

大学或机构: CourseraNew

课程主页: https://www.coursera.org/archive/sql-for-data-science

课程评论:没有评论

第一个写评论        关注课程

课程简介

University of California, Davis

课程大纲

In this module, you will be able to define SQL and discuss how SQL differs from other computer languages. You will be able to compare and contrast the roles of a database administrator and a data scientist, and explain the differences between one-to-one, one-to-many, and many-to-many relationships with databases. You will be able to use the SELECT statement and talk about some basic syntax rules. You will be able to add comments in your code and synthesize its importance.

课程评论(0条)

课程详情

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 optimize their businesses. This is a data scientist, “part mathematician, part computer scientist, and part trend spotter” (SAS Institute, Inc.). 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 do not have any knowledge or skills in SQL. It will build on that foundation and gradually have you write both simple and complex queries to help you select data from tables. You'll start to work with different types of data like strings and numbers and discuss methods to filter and pare down your results. You will create new tables and be able to move data into them. You will learn common operators and how to combine the data. You will use case statements and concepts like data governance and profiling. You will discuss topics on data, and practice using real-world programming assignments. You will interpret the structure, meaning, and relationships in source data and use SQL as a professional to shape your data for targeted analysis purposes. Although we do not have any specific prerequisites or software requirements to take this course, a simple text editor is recommended for the final project. So what are you waiting for? This is your first step in landing a job in the best occupation in the US and soon the world!

数据科学的SQL:随着数据收集呈指数增长,对熟练使用数据并与之交互的人员的需求也随之增加。能够进行批判性思考,并提供见解以做出更好的决策并优化其业务。这是一位数据科学家,“部分数学家,部分计算机科学家和部分趋势发现者”(SAS Institute,Inc.)。根据Glassdoor的说法,成为数据科学家是美国最好的工作。基本年薪中位数为110,000美元,一次有数千个职位空缺。成为一名优秀的数据科学家所必需的技能包括能够检索和处理数据,并且要做到这一点,您需要精通SQL(与数据库系统进行通信的标准语言)。 本课程旨在为您提供SQL基础知识和数据处理入门,以便您可以出于数据科学目的开始对其进行分析。您将开始提出正确的问题,并给出良好的答案,以为您的组织提供有价值的见解。本课程从基础开始,并假定您不具备任何SQL知识或技能。它将在此基础上建立,并逐步让您编写简单和复杂的查询,以帮助您从表中选择数据。您将开始处理不同类型的数据,例如字符串和数字,并讨论过滤和缩减结果的方法。 您将创建新表,并能够将数据移入其中。您将学习常见的运算符以及如何合并数据。您将使用案例陈述和概念,例如数据治理和概要分析。您将讨论有关数据的主题,并使用实际编程任务进行练习。您将解释源数据中的结构,含义和关系,并使用SQL作为专业人员来针对目标分析目的对数据进行整形。 尽管本课程没有任何特定的先决条件或软件要求,但建议对最终项目使用简单的文本编辑器。你还在等什么?这是您在美国乃至全世界最优秀的职业中找到工作的第一步!

课程标签

0人关注该课程

主题相关的课程