DEV Community

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
SQL, split values of two columns respectively and count members of their intersection #eg20
esproc_spl profile
Judy

SQL, split values of two columns respectively and count members of their intersection #eg20

#sql #development #programming
7
Comments 1
1 min read
Build a Database Schema In 5 Steps
domfive profile

Build a Database Schema In 5 Steps

#database #mysql #sql #sqlserver
Comments
26 min read
SQL as fast as NoSQL, Bulk Loads, Covering and Partial Indexes
franckpachot profile

SQL as fast as NoSQL, Bulk Loads, Covering and Partial Indexes

#yugabytedb #sql #nosql #distributed
2
Comments
4 min read
SQL, Set different flags for different groups according to whether there are duplicate values #eg19
esproc_spl profile
Judy

SQL, Set different flags for different groups according to whether there are duplicate values #eg19

#sql #development #programming #esproc
8
Comments 1
1 min read
How Indexing Works in MariaDB and Why It Helps with Optimization
0x49d1 profile

How Indexing Works in MariaDB and Why It Helps with Optimization

#database #mariadb #indexing #sql
1
Comments
9 min read
5 Common SQL Server Performance Issues and How to Fix Them.
icodemechanic profile

5 Common SQL Server Performance Issues and How to Fix Them.

#sqlserver #sql #performance #tuning
1
Comments
2 min read
Add Missing Sequence Numbers to One Table according to The Other and Combine Two Tables #eg18
esproc_spl profile
Judy

Add Missing Sequence Numbers to One Table according to The Other and Combine Two Tables #eg18

#sql #development #programming #esproc
6
Comments 1
1 min read
Data Analyst vs Business Analyst: Understanding the Key Differences and Required Skill Sets
parthmagicss profile

Data Analyst vs Business Analyst: Understanding the Key Differences and Required Skill Sets

#sql #datascience #business #analytics
Comments
4 min read
Get the First Missing Item for the Sequence of Should-have-been Continuous Sequence Numbers #eg16
esproc_spl profile
Judy

Get the First Missing Item for the Sequence of Should-have-been Continuous Sequence Numbers #eg16

#sql #development #programming #esproc
6
Comments 1
2 min read
Postgres major version upgrades with minimal downtime
cezz profile

Postgres major version upgrades with minimal downtime

#news #postgres #database #sql
Comments
4 min read
Enabling Special Needs Education and Empowerment
rabiezouita11 profile

Enabling Special Needs Education and Empowerment

#laravel #sql #architecture #apimail
1
Comments
2 min read
Understanding Database Isolation Levels: An Essential Overview
eric6166 profile

Understanding Database Isolation Levels: An Essential Overview

#database #sql
9
Comments
3 min read
Transpose Multiple Columns into One Row in Each Group #eg15
esproc_spl profile
Judy

Transpose Multiple Columns into One Row in Each Group #eg15

#sql #development #programming
6
Comments 1
1 min read
PostgreSQL Fitness: 10 Essential Maintenance Practices for a Healthy Database
diedataou profile

PostgreSQL Fitness: 10 Essential Maintenance Practices for a Healthy Database

#postgres #sql #monitoring #database
1
Comments
3 min read
DBMS - Introduction
jitmitra profile

DBMS - Introduction

#dbms #database #sql #beginners
1
Comments 1
1 min read
Uploading Excel Files to SSMS Table
salonynhp profile

Uploading Excel Files to SSMS Table

#api #dotnet #sql #beginners
Comments
3 min read
Building a D&D 5e Character Generator: A Journey Through SQL and RPG Complexity
paulama3 profile

Building a D&D 5e Character Generator: A Journey Through SQL and RPG Complexity

#python #sql #beginners #programming
17
Comments 5
4 min read
Why Developers should understand SQL Server Performance
icodemechanic profile

Why Developers should understand SQL Server Performance

#developer #sqlserver #database #sql
Comments
2 min read
Fixing a slow table join
mcadariu profile

Fixing a slow table join

#postgres #performance #sql #database
6
Comments
7 min read
Linearly Scalable Architecture with Separation of Concern
franckpachot profile

Linearly Scalable Architecture with Separation of Concern

