search

datacarpentry / sql-ecology-lesson

Data Management with SQL for Ecologists
http://datacarpentry.github.io/sql-ecology-lesson
Other
48 stars 145 forks source link

Adding Right Join, Full Join, and Join Visualization Tool #364

Open mostafizur67 opened 1 year ago

mostafizur67 commented 1 year ago

Hi,

I thoroughly enjoyed the lesson on left join and inner join. It provided a clear understanding of these concepts. However, I would love to see the right join and full join covered in the lesson as well.

https://datacarpentry.org/sql-ecology-lesson/03-sql-joins.html

I believe including these topics, along with practical examples, would enhance our understanding of SQL joins comprehensively.

I understand that adding additional join types may extend the lesson beyond its intended scope. If that is the case, I suggest providing supplementary resources or links where participants can explore right join, and full join independently, should they feel interested in delving deeper into these topics.

In addition to this, if you want you can add this visualization tool (https://sql-joins.leopard.in.ua/) to get a visual explanation of different joins.

Thank you for your efforts in delivering this valuable lesson, and I appreciate your consideration.

adamancer commented 1 year ago

Thanks for the suggestion! I agree that including RIGHT and OUTER JOIN would be a useful addition. If this is something you'd be interested in pursuing, please consider creating a pull request with the new information.

As a matter of historical interest, one reason these two types of joins were omitted originally is because SQLite only added support for them last year. I didn't realize this functionality had been added until I was looking into this issue.

The visualizer is a nice tool but I wonder if it provides a significant advantage over diagrams? Any thoughts, @jd-foster?

mostafizur67 commented 1 year ago

Hi Adam,

Thanks for your detailed comment and explanations. Sure, once I get some time, I will pull and try to add new information.

meghalgandhi1019 commented 4 months ago

Hello,

This is Meghal Gandhi from Carpentry community. I'd like to work on this issue as I have an expertise in SQL.

jd-foster commented 4 months ago

@meghalgandhi1019 Hello Meghal. Thank you for your offer of help. As Adam said above, if this is something you'd be interested in pursuing, please consider creating a pull request with the new information. I think the best thing would be to first post here to start discussing some of your ideas.