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.
Unraveling the Web: A Comprehensive Guide to Mastering SQL Joins

Unraveling the Web: A Comprehensive Guide to Mastering SQL Joins

Comments
3 min read
COMMON MISTAKES TO AVOID IN SQL QUERY WRITING

COMMON MISTAKES TO AVOID IN SQL QUERY WRITING

Comments
2 min read
The difficulty of SQL stems from relational algebra

The difficulty of SQL stems from relational algebra

15
Comments 1
6 min read
Navigating SQL Data Types: A Comprehensive Guide

Navigating SQL Data Types: A Comprehensive Guide

Comments
3 min read
4 numeric distribution metrics to track in Snowflake (and how to track them)

4 numeric distribution metrics to track in Snowflake (and how to track them)

Comments
9 min read
Detecting table insert misses with adaptive flatline alerts

Detecting table insert misses with adaptive flatline alerts

Comments
3 min read
Three ways to track schema drift in Snowflake

Three ways to track schema drift in Snowflake

Comments
5 min read
Better Postgres Database Migrations and Testing by Ditching Bloated ORMs

Better Postgres Database Migrations and Testing by Ditching Bloated ORMs

Comments
3 min read
Stay Fresh: Four Ways to Track Update Times for BigQuery Tables and Views

Stay Fresh: Four Ways to Track Update Times for BigQuery Tables and Views

Comments
3 min read
Comparing Snowflake Dynamic Tables with dbt

Comparing Snowflake Dynamic Tables with dbt

1
Comments
5 min read
Three Ways to Retrieve Row Counts in Redshift Tables and Views

Three Ways to Retrieve Row Counts in Redshift Tables and Views

Comments
3 min read
Stay Fresh: Two Ways to Track Update Times for Snowflake Tables and Views

Stay Fresh: Two Ways to Track Update Times for Snowflake Tables and Views

Comments
3 min read
Four Efficient Techniques to Retrieve Row Counts in BigQuery Tables and Views

Four Efficient Techniques to Retrieve Row Counts in BigQuery Tables and Views

Comments
4 min read
Three Ways to Retrieve Row Counts for Snowflake Tables and Views

Three Ways to Retrieve Row Counts for Snowflake Tables and Views

Comments
2 min read
3 ways to improve data sampling efficiency in Snowflake

3 ways to improve data sampling efficiency in Snowflake

Comments
7 min read
Query optimisation using database indexes

Query optimisation using database indexes

1
Comments
3 min read
Hey Managers! Don’t Let Developers Break Your Production! Let Metis Help You

Hey Managers! Don’t Let Developers Break Your Production! Let Metis Help You

Comments
7 min read
11 Lessons to learn when using NULLs in PostgreSQL®

11 Lessons to learn when using NULLs in PostgreSQL®

8
Comments
11 min read
Structured Query Language-SQL : Mastering SQL Queries: From Beginner to Expert

Structured Query Language-SQL : Mastering SQL Queries: From Beginner to Expert

6
Comments
6 min read
SQL vs. No SQL | Database Types | Mastering Data Architecture

SQL vs. No SQL | Database Types | Mastering Data Architecture

5
Comments
4 min read
SQLite3 Replication: A Wizard's Guide🧙🏽

SQLite3 Replication: A Wizard's Guide🧙🏽

10
Comments
4 min read
Complete Guide: Fully Uninstalling Microsoft SQL Server 2019 from Your System

Complete Guide: Fully Uninstalling Microsoft SQL Server 2019 from Your System

13
Comments
2 min read
Functions in SQL

Functions in SQL

Comments
3 min read
Use EXISTS instead of COUNT > 0 when checking if records exist

Use EXISTS instead of COUNT > 0 when checking if records exist

Comments 2
3 min read
Understanding OVER() Clause in SQL

Understanding OVER() Clause in SQL

1
Comments
2 min read
loading...