Skip to content

DEV Community

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

👋 Sign in for the ability to sort posts by relevant, latest, or top.

Mar 2

Beyond the Basics: 5 Game-Changing Secrets of SQL Joins and Window Functions

#sql #dataanalytics #database #programming

5 min read

Mar 1

Normalização de Banco de Dados: Das Origens às 5 Formas Normais (+ BCNF) com Exemplos Práticos

#database #sql

13 min read

catatsuy

Mar 15

Why I, as Someone Who Likes MySQL, Now Want to Recommend PostgreSQL

#mysql #postgres #database #sql

13 min read

Beverline Otiende

Mar 22

Advanced SQL for Data Analytics: Advanced Techniques Every Data Analyst Should Know

#sql #database #datascience

14 min read

Mar 17

Partitioning PotgreSQL Database

#sql #postgres #architecture #performance

4 min read

Teymur Bayramov

Feb 19

How to implement “CreatedAt” and “UpdatedAt” timestamps in Entity Framework Core?

#csharp #sql #database #dotnet

7 min read

Ashraf

Feb 14

Why I don't trust AI with my query plans

#postgres #database #performance #sql

2 min read

Makroumi

Mar 9

The SQL query that ruined my weekend and what I built to prevent it

#sql #devops #webdev #programming

3 min read

Isaac FEI

Mar 20

Qdrant Hybrid Search Combined with SQL Query Results

#ai #database #sql #tutorial

6 min read

Isika Millicent

Mar 9

Mastering SQL Joins and Window Functions with Real Examples

#sql #tutorial #learning

7 min read

Mar 20

I curated 1,863 Data Engineering interview questions from 97+ companies --- here's what I learned. Website :: dataengprep.tech

#ai #dataengineering #interview #sql

3 min read

s mathavi

Mar 20

PostgreSql(Aggregative Functions)

#postgressql #sql #database #mysql

1 min read

FaithInErrorsZORO

Mar 20

SQL triggers for blocking

#backend #database #programming #sql

1 min read

s mathavi

Mar 20

PostgreSQL-constraints

#postgressql #sql #java #mysql

1 min read

s mathavi

Mar 20

PostgreSql - Relationships(joins)

#sql #mysql #postgressql #innerjoin

2 min read

👋 Sign in for the ability to sort posts by relevant, latest, or top.