Skip to main content
ANVISoftware Solutions

Module 01 of 06 · SQL & Database Fundamentals

Database Foundations

What a relational database is and the vocabulary everything else builds on.

4 of 4 lessons available

Lessons in this module

  1. 01

    What Is a Database?

    Beginner

    Explain what a relational database gives you that a file does not.

    12 min
  2. 02

    Tables, Rows and Columns

    Beginner

    Describe how data is organised and choose sensible column types.

    14 min
  3. 03

    Primary and Foreign Keys

    Beginner

    Identify rows uniquely and link tables reliably.

    15 min
  4. 04

    Relationships

    Beginner

    Model one-to-many and many-to-many relationships between tables.

    15 min

Have a project worth talking through?

Tell us what you're building or what's slowing your current system down. We'll give you a direct read on scope and approach.

Start a ConversationExplore Our Services