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 write SQL recursive CTE in 5 steps
franckpachot profile

How to write SQL recursive CTE in 5 steps

#postgres #yugabytedb #sql #database
55
Comments 9
7 min read
Learn SQL: Microsoft SQL Server - Episode 12: Finding the length of a String
ifierygod profile

Learn SQL: Microsoft SQL Server - Episode 12: Finding the length of a String

#beginners #sql #database #programming
7
Comments
3 min read
Creating Tables and Associations using Ruby/Active Record/Rake
wgotterer profile

Creating Tables and Associations using Ruby/Active Record/Rake

#ruby #sql #beginners #database
6
Comments
5 min read
Fun times with MySQL upgrade
netcat5679 profile

Fun times with MySQL upgrade

#sql #tips #tipsandtricks #mysql
4
Comments
5 min read
Getting started with Redshift
barbara profile

Getting started with Redshift

#aws #beginners #dwh #sql
10
Comments
5 min read
My week three experience as an intern at TaskForce4.0
cyimanafaisal profile

My week three experience as an intern at TaskForce4.0

#database #sql
4
Comments
2 min read
Seven URL Shortener
rithvik78 profile

Seven URL Shortener

#sql #python #flask #sqlalchemy
6
Comments 1
10 min read
What Is Trino And Why Is It Great At Processing Big Data
seattledataguy profile

What Is Trino And Why Is It Great At Processing Big Data

#database #bigdata #datascience #sql
27
Comments
7 min read
Extracting example SQL statements from a log
bugmagnet profile

Extracting example SQL statements from a log

#deno #javascript #sql
3
Comments
3 min read
SQL Server Interview Questions
cloudytech147 profile

SQL Server Interview Questions

#sql #server #career
12
Comments 4
2 min read
Quick 📸 on 🐘 active SQL from pg_stat_statements
franckpachot profile

Quick 📸 on 🐘 active SQL from pg_stat_statements

#postgres #yugabytedb #sql #database
8
Comments
3 min read
7 modern and practical MySQL/MariaDB features you should know and use
martinkordas profile

7 modern and practical MySQL/MariaDB features you should know and use

#mysql #sql #database
4
Comments
5 min read
⏱ Read from the nearest peer in a multi-region database 🚀 with followers read
franckpachot profile

⏱ Read from the nearest peer in a multi-region database 🚀 with followers read

#yugabytedb #distributed #sql #database
6
Comments
12 min read
How to count newest entries created in an oracle database
ama profile

How to count newest entries created in an oracle database

#oracle #sql #codever #snippets
6
Comments 2
1 min read
What is the N prefix in MSSQL all about?
ranggakd profile

What is the N prefix in MSSQL all about?

#sql #beginners #mssql #sqlserver
5
Comments
3 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.