Back to skills

SQL

Databases (DBMS & SQL) Since Jan 2016
L4
67/100

Other technologies

MySQL PostgreSQL SQL

Evidence

  • Why this level

    Summary

    SQL is used across relational modeling, massive imports, geodata, permission constraints and business aggregates in several real contexts.

  • Current ceiling

    Summary

    The main improvement axes to reach the next level are: document advanced SQL tuning, show execution-plan analysis, and expose cases involving larger-scale datasets.

  • Batch validation and ON CONFLICT

    Permalink Source

    The batch-validation and idempotent-insertion logic in TaxHub also returns administrative statistics.

  • Permissions and business filtering

    Permalink Source

    The query assembled in gn_module_export combines users, groups, application rights and business sorting.

  • Export view and migration

    PR Source

    The evolution of the synthese export view in GeoNature adds group3_inpn with migration and tests, documenting work on evolving SQL structures.

  • Rich relational schemas

    Permalink Source

    The Quiz App backend models questions, categories, scores, histories and game modes in a complete relational schema.

  • Business relational entities

    Permalink Source

    The entities in the e-brairie project formalize domain relations, borrowing flows, wishlist and resources linked to author, type and category.