InsideEdgeInsideEdge
Download App

Phase 3 · SQL for Data Analysis

Topics

Date & String Functions

Part of the Data Analyst Roadmap.

Summary

Functions for extracting parts of a date (month, year, day-of-week) and manipulating text (concatenation, substring, trimming) — used constantly in real analyst queries.

How to Learn This

  • 1Practice extracting month and year from a date column for a monthly trend query.
  • 2Write a query concatenating first and last name into a full name.
  • 3Learn your specific SQL dialect's date function names (they vary between databases).

Previous

Window Functions

Next

Query Optimization Basics

More topics in SQL for Data Analysis

SQL Basics (SELECT, WHERE, ORDER BY)Aggregate Functions (COUNT, SUM, AVG)GROUP BY & HAVINGJoins (INNER, LEFT, RIGHT, FULL)SubqueriesCommon Table Expressions (CTEs)Window FunctionsQuery Optimization BasicsDatabase Design Basics (ER Diagrams)
InsideEdge

Stuck on this topic? Ask an Insider

Get 1:1 guidance from people who've walked this exact path — free on the InsideEdge app.

Download
InsideEdge