Skip to content

DEV Community

select * from SQL

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

👋 Sign in for the ability to sort posts by relevant, latest, or top.

Sean Drew

Dec 9 '24

Boosting SQL Query Flexibility with CROSS APPLY

#sql #sqlserver

2 min read

Abhay Singh Kathayat

Dec 20 '24

Optimizing Your MySQL Queries for Maximum Efficiency

#mysql #database #sql #interview

3 min read

Nov 15 '24

ROLLUP

#sql #oracle #mysql #sqlserver

2 min read

Dec 21 '24

SQL Basic Question for interview

#sql #mysql #interview #database

4 min read

Dec 19 '24

How to detect query which holds the lock in Postgres?

#postgres #sql #database #tutorial

1 min read

Dec 19 '24

Find high dead_tuples

#sql #postgres #database

1 min read

Dec 19 '24

Check Table size in Postgresql Database

#postgres #sql #database #tutorial

1 min read

Nageen Yerramsetty

Nov 19 '24

SQL Window functions: Understanding PARTITION BY

#sql #windowfunctions #database #beginners

5 min read

Dec 18 '24

Understanding Data Partitioning vs. Sharding: Key Concepts for Effective Data Management

#database #data #programming #sql

3 min read

Nov 28 '24

Avoid SELECT *, even on a single-column tables

#database #sql

4 min read

Abhay Singh Kathayat

Dec 18 '24

100 Essential SQL Questions Every Developer Should Master

#help #sql #learnsql #mysql

3 min read

Abhay Singh Kathayat

Dec 18 '24

Understanding SQL Triggers: Automating Database Tasks with Ease

#sql #sqltriggers #database #mysql

3 min read

Abhay Singh Kathayat

Dec 18 '24

SQL Transactions: Ensuring Data Integrity and Consistency

#sql #mysql #database #programming

3 min read

Abhay Singh Kathayat

Dec 18 '24

Mastering SQL Views: Simplify, Secure, and Optimize Your Database Queries

#sql #mysql #postgres #database

3 min read

Abhay Singh Kathayat

Dec 18 '24

Understanding ACID Properties: The Pillars of Reliable Databases

#sql #mysql #database #webdev

3 min read

👋 Sign in for the ability to sort posts by relevant, latest, or top.