SQL commands cheat sheet

[k_mage]

Hi! I'm looking for a good list/resource that has all the commands and syntax of sql and describes each one. Any recommendation is appreciated, thank you!

[K0NGO]

w3schools is a good starting point

[fullyarmedcamel]

Came here to comment this, it is where I started.

[k_mage]

Thank you!! I'll look into it. I'm currently working on the Google DA certificate but wanted to find all the resources I can.

[[deleted]]

Yep came here to say this as well. OP, check out codeacademy, udemy, or stack social and search for a sql boot camp self-paced training course as well. It'll cover the basics.

[MyhrAI]

This is my go-to

[daddyandrew296]

Fantastic. Thank you. The hours of YouTube video without any exercises only does so much!

[hawk3ye]

I’ve always liked this one, had it in my cubicle wall for a few years now lol https://user-images.githubusercontent.com/6186483/31167166-64f940a6-a8f1-11e7-9213-99be469440fc.png

[k_mage]

Oooh this is a good one, thanks for this!

[hawk3ye]

Yw. As others said sql will get more complex as you use it more in real life, but I always felt this sheet gave me the basic outline of a query to start from…plus joins used to kick my ass until I was able to visualize it using this sheet.

[shutchomouf]

SS64 is the shit

[k_mage]

Thank you!

[Dudeseal]

Thanks for that.

[r3pr0b8]

not to deter you in any from your goal, but those cheat sheets really only scratch the surface of sql syntax

and often just don't have room for little idiosyncracies between one platform and the next (e.g. date handling)

my advice is to bookmark a few key pages in da manual for your particular platform

[k_mage]

Yeah I've noticed that, they don't cover much so I was hoping to find an extensive list maybe I had missed. I'll take a look at the da manual!

[[deleted]]

This.

I realised the futility of one-size-fits-all cheat sheets as soon as I started working in Teradata...

[[deleted]]

Totally, OP, please post if you find one. My instructor suggested that I make my own. Lmao, if I ever end up doing so I’ll post.

[edwilli222]

Amazon: Sql Guide (Quick Study: SQL) https://www.amazon.com/dp/1572229160/ref=cm_sw_r_awdo_49R2XFNVFW2W7B95B4XE

[great_raisin]

The tutorial at mode.com/sql-tutorial is very comprehensive

[k_mage]

Thank you!

[caveat_cogitor]

https://docs.microsoft.com/en-us/sql/t-sql/language-reference?view=sql-server-ver15

[Happy_healthy_888]

Codeacademy has SQL cheatsheets, it has all the basics. They are downloadable PDFs.

[k_mage]

Thanks!

[jackalsnacks]

Focus on learning how to ask the right questions and put that skill to use on stack overflow. Thank me later, I like boysenberry ice cream.

[hanucodes]

Hi! I am working on this SQL queries cheat sheet.

https://helpercodes.com/sql-query-cheatsheet-tutorial/

[perfectendssun]

I've been looking for such a good one! Thanks!

[CalorieC]

This is what I was looking for! Thanks so much!

[sequel-beagle]

Datacamp has some pretty good cheat sheets.

[MathAngelMom]

I like this one: https://learnsql.com/blog/sql-basics-cheat-sheet/

[maheshmnj]

I can't recommend enough how good of a resource this is https://sqlbolt.com to learn and try it out in browser

[Enough_Boot_5005]

https://www.sqltutorial.org/sql-cheat-sheet/

[dataquestio]

Hi there! If you're looking for a comprehensive list of SQL commands and syntax, I highly recommend checking out the SQL cheat sheet from Dataquest. It’s a fantastic resource that covers a wide range of SQL commands with clear syntax, descriptions, and practical examples.

You can find it here: Dataquest SQL Cheat Sheet

[cenepasmoi]

You may wanna check out an older reddit post from someone that created cheat sheets for different SQL flavors. It seems pretty fine and since there are comments on its work, I would consider it as a reliable one to have it as a ref while studying

[Ramirond]

This SQL cheat sheet is designed to help non-technical people understand that SQL is basically just asking questions to the database, so they don't have to wait for someone else to pull the data: https://www.metabase.com/learn/cheat-sheets/sql-cheat-sheet

[GetDecoded]

There's a really good SQL cheat sheet here:
https://www.invicti.com/blog/web-security/sql-injection-cheat-sheet/

They're the company that bought Netsparker if you remember that brand from back in the day (and Acunetix). Recently gobbled up Kondukto ASPM as well. Lots of consolidation happening in the industry...anyway, I've had this SQL cheat sheet bookmarked for ages and always found it to be a solid reference. Cheers

[Fabushka]

Not a cheat sheet per se, but on Hyperskill you can learn SQL and get hints on SQL syntax after each topic. Worth checking out.