#yugabytedb #distributed #sql #database
Comments
2 min read
How To Debug SQL Procedures and Queries in Microsoft Visual Studio
njeri_muriithi profile

How To Debug SQL Procedures and Queries in Microsoft Visual Studio

#sql #storedprocedures #sqlserver #database
1
Comments
2 min read
SQL, mark continuous rows with sequence numbers #eg30
esproc_spl profile
Judy

SQL, mark continuous rows with sequence numbers #eg30

#sql #development #programming #esproc
8
Comments
1 min read
SQL, get historical status of each ID #eg22
esproc_spl profile
Judy

SQL, get historical status of each ID #eg22

#sql #development #programming #esproc
8
Comments 1
1 min read
ProjectEvent
rabiezouita11 profile

ProjectEvent

#laravel #sql #websockets #webdev
Comments
3 min read
ProBook
rabiezouita11 profile

ProBook

#sql #laravel #websockets #apimail
Comments
1 min read
Send reminder to employees when tasks are due
sqlman profile

Send reminder to employees when tasks are due

#sql #email #sqlmessenger
2
Comments
2 min read
Celebrating My Achievement: Snowflake Badge 1 Completion 🎉
techwithqasim profile

Celebrating My Achievement: Snowflake Badge 1 Completion 🎉

#snowflake #datawarehouse #sql #achievementunlocked
Comments
2 min read
Recommended Project: Querying Official Languages and Sorting
labby profile
Labby for LabEx

Recommended Project: Querying Official Languages and Sorting

#labex #sql #mysql #programming
Comments
2 min read
Understanding Transactions In Databases : Keeping Your Records Consistent 📊💰🔄📚✅
hossamgouda profile

Understanding Transactions In Databases : Keeping Your Records Consistent 📊💰🔄📚✅

#webdev #database #sql #mariadb
Comments
2 min read
NoSQL vs NewSQL vs Distributed SQL: A Comprehensive Comparison
ankitmalikg profile

NoSQL vs NewSQL vs Distributed SQL: A Comprehensive Comparison

#newsql #sql #distributedsystems
5
Comments
4 min read
LINQPad for everything(or at least a lot)
constantdeveloper profile

LINQPad for everything(or at least a lot)

#dotnet #aspnet #oop #sql
Comments
3 min read
Blackboxing SQL in CFScript - Part 1
snackcode profile

Blackboxing SQL in CFScript - Part 1

#productivity #sql #programming #coldfusion
Comments
5 min read
TypedSQL in Prisma: Type-Safe SQL Made Simple
fahimahammed profile

TypedSQL in Prisma: Type-Safe SQL Made Simple

#typedsql #prisma #typesafe #sql
5
Comments 1
4 min read
SQL, get median of all columns in each row #eg21
esproc_spl profile
Judy

SQL, get median of all columns in each row #eg21

#sql #development #programming
9
Comments 1
1 min read
Where To Learn SQL
webbswideworld profile
Jack

Where To Learn SQL

#sql #learning #career #careerdevelopment
2
Comments
3 min read
SQL 101 📊 | A Guide to Basic Commands for Beginners 💡
dipsankadariya profile

SQL 101 📊 | A Guide to Basic Commands for Beginners 💡

#sql #database #mysql #webdev
6
Comments
2 min read
Hotel reservation Schema design (PostgreSQL)
chandra179 profile

Hotel reservation Schema design (PostgreSQL)

#sql #postgres #database #schema
Comments
4 min read
Sites to practice SQL
caresle profile

Sites to practice SQL

#sql #database
Comments
1 min read
10-Day .Net Aspire Challenge: Day 2— Add MSSQL Component
ssukhpinder profile

10-Day .Net Aspire Challenge: Day 2— Add MSSQL Component

#dotnet #csharp #sql #aspire
8
Comments
2 min read
Choosing the Right Database for Your Project: Beyond Personal Experience
zhukmax profile

Choosing the Right Database for Your Project: Beyond Personal Experience

#sql #database #mysql #postgres
24
Comments 5
4 min read
SQL vs NoSQL: Understand the difference and know when to use each! 05:50
carlosfilho profile

SQL vs NoSQL: Understand the difference and know when to use each!

