{"id":845,"date":"2023-10-16T09:41:11","date_gmt":"2023-10-16T13:41:11","guid":{"rendered":"https:\/\/ve2cuy.com\/?page_id=845"},"modified":"2024-09-18T10:06:55","modified_gmt":"2024-09-18T14:06:55","slug":"420-5d3-projet-devaluations-2023","status":"publish","type":"page","link":"https:\/\/ve2cuy.com\/index.php\/420-5d3-projet-devaluations-2023\/","title":{"rendered":"420-5D3 :\u00a0 Projet d&rsquo;\u00e9valuations 2023"},"content":{"rendered":"<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"734\" height=\"752\" src=\"https:\/\/ve2cuy.com\/wp-content\/uploads\/2023\/10\/Capture-decran-le-2023-10-16-a-09.40.30.png\" alt=\"\" class=\"wp-image-846\" style=\"aspect-ratio:0.976063829787234;width:385px;height:auto\" srcset=\"https:\/\/ve2cuy.com\/wp-content\/uploads\/2023\/10\/Capture-decran-le-2023-10-16-a-09.40.30.png 734w, https:\/\/ve2cuy.com\/wp-content\/uploads\/2023\/10\/Capture-decran-le-2023-10-16-a-09.40.30-293x300.png 293w\" sizes=\"auto, (max-width: 734px) 100vw, 734px\" \/><\/figure>\n<\/div>\n\n\n<h2 class=\"wp-block-heading has-text-align-center has-vivid-red-color has-text-color\">Version pr\u00e9liminaire du 2023.10.16<\/h2>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>Ce projet d&rsquo;\u00e9valuations en plusieurs \u00e9tapes, permettra de mesurer la compr\u00e9hension des \u00e9l\u00e9ments suivants:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Notions de cryptage et de protection des donn\u00e9es\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/ve2cuy.com\/index.php\/420-5d3-notion-de-hashage\/\" data-type=\"page\" data-id=\"671\">Hashage<\/a>\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/fr.wikipedia.org\/wiki\/Fonction_de_hachage\"><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-purple-color\">Fonction de hashage<\/mark><\/a>\n<ul class=\"wp-block-list\">\n<li>MD5, SHA1, SHA2, etc<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"https:\/\/fr.wikipedia.org\/wiki\/Chiffrement#:~:text=Un%20syst\u00e8me%20de%20chiffrement%20est,cl\u00e9%20priv\u00e9e%2C%20servant%20\u00e0%20d\u00e9chiffrer.\"><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-purple-color\">Chiffrement sym\u00e9trique et asym\u00e9trique<\/mark><\/a>\n<ul class=\"wp-block-list\">\n<li>\u200b<a href=\"https:\/\/ve2cuy.com\/420-3c3\/?page_id=1492\">Cl\u00e9s priv\u00e9es et cl\u00e9s publiques&nbsp;: ssh<\/a><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-purple-color\">Algorithmes de protection des mots de passe<\/mark>\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/en.wikipedia.org\/wiki\/Argon2\"><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-purple-color\">Argon<\/mark><\/a>, <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-purple-color\">pbkdf2, scrypt, bcrypt<\/mark>\n<ul class=\"wp-block-list\">\n<li>Librairies et application<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Protection des communications WEB : <a href=\"https:\/\/ve2cuy.com\/420-21e\/index.php\/installation-dun-certificat-signe-sur-un-hote-virtuel-apache2\/\"><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-purple-color\">HTTPS et certificats (certbot)<\/mark><\/a>\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/fr.wikipedia.org\/wiki\/Chiffrement_RSA\">RSA<\/a><\/li>\n\n\n\n<li>Transport Layer Security : <a href=\"https:\/\/fr.wikipedia.org\/wiki\/Transport_Layer_Security\"><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-purple-color\">TLS<\/mark><\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/12.2\/nlspg\/choosing-character-set.html#GUID-BF26E01D-AB92-48FC-855A-69A5B3AF9A92\">Notion de jeux de caract\u00e8res<\/a><\/li>\n\n\n\n<li>Administration d&rsquo;une base de donn\u00e9es Oracle\n<ul class=\"wp-block-list\">\n<li>Utilisateurs\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/ve2cuy.com\/index.php\/420-5d3-oracle-installation\/\" data-type=\"page\" data-id=\"287\">Sch\u00e9mas<\/a>\n<ul class=\"wp-block-list\">\n<li>system<\/li>\n\n\n\n<li>sys, sysdba<\/li>\n\n\n\n<li>&#8230;<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"https:\/\/ve2cuy.com\/index.php\/420-5d3-oracle-liste-des-privileges\/\" data-type=\"page\" data-id=\"613\"><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-purple-color\">Privil\u00e8ges<\/mark><\/a><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-purple-color\"> <\/mark><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Automatisation des traitements des donn\u00e9es\n<ul class=\"wp-block-list\">\n<li>\u200b<mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-purple-color\">Commit<\/mark>\u00a0<\/li>\n\n\n\n<li>\u200b<mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-purple-color\">Rollback<\/mark>\u00a0<\/li>\n\n\n\n<li>&#8230;<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"https:\/\/ve2cuy.com\/index.php\/420-5d3-bd-procedure-stockee\/\" data-type=\"page\" data-id=\"692\"><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-purple-color\">Proc\u00e9dures stock\u00e9es : PL\/SQL<\/mark><\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/ve2cuy.com\/index.php\/420-5d5-bd-les-fonctions\/\" data-type=\"page\" data-id=\"690\">Fonctions personnalis\u00e9es<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/ve2cuy.com\/index.php\/420-5d3-bd-declencheur\/\" data-type=\"page\" data-id=\"697\"><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-purple-color\">D\u00e9clencheurs<\/mark><\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/ve2cuy.com\/index.php\/420-5d3-bd-vues\/\" data-type=\"page\" data-id=\"680\">Vue et Duality Views (pont JSON)<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/ve2cuy.com\/index.php\/420-5d3-connexion-php-avec-oracle\/\" data-type=\"page\" data-id=\"490\">Applications<\/a><\/li>\n\n\n\n<li>Tests de p\u00e9n\u00e9tration et s\u00e9curit\u00e9 des syst\u00e8mes <\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\">NOTE<\/mark><\/strong>: Ce qui est en <strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-purple-color\">MAUVE<\/mark><\/strong> sera trait\u00e9 \u00e0 l&rsquo;\u00e9preuve synth\u00e8se<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Pond\u00e9ration<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Projet total : 40%<\/h3>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\">NOTE<\/mark><\/strong>: Les \u00e9tapes de remises seront pr\u00e9cis\u00e9es prochainement. <\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Contexte de r\u00e9alisation<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u00c0 partir d&rsquo;une VM en nuage<\/li>\n\n\n\n<li>D&rsquo;un certificat HTTPS<\/li>\n\n\n\n<li>D&rsquo;une paire de cl\u00e9s asym\u00e9triques<\/li>\n\n\n\n<li>Du SGBD Oracle<\/li>\n\n\n\n<li>De notions de cryptage des donn\u00e9es et de libraires<\/li>\n\n\n\n<li>De notions de comptes utilisateurs, de sch\u00e9mas et de privil\u00e8ges du SGBS Oracle<\/li>\n\n\n\n<li>De fonctions, proc\u00e9dures stock\u00e9s, vues, &#8230;<\/li>\n\n\n\n<li>De langages de programmation, framework, &#8230;<\/li>\n<\/ul>\n\n\n\n<p>Il faut:<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Partie A &#8211; Base de donn\u00e9es, notions interm\u00e9diaires<\/h2>\n\n\n\n<p><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Un sch\u00e9ma de base de donn\u00e9es Oracle (de votre choix) avec au minimum:<\/li>\n\n\n\n<li>5 cl\u00e9s \u00e9trang\u00e8res et 3 suppressions en cascade<\/li>\n\n\n\n<li>Au moins trois cl\u00e9s primaires en incr\u00e9mentation automatique&nbsp;<\/li>\n\n\n\n<li>Au moins un &nbsp;BLOB pour stocker des images<\/li>\n\n\n\n<li>2 fonctions personnalis\u00e9es&nbsp;<\/li>\n\n\n\n<li>3 proc\u00e9dures stock\u00e9es&nbsp;<\/li>\n\n\n\n<li>Au moins un d\u00e9clencheur&nbsp;&#8211; Par exemple, sur !unicit\u00e9 d&rsquo;un mot de passe dans la BD.<\/li>\n\n\n\n<li>3 vues, dont 2 en duality view&nbsp;<\/li>\n\n\n\n<li>Injection d\u2019enregistrements de d\u00e9part dans la bd<\/li>\n\n\n\n<li>D\u00e9ploiement du sch\u00e9ma \u00e0 partir d&rsquo;un d\u00e9p\u00f4t git.<\/li>\n<\/ul>\n\n\n\n<p>\u2014-<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Partie B)<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>D\u00e9ploiement d\u2019un SGBD en nuage<\/li>\n\n\n\n<li>Installation de Oracle 23c dans une VM dans Google cloud .<\/li>\n\n\n\n<li><a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-rest-data-services\/23.2\/index.html\">Installation des services REST d&rsquo;Oracle<\/a> : ORDS<\/li>\n\n\n\n<li>Ne pas utiliser docker donne 2 points suppl\u00e9mentaires&nbsp;<\/li>\n<\/ul>\n\n\n\n<p>\u2014-<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Partie C)<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Hashing de donn\u00e9es et encryptage de mots de passe&nbsp;\n<ul class=\"wp-block-list\">\n<li><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\">D\u00e9tails \u00e0 suivre &#8230;<\/mark><\/strong><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>HTTPS : Installation d&rsquo;un certificat sur le serveur Web, <\/li>\n\n\n\n<li>Paire de cl\u00e9s pour la connexion ssh&nbsp;<\/li>\n<\/ul>\n\n\n\n<p>\u2014-<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Partie D)<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Une application Web (full\/stack)<\/li>\n\n\n\n<li>Php\/Node.js, Laravel,  \u2026 framework \u00e0 votre choix<\/li>\n\n\n\n<li>Une page de login (user\/password)<\/li>\n\n\n\n<li>Une page d\u2019inscription (login, password, nom\/pr\u00e9nom, email)<\/li>\n\n\n\n<li>Une page de contenu (\u00e0 votre choix)<\/li>\n\n\n\n<li>Une page affichant les comptes utilisateurs avec mots de passe encrypt\u00e9s et en texte<\/li>\n\n\n\n<li>Utilisation de REST donne 5 points suppl\u00e9mentaires&nbsp;<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\">NOTE<\/mark><\/strong>: <a href=\"https:\/\/ve2cuy.com\/index.php\/2023\/10\/18\/420-5d3-carre-de-sable-du-projet\/\" data-type=\"post\" data-id=\"870\">Voir le carr\u00e9 de sable pour la marche \u00e0 suivre<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Version pr\u00e9liminaire du 2023.10.16 Ce projet d&rsquo;\u00e9valuations en plusieurs \u00e9tapes, permettra de mesurer la compr\u00e9hension des \u00e9l\u00e9ments suivants: NOTE: Ce qui est en MAUVE sera trait\u00e9 \u00e0 l&rsquo;\u00e9preuve synth\u00e8se Pond\u00e9ration Projet total : 40% NOTE: Les \u00e9tapes de remises seront pr\u00e9cis\u00e9es prochainement. Contexte de r\u00e9alisation Il faut: Partie A &#8211; Base de donn\u00e9es, notions interm\u00e9diaires [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-845","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/ve2cuy.com\/index.php\/wp-json\/wp\/v2\/pages\/845","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ve2cuy.com\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/ve2cuy.com\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/ve2cuy.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ve2cuy.com\/index.php\/wp-json\/wp\/v2\/comments?post=845"}],"version-history":[{"count":12,"href":"https:\/\/ve2cuy.com\/index.php\/wp-json\/wp\/v2\/pages\/845\/revisions"}],"predecessor-version":[{"id":1022,"href":"https:\/\/ve2cuy.com\/index.php\/wp-json\/wp\/v2\/pages\/845\/revisions\/1022"}],"wp:attachment":[{"href":"https:\/\/ve2cuy.com\/index.php\/wp-json\/wp\/v2\/media?parent=845"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}