{"id":300,"date":"2025-07-27T22:11:15","date_gmt":"2025-07-27T20:11:15","guid":{"rendered":"https:\/\/giulia-governatori.alwaysdata.net\/?post_type=projects&#038;p=300"},"modified":"2025-08-13T17:10:57","modified_gmt":"2025-08-13T15:10:57","slug":"sql-practice-housing-insurance","status":"publish","type":"projects","link":"https:\/\/giulia-governatori.alwaysdata.net\/fr\/projects\/sql-practice-housing-insurance\/","title":{"rendered":"Requ\u00eater une base de donn\u00e9es avec SQL"},"content":{"rendered":"<style>.kadence-column300_b99601-80 > .kt-inside-inner-col,.kadence-column300_b99601-80 > .kt-inside-inner-col:before{border-top-left-radius:0px;border-top-right-radius:0px;border-bottom-right-radius:0px;border-bottom-left-radius:0px;}.kadence-column300_b99601-80 > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column300_b99601-80 > .kt-inside-inner-col{flex-direction:column;}.kadence-column300_b99601-80 > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column300_b99601-80 > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column300_b99601-80{position:relative;}.kadence-column300_b99601-80, .kt-inside-inner-col > .kadence-column300_b99601-80:not(.specificity){margin-top:30px;margin-bottom:30px;}@media all and (max-width: 1024px){.kadence-column300_b99601-80 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}@media all and (max-width: 767px){.kadence-column300_b99601-80 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column300_b99601-80\"><div class=\"kt-inside-inner-col\"><style>.kb-row-layout-id300_8f5a5b-3a > .kt-row-column-wrap{align-content:start;}:where(.kb-row-layout-id300_8f5a5b-3a > .kt-row-column-wrap) > .wp-block-kadence-column{justify-content:start;}.kb-row-layout-id300_8f5a5b-3a > .kt-row-column-wrap{column-gap:var(--global-kb-gap-none, 0rem );row-gap:var(--global-kb-gap-none, 0rem );padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.kb-row-layout-id300_8f5a5b-3a > .kt-row-column-wrap > div:not(.added-for-specificity){grid-column:initial;}.kb-row-layout-id300_8f5a5b-3a > .kt-row-column-wrap{grid-template-columns:minmax(0, 1fr);}.kb-row-layout-id300_8f5a5b-3a > .kt-row-layout-overlay{opacity:0.30;}@media all and (max-width: 1024px){.kb-row-layout-id300_8f5a5b-3a > .kt-row-column-wrap > div:not(.added-for-specificity){grid-column:initial;}}@media all and (max-width: 1024px){.kb-row-layout-id300_8f5a5b-3a > .kt-row-column-wrap{grid-template-columns:minmax(0, 1fr);}}@media all and (max-width: 767px){.kb-row-layout-id300_8f5a5b-3a > .kt-row-column-wrap > div:not(.added-for-specificity){grid-column:initial;}.kb-row-layout-id300_8f5a5b-3a > .kt-row-column-wrap{grid-template-columns:minmax(0, 1fr);}}<\/style><div class=\"kb-row-layout-wrap kb-row-layout-id300_8f5a5b-3a alignnone wp-block-kadence-rowlayout\"><div class=\"kt-row-column-wrap kt-has-4-columns kt-row-layout-row kt-tab-layout-inherit kt-mobile-layout-row kt-row-valign-top\">\n<style>.kadence-column300_c3154c-27 > .kt-inside-inner-col,.kadence-column300_c3154c-27 > .kt-inside-inner-col:before{border-top-left-radius:0px;border-top-right-radius:0px;border-bottom-right-radius:0px;border-bottom-left-radius:0px;}.kadence-column300_c3154c-27 > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column300_c3154c-27 > .kt-inside-inner-col{flex-direction:column;}.kadence-column300_c3154c-27 > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column300_c3154c-27 > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column300_c3154c-27{position:relative;}@media all and (max-width: 1024px){.kadence-column300_c3154c-27 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}@media all and (max-width: 767px){.kadence-column300_c3154c-27 > .kt-inside-inner-col{display:flex;flex-direction:column;justify-content:center;align-items:flex-start;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column300_c3154c-27\"><div class=\"kt-inside-inner-col\"><style>.wp-block-kadence-advancedheading.kt-adv-heading300_ccdf79-68, .wp-block-kadence-advancedheading.kt-adv-heading300_ccdf79-68[data-kb-block=\"kb-adv-heading300_ccdf79-68\"]{font-size:var(--global-kb-font-size-sm, 0.9rem);font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading300_ccdf79-68 mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading300_ccdf79-68[data-kb-block=\"kb-adv-heading300_ccdf79-68\"] mark.kt-highlight{font-style:normal;color:#f76a0c;-webkit-box-decoration-break:clone;box-decoration-break:clone;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.wp-block-kadence-advancedheading.kt-adv-heading300_ccdf79-68 img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading300_ccdf79-68[data-kb-block=\"kb-adv-heading300_ccdf79-68\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading300_ccdf79-68 wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading300_ccdf79-68\">Assurance \u2013 ESN Data (Openclassroom)<\/p>\n<\/div><\/div>\n\n\n<style>.kadence-column300_b4938a-b8 > .kt-inside-inner-col{padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.kadence-column300_b4938a-b8 > .kt-inside-inner-col,.kadence-column300_b4938a-b8 > .kt-inside-inner-col:before{border-top-left-radius:0px;border-top-right-radius:0px;border-bottom-right-radius:0px;border-bottom-left-radius:0px;}.kadence-column300_b4938a-b8 > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column300_b4938a-b8 > .kt-inside-inner-col{flex-direction:column;}.kadence-column300_b4938a-b8 > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column300_b4938a-b8 > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column300_b4938a-b8{position:relative;}.kadence-column300_b4938a-b8, .kt-inside-inner-col > .kadence-column300_b4938a-b8:not(.specificity){margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;}@media all and (max-width: 1024px){.kadence-column300_b4938a-b8 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}@media all and (max-width: 767px){.kadence-column300_b4938a-b8 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column300_b4938a-b8\"><div class=\"kt-inside-inner-col\"><h1 style=\"padding-top:0px;padding-bottom:0px;padding-left:0px;padding-right:0px;margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;\" class=\"wp-block-post-title\">Requ\u00eater une base de donn\u00e9es avec SQL<\/h1><\/div><\/div>\n\n\n<style>.kadence-column300_74d848-07 > .kt-inside-inner-col{display:flex;}.kadence-column300_74d848-07 > .kt-inside-inner-col{padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.kadence-column300_74d848-07 > .kt-inside-inner-col,.kadence-column300_74d848-07 > .kt-inside-inner-col:before{border-top-left-radius:0px;border-top-right-radius:0px;border-bottom-right-radius:0px;border-bottom-left-radius:0px;}.kadence-column300_74d848-07 > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column300_74d848-07 > .kt-inside-inner-col{flex-direction:column;align-items:flex-start;}.kadence-column300_74d848-07 > .kt-inside-inner-col > .kb-image-is-ratio-size{align-self:stretch;}.kadence-column300_74d848-07 > .kt-inside-inner-col > .wp-block-kadence-advancedgallery{align-self:stretch;}.kadence-column300_74d848-07 > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column300_74d848-07 > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column300_74d848-07{position:relative;}@media all and (max-width: 1024px){.kadence-column300_74d848-07 > .kt-inside-inner-col{flex-direction:column;justify-content:center;align-items:flex-start;}}@media all and (max-width: 767px){.kadence-column300_74d848-07 > .kt-inside-inner-col{flex-direction:column;justify-content:center;align-items:flex-start;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column300_74d848-07\"><div class=\"kt-inside-inner-col\"><style>.kb-row-layout-wrap.wp-block-kadence-rowlayout.kb-row-layout-id300_79adf6-db{margin-top:0px;margin-bottom:0px;}.kb-row-layout-id300_79adf6-db > .kt-row-column-wrap{align-content:start;}:where(.kb-row-layout-id300_79adf6-db > .kt-row-column-wrap) > .wp-block-kadence-column{justify-content:start;}.kb-row-layout-id300_79adf6-db > .kt-row-column-wrap{column-gap:var(--global-kb-gap-none, 0rem );row-gap:var(--global-kb-gap-sm, 1rem);max-width:922px;margin-left:auto;margin-right:auto;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;grid-template-columns:minmax(0, calc(40% - ((var(--global-kb-gap-none, 0rem ) * 2 )\/3)))minmax(0, calc(20% - ((var(--global-kb-gap-none, 0rem ) * 2 )\/3)))minmax(0, calc(40% - ((var(--global-kb-gap-none, 0rem ) * 2 )\/3)));}.kb-row-layout-id300_79adf6-db > .kt-row-layout-overlay{opacity:0.30;}@media all and (max-width: 1024px){.kb-row-layout-id300_79adf6-db > .kt-row-column-wrap > div:not(.added-for-specificity){grid-column:initial;}}@media all and (max-width: 1024px){.kb-row-layout-id300_79adf6-db > .kt-row-column-wrap{grid-template-columns:repeat(3, minmax(0, 1fr));}}@media all and (max-width: 767px){.kb-row-layout-id300_79adf6-db > .kt-row-column-wrap{padding-bottom:1px;grid-template-columns:minmax(0, 1fr) minmax(0, 1fr) minmax(0, 2fr);}}<\/style><div class=\"kb-row-layout-wrap kb-row-layout-id300_79adf6-db alignnone wp-block-kadence-rowlayout\"><div class=\"kt-row-column-wrap kt-has-3-columns kt-row-layout-equal kt-tab-layout-inherit kt-mobile-layout-right-half kt-row-valign-top\">\n<style>.kadence-column300_aa6bc7-a5 > .kt-inside-inner-col{display:flex;}.kadence-column300_aa6bc7-a5 > .kt-inside-inner-col,.kadence-column300_aa6bc7-a5 > .kt-inside-inner-col:before{border-top-left-radius:0px;border-top-right-radius:0px;border-bottom-right-radius:0px;border-bottom-left-radius:0px;}.kadence-column300_aa6bc7-a5 > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column300_aa6bc7-a5 > .kt-inside-inner-col{flex-direction:column;align-items:flex-start;}.kadence-column300_aa6bc7-a5 > .kt-inside-inner-col > .kb-image-is-ratio-size{align-self:stretch;}.kadence-column300_aa6bc7-a5 > .kt-inside-inner-col > .wp-block-kadence-advancedgallery{align-self:stretch;}.kadence-column300_aa6bc7-a5 > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column300_aa6bc7-a5 > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column300_aa6bc7-a5{position:relative;}@media all and (max-width: 1024px){.kadence-column300_aa6bc7-a5 > .kt-inside-inner-col{flex-direction:column;justify-content:center;align-items:flex-start;}}@media all and (max-width: 767px){.kadence-column300_aa6bc7-a5 > .kt-inside-inner-col{flex-direction:column;justify-content:center;align-items:flex-start;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column300_aa6bc7-a5\"><div class=\"kt-inside-inner-col\"><style>.wp-block-kadence-advancedheading.kt-adv-heading300_99b9b9-45, .wp-block-kadence-advancedheading.kt-adv-heading300_99b9b9-45[data-kb-block=\"kb-adv-heading300_99b9b9-45\"]{padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;font-size:var(--global-kb-font-size-sm, 0.9rem);font-style:normal;color:#ff275d;}.wp-block-kadence-advancedheading.kt-adv-heading300_99b9b9-45 mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading300_99b9b9-45[data-kb-block=\"kb-adv-heading300_99b9b9-45\"] mark.kt-highlight{font-style:normal;color:#f76a0c;-webkit-box-decoration-break:clone;box-decoration-break:clone;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.wp-block-kadence-advancedheading.kt-adv-heading300_99b9b9-45 img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading300_99b9b9-45[data-kb-block=\"kb-adv-heading300_99b9b9-45\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading300_99b9b9-45 wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading300_99b9b9-45\">Fictif<\/p>\n<\/div><\/div>\n\n\n<style>.kadence-column300_221ae1-46 > .kt-inside-inner-col,.kadence-column300_221ae1-46 > .kt-inside-inner-col:before{border-top-left-radius:0px;border-top-right-radius:0px;border-bottom-right-radius:0px;border-bottom-left-radius:0px;}.kadence-column300_221ae1-46 > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column300_221ae1-46 > .kt-inside-inner-col{flex-direction:column;}.kadence-column300_221ae1-46 > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column300_221ae1-46 > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column300_221ae1-46{position:relative;}@media all and (max-width: 1024px){.kadence-column300_221ae1-46 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}@media all and (max-width: 767px){.kadence-column300_221ae1-46 > .kt-inside-inner-col{display:flex;flex-direction:column;justify-content:center;align-items:center;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column300_221ae1-46\"><div class=\"kt-inside-inner-col\"><style>.wp-block-kadence-advancedheading.kt-adv-heading300_f7572a-2d, .wp-block-kadence-advancedheading.kt-adv-heading300_f7572a-2d[data-kb-block=\"kb-adv-heading300_f7572a-2d\"]{font-size:var(--global-kb-font-size-sm, 0.9rem);font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading300_f7572a-2d mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading300_f7572a-2d[data-kb-block=\"kb-adv-heading300_f7572a-2d\"] mark.kt-highlight{font-style:normal;color:#f76a0c;-webkit-box-decoration-break:clone;box-decoration-break:clone;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.wp-block-kadence-advancedheading.kt-adv-heading300_f7572a-2d img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading300_f7572a-2d[data-kb-block=\"kb-adv-heading300_f7572a-2d\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading300_f7572a-2d wp-block-kadence-advancedheading\" data-kb-block=\"kb-adv-heading300_f7572a-2d\">|<\/p>\n<\/div><\/div>\n\n\n<style>.kadence-column300_175857-a2 > .kt-inside-inner-col,.kadence-column300_175857-a2 > .kt-inside-inner-col:before{border-top-left-radius:0px;border-top-right-radius:0px;border-bottom-right-radius:0px;border-bottom-left-radius:0px;}.kadence-column300_175857-a2 > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column300_175857-a2 > .kt-inside-inner-col{flex-direction:column;}.kadence-column300_175857-a2 > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column300_175857-a2 > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column300_175857-a2{position:relative;}@media all and (max-width: 1024px){.kadence-column300_175857-a2 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}@media all and (max-width: 767px){.kadence-column300_175857-a2 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column300_175857-a2\"><div class=\"kt-inside-inner-col\"><style>.wp-block-kadence-advancedheading.kt-adv-heading300_c1c655-d5, .wp-block-kadence-advancedheading.kt-adv-heading300_c1c655-d5[data-kb-block=\"kb-adv-heading300_c1c655-d5\"]{text-align:left;font-size:var(--global-kb-font-size-sm, 0.9rem);font-style:normal;}.wp-block-kadence-advancedheading.kt-adv-heading300_c1c655-d5 mark.kt-highlight, .wp-block-kadence-advancedheading.kt-adv-heading300_c1c655-d5[data-kb-block=\"kb-adv-heading300_c1c655-d5\"] mark.kt-highlight{font-style:normal;color:#f76a0c;-webkit-box-decoration-break:clone;box-decoration-break:clone;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.wp-block-kadence-advancedheading.kt-adv-heading300_c1c655-d5 img.kb-inline-image, .wp-block-kadence-advancedheading.kt-adv-heading300_c1c655-d5[data-kb-block=\"kb-adv-heading300_c1c655-d5\"] img.kb-inline-image{width:150px;vertical-align:baseline;}<\/style>\n<p class=\"kt-adv-heading300_c1c655-d5 project-dates wp-block-kadence-advancedheading has-theme-palette-5-color has-text-color\" data-kb-block=\"kb-adv-heading300_c1c655-d5\">14\/12\/2024 &gt; 30\/12\/2024<\/p>\n<\/div><\/div>\n\n<\/div><\/div><\/div><\/div>\n\n\n<style>.kadence-column300_d35884-7a > .kt-inside-inner-col,.kadence-column300_d35884-7a > .kt-inside-inner-col:before{border-top-left-radius:0px;border-top-right-radius:0px;border-bottom-right-radius:0px;border-bottom-left-radius:0px;}.kadence-column300_d35884-7a > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column300_d35884-7a > .kt-inside-inner-col{flex-direction:column;}.kadence-column300_d35884-7a > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column300_d35884-7a > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column300_d35884-7a{position:relative;}@media all and (max-width: 1024px){.kadence-column300_d35884-7a > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}@media all and (max-width: 767px){.kadence-column300_d35884-7a > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column300_d35884-7a\"><div class=\"kt-inside-inner-col\">\n<hr class=\"wp-block-separator aligncenter has-text-color has-theme-palette-4-color has-alpha-channel-opacity has-theme-palette-4-background-color has-background is-style-wide\" style=\"margin-top:20px\"\/>\n<\/div><\/div>\n\n<\/div><\/div><\/div><\/div>\n\n\n<style>.kadence-column300_f917ab-60 > .kt-inside-inner-col{display:flex;}.kadence-column300_f917ab-60 > .kt-inside-inner-col,.kadence-column300_f917ab-60 > .kt-inside-inner-col:before{border-top-left-radius:0px;border-top-right-radius:0px;border-bottom-right-radius:0px;border-bottom-left-radius:0px;}.kadence-column300_f917ab-60 > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column300_f917ab-60 > .kt-inside-inner-col{flex-direction:column;justify-content:center;align-items:center;}.kadence-column300_f917ab-60 > .kt-inside-inner-col > .kb-image-is-ratio-size{align-self:stretch;}.kadence-column300_f917ab-60 > .kt-inside-inner-col > .wp-block-kadence-advancedgallery{align-self:stretch;}.kadence-column300_f917ab-60 > .kt-inside-inner-col > .aligncenter{width:100%;}.kt-row-column-wrap > .kadence-column300_f917ab-60{align-self:center;}.kt-inner-column-height-full:not(.kt-has-1-columns) > .wp-block-kadence-column.kadence-column300_f917ab-60{align-self:auto;}.kt-inner-column-height-full:not(.kt-has-1-columns) > .wp-block-kadence-column.kadence-column300_f917ab-60 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}.kadence-column300_f917ab-60 > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column300_f917ab-60{position:relative;}.kadence-column300_f917ab-60, .kt-inside-inner-col > .kadence-column300_f917ab-60:not(.specificity){margin-top:30px;margin-bottom:0px;}@media all and (max-width: 1024px){.kt-row-column-wrap > .kadence-column300_f917ab-60{align-self:center;}}@media all and (max-width: 1024px){.kt-inner-column-height-full:not(.kt-has-1-columns) > .wp-block-kadence-column.kadence-column300_f917ab-60{align-self:auto;}}@media all and (max-width: 1024px){.kt-inner-column-height-full:not(.kt-has-1-columns) > .wp-block-kadence-column.kadence-column300_f917ab-60 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}@media all and (max-width: 1024px){.kadence-column300_f917ab-60 > .kt-inside-inner-col{flex-direction:column;justify-content:center;align-items:center;}}@media all and (max-width: 767px){.kt-row-column-wrap > .kadence-column300_f917ab-60{align-self:center;}.kt-inner-column-height-full:not(.kt-has-1-columns) > .wp-block-kadence-column.kadence-column300_f917ab-60{align-self:auto;}.kt-inner-column-height-full:not(.kt-has-1-columns) > .wp-block-kadence-column.kadence-column300_f917ab-60 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}.kadence-column300_f917ab-60 > .kt-inside-inner-col{flex-direction:column;justify-content:center;align-items:center;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column300_f917ab-60\"><div class=\"kt-inside-inner-col\"><style>.kb-row-layout-id300_27a39d-82 > .kt-row-column-wrap{align-content:start;}:where(.kb-row-layout-id300_27a39d-82 > .kt-row-column-wrap) > .wp-block-kadence-column{justify-content:start;}.kb-row-layout-id300_27a39d-82 > .kt-row-column-wrap{column-gap:var(--global-kb-gap-md, 2rem);row-gap:var(--global-kb-gap-sm, 1rem);padding-top:10px;padding-bottom:24px;grid-template-columns:minmax(0, 2fr) minmax(0, 1fr);}.kb-row-layout-id300_27a39d-82 > .kt-row-layout-overlay{opacity:0.30;}@media all and (max-width: 1024px){.kb-row-layout-id300_27a39d-82 > .kt-row-column-wrap{grid-template-columns:minmax(0, 2fr) minmax(0, 1fr);}}@media all and (max-width: 767px){.kb-row-layout-id300_27a39d-82 > .kt-row-column-wrap{grid-template-columns:minmax(0, 1fr);}}<\/style><div class=\"kb-row-layout-wrap kb-row-layout-id300_27a39d-82 alignnone wp-block-kadence-rowlayout\"><div class=\"kt-row-column-wrap kt-has-2-columns kt-row-layout-left-golden kt-tab-layout-inherit kt-mobile-layout-row kt-row-valign-top\">\n<style>.kadence-column300_d8b063-d2 > .kt-inside-inner-col,.kadence-column300_d8b063-d2 > .kt-inside-inner-col:before{border-top-left-radius:0px;border-top-right-radius:0px;border-bottom-right-radius:0px;border-bottom-left-radius:0px;}.kadence-column300_d8b063-d2 > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column300_d8b063-d2 > .kt-inside-inner-col{flex-direction:column;}.kadence-column300_d8b063-d2 > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column300_d8b063-d2 > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column300_d8b063-d2{position:relative;}@media all and (max-width: 1024px){.kadence-column300_d8b063-d2 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}@media all and (max-width: 767px){.kadence-column300_d8b063-d2 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column300_d8b063-d2\"><div class=\"kt-inside-inner-col\"><style>.kb-gallery-id-300_1dcf5a-46.kb-gallery-ul.kb-gallery-type-fluidcarousel .kt-blocks-carousel figure .kb-gal-image-radius, .kb-gallery-id-300_1dcf5a-46.kb-gallery-ul.kb-gallery-type-fluidcarousel .kt-blocks-carousel figure .kb-gal-image-radius img{height:350px;}.kb-gallery-id-300_1dcf5a-46 .kadence-blocks-gallery-item .kb-gal-image-radius, .kb-gallery-id-300_1dcf5a-46 .kb-slide-item .kb-gal-image-radius img{border-radius:0px 0px 0px 0px;;}.kb-gallery-wrap-id-300_1dcf5a-46.wp-block-kadence-advancedgallery{overflow:visible;}.kb-gallery-wrap-id-300_1dcf5a-46.wp-block-kadence-advancedgallery .kt-blocks-carousel{overflow:visible;max-width:100%;}.kb-gallery-id-300_1dcf5a-46 .splide.kt-carousel-dotstyle-outlinelight .splide__pagination__page{background-color:transparent;box-shadow:inset 0 0 0 1px #fff;-webkit-transition:box-shadow 0.3s ease;-moz-transition:box-shadow 0.3s ease;transition:box-shadow 0.3s ease;}.kb-gallery-id-300_1dcf5a-46 .splide.kt-carousel-dotstyle-outlinelight .splide__pagination__page.is-active{background-color:transparent;box-shadow:inset 0 0 0 8px #fff;}<\/style><div class=\"kb-gallery-wrap-id-300_1dcf5a-46 alignnone wp-block-kadence-advancedgallery\"><div class=\"kb-gallery-ul kb-gallery-non-static kb-gallery-type-fluidcarousel kb-gallery-id-300_1dcf5a-46 kb-gallery-caption-style-bottom-hover kb-gallery-filter-none kb-gallery-magnific-init\" data-image-filter=\"none\" data-lightbox-caption=\"true\"><div class=\"kt-blocks-carousel splide kt-carousel-container-dotstyle-outlinelight kt-carousel-arrowstyle-blackonlight kt-carousel-dotstyle-outlinelight kb-slider-group-arrow kb-slider-arrow-position-center\" data-slider-anim-speed=\"1500\" data-slider-scroll=\"1\" data-slider-arrows=\"true\" data-slider-dots=\"true\" data-slider-hover-pause=\"false\" data-slider-auto=\"1\" data-slider-speed=\"3000\" data-slider-type=\"fluidcarousel\" data-slider-center-mode=\"true\" data-slider-gap=\"10px\" data-slider-gap-tablet=\"10px\" data-slider-gap-mobile=\"10px\" data-show-pause-button=\"false\"><div class=\"splide__track\"><ul class=\"kt-blocks-carousel-init kb-blocks-fluid-carousel splide__list\"><li class=\"kb-slide-item kb-gallery-carousel-item splide__slide\"><div class=\"kadence-blocks-gallery-item\"><div class=\"kadence-blocks-gallery-item-inner\"><figure class=\"kb-gallery-figure kb-gallery-item-has-link kadence-blocks-gallery-item-hide-caption\"><a href=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P3_0.webp\" class=\"kb-gallery-item-link\"  ><div class=\"kb-gal-image-radius\"><div class=\"kb-gallery-image-contain\" ><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P3_0.webp\" width=\"1334\" height=\"753\" alt=\"\" data-full-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P3_0.webp\" data-light-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P3_0.webp\" data-id=\"861\" class=\"wp-image-861 skip-lazy\" srcset=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P3_0.webp 1334w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P3_0-600x339.webp 600w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P3_0-150x85.webp 150w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P3_0-768x434.webp 768w\" sizes=\"auto, (max-width: 1334px) 100vw, 1334px\" \/><\/div><\/div><\/a><\/figure><\/div><\/div><\/li><li class=\"kb-slide-item kb-gallery-carousel-item splide__slide\"><div class=\"kadence-blocks-gallery-item\"><div class=\"kadence-blocks-gallery-item-inner\"><figure class=\"kb-gallery-figure kb-gallery-item-has-link kadence-blocks-gallery-item-hide-caption\"><a href=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P3_1.webp\" class=\"kb-gallery-item-link\"  ><div class=\"kb-gal-image-radius\"><div class=\"kb-gallery-image-contain\" ><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P3_1.webp\" width=\"1331\" height=\"759\" alt=\"\" data-full-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P3_1.webp\" data-light-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P3_1.webp\" data-id=\"862\" class=\"wp-image-862 skip-lazy\" srcset=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P3_1.webp 1331w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P3_1-600x342.webp 600w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P3_1-150x86.webp 150w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P3_1-768x438.webp 768w\" sizes=\"auto, (max-width: 1331px) 100vw, 1331px\" \/><\/div><\/div><\/a><\/figure><\/div><\/div><\/li><li class=\"kb-slide-item kb-gallery-carousel-item splide__slide\"><div class=\"kadence-blocks-gallery-item\"><div class=\"kadence-blocks-gallery-item-inner\"><figure class=\"kb-gallery-figure kb-gallery-item-has-link kadence-blocks-gallery-item-hide-caption\"><a href=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P3_2.webp\" class=\"kb-gallery-item-link\"  ><div class=\"kb-gal-image-radius\"><div class=\"kb-gallery-image-contain\" ><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P3_2.webp\" width=\"1334\" height=\"753\" alt=\"\" data-full-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P3_2.webp\" data-light-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P3_2.webp\" data-id=\"863\" class=\"wp-image-863 skip-lazy\" srcset=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P3_2.webp 1334w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P3_2-600x339.webp 600w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P3_2-150x85.webp 150w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P3_2-768x434.webp 768w\" sizes=\"auto, (max-width: 1334px) 100vw, 1334px\" \/><\/div><\/div><\/a><\/figure><\/div><\/div><\/li><li class=\"kb-slide-item kb-gallery-carousel-item splide__slide\"><div class=\"kadence-blocks-gallery-item\"><div class=\"kadence-blocks-gallery-item-inner\"><figure class=\"kb-gallery-figure kb-gallery-item-has-link kadence-blocks-gallery-item-hide-caption\"><a href=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P3_3.webp\" class=\"kb-gallery-item-link\"  ><div class=\"kb-gal-image-radius\"><div class=\"kb-gallery-image-contain\" ><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P3_3.webp\" width=\"1334\" height=\"753\" alt=\"\" data-full-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P3_3.webp\" data-light-image=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P3_3.webp\" data-id=\"864\" class=\"wp-image-864 skip-lazy\" srcset=\"https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P3_3.webp 1334w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P3_3-600x339.webp 600w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P3_3-150x85.webp 150w, https:\/\/giulia-governatori.alwaysdata.net\/wp-content\/uploads\/P3_3-768x434.webp 768w\" sizes=\"auto, (max-width: 1334px) 100vw, 1334px\" \/><\/div><\/div><\/a><\/figure><\/div><\/div><\/li><\/ul><\/div><\/div><\/div><\/div><\/div><\/div>\n\n\n<style>.kadence-column300_eddda8-13 > .kt-inside-inner-col,.kadence-column300_eddda8-13 > .kt-inside-inner-col:before{border-top-left-radius:0px;border-top-right-radius:0px;border-bottom-right-radius:0px;border-bottom-left-radius:0px;}.kadence-column300_eddda8-13 > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column300_eddda8-13 > .kt-inside-inner-col{flex-direction:column;}.kadence-column300_eddda8-13 > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column300_eddda8-13 > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column300_eddda8-13{position:relative;}@media all and (max-width: 1024px){.kadence-column300_eddda8-13 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}@media all and (max-width: 767px){.kadence-column300_eddda8-13 > .kt-inside-inner-col{flex-direction:column;justify-content:center;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column300_eddda8-13\"><div class=\"kt-inside-inner-col\"><style>.kb-table-of-content-nav.kb-table-of-content-id300_9703ca-c8 .kb-table-of-content-wrap{padding-top:40px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.kb-table-of-content-nav.kb-table-of-content-id300_9703ca-c8 .kb-table-of-contents-title-wrap{padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.kb-table-of-content-nav.kb-table-of-content-id300_9703ca-c8 .kb-table-of-contents-title-wrap{color:#9b9958;}.kb-table-of-content-nav.kb-table-of-content-id300_9703ca-c8 .kb-table-of-contents-title{color:#9b9958;font-size:35px;line-height:5px;font-family:'Crimson Text';font-weight:400;font-style:normal;}.kb-table-of-content-nav.kb-table-of-content-id300_9703ca-c8 .kb-table-of-content-wrap .kb-table-of-content-list{color:#cef8a9;font-size:22px;font-style:normal;margin-top:var(--global-kb-spacing-sm, 1.5rem);margin-right:0px;margin-bottom:0px;margin-left:0px;}.kb-table-of-content-nav.kb-table-of-content-id300_9703ca-c8 .kb-table-of-content-wrap .kb-table-of-content-list .kb-table-of-contents__entry:hover{color:var(--global-palette2, #2B6CB0);}<\/style><\/div><\/div>\n\n<\/div><\/div><\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Contexte<\/strong><\/h2>\n\n\n\n<p>J\u2019ai r\u00e9alis\u00e9 ce projet pour ESN\u202fData (fictif), dans le cadre de ma formation de Business\u202fIntelligence Analyst. L\u2019objectif \u00e9tait de cr\u00e9er et g\u00e9rer une base de donn\u00e9es relationnelle afin d\u2019analyser le march\u00e9 des assurances habitation en France. J\u2019ai aid\u00e9 une entreprise d\u2019assurance fictive \u00e0 structurer ses donn\u00e9es, charger un jeu de contrats et un r\u00e9f\u00e9rentiel g\u00e9ographique, puis \u00e0 r\u00e9diger des requ\u00eates SQL pour en extraire des indicateurs cl\u00e9s.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Datasets<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"translation-block\">CONTRAT.CSV\u202f\u2013 30\u202f335\u202fcontrats d\u2019assurance habitation (11\u202fattributs)<\/li>\n\n\n\n<li class=\"translation-block\">REGION.CSV\u202f\u2013 38\u202f916\u202fpaires d\u00e9partement\u2011commune (7\u202fattributs)<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Workflow<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Exploration et dictionnaire des donn\u00e9es dans Excel (types, contraintes, descriptions).<\/li>\n\n\n\n<li>Mod\u00e9lisation UML puis sch\u00e9ma relationnel via SQL Power\u202fArchitect.<\/li>\n\n\n\n<li>Import des CSV dans MySQL (nettoyage d\u2019incoh\u00e9rences via VLOOKUP).<\/li>\n\n\n\n<li>R\u00e9daction de 12\u202frequ\u00eates SQL (SELECT, JOIN, agr\u00e9gations, ORDER\u202fBY, fonctions AVG\/COUNT).<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Insights<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>5\u202fcontrats avec les plus grandes surfaces\u202f: entre 559\u202fm\u00b2 et 815\u202fm\u00b2.<\/li>\n\n\n\n<li>Cotisation mensuelle moyenne\u202f: 19\u202f\u20ac par mois.<\/li>\n\n\n\n<li>R\u00e9partition des valeurs d\u00e9clar\u00e9es\u202f: majorit\u00e9 \u202f100\u202f000\u202f\u20ac.<\/li>\n\n\n\n<li>Formules \u201cIntegral\u201d en Pays\u202fde\u202fla\u202fLoire\u202f: 589\u202foccurrences.<\/li>\n\n\n\n<li>Maisons dans le d\u00e9partement\u202f71\u202f: 48\u202fcontrats, \u00e9quitablement r\u00e9partis entre formules classique et int\u00e9grale.<\/li>\n\n\n\n<li>Surface moyenne \u00e0 Paris\u202f: 52\u202fm\u00b2.<\/li>\n\n\n\n<li>Top\u202f10\u202fd\u00e9partements par cotisation moyenne\u202f: Paris (36\u202f\u20ac), Hauts\u2011de\u2011Seine (26\u202f\u20ac), Val\u2011de\u2011Marne (20\u202f\u20ac), etc.<\/li>\n\n\n\n<li>Commune la plus couverte\u202f: Paris.<\/li>\n\n\n\n<li>R\u00e9gion la plus active\u202f: \u00cele\u2011de\u2011France (14\u202f177\u202fcontrats).<\/li>\n<\/ul>\n\n\n\n<p>Ces r\u00e9sultats mettent en \u00e9vidence la forte concentration des contrats en \u00cele\u2011de\u2011France, les \u00e9carts de cotisation selon les zones g\u00e9ographiques et le profil des biens assur\u00e9s.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Business Impact<\/strong><\/h2>\n\n\n\n<p>Gr\u00e2ce \u00e0 ce projet, j\u2019ai d\u00e9velopp\u00e9 une ma\u00eetrise op\u00e9rationnelle de la conception de base de donn\u00e9es et du requ\u00eatage SQL, comp\u00e9tences essentielles pour un BI\u202fAnalyst. Les insights obtenus peuvent \u00eatre exploit\u00e9s par l\u2019assureur pour  :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Prioriser des offres adapt\u00e9es aux zones \u00e0 forte cotisation (ex. Paris).<\/li>\n\n\n\n<li>Ajuster les formules selon la r\u00e9partition des valeurs d\u00e9clar\u00e9es.<\/li>\n\n\n\n<li>Cibler des campagnes de prospection sur les communes sous\u2011couvertes.<\/li>\n<\/ul>\n\n\n\n<p>En interne, ces livrables (sch\u00e9ma, code SQL, captures d\u2019\u00e9cran) serviront de r\u00e9f\u00e9rence pour des analyses futures et faciliteront la prise de d\u00e9cision business.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Links<\/strong><\/h2>\n\n\n\n<p><a href=\"https:\/\/giulia-governatori.alwaysdata.net\/doc\/projects\/P3\/Governatori_Giulia_1_document_technique_122024.pdf\" data-type=\"link\" data-id=\"https:\/\/giulia-governatori.alwaysdata.net\/doc\/projects\/P3\/Governatori_Giulia_1_document_technique_122024.pdf\" target=\"_blank\" rel=\"noreferrer noopener\">Document technique<\/a><\/p>\n\n\n\n<p><a href=\"https:\/\/giulia-governatori.alwaysdata.net\/doc\/projects\/P3\/Governatori_Giulia_2_liste_122024.pdf\" data-type=\"link\" data-id=\"https:\/\/giulia-governatori.alwaysdata.net\/doc\/projects\/P3\/Governatori_Giulia_2_liste_122024.pdf\" target=\"_blank\" rel=\"noreferrer noopener\">Liste des analyses<\/a><\/p>\n\n\n\n<p><a href=\"https:\/\/giulia-governatori.alwaysdata.net\/doc\/projects\/P3\/Governatori_Giulia_3_methodologie_122024.pdf\" data-type=\"link\" data-id=\"https:\/\/giulia-governatori.alwaysdata.net\/doc\/projects\/P3\/Governatori_Giulia_3_methodologie_122024.pdf\" target=\"_blank\" rel=\"noreferrer noopener\">M\u00e9thodologie<\/a><\/p>\n\n\n<style>.kadence-column311_6aa044-75 > .kt-inside-inner-col{display:flex;}.kadence-column311_6aa044-75{max-width:1140px;margin-left:auto;margin-right:auto;}.wp-block-kadence-column.kb-section-dir-horizontal:not(.kb-section-md-dir-vertical)>.kt-inside-inner-col>.kadence-column311_6aa044-75{-webkit-flex:0 1 1140px;flex:0 1 1140px;max-width:unset;margin-left:unset;margin-right:unset;}.kadence-column311_6aa044-75 > .kt-inside-inner-col,.kadence-column311_6aa044-75 > .kt-inside-inner-col:before{border-top-left-radius:0px;border-top-right-radius:0px;border-bottom-right-radius:0px;border-bottom-left-radius:0px;}.kadence-column311_6aa044-75 > .kt-inside-inner-col{column-gap:var(--global-kb-gap-sm, 1rem);}.kadence-column311_6aa044-75 > .kt-inside-inner-col{flex-direction:column;align-items:center;}.kadence-column311_6aa044-75 > .kt-inside-inner-col > .kb-image-is-ratio-size{align-self:stretch;}.kadence-column311_6aa044-75 > .kt-inside-inner-col > .wp-block-kadence-advancedgallery{align-self:stretch;}.kadence-column311_6aa044-75 > .kt-inside-inner-col > .aligncenter{width:100%;}.kadence-column311_6aa044-75 > .kt-inside-inner-col:before{opacity:0.3;}.kadence-column311_6aa044-75{position:relative;}@media all and (min-width: 1025px){.wp-block-kadence-column.kb-section-dir-horizontal>.kt-inside-inner-col>.kadence-column311_6aa044-75{-webkit-flex:0 1 1140px;flex:0 1 1140px;max-width:unset;margin-left:unset;margin-right:unset;}}@media all and (max-width: 1024px){.kadence-column311_6aa044-75 > .kt-inside-inner-col{flex-direction:column;justify-content:center;align-items:center;}}@media all and (max-width: 767px){.wp-block-kadence-column.kb-section-sm-dir-vertical:not(.kb-section-sm-dir-horizontal):not(.kb-section-sm-dir-specificity)>.kt-inside-inner-col>.kadence-column311_6aa044-75{max-width:1140px;-webkit-flex:1;flex:1;margin-left:auto;margin-right:auto;}.kadence-column311_6aa044-75 > .kt-inside-inner-col{flex-direction:column;justify-content:center;align-items:center;}}<\/style>\n<div class=\"wp-block-kadence-column kadence-column311_6aa044-75\"><div class=\"kt-inside-inner-col\">\n<style>\n  .project-select-wrapper {\n    display: flex;\n    align-items: center;\n    gap: 0.5rem;\n    font-family: 'Roboto Mono', monospace;\n    position: relative;\n  }\n\n  .project-select-wrapper label {\n    font-weight: 600;\n    margin: 0;\n    white-space: nowrap; \/* Ne passe pas \u00e0 la ligne *\/\n  }\n\n  .custom-select {\n    font-family: 'Roboto Mono', monospace;\n    font-size: 1rem;\n    font-weight: 700;\n    padding: 0.5rem 0.8rem;\n    border: 1px solid #fff;\n    border-radius: 6px;\n    background: transparent;\n    color: #fff;\n    cursor: pointer;\n    min-width: 90px; \/* juste suffisant pour le texte \"Select\" *\/\n  }\n.custom-select:focus,\n.custom-select:active,\n.custom-select:hover {\n    border: 1px solid #FF678D!important;\n    background: transparent!important;\n    color: #FF678D!important;\n}\n\n  .dropdown-menu {\n    margin-bottom: 5px;\n    position: absolute;\n    bottom: 100%;\n    left: 0;\n    background: #9b9958;\n    border-radius: 6px;\n    display: none;\n    flex-direction: column;\n    z-index: 100;\n    white-space: nowrap;\n  }\n\n  .dropdown-menu a {\n    display: block;\n    padding: 0.5rem 0.8rem;\n    color: #7D0202;\n    text-decoration: none;\n  }\n\n  .dropdown-menu a:hover {\n    background: #7D0202;\n    color: #fff;\n  }\n\n  .project-select-wrapper.open .dropdown-menu {\n    display: flex;\n  }\n<\/style>\n\n<div class=\"project-select-wrapper\">\n  <label for=\"project-toggle\">Voir les autres projets<\/label>\n  <button id=\"project-toggle\" class=\"custom-select\" type=\"button\">S\u00e9lectionner<\/button>\n  <div class=\"dropdown-menu\">\n    <a href=\"\/fr\/projects\/real%E2%80%91estate-price-prediction\/\">Analyser l\u2019\u00e9volution des prix \u2028de l\u2019immobilier avec Python<\/a>\n    <a href=\"\/fr\/projects\/market-segmentation-aaa-strategy-uoi-games\/\">Segmentation du march\u00e9 et strat\u00e9gie AAA<\/a>\n    <a href=\"\/fr\/projects\/portfolio-creation-documentation\/\">Cr\u00e9er mon portfolio de professionnel de la data<\/a>\n    <a href=\"\/fr\/projects\/the-hidden-realities-of-animation-in-france\/\">Sondage personnel : les r\u00e9alit\u00e9s cach\u00e9es de l'animation en France<\/a>\n    <a href=\"\/fr\/projects\/power-bi-project-dashboard-sanitoral\/\">Cr\u00e9er un tableau de bord dynamique avec PowerBI<\/a>\n    <a href=\"\/fr\/projects\/stock-management-data-cleaning-bottleneck\/\">Optimiser la gestion &amp; nettoyez les donn\u00e9es \u2028du stock d'une boutique<\/a>\n    <a href=\"\/fr\/projects\/sales-dashboard-recs-bottleneck\/\">Am\u00e9liorez les performances de l'entreprise<\/a>\n    <a href=\"\/fr\/projects\/customer-satisfaction-tracking-bestmarket\/\">Manipuler une base de donn\u00e9es avec SQL pour suivre la satisfaction client<\/a>\n    <a href=\"\/fr\/projects\/gdpr%E2%80%91compliant-data-collection\/\">Collecter des donn\u00e9es \u2028en respectant les normes RGPD<\/a>\n    <a href=\"\/fr\/projects\/analyze-customer-churn\/\">Visualiser des donn\u00e9es avec Excel<\/a>\n    <a href=\"\/fr\/projects\/sql-practice-housing-insurance\/\">Requ\u00eater une base de donn\u00e9es avec SQL<\/a>\n    <a href=\"\/fr\/projects\/analysis-of-my-business-intelligence-analyst-training\/\">Analyse de ma formation de Business Intelligence Analyst<\/a>\n  <\/div>\n<\/div>\n\n<script>\n  const toggle = document.getElementById('project-toggle');\n  const wrapper = document.querySelector('.project-select-wrapper');\n\n  toggle.addEventListener('click', () => {\n    wrapper.classList.toggle('open');\n  });\n\n  document.addEventListener('click', (e) => {\n    if (!wrapper.contains(e.target)) {\n      wrapper.classList.remove('open');\n    }\n  });\n\n  document.querySelectorAll('.dropdown-menu a').forEach(link => {\n    link.addEventListener('click', () => {\n      window.location.href = link.href;\n    });\n  });\n<\/script>\n\n<\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>Insurance &#8211; ESN Data (Openclassroom) Fictional | 14\/12\/2024 &gt; 30\/12\/2024 Context I completed this project for ESN\u202fData (fictional) as part of my Business\u202fIntelligence Analyst training. The goal was to create and manage a relational database to analyze the French housing insurance market. I helped a fictional insurance company structure its data, load a dataset of&#8230;<\/p>","protected":false},"featured_media":284,"menu_order":11,"template":"","meta":{"_kad_post_transparent":"","_kad_post_title":"hide","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":""},"categories":[8,35,4,34,5,6,23,33,26,9],"class_list":["post-300","projects","type-projects","status-publish","has-post-thumbnail","hentry","category-data-cleaning","category-data-gouvernance","category-data-methods","category-data-modeling","category-data-tools","category-languages","category-mysql-workbench","category-sql","category-sqlite","category-statistical-analysis"],"_links":{"self":[{"href":"https:\/\/giulia-governatori.alwaysdata.net\/fr\/wp-json\/wp\/v2\/projects\/300","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/giulia-governatori.alwaysdata.net\/fr\/wp-json\/wp\/v2\/projects"}],"about":[{"href":"https:\/\/giulia-governatori.alwaysdata.net\/fr\/wp-json\/wp\/v2\/types\/projects"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/giulia-governatori.alwaysdata.net\/fr\/wp-json\/wp\/v2\/media\/284"}],"wp:attachment":[{"href":"https:\/\/giulia-governatori.alwaysdata.net\/fr\/wp-json\/wp\/v2\/media?parent=300"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/giulia-governatori.alwaysdata.net\/fr\/wp-json\/wp\/v2\/categories?post=300"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}