Skip to main content
ANVISoftware Solutions

Module 02 of 06 · SQL & Database Fundamentals

Reading and Changing Data

The four operations you will use constantly, and how to target exactly the rows you mean.

4 of 4 lessons available

Lessons in this module

  1. 01

    SELECT

    Beginner

    Retrieve columns and rows, and alias results readably.

    14 min
  2. 02

    Filtering with WHERE

    Beginner

    Target exactly the rows you mean, including null handling.

    18 min
  3. 03

    Sorting and Limiting

    Beginner

    Order results and return only the rows you need.

    13 min
  4. 04

    INSERT, UPDATE and DELETE

    Beginner

    Change data safely, always checking the affected rows first.

    17 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