Follow Friday: SQL Edition (8 July 2022)

Happy Friday, friends! 🎉 Follow Friday is your weekly opportunity to shout out fellow DEV Community members doing awesome work. Check out the comments and follow someone new!

If you were at #CodeLand22, you may have heard this…

And the general consensus?

So, devs: who are your favorite DEV community members writing about SQL?

Formatting tip: to populate a card with a follow button, use the liquid tag syntax {% embed https://... %} and insert the URL of your favorite author's profile.

Join in on the #FollowFriday fun by @mentioning your favorite author to follow for SQL explainers (and letting us know why you love their posts!) ⤵️

Comments

[Michael Tharrington]

Gotta give up for our teammate Jeremy (@jeremyf) 🙌 who has been dropping lots of #sql posts about different things he's been working on or digging into at DEV using SQL (side note: these posts are also tagged with #meta, since they're about this community — follow that tag if you wanna learn and talk more about the making of dev.to).

Anywho, here's one of Jeremy's most recent posts on SQL:

A Second Walk Through of Composing a SQL Query

Jeremy Friesen for The DEV Team ・ Jun 15 ・ 4 min read

#programming #meta #postgres #sql

And here's Jeremy 😀:

Jeremy FriesenFollow

Recovering interrupter with occasional relapses, lover of spreadsheets, blogger, programmer, adept debugger, conjurer of analogies, and probably other things.

[Chris Greening]

Yessss I read this a couple weeks ago and the fact that he used DEV itself as the example was my favorite part of the walkthrough - fantastic post!

[Gracie Gregory (she/her)]

@helenanders26 has been part of this community for a long time (check out that 5 years badge!!) — if you haven’t already, you gotta check out her guide to SQL concepts from A to Z ⤵️

SQL concepts from A to Z

Helen Anderson ・ Feb 6 '19 ・ 14 min read

#data #database #sql #beginners

[Michael Tharrington]

YES!!! Helen is awesome. 🔥

[Bobby Iliev]

Here is also a free eBook that I've written a few months ago:

bobbyiliev / introduction-to-sql

Free Introduction to SQL eBook

💡 Introduction to SQL

This is an open-source introduction to SQL guide that will help you to learn the basics of SQL and start using relational databases for your SysOps, DevOps, and Dev projects. No matter if you are a DevOps/SysOps engineer, developer, or just a Linux enthusiast, you will most likely have to use SQL at some point in your career.

The guide is suitable for anyone working as a developer, system administrator, or a DevOps engineer and wants to learn the basics of SQL.

🚀 Download

To download a copy of the ebook use one of the following links:

• Dark mode

• Light mode

📘 Chapters

• About the book
• Databases
• MySQL
• Tables
• Basic Syntax
• SELECT
• WHERE
• ORDER and GROUP BY
• INSERT
• UPDATE
• DELETE
• JOIN
• SQL Command Categories
• Sub Queries
• Unions
• The MySQL dump command
• Conclusion

🌟 Sponsors

Thanks to these fantastic companies that made this book possible!

📊 Materialize

…

View on GitHub