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.
Mastering Oracle SQL Interview Questions: Tips and Answers
nikhilxd profile

Mastering Oracle SQL Interview Questions: Tips and Answers

#sql #oracle #plsql #interview
2
Comments
2 min read
Multi-Tenant SaaS Architecture - Database Per Tenant
developerpartners profile

Multi-Tenant SaaS Architecture - Database Per Tenant

#dotnet #saas #csharp #sql
3
Comments 1
6 min read
Visualização automática de esquemas de databases do Sqlite
msc2020 profile

Visualização automática de esquemas de databases do Sqlite

#sql #tutorial #beginners #braziliandevs
Comments
7 min read
Crash on clock skew: performance vs availability
franckpachot profile

Crash on clock skew: performance vs availability

#yugabytedb #distributed #sql #database
2
Comments
7 min read
Fetching Data (Next.js)
samuellubliner profile

Fetching Data (Next.js)

#webdev #javascript #sql #nextjs
1
Comments
2 min read
Foreign-key pre-join
esproc_spl profile
Judy

Foreign-key pre-join

#sql #join #development #lauguage
6
Comments
5 min read
⚡️ Gowebly CLI now supports the PocketBase framework
koddr profile

⚡️ Gowebly CLI now supports the PocketBase framework

#news #go #webdev #sql
7
Comments 1
2 min read
Introdução aos Princípios do SQL: Fundamentos Teóricos e Práticos
brunopizol profile

Introdução aos Princípios do SQL: Fundamentos Teóricos e Práticos

#sql #braziliandevs #dotnet #mysql
7
Comments
17 min read
OLAP: CUBE, ROLLUP, AND GROUPING SETS
marklouisalter profile

OLAP: CUBE, ROLLUP, AND GROUPING SETS

#database #sql #mysql #postgres
2
Comments 1
4 min read
Advisory/Custom/Application Lock with YugabyteDB
franckpachot profile

Advisory/Custom/Application Lock with YugabyteDB

#yugqbytedb #distributed #sql #database
Comments
5 min read
Journey to modern databases
adammetis profile

Journey to modern databases

#sql #database #monitoring #observability
Comments
9 min read
DynamoDB Query Evaluation Order Differs from SQL
siddhantkcode profile

DynamoDB Query Evaluation Order Differs from SQL

#database #learning #sql #aws
4
Comments
2 min read
SQL Join Types Explained: Inner, Outer, and More in 2024
nikhilxd profile

SQL Join Types Explained: Inner, Outer, and More in 2024

#sql #programming #computerscience #database
1
Comments
2 min read
Streamlining Node Property Data Retrieval in Umbraco: A Quick Guide
shekhartarare profile

Streamlining Node Property Data Retrieval in Umbraco: A Quick Guide

#umbraco #sql #tutorial
Comments
2 min read
SQL's LIKE, ILIKE, and NOT LIKE: Beginner's Breakdown
marklouisalter profile

SQL's LIKE, ILIKE, and NOT LIKE: Beginner's Breakdown

#sql #mysql #database #postgres
5
Comments
2 min read
A lightweight YugabyteDB docker image for CI/CD
franckpachot profile

A lightweight YugabyteDB docker image for CI/CD

#yugabyteb #docker #distributed #sql
Comments
2 min read
Dimension alignment
esproc_spl profile
Judy

Dimension alignment

#sql #development #join #programming
5
Comments 1
4 min read
Top 10 most asked SQL interview questions along with their answers
nikhilxd profile

Top 10 most asked SQL interview questions along with their answers

#sql #database #computerscience #career
1
Comments 2
3 min read
How does Wave Analytics handle data from external databases in PostgreSQL?
shiviyer profile

How does Wave Analytics handle data from external databases in PostgreSQL?

#postgres #sql #dba
Comments
3 min read
Using T-SQL To Generate Large Amounts Of Test Data
jzuerlein profile

Using T-SQL To Generate Large Amounts Of Test Data

