TRAINING · TAILORED PROGRAMME · SQL

Your data describes relationships. Let the schema protect them through every conflict.

Training to model persistent data with PostgreSQL and Prisma, then read and change it under constraints.

On request · Programme, level and delivery to be agreed

A learning path built around practiceSQL / 04
Proposed programme

Relational model

View the programme
Proposed programme, subject to approval
PostgreSQL and Prisma trainingMC / SERVICES
A skill to put into practice

Model, read and change data with constraints.

Who is this proposal for?

Developers working with persistent data.

Suggested prerequisites

TypeScript and a basic understanding of data.

01 → 04

Level assessment

A conversation and a level assessment exercise help us adapt the starting point.

Proposed programme

Four progressive modules

This progression is a teaching proposal. The content is adapted after the level assessment and programme approval.

01

Relational model

Identify entities, their relationships and the responsibilities carried by each piece of data.

Hands-on work
02

Schema and migrations

Evolve a Prisma schema and model organisations and members without mixing their roles.

Hands-on work
03

Queries

Read and change data while preventing duplicates according to an explicit constraint.

Hands-on work
04

Transactions and constraints

Group related operations and handle conflicts without hiding limitations.

Hands-on work
Hands-on work

Learn by building

Exercise / 01

Model organisations and members without mixing their roles.

Exercise / 02

Prevent a duplicate according to an explicit constraint.

Proposed final exercise

A case-file model with queries and conflict cases.

Assessment

Observable assessment criteria

The assessment is based on the completed work and identifies areas to continue developing. Its format is specified with the programme.

  • The result handles the stated scenario.
  • The choices are explained with appropriate terminology.
  • An error case or limitation is addressed.
  • The work can be reproduced from clear instructions.
Organisation

Prepare the right working conditions

Format and delivery

Remote or on site, depending on the agreed arrangements. Duration, group size, delivery details and price are quoted after the level assessment; dates are available on request.

Equipment

The computer and required tools are specified with the programme. Test accounts are provided when the exercises require them.

Learning materials

Materials, exercises and solutions are prepared for the agreed programme. Their format and handover terms are agreed together.

Accessibility and adjustments

Adjustment needs can be described in the request. Suitable arrangements are considered before the programme is agreed.

Frequently asked questions

Your questions about this programme

How is the data model assessed?+

The final exercise checks relationships, constraints, expected queries and explicit handling of a conflict.

Can the programme be adapted for a team?+

Yes. The starting level, target tasks and team constraints are clarified before the programme is agreed.

Is a session already open?+

Dates and delivery details are proposed on request and then agreed together. This page does not confirm enrolment.

Your next step

Let’s build your learning path.

Your starting level and the tasks to master guide the proposed programme, exercises and delivery.

Request this training