In this project you will learn to identify and use correct syntax when writing SQL retrieval queries. Through hands-on activities in SQLiteStudio, you will gain experience with the SQL syntax used to display specific columns, filter for specific rows, and determine the sequence of those columns and rows in query output. Familiarity with SQL syntax is a marketable skill for both Information Technology professionals and non-IT super users.


您将学到什么
Identify and use correct syntax when writing SQL retrieval queries.
要了解的详细信息

添加到您的领英档案
仅桌面可用
了解顶级公司的员工如何掌握热门技能

在不到 2 个小时的时间内学习、练习和应用为就业做好准备的技能
- 接受行业专家的培训
- 获得解决实训工作任务的实践经验
- 使用最新的工具和技术来建立信心

关于此指导项目
分步进行学习
在与您的工作区一起在分屏中播放的视频中,您的授课教师将指导您完成每个步骤:
Describe basic SQL syntax rules along with requirements for the names of tables, and the naming and data type requirements for table columns (fields).
Use the SELECT command and FROM clause to control the columns that are displayed and the order in which they display in query output.
Limit the rows retrieved by an SQL query by applying the WHERE clause with one or more conditions.
Use the ORDER BY clause to modify the sort order of the rows returned from an SQL retrieval query.
Code an SQL retrieval query that uses the JOIN command to retrieve data rows from tables that are related via a common column.
推荐体验
Ability to navigate in Windows is required. Some familiarity with relational tables would be helpful.
5个项目图片
位教师

学习方式
基于技能的实践学习
通过完成与工作相关的任务来练习新技能。
专家指导
使用独特的并排界面,按照预先录制的专家视频操作。
无需下载或安装
在预配置的云工作空间中访问所需的工具和资源。
仅在台式计算机上可用
此指导项目专为具有可靠互联网连接的笔记本电脑或台式计算机而设计,而不是移动设备。
人们为什么选择 Coursera 来帮助自己实现职业发展




学生评论
324 条评论
- 5 stars
73.84%
- 4 stars
20.61%
- 3 stars
3.69%
- 2 stars
1.23%
- 1 star
0.61%
显示 3/324 个
已于 Feb 8, 2024审阅
Comprehensive overview of basic SQL syntax, applicable and use case.
已于 Sep 8, 2024审阅
This was my first time ever learning about SQL and coding in general. It was very helpful and explained in a simple way that made understanding it a breeze.
已于 Apr 6, 2025审阅
The course was easy to understand and thorough enough to move on to another SQL course with a good understanding of basic SQL syntax.
您可能还喜欢
Coursera Project Network
- 状态:免费试用
University of California, Davis
- 状态:免费试用
LearnQuest
Coursera Project Network
常见问题
购买指导项目后,您将获得完成指导项目所需的一切,包括通过 Web 浏览器访问云桌面工作空间,工作空间中包含您需要了解的文件和软件,以及特定领域的专家提供的分步视频说明。
由于您的工作空间包含适合笔记本电脑或台式计算机使用的云桌面,因此指导项目不在移动设备上提供。
指导项目授课教师是特定领域的专家,他们在项目的技能、工具或领域方面经验丰富,并且热衷于分享自己的知识以影响全球数百万的学生。