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
TEC-07-CENTRE
Illustration of training in software development technologies.
01
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.
02
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.
03
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.
04
How the service works
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.
Understand and practise
Guidance combines explanations with practice on the selected subject. Progress depends on the starting level, available time and participation.
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.
05
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.
06
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.
07
Understanding the price
Indicative price€1,300.00 Excl. tax (HT)
On-site attendance per session540 min
Number of sessions2
Participants included6
DeliveryOn site
08
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.