Skip to content

DEV Community

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

👋 Sign in for the ability to sort posts by relevant, latest, or top.

Apaksh

Mar 18

SQL Mastery: The Essential Cheat Sheet for Data Professionals

#sql #database #beginners #tutorial

5 min read

Mar 18

Window Functions for Call Centre Analytics — A Practical PostgreSQL Guide

#postgres #sql #beginners #analytics

3 min read

fosres

Mar 17

Week 9: Audit 15 Code Snippets for SQL Injection

#security #python #appsec #sql

20 min read

Mar 30

#Understanding Data Modelling in Power BI: Joins, Relationships, and Schemas Explained

#dataengineering #microsoft #sql #tutorial

6 min read

Makroumi

Mar 16

Real-Time SQL Analysis in VS Code: Catch Dangerous Queries Before You Save the File

#sql #vscode #database #security

3 min read

Mar 29

Understanding Data Modeling in Power BI: Joins, Relationships, and Schemas Explained

#data #datascience #sql #tutorial

12 min read

Mar 16

SurrealDB: How I Deleted 70% of My Backend Code (Part 2)

#sql #backend #database #webdev

2 min read

Baris Terzioglu

Mar 15

Materialization strategies: how Bruin and dbt turn SELECT queries into tables

#dataengineering #sql #dbt #datapipeline

11 min read

Mar 29

Understanding Data Modeling in Power BI: Joins, Relationships, and Schemas Explained

#datascience #sql #powerfuldevs #datastructures

4 min read

Baris Terzioglu

Mar 15

How Bruin turns a SELECT query into 9 different materialization strategies across 14 databases

#dataengineering #go #sql #programming

10 min read

Baris Terzioglu

Mar 15

Data quality testing: how Bruin and dbt take different paths to the same goal

#dataengineering #sql #dataquality #devops

7 min read

soy

Mar 28

SQLite, Go/Postgres, & Petabytes: Database Patterns for Builders

#database #sql #dataengineering

4 min read

Murad Aghamirzayev

Mar 15

Creating a Cross-platform Data Sandbox that makes Working with Data Easier and Faster

#dataengineering #python #datascience #sql

3 min read

Mar 14

Schema-risk

#rust #postgres #sql #cli

2 min read

ZevinChen

Mar 15

5 SQL Formatting Rules That Make Your Queries Actually Readable

#sql #database #productivity #beginners

3 min read

👋 Sign in for the ability to sort posts by relevant, latest, or top.