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.

Cover image for Understand SQL cartisien product !

shAtud

Jan 28 '22

Understand SQL cartisien product !

#sql #mysql #tutorial #beginners

1 min read

பாலாஜி

Mar 2 '22

How to use pg_cron in postgres to do historic aggregation?

#devops #postgres #devsec #sql

2 min read

Ortiz de Arcanjo António David

Mar 2 '22

Normalização do Tipo de Identificação

#database #sql #modeling

2 min read

Ortiz de Arcanjo António David

Mar 2 '22

Atributos e Tabelas para Estados

#sql #database #normalization

2 min read

Ortiz de Arcanjo António David

Mar 2 '22

Simplificar queries com Views SQL

#views #sql #query #python

2 min read

Ortiz de Arcanjo António David

Mar 2 '22

Limitar a Inserção de Registos

#sql #trigger #insert

1 min read

Franck Pachot for YugabyteDB

Mar 1 '22

YugabyteDB on Public network 🚀🌐

#yugabytedb #distributed #sql #database

7 min read

Mar 1 '22

Computed columns in PostgreSQL 🐘 / YugabyteDB🚀

#postgres #yugabytedb #sql #database

4 min read

Feb 26 '22

The ultimate solution to image storage.

#javascript #programming #sql #python

1 min read

Feb 26 '22

How to build a Trading bot with Python and SQlite.

#python #cryptocurrencies #sql #datascience

5 min read

Franck Pachot for YugabyteDB

Feb 25 '22

Which 🐘PostgreSQL problems are solved with 🚀YugabyteDB

#yugabytedb #sql #database #postgres

7 min read

Cover image for SQL-Quick tip #1 - Range of Int

Feb 25 '22

SQL-Quick tip #1 - Range of Int

#tsql #sqlserver #sql #mssql

1 min read

Cover image for What is the difference between DATETIME and TIMESTAMP data type in MySQL?

Bobby

Feb 23 '22

What is the difference between DATETIME and TIMESTAMP data type in MySQL?

#mysql #database #webdev #sql

3 min read

Cover image for Drop all tables and reset an Azure SQL Database

Emanuele Bartolesi

Feb 24 '22

Drop all tables and reset an Azure SQL Database

#azure #sql

1 min read

Mvuselelo Houston Khanyile

Feb 24 '22

How do I extract a nested tuple from a tuple?

#python #sql #beginners #programming

1 min read

Franck Pachot for YugabyteDB

Feb 23 '22

Reference Tables as duplicate covering indexes

#yugabytedb #distributed #sql #database

16 min read

Gabriel_Silvestre

Feb 23 '22

Introdução a Manipulação de Dados - SQL

#beginners #sql #mysql #braziliandevs

4 min read

Gabriel_Silvestre

Feb 23 '22

Introdução a Filtragem de Dados - SQL

#beginners #sql #mysql

4 min read

taijidude

Feb 23 '22

Get rid of an MS SQL Server database in SingleUserMode

#sqlserver #sql #sledgehammersolution

1 min read

Gabriel_Silvestre

Feb 22 '22

Introdução a Pesquisa de Dados - SQL

#beginners #sql #mysql #braziliandevs

5 min read

Gabriel_Silvestre

Feb 21 '22

Introdução ao SQL

#mysql #sql #beginners #braziliandevs

4 min read

Cover image for How to provision an Azure SQL Database with Active Directory authentication

Alexandre Nédélec

Feb 22 '22

How to provision an Azure SQL Database with Active Directory authentication

#pulumi #azure #sql #dotnet

13 min read

Sandor Drieënhuizen

Feb 21 '22

Restoring an SQL server backup in a Docker Container on Windows

#docker #sql

4 min read

Cover image for Apache ShardingSphere 5.1.0 Now Available

Apache ShardingSphere

Feb 21 '22

Apache ShardingSphere 5.1.0 Now Available

#database #sql #postgres #devops

8 min read

stuxnat

Feb 21 '22

CTE in SQL

#sql

1 min read

loading...