SMC ServicesSteven Maitre
SMC ServicesSteven Maitre

TrainingTechnical training

PostgreSQL and Prisma: Training centre

Model relationships, query data and organise migrations. Total price for the group, standard programme. Digital materials and standard assessment included.

  • 9 hr
  • 2 sessions
  • On site
  • People included : 6
Laptop displaying stylised lines of code
Illustration of training in software development technologies.

Who this offer is for

For training centres organising the programme for their group with the stated equipment and prerequisites.

The intended outcome

Learn to translate a simple need into PostgreSQL relationships and manipulate data with Prisma. You study table links, useful queries and model evolution through migrations. The aim is to understand structural choices' consequences and verify changes on an isolated learning database.

What is included

Scope and limits

  • Model relationships, query data and organise migrations. Total price for the group, standard programme. Digital materials and standard assessment included.

What we work on in practice

Model relationships

You identify exercise entities and links, then choose necessary fields and constraints. You examine missing data, duplicates and incorrect references. This explains what the database can protect itself and what the programme must still validate.

Read and write with Prisma

You connect the model to TypeScript queries and observe actually returned data. You filter a list, query a relationship and examine a write error in selected cases. You learn to explain queries and results without assuming the data client replaces database constraints.

Evolve the practice database

You study a model change, read the associated structural change and verify effects on existing queries. You work in a learning environment to distinguish preparing, applying and checking a migration. No production database intervention or real data migration is included.

A practical example

A practice database connects fictional training courses with enrolments. You choose relationships, find a course's participants and add a learning-model field. Before/after comparison shows how a change affects queries without handling a client database or promising operational migration.

How the service works

  1. Choose a suitable objective

    The subject follows the planned programme, your starting level and intended uses. Group prerequisites and equipment must allow participants to follow the exercises.

  2. Understand and practise

    Guidance combines explanations with practice on the selected subject. Progress depends on the starting level, available time and participation.

  3. Review the key points

    Review what was practised and what needs further work. Materials and assessments are included when the offer explicitly lists them. Complete mastery is not guaranteed by attending training.

What your purchase pays for

  • Guidance time on the selected subject, with explanations and guided practice.
  • Attention to difficulties during exercises, in the agreed individual or group format.
  • Digital materials and a standard assessment only where stated. Equipment, licences and subscriptions follow the offer’s terms.

What to prepare

  • Review SQL and TypeScript basics.
  • Prepare an authorised local or learning database.
  • Describe simple relationships with fictional data. Training centre: validate group level and learning pathway.

Prerequisites

  • SQL and TypeScript basics. Programme, exercises, expertise, training obligations and dates confirmed.

Exclusions

  • Licences, room, equipment, guaranteed funding, external certification and production development.

Understanding the price

Indicative price€1,300.00 Excl. tax (HT)
On-site attendance per session540 min
Number of sessions2
Participants included6
DeliveryOn site

Questions about this offer

Can we work on our production database?

Learning uses an isolated test database and fictional data. Production development is excluded; operational migration or copying real data needs separate scope and authorisation.

What does the training centre arrangement include?

Programme, exercises, skills, obligations and dates are confirmed. Digital materials and standard assessment included. On-site presence and teaching have separate durations. Exclusions: licences, room, equipment, guaranteed funding, external certification and production development.

These explanations describe the proposed work. Tasks, quantities, deliverables, dates and options are confirmed in the quote or order. The published limits still apply.

PostgreSQL and Prisma: Training centre | MaestroComputer Services