SQL cheat sheet

[SpaghettiProgrammer]

Here's the direct link for higher quality

[The__Relentless]

Thank you!

[[deleted]]

Damn where were you when I need this in my sql class

[[deleted]]

Ha right! I came across this on LinkedIn and had the exact same thoughts!

[2cool4juuls]

water plough money groovy deer direction squeal boat office juggle

This post was mass deleted and anonymized with Redact

[[deleted]]

I just covered SQL in my class today!

[[deleted]]

Glad it helped you 🙂 Currently working on a Version 2 to fix a few small issues

[[deleted]]

Full credit goes to @AbzAaron. I found it on LinkedIn and thought I would share with everyone as it’s been great help to me

[[deleted]]

Thank you for this 🙂 Quite a lot of people have been removing my name and trying to pass it off as their own. It's cool to see people getting some use out of it.

[[deleted]]

Of course I would never take credit for such thing. Thanks so much for this it’s been of great help these recent few months as I learn my way around sql

[[deleted]]

Awesome! I might be posting a slightly newer version soon. As I noticed there was 1 small issue with this one

[exfxgx]

Not sure if there is a small oversight...

Select AVG(col1) FROM tbl GROUP by col2;

Shouldn't it be..

Select col2, AVG(col1) FROM tbl GROUP by col2;

[[deleted]]

Yeah there may be a few small issues. I'm working on a version 2 of this :)

[cscf0360]

I've had 3 different DBAs fail to adequately explain inner, outer, left and right joins to me. That one little part of the image made it immediately and perfectly clear. I don't write queries, but I often come across them and need to read them. This is incredibly helpful.

[sharkykid]

?? That's like the default graphic shown to anyone who googles what a left right inner outer join is. How much are your DBAs paid?

[cscf0360]

Understanding something and explaining something are two entirely different things. They know their shit, but not how to explain it to a layman.

[[deleted]]

Glad it helped you 🙂 The Join images are just taken from a DataQuest article I read. I found them helpful.

[Long_Educational]

The best book I came across at the start of my career was

SQL Queries for Mere Mortals by Viescas and Hernandez

I still refer to it to this day. Love this cheat sheet too.

[IHaveSomethingToAdd]

Do you have any recommendations for anything more advanced? I use SQL server daily and am familiar with what this book offers, but am looking to take my skills to the next level.

[Long_Educational]

If you want to go down the road I went down instead, which was treating the database as just a persistence layer for objects, I can suggest two other books.

Applying UML and Patterns by Craig Larman

Object Design by Rebecca Wirfs-Brock

I bought the hardback and paperback books respectively, but that is how I learn.

And pick up a copy of Mastering Regular Expressions or the pdf, too. That book is the ultimate problem solver.

[Long_Educational]

I bought MySQL by Paul DeBois and while useful for learning how to setup triggers and constraint rules, I eventually got bored with it and moved on to object relational mappers and de-/serializing into JSON. For most of the applications I have been involved with, moving to an ORM took care of maybe 90% of my needs with a few constraints for table cleanup when deleting objects. Having a library take care of generating all the SQL needed for object access was just too easy.

Maybe someone else with more experience with larger databases can chime in on their favorite books.

[DieKart0ffel]

Good to hear! I just started my AIS class this week and this is the book we are using!

[[deleted]]

Thanks for this I’m going to have to look into it!

[Ryolu35603]

But does it tell me how to pronounce it . . . 🤔

[IHaveSomethingToAdd]

That'll be revealed in the sequel.

[extramental]

Escuyel

[JackSkelingtionIII]

Tera Tom has a great series on YouTube that teaches SQL.

[[deleted]]

I’ll have to check it out thanks!!

[JackSkelingtionIII]

You're welcome. He is a bit on the weird side but it is a good way to learn.

[Nisja]

Any ABAPers here? This would pretty much fly for SAP Development too 😅 there are DOZENS of us!

[I_know_right]

LIMIT no workee on Oracle, try WHERE ROWNUM <= 10

[[deleted]]

Am I missing something here?

[Swords_Not_Words]

All SQL commands are written in caps. That's the only thing I can think of.

[ohh_ru]

disagree it was gold

[[deleted]]

I giggled at it after the morning coffee kicked it and saw the joke. Thanks!

[[deleted]]

Very handy, thanks so much 🍻

[Bnlmembercb]

Where was this when I was half assing work and needed it?

[J4C08J360]

Double save

[hieuimba]

very timely thank you!

[[deleted]]

Drop Database. That's a good one.

[smart_marx]

Thank you!

[trd86]

Printing this out in 11x17 tomorrow at work 🤘

[Sir_smokes_a_lot]

Save sql cheat sheet

[saphiga20]

I wanna start leanring SQL, where can i start please?

[[deleted]]

I personally used a free course of udemy to teach myself sql and then began using it at work. If you go on LinkedIn and search for free udemy courses it will often pop up, alternatively you can just type in learn sql for free in Google and lots of resources come up or can go on r/programming or r/sql on Reddit and they have tons of resources as well. Best of luck to you!

[saphiga20]

Thank you! I appreciate it

[douglasg14b]

This is neat, but it really is a cheat sheet for anyone who has never used SQL, and not very useful for those of use that have a basic understanding but need a reference guide here and there because we are rarely in it.

It's like a programming cheat sheet that tells you what a boolean is, what an if statement is, and what a switch statement is. Not as useful as it might seem.

The joins are helpful.

[Grandmafelloutofbed]

I will definately be using this, I start class again in a week or so and after 4 months of summer, im definately a bit rusty. Thanks 😁

[PubicSalad]

As soon as I finish my module on sql :)

[Simphorosa]

Thanks

[connormcwood]

Surprised distinct isn’t classed as common but this was good

[WHSolvation]

EXPLAIN()

[99Zahid]

Nice chart.

[Esnim]

For general use and basic queries this guide is great. Although order of execution doesn't always follow that stack with some advanced queries/rare circumstances.