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.

Team Timescale for Timescale

Dec 20 '24

13 Tips to Improve PostgreSQL Insert Performance

#postgres #database #beginners #sql

11 min read

Dec 20 '24

Front-End to Full-Stack Journey Part 2: SQL & SQLite

#sql #webdev #express #learning

3 min read

Bobur Umurzokov

Dec 20 '24

Migrating from Azure Database for PostgreSQL to Neon

#postgres #sql #database #programming

7 min read

Sean Drew

Dec 9 '24

Enhancing Time Zone-Sensitive Business Engagement: SQL Logic for Business Hour Validation by Time Zone

#sql #sqlserver

7 min read

Sean Drew

Dec 9 '24

Easily Display Record Counts in SQL Server Using COUNT(*) OVER()

#sql #sqlserver

3 min read

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

Nageen Yerramsetty

Nov 19 '24

SQL Window functions: Understanding PARTITION BY

#sql #windowfunctions #database #beginners

5 min read

Chevy Vall

Nov 14 '24

Validatorian

#webdev #sql #python #flask

4 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

Mastering the SQL UPDATE Statement: Modify Data with Precision

#sql #mysql #postgres #postsql

3 min read

Abhay Singh Kathayat

Dec 18 '24

Understanding ACID Properties: The Pillars of Reliable Databases

#sql #mysql #database #webdev

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 SQL Triggers: Automating Database Tasks with Ease

#sql #sqltriggers #database #mysql

3 min read

Abhay Singh Kathayat

Dec 18 '24

Understanding Stored Procedures: A Guide to Efficient SQL Programming

#sql #mysql #database #webdev

3 min read

Abhay Singh Kathayat

Dec 18 '24

Denormalization in Databases: Enhancing Performance with Redundant Data

#sql #mysql #database #webdev

3 min read

Abhay Singh Kathayat

Dec 18 '24

Understanding Database Normalization: Ensuring Efficient and Consistent Data Storage

#sql #database #databasenormalization #mysql

3 min read

Abhay Singh Kathayat

Dec 18 '24

Clustered vs Non-Clustered Indexes: Key Differences for Database Optimization

#sql #mysql #database #webdev

3 min read

Abhay Singh Kathayat

Dec 18 '24

Understanding Normal Forms in Database Design: A Comprehensive Guide

#sql #mysql #database #tutorial

4 min read

Abhay Singh Kathayat

Dec 18 '24

SQL UNION vs UNION ALL: Key Differences Explained

#sql #mysql #database #webdev

2 min read

Abhay Singh Kathayat

Dec 18 '24

Understanding SQL Subqueries: A Complete Guide with Examples

#sql #sqlserver #mysql #database

2 min read

loading...