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.
🧠 SQL for Beginners: The 10 Most Common Queries Explained

🧠 SQL for Beginners: The 10 Most Common Queries Explained

Comments
3 min read
PL/SQL Program Data: Naming, Declaring, and Best Practices

PL/SQL Program Data: Naming, Declaring, and Best Practices

Comments
3 min read
Templating Columns in dbt: Helpful path to forward

Templating Columns in dbt: Helpful path to forward

Comments
6 min read
😱 Stop Writing Useless SQL Queries! Discover the Secret Powers of Window Functions

😱 Stop Writing Useless SQL Queries! Discover the Secret Powers of Window Functions

Comments
3 min read
Getting Started Building a Data Platform

Getting Started Building a Data Platform

Comments
3 min read
The Real Costs of ETL and How MindsDB Eliminates Them

The Real Costs of ETL and How MindsDB Eliminates Them

Comments
8 min read
Detecting Sales Anomalies with ML.NET — Razor Dashboard + SQL Integration

Detecting Sales Anomalies with ML.NET — Razor Dashboard + SQL Integration

1
Comments
3 min read
Is SPL more difficult or easier than SQL?

Is SPL more difficult or easier than SQL?

5
Comments
15 min read
Understanding Subqueries in SQL and Building JSON Directly in PostgreSQL

Understanding Subqueries in SQL and Building JSON Directly in PostgreSQL

1
Comments
5 min read
ChatGPT Alternative for SQL Query Optimization

ChatGPT Alternative for SQL Query Optimization

5
Comments
2 min read
Making SQL Queries Clearer with Aliases

Making SQL Queries Clearer with Aliases

2
Comments
2 min read
An Introduction to Commonly Used PL/SQL Data Types

An Introduction to Commonly Used PL/SQL Data Types

Comments
4 min read
Beautify and Organize Your Queries Effortlessly with DevUtilX SQL Formatter 💡

Beautify and Organize Your Queries Effortlessly with DevUtilX SQL Formatter 💡

Comments
2 min read
Undo Redo Database Queries

Undo Redo Database Queries

Comments
25 min read
Implementing Hierarchical Data Structures in PostgreSQL: LTREE vs Adjacency List vs Closure Table

Implementing Hierarchical Data Structures in PostgreSQL: LTREE vs Adjacency List vs Closure Table

Comments
18 min read
Query Anything with SQL: Your Developer's Deep Dive into Apache Drill

Query Anything with SQL: Your Developer's Deep Dive into Apache Drill

Comments
8 min read
SQL is King, But is it Your Only Ruler? A Developer's Guide to NoSQL

SQL is King, But is it Your Only Ruler? A Developer's Guide to NoSQL

1
Comments
7 min read
🏦 Database Magic: Automating Tasks with Cursor and Trigger ✨

🏦 Database Magic: Automating Tasks with Cursor and Trigger ✨

Comments
3 min read
py schema

py schema

Comments
2 min read
Database Normalization: From 1NF to 3NF

Database Normalization: From 1NF to 3NF

Comments
2 min read
Cursor +Trigger

Cursor +Trigger

Comments
2 min read
🚀 Unlocking Data with Natural Language: Introducing QueryCraftAI

🚀 Unlocking Data with Natural Language: Introducing QueryCraftAI

5
Comments
3 min read
Understanding SQL Databases

Understanding SQL Databases

1
Comments
1 min read
How I helped Revamp an Organization's Online Presence

How I helped Revamp an Organization's Online Presence

Comments
2 min read
ACID Properties in DBMS

ACID Properties in DBMS

Comments
1 min read
loading...