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.
The True Guide to True and False in PostgreSQL

The True Guide to True and False in PostgreSQL

10
Comments
2 min read
SQLite, json et dénormalisation

SQLite, json et dénormalisation

5
Comments 7
7 min read
Working with BigQuery Analytic Functions

Working with BigQuery Analytic Functions

6
Comments
5 min read
How to ace coding interviews; and scaling tips from Netflix & Shopify

How to ace coding interviews; and scaling tips from Netflix & Shopify

123
Comments
2 min read
Data Science Interview Study Guide

Data Science Interview Study Guide

231
Comments 2
12 min read
#SQL30 Day 16: Dev Badges

#SQL30 Day 16: Dev Badges

7
Comments
4 min read
Using Tableau with Kafka: How to Build a Real-Time SQL Dashboard on Streaming Data

Using Tableau with Kafka: How to Build a Real-Time SQL Dashboard on Streaming Data

9
Comments
6 min read
When it comes to Data, the customer is always wrong - The Four Horsemen of the Assumption Apocalypse

When it comes to Data, the customer is always wrong - The Four Horsemen of the Assumption Apocalypse

25
Comments 3
2 min read
How i learned flask in one week by building

How i learned flask in one week by building

12
Comments 3
2 min read
pandas #1: Getting started with pandas

pandas #1: Getting started with pandas

46
Comments 2
4 min read
DynamoDB vs. Hadoop vs. MongoDB

DynamoDB vs. Hadoop vs. MongoDB

48
Comments
8 min read
#SQL30 Day 12: Greatest Discount

#SQL30 Day 12: Greatest Discount

6
Comments
3 min read
#SQL30 Day 11: Soft Deletes

#SQL30 Day 11: Soft Deletes

8
Comments
3 min read
Manipulating arrays with PostgreSQL

Manipulating arrays with PostgreSQL

15
Comments 2
3 min read
#SQL30 Day 10: Random Sampling

#SQL30 Day 10: Random Sampling

7
Comments 1
3 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.