{"id":222,"date":"2026-04-08T13:07:48","date_gmt":"2026-04-08T13:07:48","guid":{"rendered":"https:\/\/croqueloisromeo.fr\/?p=222"},"modified":"2026-04-08T13:22:28","modified_gmt":"2026-04-08T13:22:28","slug":"projet-techevent","status":"publish","type":"post","link":"https:\/\/croqueloisromeo.fr\/index.php\/2026\/04\/08\/projet-techevent\/","title":{"rendered":"Projet TechEvent"},"content":{"rendered":"\n<p>TechEvent Solutions, PME lyonnaise cr\u00e9\u00e9e en 2015, organise des \u00e9v\u00e9nements professionnels autour des technologies (IA, cybers\u00e9curit\u00e9, cloud, DevOps\u2026). <br>L\u2019entreprise compte une vingtaine d\u2019employ\u00e9s structur\u00e9s hi\u00e9rarchiquement et g\u00e8re conf\u00e9rences, sessions et intervenants dans diff\u00e9rentes salles. Participants et employ\u00e9s sont tous enregistr\u00e9s comme personnes, avec des informations sp\u00e9cifiques selon leur r\u00f4le. <br>Les inscriptions, factures et mat\u00e9riels (informatique, audio\u2011vid\u00e9o\u2026) sont suivis mais actuellement dispers\u00e9s dans plusieurs fichiers Excel. <br>La direction souhaite centraliser toutes les donn\u00e9es dans une base relationnelle fiable pour am\u00e9liorer la coh\u00e9rence, la facturation et les statistiques.<br>Notre mission a \u00e9t\u00e9 de g\u00e9rer la base de donn\u00e9es \u00e0 l&rsquo;aide de requ\u00eates, triggers, et proc\u00e9dures stock\u00e9es.<\/p>\n\n\n\n<div data-wp-interactive=\"core\/file\" class=\"wp-block-file\"><object data-wp-bind--hidden=\"!state.hasPdfPreview\" hidden class=\"wp-block-file__embed\" data=\"https:\/\/croqueloisromeo.fr\/wp-content\/uploads\/2026\/04\/projet-techevent.pdf\" type=\"application\/pdf\" style=\"width:100%;height:600px\" aria-label=\"Contenu embarqu\u00e9 projet techevent.\"><\/object><a id=\"wp-block-file--media-f7236b1b-8635-4bdf-a50b-7ea8eeb989c4\" href=\"https:\/\/croqueloisromeo.fr\/wp-content\/uploads\/2026\/04\/projet-techevent.pdf\">projet techevent<\/a><a href=\"https:\/\/croqueloisromeo.fr\/wp-content\/uploads\/2026\/04\/projet-techevent.pdf\" class=\"wp-block-file__button wp-element-button\" download aria-describedby=\"wp-block-file--media-f7236b1b-8635-4bdf-a50b-7ea8eeb989c4\">T\u00e9l\u00e9charger<\/a><\/div>\n\n\n<div class=\"taxonomy-category wp-block-post-terms\"><span class=\"wp-block-post-terms__prefix\">Comp\u00e9tences : <\/span><a href=\"https:\/\/croqueloisromeo.fr\/index.php\/category\/1-2-repondre-aux-incidents-et-aux-demandes-dassistance-et-devolution\/1-2-3-traiter-des-demandes-concernant-les-applications\/\" rel=\"tag\">1.2.3 Traiter des demandes concernant les applications<\/a><span class=\"wp-block-post-terms__separator\">, <\/span><a href=\"https:\/\/croqueloisromeo.fr\/index.php\/category\/1-4-travailler-en-mode-projet\/1-4-1-analyser-les-objectifs-et-les-modalites-dorganisation-dun-projet\/\" rel=\"tag\">1.4.1 Analyser les objectifs et les modalit\u00e9s d\u2019organisation d\u2019un projet<\/a><span class=\"wp-block-post-terms__separator\">, <\/span><a href=\"https:\/\/croqueloisromeo.fr\/index.php\/category\/1-4-travailler-en-mode-projet\/1-4-2-planifier-les-activites\/\" rel=\"tag\">1.4.2 Planifier les activit\u00e9s<\/a><span class=\"wp-block-post-terms__separator\">, <\/span><a href=\"https:\/\/croqueloisromeo.fr\/index.php\/category\/1-5-mettre-a-disposition-des-utilisateurs-un-service-informatique\/1-5-1-realiser-les-tests-dintegration-et-dacceptation-dun-service\/\" rel=\"tag\">1.5.1 R\u00e9aliser les tests d\u2019int\u00e9gration et d\u2019acceptation d\u2019un service<\/a><\/div>","protected":false},"excerpt":{"rendered":"<p>TechEvent Solutions, PME lyonnaise cr\u00e9\u00e9e en 2015, organise des \u00e9v\u00e9nements professionnels autour des technologies (IA, cybers\u00e9curit\u00e9, cloud, DevOps\u2026). L\u2019entreprise compte une vingtaine d\u2019employ\u00e9s structur\u00e9s hi\u00e9rarchiquement et g\u00e8re conf\u00e9rences, sessions et intervenants dans diff\u00e9rentes salles. Participants et employ\u00e9s sont tous enregistr\u00e9s comme personnes, avec des informations sp\u00e9cifiques selon leur r\u00f4le. Les inscriptions, factures et mat\u00e9riels (informatique, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[13,20,21,25],"tags":[],"class_list":["post-222","post","type-post","status-publish","format-standard","hentry","category-1-2-3-traiter-des-demandes-concernant-les-applications","category-1-4-1-analyser-les-objectifs-et-les-modalites-dorganisation-dun-projet","category-1-4-2-planifier-les-activites","category-1-5-1-realiser-les-tests-dintegration-et-dacceptation-dun-service"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/croqueloisromeo.fr\/index.php\/wp-json\/wp\/v2\/posts\/222","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/croqueloisromeo.fr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/croqueloisromeo.fr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/croqueloisromeo.fr\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/croqueloisromeo.fr\/index.php\/wp-json\/wp\/v2\/comments?post=222"}],"version-history":[{"count":2,"href":"https:\/\/croqueloisromeo.fr\/index.php\/wp-json\/wp\/v2\/posts\/222\/revisions"}],"predecessor-version":[{"id":225,"href":"https:\/\/croqueloisromeo.fr\/index.php\/wp-json\/wp\/v2\/posts\/222\/revisions\/225"}],"wp:attachment":[{"href":"https:\/\/croqueloisromeo.fr\/index.php\/wp-json\/wp\/v2\/media?parent=222"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/croqueloisromeo.fr\/index.php\/wp-json\/wp\/v2\/categories?post=222"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/croqueloisromeo.fr\/index.php\/wp-json\/wp\/v2\/tags?post=222"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}