Categories
Programming

What is the best way to learn SQL?

In 1986, SQL (Structured Query Language) became a standard. Over the next 40 years, it became the dominant language for relational database management systems. Reading the latest standard (ANSI SQL 2016) can be time-consuming. How can I learn it? There are 5 components of the SQL language:– DDL: data definition language, such as CREATE, ALTER, […]

Categories
Agile Development Programming Software Architecture

The Backend Burger : Backend Software Architecture Checklist

Everyone loves burgers, whether it’s a full stack burger, a frontend burger, or a backend burger. While the origin of this innovative burger is unknown, a comparable full-stack burger was shared on Reddit four years ago. We want to give a special shout-out to the original creators. Watch & subscribe full video here: — Get […]

Categories
Programming Software Architecture

What distinguishes MVC, MVP, MVVM, MVVM-C, and VIPER 5 architecture patterns from each other?

These architecture patterns are among the most commonly used in app development, whether on iOS or Android platforms. Developers have introduced them to overcome the limitations of earlier patterns. So, how do they differ? MVC, the oldest pattern, dates back almost 50 years Every pattern has a “view” (V) responsible for displaying content and receiving […]

Categories
Agile Development Programming Software Architecture

The 8 Levels of Code Review Pyramid : One Diagram to Remember for Code Reviews

An essential step in the software development lifecycle is code review. Code reviews are powerful means to improve code quality, establish best practices, opportunity to learn, and knowledge sharing and mentoring, as well as promotes team cohesion. What to look for in a code review? Try to look for things such as 𝗱𝗲𝘀𝗶𝗴𝗻 (does this […]

Categories
Programming Software Architecture

How Git commands work?

Almost every software engineer has used Git before, but only a handful know how it works 🙂 To begin with, it’s essential to identify where our code is stored. The common assumption is that there are only two locations – one on a remote server like Github and the other on our local machine. However, […]

Categories
Programming Software Architecture

From 0 to Millions: A Guide to Scaling Your App

In this article, we’ll discuss a typical architectural evolution of a website/app, and how/why we make technical choices at different stages to Scaling Your App from 0 to Millions. Do we build a monolithic application at the beginning? When do we add a cache? When do we add a full-text search engine? Why do we […]

Categories
Programming

What is the best way to prepare for coding interviews?

Learning problem-solving through Coding Patterns was the best thing that happened to me when preparing for interviews. These patterns taught me how to solve unknown or unseen problems. And helped me develop the ability to map a new problem to an already known problem. That’s the best thing I could suggest to anyone. Learn the […]

Categories
IT Books Programming

23 Best Python Books to read in 2023 (Beginner & Advanced)

In this post, we’re going to explore the best books to learn Python in 2023, whether you’re a beginner or an advanced user. Finding the right book to learn can make or break your learning journey. Python is an incredibly in-demand skill for professional software developers, data analysts, and anyone looking to advance their career. Best […]

Categories
Programming

8 Types of Data Structures

As a data professional, understanding data structures is essential to optimizing your code and making it more efficient. Here are 10 key points to keep in mind: Types of Data Structures 1. Data structures are tools that enable you to store and manipulate data effectively. They include arrays, linked lists, stacks, queues, trees, and more […]

Categories
Data Science Programming Software Architecture

8 Key Data Structures That Power Modern Databases

In this video, we briefly talk about: 🔹Skiplist: a common in-memory index type. Used in Redis 🔹Hash index: a very common implementation of the “Map” data structure (or “Collection”) 🔹SSTable: immutable on-disk “Map” implementation 🔹LSM tree: Skiplist + SSTable. High write throughput 🔹B-tree: disk-based solution. Consistent read/write performance 🔹Inverted index: used for document indexing. Used […]