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.
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
#SQL30 Day 14: UFO Sightings

#SQL30 Day 14: UFO Sightings

7
Comments
2 min read
An Introduction to Oracle SQL

An Introduction to Oracle SQL

3
Comments
1 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
Generate dummy data with Postgres

Generate dummy data with Postgres

6
Comments 2
2 min read
Le comportement particulier des autoincrement dans les tables MySQL InnoDB

Le comportement particulier des autoincrement dans les tables MySQL InnoDB

5
Comments
3 min read
How to update with inner join on PostgreSQL 🐘

How to update with inner join on PostgreSQL 🐘

12
Comments 3
2 min read
Using GraphDbs to Visualize Code/SQL dependencies

Using GraphDbs to Visualize Code/SQL dependencies

7
Comments
4 min read
How to use Query Objects to refactor Rails SQL-queries

How to use Query Objects to refactor Rails SQL-queries

11
Comments
6 min read
Import data from S3 to Redshift in minutes using Dataform

Import data from S3 to Redshift in minutes using Dataform

7
Comments
4 min read
#SQL30 Day 8: Deleting Duplicates

#SQL30 Day 8: Deleting Duplicates

9
Comments
3 min read
Advanced PHP Interview Questions 2020

Advanced PHP Interview Questions 2020

9
Comments 1
2 min read
#SQL30 Day 6: Supermarket Sales

#SQL30 Day 6: Supermarket Sales

6
Comments 1
3 min read
PostgreSQL Trends: Most Popular Cloud Providers, Languages, VACUUM, Query Management Strategies & Deployment Types in Enterprise

PostgreSQL Trends: Most Popular Cloud Providers, Languages, VACUUM, Query Management Strategies & Deployment Types in Enterprise

7
Comments
11 min read
#SQL30 Day 5: Hierarchies

#SQL30 Day 5: Hierarchies

6
Comments 1
3 min read
loading...