DEV Community

loading...

select * from SQL

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

👋 Sign in for the ability sort posts by top and latest.
Cracking the PostgreSQL Interview

Cracking the PostgreSQL Interview

Reactions 9 Comments
6 min read
Fix Your dbt Concurrent Transaction Database Error

Fix Your dbt Concurrent Transaction Database Error

Reactions 1 Comments
1 min read
How to Complete a Udemy Course

How to Complete a Udemy Course

Reactions 2 Comments
2 min read
SQL & database monthly wrap up - February 2021

SQL & database monthly wrap up - February 2021

Reactions 10 Comments
2 min read
Building an event information portal with ASP.NET 5 & DotVVM

Building an event information portal with ASP.NET 5 & DotVVM

Reactions 5 Comments
10 min read
Try CrateDB Cloud for free 🐐

Try CrateDB Cloud for free 🐐

Reactions 5 Comments
4 min read
What is CrateDB? 🤔 FAQ

What is CrateDB? 🤔 FAQ

Reactions 3 Comments 2
3 min read
SQL: Calculate Bussiness Days

SQL: Calculate Bussiness Days

Reactions 2 Comments 2
1 min read
What is Amazon RDS? Explained through Comics

What is Amazon RDS? Explained through Comics

Reactions 2 Comments
1 min read
How to monitor backup and restore progress in SQL Server

How to monitor backup and restore progress in SQL Server

Reactions 3 Comments
2 min read
Obtendo dados de CNPJ's com a API Minha Receita

Obtendo dados de CNPJ's com a API Minha Receita

Reactions 13 Comments 1
7 min read
Reacty Loops : fully web-based music production

Reacty Loops : fully web-based music production

Reactions 7 Comments
1 min read
Using a PlSql cursor in a FOR loop example

Using a PlSql cursor in a FOR loop example

Reactions 6 Comments
3 min read
How to ace the Facebook data scientist interview

How to ace the Facebook data scientist interview

Reactions 6 Comments
8 min read
One-To-Many Database Relationships Complete How To

One-To-Many Database Relationships Complete How To

Reactions 6 Comments
6 min read
Create and drop oracle table example

Create and drop oracle table example

Reactions 6 Comments
2 min read
How to write a SQL Inner Join

How to write a SQL Inner Join

Reactions 5 Comments
2 min read
How to create an SQLite database in node.js

How to create an SQLite database in node.js

Reactions 6 Comments
2 min read
Criando uma API SQL para Twitter com Typescript - Parte 0

Criando uma API SQL para Twitter com Typescript - Parte 0

Reactions 4 Comments
2 min read
Effective SQL - Indexing and denormalizing JSONB

Effective SQL - Indexing and denormalizing JSONB

Reactions 33 Comments
4 min read
Five classic SQL & database posts - February 2021

Five classic SQL & database posts - February 2021

Reactions 37 Comments
2 min read
The “insert if not exists” challenge: a solution

The “insert if not exists” challenge: a solution

Reactions 7 Comments
6 min read
How do I add an item to a database without reloading the page?

How do I add an item to a database without reloading the page?

Reactions 9 Comments 8
1 min read
CRUD with C#/SQL in .NET Core

CRUD with C#/SQL in .NET Core

Reactions 6 Comments 2
2 min read
Get your SQL functions in DQL

Get your SQL functions in DQL

Reactions 5 Comments
2 min read
Console.bLog(studyNotes)

Console.bLog(studyNotes)

Reactions 4 Comments
5 min read
The difference between regular views and materialized views in PostgreSQL

The difference between regular views and materialized views in PostgreSQL

Reactions 7 Comments
1 min read
SQL 101: How Databases and Tables Are Structured

SQL 101: How Databases and Tables Are Structured

Reactions 2 Comments
5 min read
Forget SQL vs NoSQL - Get the Best of Both Worlds with JSON in PostgreSQL

Forget SQL vs NoSQL - Get the Best of Both Worlds with JSON in PostgreSQL

Reactions 15 Comments
8 min read
10 Things I Hate About SQL

10 Things I Hate About SQL

Reactions 11 Comments 14
8 min read
SQL query from the view: considered hazardous!

SQL query from the view: considered hazardous!

Reactions 7 Comments 4
5 min read
SQL & database wrap up - January 2021

SQL & database wrap up - January 2021

Reactions 12 Comments 2
2 min read
SQL Server 2019 for Data Professionals

SQL Server 2019 for Data Professionals

Reactions 2 Comments
2 min read
SQL Review

SQL Review

Reactions 2 Comments
2 min read
Introducing SAYN: A Simple Yet Powerful Data Processing Framework.

Introducing SAYN: A Simple Yet Powerful Data Processing Framework.

Reactions 3 Comments 1
5 min read
Slow Queries? 10X Query Performance with a Database Index

Slow Queries? 10X Query Performance with a Database Index

Reactions 5 Comments
5 min read
The Town Analogy for database architecture

The Town Analogy for database architecture

Reactions 1 Comments
3 min read
Sort by timestamps (month and year) in PostgreSQL

Sort by timestamps (month and year) in PostgreSQL