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.
Modern data practice and the SQL tradition

Modern data practice and the SQL tradition

17
Comments
2 min read
ROW_NUMBER, PARTITION, & other reasons SQL is beautiful

ROW_NUMBER, PARTITION, & other reasons SQL is beautiful

14
Comments
2 min read
Analyze one year of radio station songs aired with SQL, Spark, Spotify, and Databricks

Analyze one year of radio station songs aired with SQL, Spark, Spotify, and Databricks

6
Comments
16 min read
Manipulando Datas no Postgres

Manipulando Datas no Postgres

5
Comments
2 min read
Devart Introduced The New Version of Its Flagman Solution — dbForge SQL Complete v.6.4

Devart Introduced The New Version of Its Flagman Solution — dbForge SQL Complete v.6.4

4
Comments
2 min read
SQL: Select Statements

SQL: Select Statements

7
Comments
3 min read
A (not so) small rant on techniques to copy MySQL database structures

A (not so) small rant on techniques to copy MySQL database structures

6
Comments
4 min read
Visually Creating MySQL Queries With dbForge Studio for MySQL

Visually Creating MySQL Queries With dbForge Studio for MySQL

6
Comments
4 min read
SQL: Table Creation and Basic Queries

SQL: Table Creation and Basic Queries

6
Comments
3 min read
A 'Nike Foamposites' mobile app I developed was finally accepted by Apple

A 'Nike Foamposites' mobile app I developed was finally accepted by Apple

4
Comments
2 min read
Psycopg2: PostgreSQL & Python (the Old Fashioned Way)

Psycopg2: PostgreSQL & Python (the Old Fashioned Way)

16
Comments
6 min read
Temporal tables or JSON storage

Temporal tables or JSON storage

6
Comments
3 min read
Rewrite this SQL for NoSQL, graph-db (e.g. Neo4j)

Rewrite this SQL for NoSQL, graph-db (e.g. Neo4j)

7
Comments
1 min read
Answer: Does the join order matter in SQL?

Answer: Does the join order matter in SQL?

2
Comments
1 min read
Automate SQL Queries in the cloud

Automate SQL Queries in the cloud

6
Comments
1 min read
Basic DB Using SQL Server (Part 1) - Basic commands!

Basic DB Using SQL Server (Part 1) - Basic commands!

9
Comments
3 min read
Makers - Week 4

Makers - Week 4

4
Comments
1 min read
i doing SQL tuning in Company databases but i don't know where to start

i doing SQL tuning in Company databases but i don't know where to start

3
Comments 3
1 min read
Joining Data in DynamoDB and S3 for Live Ad Hoc Analysis

Joining Data in DynamoDB and S3 for Live Ad Hoc Analysis

5
Comments
8 min read
Answer: SQL Server - How to lock a table until a stored procedure finishes

Answer: SQL Server - How to lock a table until a stored procedure finishes

6
Comments
1 min read
Importing geo-partitioned data… the easy way

Importing geo-partitioned data… the easy way

3
Comments 1
1 min read
Popular SQL interview question met in practice

Popular SQL interview question met in practice

10
Comments
3 min read
λ➕ Sum Types in relational databases: Yet another (IMO pretty neat) way to model them in SQL

λ➕ Sum Types in relational databases: Yet another (IMO pretty neat) way to model them in SQL

8
Comments
3 min read
How to deploy project local to production server using gulp?

How to deploy project local to production server using gulp?

6
Comments 1
1 min read
What is an execution plan?

What is an execution plan?

5
Comments
1 min read
loading...