SQL Joins

4.8
stars
6 ratings
Offered By
Coursera Project Network
In this Guided Project, you will:

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
BeginnerBeginner
CloudNo download needed
VideoSplit-screen video
Comment DotsEnglish
LaptopDesktop only

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.

Skills you will develop

Database (DBMS)Data AnalysisSQLComputer ProgrammingComputer Science

Learn step-by-step

In a video that plays in a split-screen with your work area, your instructor will walk you through these steps:

  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.

How Guided Projects work

Your workspace is a cloud desktop right in your browser, no download required

In a split-screen video, your instructor guides you step-by-step

Reviews

TOP REVIEWS FROM SQL JOINS

View all reviews

Frequently asked questions

Frequently Asked Questions

More questions? Visit the Learner Help Center.