SQL vs NoSQL Databases: How to Choose
SQL vs NoSQL explained by data shape and access pattern, with concrete examples for relational, document, key-value, wide-column and graph databases.
#sql
Everything we have written about sql.
Data & Analytics
Trending
What Is dbt? The Data Build Tool Explained With a Simple Example
What dbt does, how models, tests and docs work, a simple model example you can follow, what changed with dbt v2 and the Fivetran merger, and how to start.
SQL for Beginners: The Queries You Need to Know
Learn SELECT, WHERE, GROUP BY and JOIN using one realistic coffee shop sales table, with every query's real output shown so you can follow along.
How to Become a Data Engineer: A Skills Roadmap From SQL to Cloud Pipelines
A practical roadmap to become a data engineer: which skills to learn in order, the cloud certifications worth knowing, portfolio projects that prove you can build pipelines and common paths in.
Data & Analytics
Trending
How to Clean Data: A Step-by-Step Guide for Excel and SQL
An 8-step process for cleaning messy data, with the exact Excel functions and SQL queries to fix duplicates, missing values, stray spaces, bad dates and inconsistent categories.
Structured vs Unstructured Data: Differences and Examples
What structured, unstructured and semi-structured data are, with real business examples, a side-by-side comparison table and how AI is turning unused documents and recordings into usable data.
How to Become a Data Analyst: Skills, Projects and Entry Routes
The core skills, portfolio projects and entry routes for becoming a data analyst, including how to move into analytics from marketing, finance, operations and other fields.