Database Management · Beginner level

Beginner level · Module 1 of 5 · 10 guided hours

Relational Databases and First Queries

Understand what relational databases are, set up a database tool and run your first queries to read and change data.

Learning objectives

  • Explain tables, rows, columns and data types
  • Set up SQLite or PostgreSQL with a graphical tool
  • Write basic SELECT, INSERT, UPDATE and DELETE statements

Topics

  • databases vs spreadsheets
  • tables, rows, columns and types
  • SQLite, PostgreSQL and database tools
  • SELECT and column lists
  • INSERT, UPDATE and DELETE
  • the danger of UPDATE without WHERE

Lessons

  1. Lesson 1 What a Relational Database Is

    See how databases store data in related tables and why organisations move from spreadsheets to databases.

    table, row and columndata typerelationalDBMS

  2. Lesson 2 Setting Up a Database and Tool

    Install a database and a graphical tool, create a database and run SQL statements.

    SQLite file databasePostgreSQL servergraphical clientCREATE TABLE

  3. Lesson 3 Reading and Changing Data

    Use SELECT to read data and INSERT, UPDATE and DELETE to change it — safely.

    SELECTINSERT INTO … VALUESUPDATE … SET … WHEREDELETE … WHERE

Practical activity

Create a table of library books, add ten books, list them in different ways and update and delete records safely.

Expected outcomes

  • A working database environment
  • Confident use of the four basic statements

Assessment

Practical: write eight statements against a provided table; marked on correct results and safe use of WHERE.

Free taster lesson Database Fundamentals & SQL Basics (MySQL & PostgreSQL) Read a free self-study lesson on this topic in the Free Course Library.

Taught live by an instructor — online or in person. Free course lessons are for self-study and do not lead to a certificate — see registration options.