SQL Joins

4.7
66 個評分
提供方
Coursera Project Network
2,473 人已註冊
在此指導項目中,您將:

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 的熱門評論

查看所有評論

常見問題

常見問題

還有其他問題嗎?請訪問 學生幫助中心