SQL Joins

4.6
70 个评分
提供方
Coursera Project Network
2,509 人已注册
在此指导项目中,您将:

Understand and be able to utilize an inner, left and right join.

Understand and be able to utilize self-join and cross join.

Understand and be able to utilize the union and union all keywords.

Clock1 hour
Beginner初级
Cloud无需下载
Video分屏视频
Comment Dots英语(English)
Laptop仅限桌面

In this 1-hour long project-based course, you will learn how to utilize MySQL joins in your queries. By the end of this project, you will create a number of examples that will develop your learning around joins in SQL. This course will enable you to take your beginner knowledge of SQL to the next level by enabling you to utilize joins. Thus, being able to develop more complex queries. This course will provide students with the knowledge behind different joins that are available in MySQL language such as inner join, outer join, and left join. This project will take students through a number of examples demonstrating SQL functions based on a database around a bookstore. You will gain an understanding of these concepts from the in-depth examples provided.

您要培养的技能

  • Database (DBMS)
  • Data Analysis
  • SQL
  • Computer Programming
  • Computer Science

分步进行学习

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

  1. Be able to develop an inner join.

  2. Be able to develop a left join.

  3. Be able to develop a right join.

  4. Be able to develop a self-join and cross join.

  5. Be able to develop query using the union and union all keywords.

指导项目工作原理

您的工作空间就是浏览器中的云桌面,无需下载

在分屏视频中,您的授课教师会为您提供分步指导

审阅

来自SQL JOINS 的热门评论

查看所有评论

常见问题

常见问题

还有其他问题吗?请访问 学生帮助中心