𝐒𝐐𝐋 𝐮𝐬𝐢𝐧𝐠 𝐒𝐪𝐮𝐢𝐝 𝐆𝐚𝐦𝐞

Source

Grokking Object-Oriented design interview

Object-oriented programming (OOP) is a style of programming that focuses on using objects to design and build applications. Contrary to procedure-oriented programming where programs are designed as blocks of statements to manipulate data, OOP organizes the program to combine data and functionality and wrap it inside something called an “Object”.

Link

If you need to run remote commands on servers with #Python, then Fabric is your friend.

You can use it to do remote installs, run docker commands, cleanup scripts and so much more.

Source

𝟭𝟮 𝗠𝘂𝘀𝘁 𝗞𝗻𝗼𝘄 𝗖𝗼𝗱𝗶𝗻𝗴 𝗣𝗮𝘁𝘁𝗲𝗿𝗻𝘀 & 𝗧𝗵𝗲𝗶𝗿 𝗔𝗽𝗽𝗹𝗶𝗰𝗮𝘁𝗶𝗼𝗻𝘀 𝗶𝗻 𝗦𝘆𝘀𝘁𝗲𝗺 𝗗𝗲𝘀𝗶𝗴𝗻 𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄

Here are 8 proven tips to improve your SQL query performance:

- Use the correct index

- Reduce network hops

- SELECT fewer columns

- Avoid table/index scans

- Use EXISTS instead of IN

- Use INNER JOIN instead of WHERE

- Avoid using subqueries when possible

- Examine execution plans on a realistic dataset

Source

The diagram below shows typical API designs with a shopping cart example.