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.
How to create a table with SQL code?
jing_li profile

How to create a table with SQL code?

#sql #database #ai #opensource
3
Comments
6 min read
Scenario 2: Mastering Backfilling for New dB Columns – Update Like a Pro!
chidioguejiofor profile

Scenario 2: Mastering Backfilling for New dB Columns – Update Like a Pro!

#sql #typescript #backenddevelopment #performance
1
Comments
4 min read
How to Downsample Your Data Efficiently
dolphindb profile

How to Downsample Your Data Efficiently

#database #dolphindb #quant #sql
Comments
2 min read
Scenario 1: When You Need to Update Multiple Rows with Different Values – The Smart Way!
chidioguejiofor profile

Scenario 1: When You Need to Update Multiple Rows with Different Values – The Smart Way!

#sql #typescript #backenddevelopment #performance
13
Comments 3
3 min read
Turbocharge Your App: Slash DB Calls with Raw SQL Magic!
chidioguejiofor profile

Turbocharge Your App: Slash DB Calls with Raw SQL Magic!

#sql #typescript #performance #sequelize
4
Comments
2 min read
Transaction Control Language TCL - COMMIT, ROLLBACK, and SAVEPOINT
mrcaption49 profile

Transaction Control Language TCL - COMMIT, ROLLBACK, and SAVEPOINT

#sql #plsql #database #backend
4
Comments
3 min read
CASE | DECODE | IF ELSE - Conditional Logic in PLSQL
mrcaption49 profile

CASE | DECODE | IF ELSE - Conditional Logic in PLSQL

#sql #plsql #backend #database
1
Comments
2 min read
Understanding Recursive Queries in PostgreSQL: A Process Hierarchy Example
dm8ry profile

Understanding Recursive Queries in PostgreSQL: A Process Hierarchy Example

#postgres #database #howto #sql
Comments
3 min read
Logical Processing order of a SQL query
mrcaption49 profile

Logical Processing order of a SQL query

#sql #plsql #backend #database
9
Comments 2
4 min read
PL/SQL Cursors
mrcaption49 profile

PL/SQL Cursors

#sql #backend #database #fullstack
2
Comments 2
4 min read
DbVisualizer 24.2: A Complete Review
antozanini profile

DbVisualizer 24.2: A Complete Review

#news #sql #database #productivity
10
Comments
11 min read
PL/SQL Triggers
mrcaption49 profile

PL/SQL Triggers

#sql #plsql #backend #database
1
Comments
3 min read
Deleting Duplicate Data from MySQL
nikhilxd profile

Deleting Duplicate Data from MySQL

#database #sql #programming #tutorial
1
Comments
3 min read
Different ways of working with SQL Databases in Go
der_gopher profile

Different ways of working with SQL Databases in Go

#go #sql #database
2
Comments
9 min read
PLSQL Top 10 Interview Questions
mrcaption49 profile

PLSQL Top 10 Interview Questions

#plsql #sql #backend #fullstack
2
Comments
4 min read
How data is replicated in slave nodes in SQL databases
ankitmalikg profile

How data is replicated in slave nodes in SQL databases

#sql #database #systemdesign #architecture
Comments
3 min read
How I used ChatGPT o1 and Claude for generating a SQL RBAC report and was surprised by the results
juanstoppa profile

How I used ChatGPT o1 and Claude for generating a SQL RBAC report and was surprised by the results

#chatgpt #claude #rbac #sql
Comments
9 min read
Join the Party: A Comprehensive Guide to SQL Joins with Examples
asim_khan_cbe65e41bcbbc65 profile

Join the Party: A Comprehensive Guide to SQL Joins with Examples

#javascript #sql #database #sqlserver
1
Comments
4 min read
NoSQL vs SQL Which one you should use ?
yashrajxdev profile

NoSQL vs SQL Which one you should use ?

#database #sql #programming #beginners
7
Comments
3 min read
Deploy a lightweight BI solution with your first dashboard in 5 steps
jypelle profile

Deploy a lightweight BI solution with your first dashboard in 5 steps

#dashboard #reporting #sql #businessintelligence
1
Comments
2 min read
Database Dizaynda Kalitlar: Hamma Joyda Kalit! 🗝
samandar_komilov profile

Database Dizaynda Kalitlar: Hamma Joyda Kalit! 🗝

#database #sql
1
Comments
5 min read
Fundamentals of Transact-SQL (T-SQL) Queries
minhduc159 profile

Fundamentals of Transact-SQL (T-SQL) Queries

#database #sql #dba #administrator
Comments
2 min read
ERROR: index row size 3056 exceeds btree version 4 maximum 2704 for index
franckpachot profile

ERROR: index row size 3056 exceeds btree version 4 maximum 2704 for index

#yugabytedb #postgres #sql #database
8
Comments
4 min read
7 SQL Concepts You Should Know as a Data Scientist?
sachingeek profile

7 SQL Concepts You Should Know as a Data Scientist?

#sql #datascience
4
Comments
3 min read
Chat2DB: Data Analysis Without Writing SQL Code
jing_li profile

Chat2DB: Data Analysis Without Writing SQL Code

#sql #database #datascience #opensource
2
Comments
4 min read
loading...