Erudex sealErudex
Data & Analytics
Beginner

SQL & Relational Databases

Query, design and manage relational databases with professional SQL.

A 12-module SQL course from relational foundations to advanced querying, database design, normalisation, indexing, transactions and administration, using PostgreSQL with notes for MySQL, SQL Server and SQLite. Every lesson has hands-on labs, exercises and a quiz you must pass at 80%, followed by a pooled final exam.

240h Certificate available
SQLRelational DatabasesPostgreSQLDatabase DesignRelational Algebra

Curriculum

One complete track with its own final exam and certificate.

Twelve modules from relational foundations to production-ready database skills.

Practice outcome: Set up and explore a practice PostgreSQL database.

  • 1.1 What a relational database is: tables, rows and columns Lab60 min
  • 1.2 Primary keys, foreign keys and relationships Lab60 min
  • 1.3 Database systems: PostgreSQL, MySQL, SQL Server and SQLite Lab60 min
  • 1.4 Installing PostgreSQL and a SQL client Lab60 min
  • 1.5 Loading and exploring a practice database Lab60 min
  • 1.6 Schemas, catalogs and system tables Lab60 min
  • 1.7 How SQL statements are processed Lab60 min
  • 1.8 Your first queries and a query journal Lab60 min

Careers this prepares you for

  • Junior Database Administrator
  • Data Analyst
  • Junior Data Engineer
  • Backend Software Engineer

How you study

Every lesson pairs an in-depth video with written notes, key takeaways, a hands-on lab, exercises and a quiz. Work at your own pace, then sit the final examination for your Erudex certificate.