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.
Normalização do Tipo de Identificação

Normalização do Tipo de Identificação

5
Comments
2 min read
Atributos e Tabelas para Estados

Atributos e Tabelas para Estados

3
Comments
2 min read
Simplificar queries com Views SQL

Simplificar queries com Views SQL

3
Comments
2 min read
Limitar a Inserção de Registos

Limitar a Inserção de Registos

3
Comments
1 min read
YugabyteDB on Public network 🚀🌐

YugabyteDB on Public network 🚀🌐

4
Comments
7 min read
Computed columns in PostgreSQL 🐘 / YugabyteDB🚀

Computed columns in PostgreSQL 🐘 / YugabyteDB🚀

2
Comments
4 min read
The ultimate solution to image storage.

The ultimate solution to image storage.

5
Comments 2
1 min read
How to build a Trading bot with Python and SQlite.

How to build a Trading bot with Python and SQlite.

12
Comments
5 min read
Which 🐘PostgreSQL problems are solved with 🚀YugabyteDB

Which 🐘PostgreSQL problems are solved with 🚀YugabyteDB

8
Comments 2
7 min read
SQL-Quick tip #1 - Range of Int

SQL-Quick tip #1 - Range of Int

7
Comments
1 min read
Drop all tables and reset an Azure SQL Database

Drop all tables and reset an Azure SQL Database

9
Comments
1 min read
What is the difference between DATETIME and TIMESTAMP data type in MySQL?

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

20
Comments 2
3 min read
How do I extract a nested tuple from a tuple?

How do I extract a nested tuple from a tuple?

2
Comments 1
1 min read
Introdução a Manipulação de Dados - SQL

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

6
Comments
4 min read
Reference Tables as duplicate covering indexes

Reference Tables as duplicate covering indexes

7
Comments
16 min read
Introdução a Filtragem de Dados - SQL

Introdução a Filtragem de Dados - SQL

6
Comments
4 min read
Get rid of an MS SQL Server database in SingleUserMode

Get rid of an MS SQL Server database in SingleUserMode

6
Comments
1 min read
Introdução a Pesquisa de Dados - SQL

Introdução a Pesquisa de Dados - SQL

7
Comments
5 min read
Introdução ao SQL

Introdução ao SQL

10
Comments 6
4 min read
How to provision an Azure SQL Database with Active Directory authentication

How to provision an Azure SQL Database with Active Directory authentication

11
Comments
13 min read
Restoring an SQL server backup in a Docker Container on Windows

Restoring an SQL server backup in a Docker Container on Windows

8
Comments 2
4 min read
Apache ShardingSphere 5.1.0 Now Available

Apache ShardingSphere 5.1.0 Now Available

6
Comments
8 min read
CTE in SQL

CTE in SQL

6
Comments
1 min read
How to Implement Many-to-Many Relationships in Relational Databases

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

8
Comments
6 min read
MySQL Materialized Views

MySQL Materialized Views

10
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

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

Using Athena Views As A Source In Glue

15
Comments 3
4 min read
3 SQL Interview Tips For Data Scientists And Data Engineers

3 SQL Interview Tips For Data Scientists And Data Engineers

10
Comments
8 min read
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 🔬

Exploring Git Repos With MergeStat 🔬

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

Concorrência em banco de dados explicada de forma simples

10
Comments
5 min read
[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)

Finding all tables with a specific column name (postgres)

6
Comments
3 min read
Database: DDL, DML, DCL, TCL

Database: DDL, DML, DCL, TCL

4
Comments
2 min read
How to generate Permutations in SQL?

How to generate Permutations in SQL?

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

Leetcode SQL: 175. Combine Two Tables

5
Comments
2 min read
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

5 Tips On How To Become a Better Data Analyst

20
Comments
5 min read
Polymorphic joins in Active Record

Polymorphic joins in Active Record

20
Comments 4
3 min read
Tools for Querying Logs with SQL

Tools for Querying Logs with SQL

6
Comments
9 min read
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

Programmatic inspection of databases in Go using Atlas

7
Comments
8 min read
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 🚀

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

Supabase Date Protection on PostgreSQL

10
Comments
3 min read
REST Data Service on YugabyteDB / PostgreSQL

REST Data Service on YugabyteDB / PostgreSQL

8
Comments
3 min read
Coding Unmanaged and Managed Transactions with NodeJS, Express and Sequelize

Coding Unmanaged and Managed Transactions with NodeJS, Express and Sequelize

8
Comments
2 min read
SQL Duplicates

SQL Duplicates

5
Comments
2 min read
Links úteis para DBAs e DBREs

Links úteis para DBAs e DBREs

2
Comments
7 min read
100 Days of Learning - Day 5

100 Days of Learning - Day 5

2
Comments 5
2 min read
Creating a database using PostgreSQL

Creating a database using PostgreSQL

6
Comments
3 min read
100 Days Of Learning - Day 4

100 Days Of Learning - Day 4

2
Comments
2 min read
Water of Life - A Scotch Whisky API

Water of Life - A Scotch Whisky API

3
Comments
3 min read
#SQL na unha: recursos do SGBD

#SQL na unha: recursos do SGBD

6
Comments
3 min read
Parsing Data with Just SQL

Parsing Data with Just SQL

6
Comments
7 min read
Pandas and SQL side by side

Pandas and SQL side by side

6
Comments
21 min read
How to shape sample data with PostgreSQL generate_series() and SQL

How to shape sample data with PostgreSQL generate_series() and SQL

6
Comments
21 min read
Create Streaming SQL Pipelines With dbt

Create Streaming SQL Pipelines With dbt

6
Comments
6 min read
loading...