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 Versus NoSQL Databases: Which to Use, When, and Why
yuvalhazaz profile

SQL Versus NoSQL Databases: Which to Use, When, and Why

#sql #postgres #mongodb #database
16
Comments
9 min read
Stored Procedures in SQL database
roywanyoike profile

Stored Procedures in SQL database

#database #sql #backend #mongodb
2
Comments
2 min read
DROP IF EXISTS & CREATE IF NOT EXISTS in Oracle, MySQL, MariaDB, PostgreSQL, YugabyteDB
franckpachot profile

DROP IF EXISTS & CREATE IF NOT EXISTS in Oracle, MySQL, MariaDB, PostgreSQL, YugabyteDB

#sql #database #ddl #idempotent
15
Comments
5 min read
Transactions - difference between SQL, SQLAlchemy and Django ORM
skerdi profile

Transactions - difference between SQL, SQLAlchemy and Django ORM

#sql #django #sqlalchemy #transaction
Comments
2 min read
Simplest pyspark tutorial
ndurumo254 profile

Simplest pyspark tutorial

#spark #bigdata #machinelearning #sql
2
Comments
7 min read
Cloud ETL Pipeline in Azure
mannyerivero profile

Cloud ETL Pipeline in Azure

#azure #python #sql #cloud
1
Comments
8 min read
SQL 102:Intermediate SQL
marrie profile

SQL 102:Intermediate SQL

#sql #database #postgres #dataengineering
Comments
10 min read
When to use (SELCET * FROM CTE) or just LEFT JOIN CTE?
mahmoudai profile

When to use (SELCET * FROM CTE) or just LEFT JOIN CTE?

#sql
6
Comments 1
2 min read
Loop on static content to upsert many rows in Oracle SQL
zopad profile

Loop on static content to upsert many rows in Oracle SQL

#oracle #sql #programming #database
1
Comments
1 min read
Performance Enhancement: Conversion Funnel Analysis
jbx1279 profile

Performance Enhancement: Conversion Funnel Analysis

#bigdata #sql #database #programming
Comments
9 min read
Quick and Handy Tips for Everyday PostgreSQL Tasks
andreasbergstrom profile

Quick and Handy Tips for Everyday PostgreSQL Tasks

#postgres #sql
1
Comments
2 min read
🔄 Self-reference Laravel Model
joaorbrandao profile

🔄 Self-reference Laravel Model

#php #laravel #sql #relational
6
Comments
3 min read
How to write an anonymous PL/SQL function and use it in your SQL statement
gvenzl profile

How to write an anonymous PL/SQL function and use it in your SQL statement

#sql #oracle #database #plsql
Comments
3 min read
Scalable bounded COUNT DISTINCT in YugabyteDB
franckpachot profile

Scalable bounded COUNT DISTINCT in YugabyteDB

#yugabytedb #distributed #sql #database
Comments
6 min read
All about Structure Query Language (SQL)
zapeeosheikh profile

All about Structure Query Language (SQL)

#sql #sqlquery #mysql #dataengineering
Comments
10 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.