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.
Simple overview of MySQL (Relational Database)

Simple overview of MySQL (Relational Database)

9
Comments
2 min read
TEMPLATE: Relational Data And Custom Codeless APIs (App Blueprint)

TEMPLATE: Relational Data And Custom Codeless APIs (App Blueprint)

2
Comments
6 min read
Learn SQL: Microsoft SQL Server - Episode 13: Insert new records in a Table

Learn SQL: Microsoft SQL Server - Episode 13: Insert new records in a Table

6
Comments
3 min read
Airbyte: Data Integration / CDC Solution for Modern Data Teams!

Airbyte: Data Integration / CDC Solution for Modern Data Teams!

6
Comments
12 min read
🐘🚀 Triggers & Stored Procedures for pure data integrity logic and performance

🐘🚀 Triggers & Stored Procedures for pure data integrity logic and performance

5
Comments 2
15 min read
Data structures in SQL: the definitive guide

Data structures in SQL: the definitive guide

16
Comments
7 min read
How to read / make sense this multiple JOINS SQL query properly?

How to read / make sense this multiple JOINS SQL query properly?

3
Comments 1
1 min read
How to write SQL recursive CTE in 5 steps

How to write SQL recursive CTE in 5 steps

55
Comments 9
7 min read
Learn SQL: Microsoft SQL Server - Episode 12: Finding the length of a String

Learn SQL: Microsoft SQL Server - Episode 12: Finding the length of a String

7
Comments
3 min read
Creating Tables and Associations using Ruby/Active Record/Rake

Creating Tables and Associations using Ruby/Active Record/Rake

6
Comments
5 min read
Fun times with MySQL upgrade

Fun times with MySQL upgrade

4
Comments
5 min read
Getting started with Redshift

Getting started with Redshift

10
Comments
5 min read
My week three experience as an intern at TaskForce4.0

My week three experience as an intern at TaskForce4.0

4
Comments
2 min read
Seven URL Shortener

Seven URL Shortener

6
Comments 1
10 min read
What Is Trino And Why Is It Great At Processing Big Data

What Is Trino And Why Is It Great At Processing Big Data

27
Comments
7 min read
Extracting example SQL statements from a log

Extracting example SQL statements from a log

3
Comments
3 min read
SQL Server Interview Questions

SQL Server Interview Questions

12
Comments 4
2 min read
Quick 📸 on 🐘 active SQL from pg_stat_statements

Quick 📸 on 🐘 active SQL from pg_stat_statements

8
Comments
3 min read
7 modern and practical MySQL/MariaDB features you should know and use

7 modern and practical MySQL/MariaDB features you should know and use

4
Comments
5 min read
⏱ Read from the nearest peer in a multi-region database 🚀 with followers read

⏱ Read from the nearest peer in a multi-region database 🚀 with followers read

6
Comments
12 min read
How to count newest entries created in an oracle database

How to count newest entries created in an oracle database

6
Comments 2
1 min read
What is the N prefix in MSSQL all about?

What is the N prefix in MSSQL all about?

5
Comments
3 min read
Making Dapper and JSON friends

Making Dapper and JSON friends

32
Comments 3
6 min read
"Rows Removed by Index Recheck" on YugabyteDB Index Scan

"Rows Removed by Index Recheck" on YugabyteDB Index Scan

5
Comments
8 min read
De-identify SQL: Transforming Production Data

De-identify SQL: Transforming Production Data

7
Comments
3 min read
loading...