#sql #testing
Comments
1 min read
Understanding JDBC Three-Tier Architecture: A Detailed Overview
nikhilxd profile

Understanding JDBC Three-Tier Architecture: A Detailed Overview

#java #jdbc #springboot #sql
1
Comments
3 min read
Complete Guide To Transaction Isolation Levels in SQL
antonmartyniuk profile

Complete Guide To Transaction Isolation Levels in SQL

#programming #database #sql
Comments
7 min read
Common Table Expressions (CTEs) in SQL
johnkyalo profile

Common Table Expressions (CTEs) in SQL

#database #datascience #sql #analytics
3
Comments
1 min read
Flask and APIs
whoamivoyager profile

Flask and APIs

#webdev #flask #sql #python
Comments
3 min read
Exploring SQL Functions: Harnessing the Power of Built-in Functions
tinapyp profile

Exploring SQL Functions: Harnessing the Power of Built-in Functions

#datascience #database #sql #beginners
Comments
3 min read
Are There “Queries over Trillion-Row Tables in Seconds”? Is “N-Times Faster Than ORACLE” an Exaggeration?
jbx1279 profile

Are There “Queries over Trillion-Row Tables in Seconds”? Is “N-Times Faster Than ORACLE” an Exaggeration?

#sql #performance #bigdata #database
Comments
4 min read
Scheduling a BigQuery SQL script, using Apache Airflow, with an example
rajun profile

Scheduling a BigQuery SQL script, using Apache Airflow, with an example

#airflow #bigquery #dataengineering #sql
7
Comments 1
2 min read
HackerRank SQL preparation; Revising the Select Query II(MySQL)
christianpaez profile

HackerRank SQL preparation; Revising the Select Query II(MySQL)

#sql #writeups #hackerrank
1
Comments
1 min read
Exploring Advanced SQL Techniques: Aggregation Methods for Structured Data Retrieval
emtiajium profile

Exploring Advanced SQL Techniques: Aggregation Methods for Structured Data Retrieval

#postgres #sql #database
33
Comments 1
4 min read
SQL Server Basics
quyit profile

SQL Server Basics

#sql #sqlserver #nqdev
Comments
6 min read
How I migrated from Firebase to Supabase
ja profile

How I migrated from Firebase to Supabase

#postgres #sql #firebase #webdev
21
Comments 2
5 min read
Using Temporary Tables in MariaDB
alejandro_du profile

Using Temporary Tables in MariaDB

#mariadb #sql #database #tips
3
Comments
2 min read
A tale of TimescaleDB, SQLx and testing in Rust
exein profile
Exein

A tale of TimescaleDB, SQLx and testing in Rust

#security #rust #sql #testing
2
Comments 1
18 min read
The Essential Guide to Database Backup: Tips & Strategies
adammetis profile

The Essential Guide to Database Backup: Tips & Strategies

#sql #database #backup
1
Comments
11 min read
Quick SQL guide and cheat sheet: Essential Commands
dbvismarketing profile

Quick SQL guide and cheat sheet: Essential Commands

#sql
Comments
1 min read
Find increases, latest values, and cumulative sums in SQL (postgres)
jasonstitt profile

Find increases, latest values, and cumulative sums in SQL (postgres)

#sql #postgres #database #tutorial
Comments
7 min read
INTRODUCTION TO SQL
marklouisalter profile

INTRODUCTION TO SQL

#sql #mysql #postgres #database
1
Comments 2
4 min read
Tracking Personal Finances with SQL: Learn As You Manage Your Money!
yisakt profile

Tracking Personal Finances with SQL: Learn As You Manage Your Money!

#sql #database #personalfinance
7
Comments
2 min read
SQL | DDL, DQL, DML, DCL and TCL Commands
rakeshvngowda profile

SQL | DDL, DQL, DML, DCL and TCL Commands

#sql #database
6
Comments
2 min read
A Software Engineer's Tips and Tricks #1: Drizzle
alisdairbr profile

A Software Engineer's Tips and Tricks #1: Drizzle

