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.
What is SQL and Why It’s Essential for Data Management

What is SQL and Why It’s Essential for Data Management

1
Comments
3 min read
Understanding DDL, DML, DCL, and TCL in SQL: Key Differences Explained

Understanding DDL, DML, DCL, and TCL in SQL: Key Differences Explained

Comments
3 min read
SQL Server Database Design and Management in 2025 with a GUI Tool

SQL Server Database Design and Management in 2025 with a GUI Tool

8
Comments 2
6 min read
Construindo Busca Completa no PostgresSQL / Building Complete Search in PostgresSQL

Construindo Busca Completa no PostgresSQL / Building Complete Search in PostgresSQL

1
Comments
5 min read
2024.2: Faster with Shared Memory Between PostgreSQL and TServer Layers

2024.2: Faster with Shared Memory Between PostgreSQL and TServer Layers

Comments
4 min read
Java JDBC + IntelliJ + SQLite - A Beginner's Walkthrough

Java JDBC + IntelliJ + SQLite - A Beginner's Walkthrough

2
Comments
2 min read
Exploring new AWS Aurora DSQL. What is it ? Why it is important ? How to quickstart ?

Exploring new AWS Aurora DSQL. What is it ? Why it is important ? How to quickstart ?

5
Comments
4 min read
Day 1: Getting Started with SQL - Basics | Beginners' Guide : Mastering

Day 1: Getting Started with SQL - Basics | Beginners' Guide : Mastering

7
Comments
2 min read
How to use variables in SQL raiserror

How to use variables in SQL raiserror

Comments
1 min read
Steampipe: Query your cloud infrastructure with SQL for faster insights

Steampipe: Query your cloud infrastructure with SQL for faster insights

Comments 1
1 min read
Top 5 Text2SQL Tools for Effortless SQL Generation

Top 5 Text2SQL Tools for Effortless SQL Generation

3
Comments 1
7 min read
How to Reset a Forgotten MariaDB User Password

How to Reset a Forgotten MariaDB User Password

Comments
1 min read
SQL database projects intro

SQL database projects intro

1
Comments
5 min read
Top AI Tools for Generating SQL in 2024

Top AI Tools for Generating SQL in 2024

1
Comments 1
8 min read
Query optimization in MySQL is crucial for improving database performance, especially when dealing with large datasets

Query optimization in MySQL is crucial for improving database performance, especially when dealing with large datasets

Comments
2 min read
SQL in CouchDB: Get SQS for FREE and Celebrate Our Birthday

SQL in CouchDB: Get SQS for FREE and Celebrate Our Birthday

1
Comments
3 min read
Oracle SQL Script Browser Online

Oracle SQL Script Browser Online

2
Comments
1 min read
Rust-Based Reimagining of SQLite: Leading Asynchronous I/O and Contemporary Improvements

Rust-Based Reimagining of SQLite: Leading Asynchronous I/O and Contemporary Improvements

Comments
2 min read
Technical Interview Questions - Part 6 - SQL 2

Technical Interview Questions - Part 6 - SQL 2

1
Comments
3 min read
SQL: Generate event sequence numbers within a specified time interval #eg89

SQL: Generate event sequence numbers within a specified time interval #eg89

7
Comments
1 min read
Entity Framework Core | Object Relation Mapping | C# | A Beginner's Guide : Mastering

Entity Framework Core | Object Relation Mapping | C# | A Beginner's Guide : Mastering

7
Comments
3 min read
Day 7 of SQL Series || Keys

Day 7 of SQL Series || Keys

5
Comments
5 min read
# 揭秘Proof of SQL:让数据验证变得高效又安全

# 揭秘Proof of SQL:让数据验证变得高效又安全

Comments
1 min read
How I Completed My First SQL Project (And What I Learned)

How I Completed My First SQL Project (And What I Learned)

Comments
3 min read
Everyone Uses Postgres… But Why?

Everyone Uses Postgres… But Why?

2
Comments
9 min read
loading...