I was recently going through my notes of SQL Antipatterns and was shocked to realize how actual this book still is.

A Zero to SQL 90 Days Roadmap

This brief article on VIews in SQL explains how to create a view and other various operations in a step-by-step explanation.

First introduced as part of the SQ:2003 Standard and available in MySQL 8.0, window functions in MySQL are compelling, but the syntax can be difficult to grok.

Let’s dive into the main types of databases, their main features, and their working principles. And also development differences to be more practical. 

SQL Server 2022 has received a lot of attention since its release. What are the new features we explore in the latest SQL Server version? Read on!

Today we will do a short review and features comparison of dbForge SQL Complete and SSMSBoost.

Race conditions in a database and how you can solve them using techniques such as pessimistic and optimistic concurrency control.

SQL (Structured Query Language) is a programming tool or language that is widely used by data scientists and other professionals

Understanding MySQL explains query output is essential to optimize the query. EXPLAIN is good tool to analyze your query.

Understanding MySQL explains query output is essential to optimize the query. EXPLAIN is good tool to analyze your query.

With Chat2Query, you don’t need to be an SQL expert to extract insights from your data.