Forem

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.
🗂️ Master SQL from Scratch – A Step-by-Step Roadmap with Visual Guide & Progress Tracker
Cover image for 🗂️ Master SQL from Scratch – A Step-by-Step Roadmap with Visual Guide & Progress Tracker

🗂️ Master SQL from Scratch – A Step-by-Step Roadmap with Visual Guide & Progress Tracker

4
Comments 2
3 min read
SQL Project in VS: Why column order matters?

SQL Project in VS: Why column order matters?

Comments 15
2 min read
🚀 Seamless Data Magic: From Notion to Database with MCP Server & AI Agents
Cover image for 🚀 Seamless Data Magic: From Notion to Database with MCP Server & AI Agents

🚀 Seamless Data Magic: From Notion to Database with MCP Server & AI Agents

1
Comments 1
3 min read
SQL COALESCE in Postgres: A Simple Guide

SQL COALESCE in Postgres: A Simple Guide

13
Comments 7
3 min read
SQL Made Easy: A Tutorial for Beginners
Cover image for SQL Made Easy: A Tutorial for Beginners

SQL Made Easy: A Tutorial for Beginners

1
Comments
4 min read
5 SQL Queries Everyone Should Know
Cover image for 5 SQL Queries Everyone Should Know

5 SQL Queries Everyone Should Know

6
Comments 1
2 min read
Step-by-Step Guide to Set Up a Cron Job to Run a Report
Cover image for Step-by-Step Guide to Set Up a Cron Job to Run a Report

Step-by-Step Guide to Set Up a Cron Job to Run a Report

Comments
4 min read
Creating Reports to Find Missing Data During the Normalization Process in SQL
Cover image for Creating Reports to Find Missing Data During the Normalization Process in SQL

Creating Reports to Find Missing Data During the Normalization Process in SQL

Comments
3 min read
Getting Started with SQL: The Language of Data
Cover image for Getting Started with SQL: The Language of Data

Getting Started with SQL: The Language of Data

1
Comments
3 min read
SQL For Data Analytics in a Nutshell
Cover image for SQL For Data Analytics in a Nutshell

SQL For Data Analytics in a Nutshell

4
Comments
5 min read
Why Transactional Databases Matter: Concepts, Use Cases, and Examples

Why Transactional Databases Matter: Concepts, Use Cases, and Examples

2
Comments 2
3 min read
Number Non-Null Values in Order within the Group — From SQL to SPL #17
Cover image for Number Non-Null Values in Order within the Group — From SQL to SPL #17

Number Non-Null Values in Order within the Group — From SQL to SPL #17

6
Comments 1
2 min read
Hashing in Presto/Athena

Hashing in Presto/Athena

1
Comments
1 min read
Oracle 23ai (23.7) — Materialized Expression Columns

Oracle 23ai (23.7) — Materialized Expression Columns

1
Comments
1 min read
How to Use SQL in Go

How to Use SQL in Go

Comments
6 min read
Getting Started with SQL: A Guide for Data Analysts

Getting Started with SQL: A Guide for Data Analysts

Comments 1
2 min read
Olake (Lakehouse)
Cover image for Olake (Lakehouse)

Olake (Lakehouse)

Comments
2 min read
Apresentação do Repositório Dotnet Templates

Apresentação do Repositório Dotnet Templates

Comments
2 min read
Features I Wish MySQL Had but Postgres 🐘 Already Has 😻
Cover image for Features I Wish MySQL Had but Postgres 🐘 Already Has 😻

Features I Wish MySQL Had but Postgres 🐘 Already Has 😻

5
Comments 2
5 min read
ORM vs ODM: What's the Difference and When to Use Them?

ORM vs ODM: What's the Difference and When to Use Them?

7
Comments
1 min read
Top 5 Alternative Data Career Paths (And How to Learn Each for Free)
Cover image for Top 5 Alternative Data Career Paths (And How to Learn Each for Free)

Top 5 Alternative Data Career Paths (And How to Learn Each for Free)

Comments 2
4 min read
Backup (and restore) an Sql database inside a docker container.
Cover image for Backup (and restore) an Sql database inside a docker container.

Backup (and restore) an Sql database inside a docker container.

Comments
1 min read
10 SQL Anti-Patterns You Must Avoid in Production

10 SQL Anti-Patterns You Must Avoid in Production

2
Comments
2 min read
SQL Join Dark Arts: Anti Joins, Semi Joins, and Beyond

SQL Join Dark Arts: Anti Joins, Semi Joins, and Beyond

Comments
2 min read
Transforming Rows to Columns and Back: SQL PIVOT/UNPIVOT Techniques

Transforming Rows to Columns and Back: SQL PIVOT/UNPIVOT Techniques

1
Comments
2 min read
loading...