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.
AEM: Connect AEM to an External database (Oracle example)

AEM: Connect AEM to an External database (Oracle example)

Comments
5 min read
607. Sales Person leetcode solution

607. Sales Person leetcode solution

4
Comments
1 min read
Quem é melhor? ORM ou SQL puro?

Quem é melhor? ORM ou SQL puro?

3
Comments 1
9 min read
SQL Versus NoSQL Databases: Which to Use, When, and Why

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

16
Comments
9 min read
Stored Procedures in SQL database

Stored Procedures in SQL database

2
Comments
2 min read
DROP IF EXISTS & CREATE IF NOT EXISTS in Oracle, MySQL, MariaDB, PostgreSQL, YugabyteDB

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

15
Comments
5 min read
Transactions - difference between SQL, SQLAlchemy and Django ORM

Transactions - difference between SQL, SQLAlchemy and Django ORM

Comments
2 min read
Simplest pyspark tutorial

Simplest pyspark tutorial

2
Comments
7 min read
Cloud ETL Pipeline in Azure

Cloud ETL Pipeline in Azure

1
Comments
8 min read
SQL 102:Intermediate SQL

SQL 102:Intermediate SQL

Comments
10 min read
When to use (SELCET * FROM CTE) or just LEFT JOIN CTE?

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

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

Loop on static content to upsert many rows in Oracle SQL

1
Comments
1 min read
Performance Enhancement: Conversion Funnel Analysis

Performance Enhancement: Conversion Funnel Analysis

Comments
9 min read
Quick and Handy Tips for Everyday PostgreSQL Tasks

Quick and Handy Tips for Everyday PostgreSQL Tasks

1
Comments
2 min read
🔄 Self-reference Laravel Model

🔄 Self-reference Laravel Model

6
Comments
3 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.