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.
SQL to avoid data corruption in race conditions with SERIALIZABLE 🐘 🚀

SQL to avoid data corruption in race conditions with SERIALIZABLE 🐘 🚀

8
Comments 2
5 min read
What are the top 9 SQL Queries for freshers?

What are the top 9 SQL Queries for freshers?

5
Comments 1
2 min read
Importing Large SQL File

Importing Large SQL File

4
Comments
2 min read
MySQL- RDBMS

MySQL- RDBMS

6
Comments
3 min read
100 Languages Speedrun: Episode 39: SQLite

100 Languages Speedrun: Episode 39: SQLite

7
Comments
8 min read
🦸 Become a Super Hero by Learning SQL!

🦸 Become a Super Hero by Learning SQL!

7
Comments
4 min read
String Operations On Phone Numbers In SQL

String Operations On Phone Numbers In SQL

11
Comments
7 min read
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

11
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
loading...