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 build a Trading bot with Python and SQlite.
shadyshafik profile

How to build a Trading bot with Python and SQlite.

#python #cryptocurrencies #sql #datascience
14
Comments
5 min read
Which 🐘PostgreSQL problems are solved with 🚀YugabyteDB
franckpachot profile

Which 🐘PostgreSQL problems are solved with 🚀YugabyteDB

#yugabytedb #sql #database #postgres
11
Comments 2
7 min read
SQL-Quick tip #1 - Range of Int
coderallan profile

SQL-Quick tip #1 - Range of Int

#tsql #sqlserver #sql #mssql
8
Comments
1 min read
What is the difference between DATETIME and TIMESTAMP data type in MySQL?
bobbyiliev profile

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

#mysql #database #webdev #sql
21
Comments 2
3 min read
How do I extract a nested tuple from a tuple?
houstonkhanyile profile

How do I extract a nested tuple from a tuple?

#python #sql #beginners #programming
2
Comments 1
1 min read
Reference Tables as duplicate covering indexes
franckpachot profile

Reference Tables as duplicate covering indexes

#yugabytedb #distributed #sql #database
7
Comments
16 min read
Introdução a Pesquisa de Dados - SQL
gabrielhsilvestre profile

Introdução a Pesquisa de Dados - SQL

#beginners #sql #mysql #braziliandevs
8
Comments
5 min read
Introdução ao SQL
gabrielhsilvestre profile

Introdução ao SQL

#mysql #sql #beginners #braziliandevs
11
Comments 6
4 min read
How to provision an Azure SQL Database with Active Directory authentication
techwatching profile

How to provision an Azure SQL Database with Active Directory authentication

#pulumi #azure #sql #dotnet
11
Comments
13 min read
Restoring an SQL server backup in a Docker Container on Windows
sandord profile

Restoring an SQL server backup in a Docker Container on Windows

#docker #sql
16
Comments 2
4 min read
How to Implement Many-to-Many Relationships in Relational Databases
erikwhiting88 profile

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

#database #sql
9
Comments
6 min read
MySQL Materialized Views
codingdudecom profile

MySQL Materialized Views

#mysql #sql #webdev #database
16
Comments
3 min read
YugabyteDB table_id UUID for PostgreSQL tables
franckpachot profile

YugabyteDB table_id UUID for PostgreSQL tables

#yugabytedb #distributed #sql #database
7
Comments 3
6 min read
Using Athena Views As A Source In Glue
mattdevdba profile

Using Athena Views As A Source In Glue

#aws #sql #etl #glue
20
Comments 3
4 min read
3 SQL Interview Tips For Data Scientists And Data Engineers
seattledataguy profile

3 SQL Interview Tips For Data Scientists And Data Engineers

#sql #database #datascience #analytics
13
Comments
8 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.