Skip to content

DEV Community

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

👋 Sign in for the ability to sort posts by relevant, latest, or top.

Soumitra Banerjee

May 1 '21

PIVOT-UNPIVOT

#sql #database

1 min read

Greg Schafer for Tangram Vision

Apr 30 '21

Creating PostgreSQL Test Data with SQL, PL/pgSQL, and Python

#tutorial #postgres #sql #python

15 min read

Neha Soni

Apr 30 '21

Oracle Cheat Sheet

#database #sql #beginners

5 min read

Arctype Team for Arctype

Apr 26 '21

Getting started with PostgreSQL Set Operators

#postgres #sql #database #tutorial

4 min read

Apr 23 '21

Using SQL or NoSQL

#sql #nosql

1 min read

Jo

Apr 23 '21

Popular string functions in MySQL - CONCAT and SUBSTRING

#sql #mysql

2 min read

Yoshiaki Matsutomo

Apr 23 '21

TypeORM - Multiple DB Calls vs Single DB Call

#node #sql #typescript #database

6 min read

anatdagan

Apr 23 '21

Can I get a dash of regular expression in my KQL?

#kusto #regex #sql #syntax

1 min read

Apr 22 '21

3 small tips to make your SQL Server experience easier

#sql #5days5blogposts

5 min read

Jo

Apr 21 '21

SQL Review - Useful queries for mySQL

#mysql #sql #postgres

1 min read

Marcelo Garbarino

Apr 20 '21

What is SQL - Part 4

#sql #beginners

7 min read

John G for Fabric

Apr 20 '21

Building a Hybrid SQL + NoSQL E-Commerce Data Model

#database #mongodb #sql

7 min read

Vladimir Ozerov

Apr 20 '21

Inside Presto Optimizer

#presto #sql #database #bigdata

9 min read

Krzysztof Szala

Apr 19 '21

How to output raw SQL with filled parameters in TypeORM?

#javascript #typescript #typeorm #sql

2 min read

Shanika Wickramasinghe for Fabric

Apr 18 '21

What’s an Example of Good E-Commerce Database Design?

#ecommerce #database #sql #nosql

8 min read

👋 Sign in for the ability to sort posts by relevant, latest, or top.