|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-for-beginners-data-analytics/
课程评论：没有评论
《Coursera SQL 入门：开启数据分析之路》课程总结 **课程概述：** 本课程旨在帮助您将原始数据转化为有洞察力的实际解决方案。SQL 是目前最流行的数据管理和数据探索编程语言，是任何数据分析师的必备工具。课程将从零开始教授 SQL，引导您下载安装必要的工具，创建并填充自己的数据库，然后使用 SQL 查询进行数据探索。无论您是对数据、数据存储还是数据探索感到好奇，本课程都是一个绝佳的起点。 **学习内容：** 您将学会如何使用 SQL 在本地数据库中创建和探索包含数据的表格。课程内容涵盖： * SQL 基础概念 * 表格管理 * 查询语句 * 聚合函数 * 多表连接 * 临时表 **为何学习本课程：** 掌握数据处理能力是当今最有价值的技能之一。学习如何管理和探索数据将为您在这个数据驱动的世界中带来显著优势。本课程将为您提供使用 SQL 管理和探索数据库以提取所需数据的必备知识。 **课程目标受众：** 本课程面向绝对的初学者，即使是对 SQL 或数据库一无所知的人也适合。它是学习数据并动手实践最流行的数据库访问和探索语言的理想选择。对于已经熟悉 SQL 但希望系统性复习的人来说，本课程也同样适用。 **最终项目：** 您将创建自己的数据库并探索其中的数据。课程将以一家公司为例，构建一个包含客户、订阅和订单三个数据表的示例数据库。您可以根据自己的兴趣调整这个示例。 **项目完成步骤：** 1. 在开始第一课之前，创建您的项目（在学习过程中不断创建和调整数据库）。 2. 跟随课程进度，在学习过程中更新您的项目。 3. 完成所有课程后，分享您的最终数据库版本，并附上数据库用途的描述。
What is this class about?You're in the right place if you're looking to learn how to turn data into insightful real-world solutions. SQL is the most popular programming language used to manage and explore data stored in databases. It is a vital tool in any Data Analyst toolkit.In this class, you'll learn how to use SQL from scratch. We'll download the tools we need to start off by creating our own database and filling it with data and then we'll explore it using SQL queries. This class is the perfect place for you if you're curious about data, how it's stored, and how to explore it.What will I learn in this class?Throughout this class, you will learn how to use SQL to create and explore tables with data on your own local database. In this class we'll cover the following:What is SQL?Managing TablesQueriesAggregate FunctionsMultiple TablesTemporary TablesWhy should I take this class?Knowing how to work with data is one of the most valuable skills nowadays. That means that learning how to manage and explore data will give you an advantage in this data-filled world that we live in. This course will teach you the things you need to know to start using SQL to manage databases and explore them to get the data you want.Who is this class for?This class is meant for absolute beginners; anyone who has no idea what SQL or a database is. It's the perfect place to start learning about data and getting your hands dirty with one of the most popular languages used to access and explore databases. This course is also meant for anyone who's already familiar with SQL but is looking for a structured refresher.Final Project:Create your own database and explore the data inside it. Throughout the class, we'll build an example database for a company with three tables: customers, subscriptions, and orders. Feel free to adapt this example to whatever you want!Follow these steps to complete the class project:On day one, create your project even before starting the first lesson (create and adapt the database as you progress).Go through the lessons and make updates to your project as you go.Once you go through all the lessons, share your final version of your database with a description stating how it's used.