#webdev #sql #orm #tutorial
2
Comments 1
2 min read
Tutorial Duckdb
fsimoes profile

Tutorial Duckdb

#duckdb #sql #python
1
Comments 1
6 min read
Widget Dashboards via Wizard's Toolkit
alecbsherman profile
Alec

Widget Dashboards via Wizard's Toolkit

#webdev #lowcode #php #sql
Comments
3 min read
What is SQL in pictures. Diving deeper (Part 2)
onumaku_bobby profile

What is SQL in pictures. Diving deeper (Part 2)

#sql #datascience
1
Comments
2 min read
Optimizing ClickHouse Performance: Strategies for Identifying and Reducing Over-fetching in SELECT Queries
shiviyer profile

Optimizing ClickHouse Performance: Strategies for Identifying and Reducing Over-fetching in SELECT Queries

#clickhouse #sql #dba #olap
2
Comments
3 min read
SQL DATA MANIPULATION
marklouisalter profile

SQL DATA MANIPULATION

#sql #database #mysql #postgressql
2
Comments
3 min read
5 Best SQL IDEs [EXPERT RANKING]
domfive profile

5 Best SQL IDEs [EXPERT RANKING]

#sql #sqlserver #learning #review
Comments
13 min read
JOINS IN SQL
johnkyalo profile

JOINS IN SQL

#datascience #database #sql #data
2
Comments
2 min read
How to Back Up and Restore Azure SQL Databases
alex_tray profile

How to Back Up and Restore Azure SQL Databases

#azure #sql #database #backup
1
Comments
8 min read
How to calculate the distance between Kyoto and Tokyo using a PostgreSQL database?
dm8ry profile

How to calculate the distance between Kyoto and Tokyo using a PostgreSQL database?

#postgres #database #sql #howto
3
Comments 1
2 min read
Configuring Statement Timeout in PostgreSQL for Optimal Performance Management
shiviyer profile

Configuring Statement Timeout in PostgreSQL for Optimal Performance Management

#postgres #sql #dbatips #dba
15
Comments
2 min read
Optimizing SQL Performance: Best Practices for Efficient Database Operations
tinapyp profile

Optimizing SQL Performance: Best Practices for Efficient Database Operations

#sql #database #beginners #datascience
Comments
3 min read
About transaction identifier (transaction_id) in PostgreSQL.
dm8ry profile

About transaction identifier (transaction_id) in PostgreSQL.

#postgres #devops #database #sql
8
Comments
2 min read
Platform Engineers Must Change Developers and Databases - And Here Is How
adammetis profile

Platform Engineers Must Change Developers and Databases - And Here Is How

#sql #database #monitoring #platformengineering
Comments
9 min read
Statistical information about tables in a PostgreSQL Database.
dm8ry profile

Statistical information about tables in a PostgreSQL Database.

#postgres #database #sql #devops
3
Comments
2 min read
Understanding of NULL in PostgreSQL database.
dm8ry profile

Understanding of NULL in PostgreSQL database.

#postgressql #database #sql #howto
3
Comments
2 min read
PostgreSQL: Deleting all records from a table, except for the first and last ones.
dm8ry profile

PostgreSQL: Deleting all records from a table, except for the first and last ones.

#postgres #database #sql #data
3
Comments
2 min read
How to find the third and fifth-highest values in a PostgreSQL table?
dm8ry profile

How to find the third and fifth-highest values in a PostgreSQL table?

#postgres #database #howto #sql
2
Comments
2 min read
How to join tables in PostgreSQL using the WITH clause?
dm8ry profile

How to join tables in PostgreSQL using the WITH clause?

#postgres #database #sql #howto
1
Comments
2 min read
Types of equi-joins
esproc_spl profile
Judy

Types of equi-joins

#sql #join #eaui #development
7
Comments 1
4 min read
Calculate the Total Price According to the Cumulative Price Table
esproc_spl profile
Judy

Calculate the Total Price According to the Cumulative Price Table

#sql #database #development #laugenge
11
Comments 3
1 min read
loading...