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.
Learn SQL: Microsoft SQL Server - Episode 2: Selecting Records

Learn SQL: Microsoft SQL Server - Episode 2: Selecting Records

7
Comments
6 min read
The Data Engineer Roadmap 🗺

The Data Engineer Roadmap 🗺

65
Comments 4
4 min read
Boost Secondary Index Queries with Index Only Scan

Boost Secondary Index Queries with Index Only Scan

7
Comments
11 min read
Calculate Distance between 2 Geo Locations in PHP MySQL

Calculate Distance between 2 Geo Locations in PHP MySQL

39
Comments 3
2 min read
How Python and SQL are Changing the Hedge Fund Industry

How Python and SQL are Changing the Hedge Fund Industry

13
Comments
4 min read
Learn SQL: Microsoft SQL Server - Episode 1: Introduction

Learn SQL: Microsoft SQL Server - Episode 1: Introduction

31
Comments 2
8 min read
Primary Keys in SQL

Primary Keys in SQL

10
Comments 1
2 min read
SQL Server to React in 60 Seconds With Prisma

SQL Server to React in 60 Seconds With Prisma

53
Comments 1
5 min read
🚀 The Missing SQL Basics Crash Course

🚀 The Missing SQL Basics Crash Course

116
Comments 12
12 min read
Nebula Operator Kind, oneliner installer for Nebula K8s Operator Playground

Nebula Operator Kind, oneliner installer for Nebula K8s Operator Playground

6
Comments
1 min read
Should I use SQLite, PostgreSQL, or MySQL?

Should I use SQLite, PostgreSQL, or MySQL?

172
Comments 26
5 min read
Making SQLite Easy with Codesphere!

Making SQLite Easy with Codesphere!

13
Comments
2 min read
Four Database APIs

Four Database APIs

9
Comments
15 min read
Schemaless SQL database for strong and lasting back end

Schemaless SQL database for strong and lasting back end

10
Comments
2 min read
when you have millions of insert statements in a file...

when you have millions of insert statements in a file...

29
Comments
6 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.