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 Interview Study Guide For Software Engineers

The Interview Study Guide For Software Engineers

Reactions 7407 Comments 86
12 min read
SQL concepts from A to Z

SQL concepts from A to Z

Reactions 854 Comments 20
14 min read
You Can Do it in SQL, Stop Writing Extra Code for it

You Can Do it in SQL, Stop Writing Extra Code for it

Reactions 519 Comments 103
5 min read
1 SQL Query You Should Stop Using

1 SQL Query You Should Stop Using

Reactions 367 Comments 43
3 min read
How to set up a free PostgreSQL database on Heroku

How to set up a free PostgreSQL database on Heroku

Reactions 349 Comments 11
3 min read
Speed up your queries with indexes

Speed up your queries with indexes

Reactions 312 Comments 37
4 min read
Everything you need to know about (Relational) Databases

Everything you need to know about (Relational) Databases

Reactions 311 Comments 7
16 min read
15 Of The Best Machine Learning Courses On Coursera For Free

15 Of The Best Machine Learning Courses On Coursera For Free

Reactions 268 Comments 1
10 min read
How to ace coding interviews. The ultimate guide.

How to ace coding interviews. The ultimate guide.

Reactions 254 Comments
14 min read
Improving PostgreSQL queries

Improving PostgreSQL queries

Reactions 227 Comments 6
23 min read
Data Science Interview Study Guide

Data Science Interview Study Guide

Reactions 227 Comments 2
12 min read
Entity Relationship Diagrams explained by Sonic the Hedgehog

Entity Relationship Diagrams explained by Sonic the Hedgehog

Reactions 223 Comments 11
2 min read
When to choose NoSQL over SQL?

When to choose NoSQL over SQL?

Reactions 208 Comments 22
2 min read
SQL tips for beginners; what I learned after 10+ years of occasionally writing queries and schemas as a web dev

SQL tips for beginners; what I learned after 10+ years of occasionally writing queries and schemas as a web dev

Reactions 206 Comments 30
2 min read
Tips on Designing a Million Dollar Dashboard

Tips on Designing a Million Dollar Dashboard

Reactions 203 Comments 9
7 min read
A mini-guide — Build a REST API as a Go microservice together with MySQL

A mini-guide — Build a REST API as a Go microservice together with MySQL

Reactions 198 Comments 4
4 min read
Should I use SQLite, PostgreSQL, or MySQL?

Should I use SQLite, PostgreSQL, or MySQL?

Reactions 164 Comments 26
5 min read
8 New SQL Tools That Will Change How You Work in 2020

8 New SQL Tools That Will Change How You Work in 2020

Reactions 163 Comments 7
6 min read
Top 5 Online Courses to Learn SQL and Database for Beginners - Best of Lot

Top 5 Online Courses to Learn SQL and Database for Beginners - Best of Lot

Reactions 163 Comments 5
10 min read
Every SQL Join You’ll Ever Need

Every SQL Join You’ll Ever Need

Reactions 161 Comments 2
20 min read
Database Design Tutorial

Database Design Tutorial

Reactions 158 Comments 1
9 min read
Database Naming Standards

Database Naming Standards

Reactions 154 Comments 16
6 min read
The SQL I Love. Efficient pagination of a table with 100M records

The SQL I Love. Efficient pagination of a table with 100M records

Reactions 145 Comments 10
6 min read
Your Old Laptop Is Your New Database Server

Your Old Laptop Is Your New Database Server

Reactions 143 Comments 12
8 min read
SQL From Scratch Part 1 - Getting Started with SQL

SQL From Scratch Part 1 - Getting Started with SQL

Reactions 130 Comments 9
7 min read
SQL injection for developers

SQL injection for developers

Reactions 127 Comments 5
12 min read
Why ORMs Aren't Always a Great Idea

Why ORMs Aren't Always a Great Idea

Reactions 127 Comments 44
9 min read
How to ace coding interviews; and scaling tips from Netflix & Shopify

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

Reactions 123 Comments
2 min read
What exactly does Indexing in a Database do?

What exactly does Indexing in a Database do?

Reactions 114 Comments 4
2 min read
Learn Web Development for Free

Learn Web Development for Free

Reactions 113 Comments 6
8 min read
🚀 The Missing SQL Basics Crash Course

🚀 The Missing SQL Basics Crash Course

Reactions 111 Comments 10
12 min read
SQL Joins without the Venn diagrams

