Share this page!

Enter URL or ID to Unroll

You can paste full URL like: https://x.com/threadreaderapp/status/1644127596119195649
or just the ID like: 1644127596119195649

How to get URL link on X (Twitter) App

  1. On the Twitter thread, click on or icon on the bottom
  2. Click again on or Share Via icon
  3. Click on Copy Link to Tweet
  4. Paste it above and click "Unroll Thread"!
  5. More info at Twitter Help
Aaron Profile picture
Aaron
@AbzAaron
Programmer | Python | SQL | Open to Junior Data or Software Engineering Opportunities | Sharing Insight 🙂
Aug 1, 2022 • 12 tweets • 3 min read
If you'd like to improve your SQL, here's some things to look into

• CTEs
• CASE WHEN with SUM
• Window Functions
• Logical Processing Order
• Query Optimisation
• Indexing
• Database Design
• Transactions
• Correlated Subqueries
• Self Joins
• Set Operators
• Views Resource for CTEs
postgresqltutorial.com/postgresql-tut…
Sep 5, 2021 • 4 tweets • 1 min read
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…
Sep 3, 2021 • 5 tweets • 1 min read
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!
Aug 16, 2021 • 13 tweets • 5 min read
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
Aug 12, 2021 • 22 tweets • 7 min read
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.
Aug 5, 2021 • 11 tweets • 3 min read
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.
Aug 2, 2021 • 10 tweets • 3 min read
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