#sql #nosql #aws #awsbuilder
2
Comments 1
3 min read
Ice vegas
rabiezouita11 profile

Ice vegas

#laravel #sql #apimail #webdev
Comments
1 min read
SQL, output associated records having many-to-many relationship row by row #eg26
esproc_spl profile
Judy

SQL, output associated records having many-to-many relationship row by row #eg26

#sql #development #programming #esproc
8
Comments
1 min read
HackerRank SQL Preparation: Weather Observation Station 3(MySQL)
christianpaez profile

HackerRank SQL Preparation: Weather Observation Station 3(MySQL)

#sql #hackerrank #writeups #mysql
1
Comments
1 min read
Create Histogram Charts With MySQL – Tutorial
ilvalerione profile

Create Histogram Charts With MySQL – Tutorial

#webdev #mysql #sql #php
4
Comments
4 min read
Launching ChartDB: Visualize database schemas with a single query
jonathanfishner profile

Launching ChartDB: Visualize database schemas with a single query

#database #ai #sql #typescript
5
Comments
1 min read
PREVENT YOUR BACKEND FROM SQL INJECTION
graphitecommunity profile

PREVENT YOUR BACKEND FROM SQL INJECTION

#sql #security #softwareengineering #backend
1
Comments 1
3 min read
RoadMap to Data-Analytics 2024!
parthmagicss profile

RoadMap to Data-Analytics 2024!

#datascience #dataengineering #sql #database
3
Comments
2 min read
An ASP.NET Core Web Api to access and manipulate project data using EF Core, and JWT on a PostgreSQL or SQL Server database.
rperezrosario profile

An ASP.NET Core Web Api to access and manipulate project data using EF Core, and JWT on a PostgreSQL or SQL Server database.

#aspdotnet #webapi #ef #sql
Comments
1 min read
SQL Complete guide for Interview
madgan95 profile

SQL Complete guide for Interview

#sql #mysql #postgres #database
57
Comments 7
13 min read
How to Effectively Use the ALL Keyword in SQL Server Queries
amr-saafan profile

How to Effectively Use the ALL Keyword in SQL Server Queries

#sql #sqlserver #database
Comments
6 min read
Recommended Project: Personnel Management System Database Setup
labby profile
Labby for LabEx

Recommended Project: Personnel Management System Database Setup

#labex #sql #mysql #programming
Comments
3 min read
How I Slashed CPU Usage by 20%: 5 Proven SQL Optimization Techniques
cuongnp profile

How I Slashed CPU Usage by 20%: 5 Proven SQL Optimization Techniques

#sql #webdev #programming #productivity
2
Comments
2 min read
Ma Première Expérience avec SQL Server et T-SQL : Création d'une Base de Données pour une Bibliothèque
ech__nouha profile
nuha

Ma Première Expérience avec SQL Server et T-SQL : Création d'une Base de Données pour une Bibliothèque

#sqlserver #database #sql
Comments
5 min read
Creating Unique Slugs on Supabase with PostgreSQL
g5l profile

Creating Unique Slugs on Supabase with PostgreSQL

#opensource #supabase #postgres #sql
53
Comments 1
3 min read
SQL Server: How to Use the ADD Keyword for Schema Changes
amr-saafan profile

SQL Server: How to Use the ADD Keyword for Schema Changes

#sql #sqlserver #database
Comments
3 min read
Exploring New Features in PostgreSQL 17 with Python
rishisharma profile

Exploring New Features in PostgreSQL 17 with Python

#python #postgres #database #sql
2
Comments 1
3 min read
Understanding Your Data: The Essentials of Exploratory Data Analysis
byron_25abe71a080f93df530 profile

Understanding Your Data: The Essentials of Exploratory Data Analysis

#python #datascience #sql #machinelearning
4
Comments
8 min read
Basic MySQL Queries: A Comprehensive Guide
nirmalyax profile

Basic MySQL Queries: A Comprehensive Guide

#sql #mysql #database #microsoft
7
Comments
4 min read
Database Indexing Explained: Why It's Like a Book's Table of Contents
rajasekhar_beemireddy_cb8 profile

Database Indexing Explained: Why It's Like a Book's Table of Contents

#database #indexing #performance #sql
Comments
3 min read
loading...