Public notes

    SQL And Databases

    SQL and Databases

    Querying and shaping structured data in relational databases. The default language of analytics.

    Overview

    Add a short personal take on this subject — why it matters to you, where you use it.

    Key Concepts

    • SELECT and JOINs
    • Window functions
    • CTEs
    • Indexing
    • Query optimization

    Skills

    Learned

    Skills I'm confident with. Tag with #learned.

    Learning

    Skills I'm actively working on. Tag with #learning.

    To Learn

    Skills on the roadmap. Tag with #to-learn.

    Projects

    Projects that use this subject. These will also show up as backlinks when project notes link here with [[SQL and Databases]].

    Resources

    Books, courses, papers, videos.

    Notes

    Free-form notes, gotchas, insights.