Skip to content

Backend, APIs & databases · Corporate training

Sample curriculum

SQL & relational databases

Query and model relational data with practical exercises adaptable to MySQL, PostgreSQL, or MSSQL.

  • Foundation to intermediate
  • Live online and in person
Explore the curriculum Discuss your team’s training

At a glance

Who it’s for

Freshers or teams building a foundation in this technology, with the starting knowledge listed here.

Starting point: Foundation to intermediate

Bring these foundations

  • Comfort working with tables and basic data concepts.
Foundation sessions can be included when needed.

Technologies & tools

  • SQL
  • MySQL / PostgreSQL / MSSQL
  • Database client
Setup and versions agreed for your environment.

A practical destination

Skills to practise.

The sample path works towards these capabilities. Final goals reflect your team’s starting point and agreed scope.

  1. 01

    Model related data with keys and useful constraints.

  2. 02

    Write and explain joins, grouped queries and transactions.

  3. 03

    Investigate analytical queries and performance trade-offs.

Sample curriculum

Follow the learning route.

Each module connects the concepts to practical work. Open a module to explore both.

01Module 1

Relational foundations

Concepts to understand

  • Tables, keys, and relationships
  • SELECT, filtering, sorting, and NULL
  • Inserts, updates, and deletes

Practical work

Turn a small business scenario into related tables. Explain the primary and foreign keys using sample records.

Show the result. Explain one decision. Identify what you would improve.
02Module 2

Querying across tables

Concepts to understand

  • Inner and outer joins
  • Aggregation, grouping, and HAVING
  • Subqueries and common table expressions

Practical work

Answer business questions with joins, filtering and grouping. Check how missing or duplicate relationships affect the result.

Show the result. Explain one decision. Identify what you would improve.
03Module 3

Schema & integrity

Concepts to understand

  • Data types and constraints
  • Normalization and schema design
  • Transactions and concurrency basics

Practical work

Improve a schema with constraints and a transaction. Demonstrate what happens when one step of a multi-step change fails.

Show the result. Explain one decision. Identify what you would improve.
04Module 4

Analytical queries & performance

Concepts to understand

  • Window functions
  • Indexes and execution plans
  • Query review and database-specific differences

Practical work

Write an analytical query and inspect its execution plan. Compare an index choice with the cost of maintaining it.

Show the result. Explain one decision. Identify what you would improve.

A sample project

Bring the skills together.

Design a relational schema and write reporting queries with joins, aggregates, and transaction-safe updates.

Shorter engagements can focus on selected exercises. A larger, learner-owned capstone can be scoped for a longer programme.

Review the work & reasoning

Four useful questions.

  1. 01

    Does the work meet the agreed requirements?

  2. 02

    Can the learner explain the key decisions and trade-offs?

  3. 03

    What happens with invalid input, failure or an unexpected condition?

  4. 04

    What would they change or explore next?

Designed & delivered by Ragav Kumar V.

Training since 2016 · 100+ batches · 3,000+ professionals trained

Live demonstrations, guided exercises, pair work and project reviews connect the concepts to implementation. We agree the goals, starting knowledge, cohort size, delivery and schedule before shaping the final curriculum.

Shape this for your team

Connect the next skill

All backend, apis & databases curricula
Intermediate

Node.js & Express

Intermediate

Flask

Intermediate

Django