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
bantu_ngxola profile

🧠 SQL for Beginners: The 10 Most Common Queries Explained

#sql #sqlserver #mariadb #database
Comments
3 min read
PL/SQL Program Data: Naming, Declaring, and Best Practices
ayako_yk profile

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

#beginners #learning #database #sql
Comments
3 min read
INNER JOIN and LEFT OUTER JOIN in MongoDB (with $lookup and $unwind)
franckpachot profile

INNER JOIN and LEFT OUTER JOIN in MongoDB (with $lookup and $unwind)

#mongodb #database #sql #join
2
Comments 2
8 min read
The Offline Data Engineer: Building Resilient API Pipelines that Work on an Airplane
markolekic profile

The Offline Data Engineer: Building Resilient API Pipelines that Work on an Airplane

#python #dataengineering #api #sql
4
Comments
5 min read
Advanced Query Capabilities 👉🏻 aggregation pipelines
franckpachot profile

Advanced Query Capabilities 👉🏻 aggregation pipelines

#database #mongodb #sql
Comments
4 min read
😱 Stop Writing Useless SQL Queries! Discover the Secret Powers of Window Functions
ekwoster profile

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

#sql #webdev #performance #database
Comments
3 min read
База Данных
erlan_akbar profile

База Данных

#beginners #tutorial #database #sql
Comments
4 min read
Why Couchbase Is the NoSQL Solution for Demanding Applications
jumptotech profile

Why Couchbase Is the NoSQL Solution for Demanding Applications

#distributedsystems #database #sql #performance
2
Comments
5 min read
🧠 ClickHouse LEFT JOINs: Why join_use_nulls Matters
ranjbaryshahab profile

🧠 ClickHouse LEFT JOINs: Why join_use_nulls Matters

#clickhouse #sql #dataengineering #join
5
Comments
2 min read
Getting Started Building a Data Platform
jorinvo profile

Getting Started Building a Data Platform

#dataengineering #database #sql
Comments
3 min read
База Данных 2 Практика
erlan_akbar profile

База Данных 2 Практика

#sql #database #tutorial #beginners
Comments
2 min read
Beyond Text: Building an AI-Powered Color Matcher in Oracle FreeSQL
smyekh profile

Beyond Text: Building an AI-Powered Color Matcher in Oracle FreeSQL

#oracle #ai #sql #tutorial
3
Comments
14 min read
Detecting Sales Anomalies with ML.NET — Razor Dashboard + SQL Integration
reshma_p_f93cbf8b077366c6 profile

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

#dotnet #sql #tutorial #machinelearning
1
Comments
3 min read
SQL as Contract vs. Python as Procedure — a Short Note on Atlas vs. Alembic
unauthorized profile

SQL as Contract vs. Python as Procedure — a Short Note on Atlas vs. Alembic

#database #sql #architecture #python
Comments 1
2 min read
Beginner-Friendly PL/SQL and JavaScript MLE Examples for Oracle 26ai
rajesh_vohra_e75f579b7888 profile

Beginner-Friendly PL/SQL and JavaScript MLE Examples for Oracle 26ai

#javascript #beginners #database #sql
10
Comments 1
2 min read
Understanding Oracle Datetime Datatypes: DATE, TIMESTAMP, and INTERVAL
ayako_yk profile

Understanding Oracle Datetime Datatypes: DATE, TIMESTAMP, and INTERVAL

#beginners #database #learning #sql
3
Comments
3 min read
ChatGPT Alternative for SQL Query Optimization
drupaladmin profile

ChatGPT Alternative for SQL Query Optimization

#webdev #programming #sql #devops
5
Comments
2 min read
The Six Failures of Text-to-SQL (And How to Fix Them with Agents)
kweinmeister profile

The Six Failures of Text-to-SQL (And How to Fix Them with Agents)

#googleadk #relationaldatabases #sql #agents
18
Comments
10 min read
Trying to start using graphql and psql using pytthon to start a website
vatsalya_rabari_2ad492f38 profile

Trying to start using graphql and psql using pytthon to start a website

#python #webdev #graphql #sql
2
Comments
1 min read
Making SQL Queries Clearer with Aliases
dbvismarketing profile

Making SQL Queries Clearer with Aliases

#sql #alias
Comments
2 min read
Undo Redo Database Queries
mohammed-al-ameen profile

Undo Redo Database Queries

#database #postgres #sql #tutorial
Comments
25 min read
Implementing Hierarchical Data Structures in PostgreSQL: LTREE vs Adjacency List vs Closure Table
dowerdev profile

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

#database #postgres #sql
Comments
18 min read
Query Anything with SQL: Your Developer's Deep Dive into Apache Drill
jennythomas498 profile

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

#sql #bigdata #database
Comments
8 min read
SQL is King, But is it Your Only Ruler? A Developer's Guide to NoSQL
kallileiser profile

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

#database #nosql #sql
1
Comments
7 min read
Your ORM is Lying to You About SQL (CTEs Explained)
pascal_cescato_692b7a8a20 profile

Your ORM is Lying to You About SQL (CTEs Explained)

#sql #database #performance #productivity
5
Comments
8 min read
loading...