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 Implement Many-to-Many Relationships in Relational Databases
Cover image for How to Implement Many-to-Many Relationships in Relational Databases

How to Implement Many-to-Many Relationships in Relational Databases

9
Comments
6 min read
MySQL Materialized Views
Cover image for MySQL Materialized Views

MySQL Materialized Views

16
Comments
3 min read
YugabyteDB table_id UUID for PostgreSQL tables

YugabyteDB table_id UUID for PostgreSQL tables

7
Comments 3
6 min read
Javascript, Sql, and File Saving

Javascript, Sql, and File Saving

6
Comments
2 min read
Using Athena Views As A Source In Glue

Using Athena Views As A Source In Glue

20
Comments 3
4 min read
3 SQL Interview Tips For Data Scientists And Data Engineers
Cover image for 3 SQL Interview Tips For Data Scientists And Data Engineers

3 SQL Interview Tips For Data Scientists And Data Engineers

13
Comments
8 min read
AzureFunBytes Reminder - Intro to @Azure Stream Analytics with @fleid_bi - 02/17/2022
Cover image for AzureFunBytes Reminder - Intro to @Azure Stream Analytics with @fleid_bi - 02/17/2022

AzureFunBytes Reminder - Intro to @Azure Stream Analytics with @fleid_bi - 02/17/2022

8
Comments
4 min read
Exploring Git Repos With MergeStat 🔬
Cover image for Exploring Git Repos With MergeStat 🔬

Exploring Git Repos With MergeStat 🔬

22
Comments 1
6 min read
Concorrência em banco de dados explicada de forma simples
Cover image for Concorrência em banco de dados explicada de forma simples

Concorrência em banco de dados explicada de forma simples

13
Comments
5 min read
[mysql curtas] Função case no MySQL
Cover image for [mysql curtas] Função case no MySQL

[mysql curtas] Função case no MySQL

7
Comments
1 min read
Finding all tables with a specific column name (postgres)
Cover image for Finding all tables with a specific column name (postgres)

Finding all tables with a specific column name (postgres)

8
Comments
3 min read
How to generate Permutations in SQL?

How to generate Permutations in SQL?

5
Comments
2 min read
Database: DDL, DML, DCL, TCL

Database: DDL, DML, DCL, TCL

4
Comments
2 min read
Leetcode SQL: 175. Combine Two Tables

Leetcode SQL: 175. Combine Two Tables

16
Comments
2 min read
Order of Execution in a SQL Query.
Cover image for Order of Execution in a SQL Query.

Order of Execution in a SQL Query.

7
Comments
5 min read
5 Tips On How To Become a Better Data Analyst
Cover image for 5 Tips On How To Become a Better Data Analyst

5 Tips On How To Become a Better Data Analyst

22
Comments 1
5 min read
Polymorphic joins in Active Record
Cover image for Polymorphic joins in Active Record

Polymorphic joins in Active Record

25
Comments 4
3 min read
Deadlock in mysql
Cover image for Deadlock in mysql

Deadlock in mysql

4
Comments
2 min read
Tools for Querying Logs with SQL
Cover image for Tools for Querying Logs with SQL

Tools for Querying Logs with SQL

5
Comments
9 min read
Crack the top 40 SQL interview questions
Cover image for Crack the top 40 SQL interview questions

Crack the top 40 SQL interview questions

18
Comments 3
14 min read
Programmatic inspection of databases in Go using Atlas
Cover image for Programmatic inspection of databases in Go using Atlas

Programmatic inspection of databases in Go using Atlas

7
Comments
8 min read
Protect your project from SQL injections
Cover image for Protect your project from SQL injections

Protect your project from SQL injections

7
Comments 1
3 min read
Most recent record (of many items) with YugabyteDB 🚀

Most recent record (of many items) with YugabyteDB 🚀

9
Comments
11 min read
YBDemo: simple 💻 demo lab for YugabyteDB with Java client and Docker🚀☕🐳🐘
Cover image for YBDemo: simple 💻 demo lab for YugabyteDB with Java client and Docker🚀☕🐳🐘

YBDemo: simple 💻 demo lab for YugabyteDB with Java client and Docker🚀☕🐳🐘

4
Comments
1 min read
Supabase Date Protection on PostgreSQL
Cover image for Supabase Date Protection on PostgreSQL

Supabase Date Protection on PostgreSQL

18
Comments
3 min read
loading...