Aaron Profile picture
8 Sep, 3 tweets, 1 min read
Hey Tech Twitter

Here's an updated SQL Cheatsheet

I added the INSERT statement & a few other things. Feel free to use πŸ™‚

PDF version in comments
#CodeNewbie
PDF versions here.

There's a lighter and darker version of it available. Older version still available too πŸ‘
github.com/ABZ-Aaron/Chea…
Also fixed an issue with the aggregate function example, which would have actually thrown an error.

β€’ β€’ β€’

Missing some Tweet in this thread? You can try to force a refresh
γ€€

Keep Current with Aaron

Aaron Profile picture

Stay in touch and get notified when new unrolls are available from this author!

Read all threads

This Thread may be Removed Anytime!

PDF

Twitter may remove this content at anytime! Save it as PDF for later use!

Try unrolling a thread yourself!

how to unroll video
  1. Follow @ThreadReaderApp to mention us!

  2. From a Twitter thread mention us with a keyword "unroll"
@threadreaderapp unroll

Practice here first or read more on our help page!

More from @AbzAaron

5 Sep
Python has a lot of String Methods!

It's worth getting familiar with these πŸ™‚
Higher res PDF version here if anyone's interested
github.com/ABZ-Aaron/Chea…
Glad twitter is liking this! It's currently sitting at 1 like on LinkedIn lol
Read 4 tweets
3 Sep
Found out my SQL cheatsheet went viral on LinkedIn

Some people have actually covered up my name so they can pass it off as their own lol

Why do people do this? πŸ€·β€β™‚οΈ Image
I actually need to create a Version 2 of this. Completely forgot to include INSERT and a few other things first time around!
Also why cover my name up with sunglasses? Such a random choice πŸ˜…
Read 5 tweets
16 Aug
10 useful operations in SQL.

A Thread πŸ‘‡
Quick Note πŸ™‚

1. To run some of these operations, you'll likely need certain admin rights within your organisation

2. Always consult DBMS (database management system) documentation, as syntax will differ between DBMS
1⃣ CREATE DATABASE

Databases are essentially containers used to store organised data electronically, usually controlled by a database management system (DBMS)

Creating one is simple πŸ™‚
Read 13 tweets
12 Aug
20 useful tricks & tips in Python.

A Thread πŸ‘‡
1. Negative Rounding

We can specify an optional 2nd argument in Python's *round* function.

If we pass a negative value here, this will start rounding from the left of the decimal point; meaning we can round to the nearest 10, 100, and so on.
2. Reversing a String

There's an extremely easy way to reverse strings in Python using slicing.

Below we use [::-1]

This means start at the end of our string, and end up at position 0.
Read 22 tweets
5 Aug
9 Database basics you should probably know.

A Thread πŸ‘‡
1. What is a database?

This is essentially a container storing organised data electronically, usually controlled by something called a database management system (DBMS for short).

These can store more data (and are more secure) than a text file or spreadsheet.
2. What is a DBMS?

These are software packages which allow us to create, manipulate and manage our databases.

You've probably heard of some before.

They include:

-- MySQL
-- SQLite
-- PostgreSQL
Read 11 tweets
2 Aug
Learn 3 commands used to control SQL transactions.

A Thread πŸ‘‡
First, what are transactions?

Transactions essentially group tasks into a single execution unit. If any of these tasks fail, the transaction is cancelled. Image
Transactions typically have 4 properties, which fall under the acronym ACID.

Each of these properties should be achieved for a database to be considered reliable. Image
Read 10 tweets

Did Thread Reader help you today?

Support us! We are indie developers!


This site is made by just two indie developers on a laptop doing marketing, support and development! Read more about the story.

Become a Premium Member ($3/month or $30/year) and get exclusive features!

Become Premium

Too expensive? Make a small donation by buying us coffee ($5) or help with server cost ($10)

Donate via Paypal Become our Patreon

Thank you for your support!

Follow Us on Twitter!

:(