Member-only story
This is the biggest SQL cheat sheet
Welcome back! I’ve been talking about some of the best cheat sheets for a variety of different programming languages, now let’s take a look at a massive cheat sheet for SQL! Here’s a link to the sheet that i’m going to be referencing in this article:
The rest of this article is going to be referencing this sheet so make sure to check it out, but this sheet is broken down into 2 parts, a 3 page downloadable pdf and the actual website portion, it’s the same content on both but a different way to view it. This sheet starts off with getting data from a database, this includes using select statements with different conditions:
We then get into creating tables with SQL, this includes filling the tables with different data points, this is extremely important when developing databases and every SQL programmer will have to know how to do this: