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.
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
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
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
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
2
Comments
3 min read
DBMS - Introduction
jitmitra profile

DBMS - Introduction

#dbms #database #sql #beginners
1
Comments 1
1 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 6
4 min read
Uploading Excel Files to SSMS Table
salonynhp profile

Uploading Excel Files to SSMS Table

#api #dotnet #sql #beginners
Comments
3 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
3
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
Compare two csv files #eg34
esproc_spl profile
Judy

Compare two csv files #eg34

#sql #development #programming #esproc
7
Comments 1
1 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
9
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
26
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
2
Comments
1 min read
Create Histogram Charts With MySQL – Tutorial
ilvalerione profile

Create Histogram Charts With MySQL – Tutorial

#webdev #mysql #sql #php
1
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
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
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
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
Boost Your Website Security for Free with SafeLine WAF
lulu_liu_c90f973e2f954d7f profile
Lulu

Boost Your Website Security for Free with SafeLine WAF

#cybersecurity #webdev #sql #opensource
6
Comments
3 min read
SQL, compute cumulative sums according to the termination condition #eg29
esproc_spl profile
Judy

SQL, compute cumulative sums according to the termination condition #eg29

#sql #development #programming #esproc
7
Comments 1
1 min read
SafeLine: Secure Your Web Applications Effortlessly
lulu_liu_c90f973e2f954d7f profile
Lulu

SafeLine: Secure Your Web Applications Effortlessly

#cybersecurity #sql #webdev #opensource
6
Comments
2 min read
Cast for type conversion in SQL
allan-pg profile

Cast for type conversion in SQL

#sql #database #mariadb #mysql
1
Comments
2 min read
Calculating Fingerprints For SQL Queries
adammetis profile

Calculating Fingerprints For SQL Queries

#sql #database #postgres
Comments
4 min read
loading...