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.
Recursive SQL Queries with PostgreSQL

Recursive SQL Queries with PostgreSQL

50
Comments
7 min read
Creating Professional Reports From MySQL Data

Creating Professional Reports From MySQL Data

14
Comments
3 min read
Database Schema Linting

Database Schema Linting

7
Comments
4 min read
Have you heard about Materialized Views in Amazon Redshift?

Have you heard about Materialized Views in Amazon Redshift?

18
Comments 1
4 min read
Comparison of Two Database Schemas in SQL Server

Comparison of Two Database Schemas in SQL Server

8
Comments
3 min read
Database: SQL or NoSQL

Database: SQL or NoSQL

40
Comments
3 min read
Charting the spread of COVID-19 using data

Charting the spread of COVID-19 using data

68
Comments 2
12 min read
Back To Basics: CRUD Operations with SQL

Back To Basics: CRUD Operations with SQL

9
Comments
3 min read
Trees and the Database.

Trees and the Database.

41
Comments 11
4 min read
Import CSV Data Into SQL Databases From The Terminal

Import CSV Data Into SQL Databases From The Terminal

57
Comments 3
3 min read
Playing with a public dataset, and playing with food

Playing with a public dataset, and playing with food

8
Comments 6
5 min read
How to set up a free PostgreSQL database on Heroku

How to set up a free PostgreSQL database on Heroku

253
Comments 13
3 min read
Introduction into Window Functions on SQL Server

Introduction into Window Functions on SQL Server

12
Comments
4 min read
Using SQL's TRIM and REPLACE to tidy up your data

Using SQL's TRIM and REPLACE to tidy up your data

8
Comments 1
3 min read
Formatting and dealing with dates in SQL

Formatting and dealing with dates in SQL

9
Comments 1
11 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.