SQL — Understand how indices work under the hood to speed up your queries.

No more waiting for slow queries to finish

SQL — insert values with joined IDs from another table

You’ve got values for which you have id’s in a table. Insert the IDs in one go!

Sql— inserting only unique values in a UNIQUE table

Insert a value into a table if it doesn’t already exist

Turn Your Code into a Real Program: Packaging, Running and Distributing Scripts using Docker

Easily share and run code in a Docker container

Python to SQL — UPSERT Safely, Easily and Fast

Lightning-fast insert and/or update with Python

Explanation of a self-learning, evolving neural network

Watch and understand how an algorithm learns, mutates and evolves

Use git submodules to install a private, custom python package in a docker image

This is a complex title but I swear it’s not difficult

Hello Rashid, I’ve just uploaded my new article on creating custom python packages that you can pip…

https://mikehuls.medium.com/create-and-publish-your-own-python-package-ea45bee41cdc

Create and publish your own Python package

A short and simple guide on how to pip install your custom made package

Create Your Custom, private Python Package That You Can PIP Install From Your Git Repository

Share your self-built Python package using your git repo.

SQL — Update-select in ONE query

Select a batch of records while simultaneously updating them

Docker Compose for absolute beginners — how does it work and how to use it (+ examples)

Defining and running multi-container Docker applications