Forem

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.
Database Indexing Done Right: Why Your "Optimized" Queries Might Be Slower Than Before

Database Indexing Done Right: Why Your "Optimized" Queries Might Be Slower Than Before

1
Comments
6 min read
Day 5: Advanced SELECT Queries and JOINs

Day 5: Advanced SELECT Queries and JOINs

Comments
3 min read
Busca de um valor em todas as tabelas e colunas no PostgreSQL 🐘
Cover image for Busca de um valor em todas as tabelas e colunas no PostgreSQL 🐘

Busca de um valor em todas as tabelas e colunas no PostgreSQL 🐘

Comments
2 min read
I Built a Tool to Turn Any SQL Dump File into a Live Database in Seconds

I Built a Tool to Turn Any SQL Dump File into a Live Database in Seconds

Comments
2 min read
How did I learn about Transaction Log, Redo Log, and Undo Log as a developer?

How did I learn about Transaction Log, Redo Log, and Undo Log as a developer?

Comments
1 min read
Building a FHIR Vector Repository with InterSystems IRIS and Python through the IRIStool module

Building a FHIR Vector Repository with InterSystems IRIS and Python through the IRIStool module

Comments
5 min read
The Future of Data-Native & Grounded AI with MindsDB: Moving Data to Models No Longer Makes Sense
Cover image for The Future of Data-Native & Grounded AI with MindsDB: Moving Data to Models No Longer Makes Sense

The Future of Data-Native & Grounded AI with MindsDB: Moving Data to Models No Longer Makes Sense

5
Comments
8 min read
Revolutionizing SQL Development with Oracle APEX AI Assistant

Revolutionizing SQL Development with Oracle APEX AI Assistant

5
Comments
2 min read
Entenda os JOINS no SQL e como aplicar certo tipo para cada cenário

Entenda os JOINS no SQL e como aplicar certo tipo para cada cenário

Comments
1 min read
Commenting in MySQL: Syntax, Hints, and Practical Examples
Cover image for Commenting in MySQL: Syntax, Hints, and Practical Examples

Commenting in MySQL: Syntax, Hints, and Practical Examples

Comments
2 min read
🧠 SQL for Beginners: The 10 Most Common Queries Explained
Cover image for 🧠 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
Advanced Query Capabilities 👉🏻 aggregation pipelines

Advanced Query Capabilities 👉🏻 aggregation pipelines

Comments
4 min read
😱 Stop Writing Useless SQL Queries! Discover the Secret Powers of Window Functions
Cover image for 😱 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
Day 4: Inserting Data and Basic CRUD Operations

Day 4: Inserting Data and Basic CRUD Operations

Comments 1
3 min read
Getting Started Building a Data Platform

Getting Started Building a Data Platform

Comments
3 min read
Detecting Sales Anomalies with ML.NET — Razor Dashboard + SQL Integration
Cover image for 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
Cover image for 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
Cover image for ChatGPT Alternative for SQL Query Optimization

ChatGPT Alternative for SQL Query Optimization

5
Comments
2 min read
Making SQL Queries Clearer with Aliases
Cover image for 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
loading...