Skip to content

Instantly share code, notes, and snippets.

@Paulius-Maruska

Paulius-Maruska/notes.md

Last active July 14, 2019 11:10
Show Gist options
  • Save Paulius-Maruska/adfd6166e3a5a6e6ad0cd2062f48defb to your computer and use it in GitHub Desktop.
Save Paulius-Maruska/adfd6166e3a5a6e6ad0cd2062f48defb to your computer and use it in GitHub Desktop.
Download ZIP
Introduction to Relational databases
Raw
readme.md

This gist is just some notes regarding a talk I'm planning to give to my fellow programmers.

Intended audience: newbies who have little to no experience with relational databases and SQL.

Raw
notes.md

Relational Databases

Things to talk about

  1. What is Relational Database?
  2. What is SQL?
  3. SQL and Django models (and maybe sqlAlchemy)
  4. Basic data types
    1. numbers
    2. texts and binary data
    3. dates, times and durations
    4. table identity
  5. Table relations
    1. One-to-One relations
    2. Many-to-One relations
    3. Many-to-Many relations
  6. Querying tables
    1. Simple queries
    2. Transforming data within a query
    3. Queries and subqueries
    4. Joining tables
    5. Aggregating data with GROUP BY
    6. Mixing everything together
    7. Short mention - Views, server functions, stored procedures
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment