{"id":91,"date":"2023-08-16T17:20:22","date_gmt":"2023-08-16T21:20:22","guid":{"rendered":"https:\/\/ve2cuy.com\/?page_id=91"},"modified":"2023-11-02T18:45:03","modified_gmt":"2023-11-02T22:45:03","slug":"420-5d3-documents","status":"publish","type":"page","link":"https:\/\/ve2cuy.com\/index.php\/420-5d3-documents\/","title":{"rendered":"420-5D3 : Les documents"},"content":{"rendered":"\n<h1 class=\"wp-block-heading\">S\u00e9curit\u00e9 des donn\u00e9es<\/h1>\n\n\n\n<h2 class=\"wp-block-heading has-text-align-center has-vivid-red-color has-text-color\">Version 2023.11.02<\/h2>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"626\" height=\"385\" src=\"https:\/\/ve2cuy.com\/wp-content\/uploads\/2023\/10\/police-man-with-handcuffs.png\" alt=\"\" class=\"wp-image-862\" style=\"aspect-ratio:1.625974025974026;width:571px;height:auto\" srcset=\"https:\/\/ve2cuy.com\/wp-content\/uploads\/2023\/10\/police-man-with-handcuffs.png 626w, https:\/\/ve2cuy.com\/wp-content\/uploads\/2023\/10\/police-man-with-handcuffs-300x185.png 300w\" sizes=\"auto, (max-width: 626px) 100vw, 626px\" \/><\/figure>\n<\/div>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<ol class=\"wp-block-list\">\n<li><a href=\"http:\/\/ve2cuy.com\/wp-content\/uploads\/2023\/11\/420-5D3-JR_ab_pc_A23.pdf\">Plan de cours<\/a><\/li>\n\n\n\n<li><a href=\"http:\/\/ve2cuy.com\/wp-content\/uploads\/2023\/11\/420-5D3-JR_ref_dt.pdf\">R\u00e9f\u00e9rentiel de cours<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/ve2cuy.com\/index.php\/420-5d3-evaluation-2023\/\" data-type=\"page\" data-id=\"972\">\u00c9valuations<\/a> \n\n\n\n\n\n\n\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/ve2cuy.com\/index.php\/420-5d3-owasp-et-la-securite-web\/\" data-type=\"page\" data-id=\"194\">Juice Shop<\/a> <strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\">20%<\/mark><\/strong><\/li>\n\n\n\n<li><a href=\"https:\/\/ve2cuy.com\/index.php\/420-5d3-projet-devaluations-2023\/\" data-type=\"page\" data-id=\"845\">Projet Oracle\/Incluant le cryptage des donn\u00e9es <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\"><strong>40%<\/strong><\/mark><\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/ve2cuy.com\/index.php\/2023\/10\/18\/420-5d3-carre-de-sable-du-projet\/\" data-type=\"post\" data-id=\"870\">Carr\u00e9 de sable du projet<\/a>\n<ul class=\"wp-block-list\">\n<li>D\u00e9ployer un SGBD Oracle dans le Cloud\n<ul class=\"wp-block-list\">\n<li>Ajout de vos comptes sous cstj.cloud.google.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Renseigner correctement les profils utilisateurs<\/li>\n\n\n\n<li>R\u00e9diger\/utiliser des fonctions<\/li>\n\n\n\n<li>R\u00e9diger\/utiliser des proc\u00e9dures stock\u00e9es: PL\/SQL<\/li>\n\n\n\n<li>Renseigner\/utiliser des d\u00e9clencheurs<\/li>\n\n\n\n<li>Utilisation de requ\u00eates SQL complexes<\/li>\n\n\n\n<li>Utiliser des librairies pour l&rsquo;encryptage et le hashage des donn\u00e9es<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Mise en place de certificats pour les liens HTTPS<\/li>\n\n\n\n<li>Utiliser des librairies (php: Oracle oci) pour l&rsquo;acc\u00e8s aux donn\u00e9es<\/li>\n\n\n\n<li>Effectuer des tests de s\u00e9curit\u00e9 (penetration test \/ pentest)<\/li>\n\n\n\n<li><strong>\u00c9preuve synth\u00e8se<\/strong> &#8211; Semaine 15 &#8211; examen th\u00e9orique &#8211; <strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\">40%<\/mark><\/strong>\n<ul class=\"wp-block-list\">\n<li>\u200b<strong><strong>\u200bObjets d\u2019\u00e9valuation <\/strong>&nbsp;<\/strong>: La capacit\u00e9 de l\u2019\u00e9tudiant \u00e0 expliquer les concepts de la s\u00e9curit\u00e9 des donn\u00e9es et \u00e0 d\u00e9terminer les contextes pertinents o\u00f9 les appliquer.&nbsp;<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"#\">Cryptage des donn\u00e9es<\/a>\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/ve2cuy.com\/index.php\/420-5d3-hachage-protection-des-mots-de-passe\/\" data-type=\"page\" data-id=\"269\">Hashage<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/ve2cuy.com\/index.php\/420-5d3-protection-des-mots-de-passe\/\" data-type=\"page\" data-id=\"658\">Protection des mots de passe<\/a>\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/wiki.php.net\/rfc\/argon2_password_hash\">argon2<\/a><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"https:\/\/fr.wikipedia.org\/wiki\/Cryptographie_sym%C3%A9trique\">Chiffrement sym\u00e9trique<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/fr.wikipedia.org\/wiki\/Cryptographie_asym%C3%A9trique\">Chiffrement asym\u00e9trique<\/a><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"https:\/\/www.kali.org\">Kali&nbsp;<em>Linux<\/em><\/a>\n<ul class=\"wp-block-list\">\n<li>Let&rsquo;s have fun \ud83d\ude09<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"https:\/\/doc.traefik.io\/traefik\/https\/acme\/\">Traefik Proxy et certificats<\/a> (contenu facultatif)<\/li>\n\n\n\n<li><a href=\"#\">Bases de donn\u00e9es &#8211; Notions interm\u00e9diaires<\/a>\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\">SGBD Oracle<\/a>, installation et premiers pas<\/li>\n\n\n\n<li><a href=\"https:\/\/ve2cuy.com\/index.php\/420-5d5-oracle-labo-example\/\" data-type=\"page\" data-id=\"783\">Labo Oracle.example<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/ve2cuy.com\/index.php\/404-2\/\" data-type=\"page\" data-id=\"651\">Cr\u00e9ation d&rsquo;un sch\u00e9ma complet pour la gestion d&rsquo;une collection de bandes dessin\u00e9es<\/a><a href=\"https:\/\/ve2cuy.com\/index.php\/420-5d4-sgbd-bandes-dessinees\/\" data-type=\"page\" data-id=\"620\">.<\/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\">Exemple d&rsquo;utilisation de php + Oracle<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/blogs.oracle.com\/database\/post\/json-relational-duality-app-dev\">JSON Relational Duality<\/a><\/li>\n\n\n\n<li><a href=\"#\">Fonctions<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/ve2cuy.com\/index.php\/420-5d3-bd-vues\/\" data-type=\"page\" data-id=\"680\">Vues<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/sql.sh\/cours\/create-trigger\">D\u00e9clencheurs<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/sql.sh\/cours\/procedure-stockee\">Proc\u00e9dures stock\u00e9es<\/a><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"#\">Sauvegarde des donn\u00e9es<\/a>\n<ul class=\"wp-block-list\">\n<li><a href=\"#\">Strat\u00e9gies de sauvegarde des volumes sous Docker\/K8S<\/a><\/li>\n\n\n\n<li><a href=\"#\">MariaDB\/MySQL, Oracle<\/a><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"https:\/\/en.wikipedia.org\/wiki\/ZFS\">Syst\u00e8me de fichiers r\u00e9silient: ZFS<\/a><\/li>\n\n\n\n<li><a href=\"#\">Failles de s\u00e9curit\u00e9<\/a>\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/ve2cuy.com\/index.php\/420-5d3-owasp-et-la-securite-web\/\" data-type=\"page\" data-id=\"194\">\u00c9tude de cas &#8211; OWASP Juice Shop<\/a>\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/ve2cuy.com\/index.php\/420-5d3-oswap-solution\/\" data-type=\"page\" data-id=\"225\">Solutions<\/a><\/li>\n\n\n\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/github.com\/moloch--\/RootTheBox\" target=\"_blank\">RootTheBox<\/a> &#8211; Pour les statistiques &#8211; <a href=\"https:\/\/pwning.owasp-juice.shop\/companion-guide\/latest\/part4\/ctf.html\">Guide d&rsquo;installation et de config<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.zaproxy.org\/getting-started\/\">zaproxy<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"#\"><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-purple-color\">Recherche et pr\u00e9sentation individuelle sur un sujet de s\u00e9curit\u00e9 des donn\u00e9es<\/mark><\/a> <\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>S\u00e9curit\u00e9 des donn\u00e9es Version 2023.11.02<\/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-91","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/ve2cuy.com\/index.php\/wp-json\/wp\/v2\/pages\/91","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=91"}],"version-history":[{"count":62,"href":"https:\/\/ve2cuy.com\/index.php\/wp-json\/wp\/v2\/pages\/91\/revisions"}],"predecessor-version":[{"id":1009,"href":"https:\/\/ve2cuy.com\/index.php\/wp-json\/wp\/v2\/pages\/91\/revisions\/1009"}],"wp:attachment":[{"href":"https:\/\/ve2cuy.com\/index.php\/wp-json\/wp\/v2\/media?parent=91"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}