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.
Building SW: Lessons from the Backend

Building SW: Lessons from the Backend

1
Comments
8 min read
👉 “Top 5 SQL Query Patterns Every Developer Should Know for Interviews”

👉 “Top 5 SQL Query Patterns Every Developer Should Know for Interviews”

Comments
1 min read
👉 “SQL Joins Explained Like You’re 5 (Interview-Friendly Guide)”

👉 “SQL Joins Explained Like You’re 5 (Interview-Friendly Guide)”

Comments
1 min read
MySQL Labs: Change Defaults, Add Constraints, Encrypt Passwords & Optimize Indexes

MySQL Labs: Change Defaults, Add Constraints, Encrypt Passwords & Optimize Indexes

Comments
2 min read
Filtering and Retrieving in SQL

Filtering and Retrieving in SQL

1
Comments 2
3 min read
How to Always Write Optimized Queries in Amazon Redshift - Complete Guide

How to Always Write Optimized Queries in Amazon Redshift - Complete Guide

Comments
7 min read
Converting CSV to PDF HTML JSON & SQL

Converting CSV to PDF HTML JSON & SQL

Comments
7 min read
Oracle SQL Plan Management - 23ai features backported to 19.22

Oracle SQL Plan Management - 23ai features backported to 19.22

2
Comments
4 min read
Simplifying SQL Date Data Types with Practical Tips

Simplifying SQL Date Data Types with Practical Tips

Comments
1 min read
OWOX Data Marts - Free Open-Source Self-Service Analytics Platform

OWOX Data Marts - Free Open-Source Self-Service Analytics Platform

Comments
1 min read
Zero Downtime Migrations: Shadow Table Strategy Explained

Zero Downtime Migrations: Shadow Table Strategy Explained

1
Comments
9 min read
Why Are Firewalls Necessary for Your Website

Why Are Firewalls Necessary for Your Website

7
Comments
2 min read
Optimized Transaction and Resource Management for Provisioning Rules in SailPoint IdentityIQ with Java

Optimized Transaction and Resource Management for Provisioning Rules in SailPoint IdentityIQ with Java

Comments
4 min read
Practice #4: Large Primary-Subtable Join:A Lightweight Solution to Speed up Queries by Dumping Data to Files

Practice #4: Large Primary-Subtable Join:A Lightweight Solution to Speed up Queries by Dumping Data to Files

5
Comments 1
4 min read
Stored Procedures: Organization and Code Quality in SQL

Stored Procedures: Organization and Code Quality in SQL

2
Comments
2 min read
SQL HAVING Explained: Filter Grouped Data With Ease

SQL HAVING Explained: Filter Grouped Data With Ease

Comments
2 min read
Inner Join vs Left Join vs Right Join vs Full Join

Inner Join vs Left Join vs Right Join vs Full Join

Comments
3 min read
SQL Server Paging: Which Method is Fastest?

SQL Server Paging: Which Method is Fastest?

Comments
4 min read
SQL Server Triggers : Made Fun to Learn!

SQL Server Triggers : Made Fun to Learn!

5
Comments
3 min read
Why Use SQL Databases for AI Agent Memory

Why Use SQL Databases for AI Agent Memory

12
Comments 1
6 min read
Capture Slowly Changing Attributes in SQL - SCD Type 2

Capture Slowly Changing Attributes in SQL - SCD Type 2

Comments
8 min read
College Student & Course Management System

College Student & Course Management System

1
Comments
3 min read
SQLite: Randomly order rows

SQLite: Randomly order rows

2
Comments
1 min read
DummyDatabase.com: DATA GENERATION MADE SIMPLE

DummyDatabase.com: DATA GENERATION MADE SIMPLE

Comments
2 min read
College Student & Course Management System

College Student & Course Management System

3
Comments
3 min read
loading...