Sort and Filter Data in SQL using MySQL Workbench

位教师：Judy Richardson

访问权限由 New York State Department of Labor 提供

1,715 人已注册

指导项目

在专家的指导下，学习、练习并应用工作就绪技能

中级等级

推荐体验

2 hours

自行安排学习进度

实践学习

了解更多

指导项目

在专家的指导下，学习、练习并应用工作就绪技能

中级等级

推荐体验

2 hours

自行安排学习进度

实践学习

了解更多

您将学到什么

Write SQL retrieval queries using MySQL Workbench.
Apply filtering in an SQL query to limit the rows displayed in the results.
Sort the rows of data retrieved by an SQL query.

您将练习的技能

要了解的详细信息

可分享的证书

添加到您的领英档案

授课语言：英语（English）

无需下载或安装

仅桌面可用

了解顶级公司的员工如何掌握热门技能

了解关于 Coursera for Business 的更多信息

Petrobras, TATA, Danone, Capgemini, P&G 和 L'Oreal 的徽标

在 2 小时内学习、练习并应用岗位必备技能

接受行业专家的培训
获得解决实训工作任务的实践经验
使用最新的工具和技术来建立信心

关于此指导项目

In this project you will use MySQL Workbench to write SQL queries that retrieve, sort, and filter data from tables in a relational database. Adding filtering to a query ensures that only the data needed is displayed in the query result. Sorting is applied to arrange the rows in that query result into an order that is meaningful to the data’s user. Adding code to an SQL query to filter and sort data generates a query result that makes data analysis easier for users, enabling more effective decision-making.

分步进行学习

在与您的工作区一起在分屏中播放的视频中，您的授课教师将指导您完成每个步骤：

Open an SQL script that contains a query with a WHERE clause that filters and an ORDER BY clause that sorts. (6 min)
Experiment with sorting by multiple columns and comparing ascending and descending sorts. (7 min)
Use the SQL WHERE clause to specify which rows to display as a result of an SQL retrieval query. (6 min)
Combine filter criterion in a combination WHERE clause in an SQL query to limit the rows retrieved and displayed. (5 min)
Combine multiple conditions in a combination WHERE clause in an SQL query to limit the rows retrieved and displayed. (5 min)