SQL Joins without the Venn diagrams

Reactions 108 Comments 5
3 min read
Cascade of doom: JIT, and how a Postgres update led to 70% failure on a critical national service

Cascade of doom: JIT, and how a Postgres update led to 70% failure on a critical national service

Reactions 106 Comments 29
14 min read
Dynamically generating SQL queries using Node.js

Dynamically generating SQL queries using Node.js

Reactions 101 Comments 25
6 min read
I built my own VS Code Syntax Highlighter from scratch and here's what I learned.

I built my own VS Code Syntax Highlighter from scratch and here's what I learned.

Reactions 101 Comments 15
4 min read
SQL Basics for Beginners

SQL Basics for Beginners

Reactions 100 Comments 4
3 min read
Creating a Simple Contacts List with Go and PostgreSQL

Creating a Simple Contacts List with Go and PostgreSQL

Reactions 100 Comments
10 min read
Data Engineering 101: Automating Your First Data Extract

Data Engineering 101: Automating Your First Data Extract

Reactions 97 Comments
7 min read
Build a simple blog with GraphQL, Node.js, SQLite and (VUE, Angular Or ReactJS)

Build a simple blog with GraphQL, Node.js, SQLite and (VUE, Angular Or ReactJS)

Reactions 96 Comments 2
2 min read
PostgreSQL Tutorial for beginners to Advance level.

PostgreSQL Tutorial for beginners to Advance level.

Reactions 95 Comments 2
18 min read
Learn SQL Injection by hacking a bank app

Learn SQL Injection by hacking a bank app

Reactions 93 Comments 4
7 min read
4 SQL Tips For Data Scientists And Data Analysts

4 SQL Tips For Data Scientists And Data Analysts

Reactions 91 Comments 4
7 min read
Beware The Missing Foreign Key Index: A Postgres Performance Gotcha

Beware The Missing Foreign Key Index: A Postgres Performance Gotcha

Reactions 90 Comments 6
12 min read
SQL is (almost) always superior to NoSQL

SQL is (almost) always superior to NoSQL

Reactions 90 Comments 29
4 min read
Differences Between SQL And NoSQL Databases

Differences Between SQL And NoSQL Databases

Reactions 89 Comments 2
4 min read
How to write SQL queries which are easier to read?

How to write SQL queries which are easier to read?

Reactions 88 Comments 21
7 min read
Programming Paradigm

Programming Paradigm

Reactions 83 Comments 9
4 min read
Understanding SQL Server Deadlocks

Understanding SQL Server Deadlocks

Reactions 82 Comments 1
5 min read
HarperDB vs. MongoDB vs. PostgreSQL

HarperDB vs. MongoDB vs. PostgreSQL

Reactions 82 Comments 7
6 min read
Build Relational Databases Like A Pro (MySQL, PostgreSQL, etc.)

Build Relational Databases Like A Pro (MySQL, PostgreSQL, etc.)

Reactions 81 Comments 9
3 min read
Big Data from the Ground up

Big Data from the Ground up

Reactions 78 Comments 2
7 min read
Fuzzy Searching with PostgreSQL

Fuzzy Searching with PostgreSQL

Reactions 78 Comments 4
6 min read
Design your SQL database visually

Design your SQL database visually

Reactions 77 Comments
3 min read
Why You Shouldn't Use OFFSET and LIMIT For Your Pagination

Why You Shouldn't Use OFFSET and LIMIT For Your Pagination

Reactions 77 Comments 26
5 min read
SQL: Outer Joins

SQL: Outer Joins

Reactions 76 Comments 10
4 min read
YEStifications: Exploring how users engage with notification prompts in the Chrome UX Report

YEStifications: Exploring how users engage with notification prompts in the Chrome UX Report

Reactions 76 Comments 6
6 min read
What I learned from only using Select in PostgreSQL

What I learned from only using Select in PostgreSQL

Reactions 75 Comments 6
4 min read
How to build a Data Pipeline for the first time

How to build a Data Pipeline for the first time

Reactions 74 Comments 10
5 min read
Airbnb’s Airflow Versus Spotify’s Luigi

Airbnb’s Airflow Versus Spotify’s Luigi

Reactions 73 Comments
7 min read
🚀 3 Tools To Scale and Grow Your Side Projects

🚀 3 Tools To Scale and Grow Your Side Projects

Reactions 73 Comments 11
3 min read
loading...