{"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\">Insurance &#8211; 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\">SQL Practice\u202f: Housing Insurance<\/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\">Fictional<\/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\"   role=\"button\" aria-haspopup=\"dialog\"><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\"   role=\"button\" aria-haspopup=\"dialog\"><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\"   role=\"button\" aria-haspopup=\"dialog\"><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\"   role=\"button\" aria-haspopup=\"dialog\"><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>Context<\/strong><\/h2>\n\n\n\n<p>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 contracts and a geographical reference file, and write SQL queries to extract key indicators.<\/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><strong>CONTRAT.CSV<\/strong> \u2013 30,335 housing insurance contracts (11 attributes)<\/li>\n\n\n\n<li><strong>REGION.CSV<\/strong> \u2013 38,916 department-city pairs (7 attributes)<\/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 and data dictionary in Excel (types, constraints, descriptions)<\/li>\n\n\n\n<li>UML modeling, then relational schema via SQL Power Architect<\/li>\n\n\n\n<li>CSV import into MySQL (inconsistencies cleaned via VLOOKUP)<\/li>\n\n\n\n<li>Wrote 12 SQL queries (SELECT, JOIN, aggregations, ORDER\u202fBY, AVG\/COUNT functions)<\/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>Top 5 contracts with the largest surface area: between 559\u202fm\u00b2 and 815\u202fm\u00b2<\/li>\n\n\n\n<li>Average monthly premium: \u20ac19\/month<\/li>\n\n\n\n<li>Declared value distribution: mostly under \u20ac25,000; only 104 contracts over \u20ac100,000<\/li>\n\n\n\n<li>\u201cIntegral\u201d plans in Pays de la Loire: 589 occurrences<\/li>\n\n\n\n<li>Houses in department 71: 48 contracts, evenly split between Classic and Integral plans<\/li>\n\n\n\n<li>Average surface area in Paris: 52\u202fm\u00b2<\/li>\n\n\n\n<li>Top 10 departments by average premium: Paris (\u20ac36), Hauts-de-Seine (\u20ac26), Val-de-Marne (\u20ac20) etc.<\/li>\n\n\n\n<li>Most covered city: Paris<\/li>\n\n\n\n<li>Most active region: \u00cele-de-France (14,177 contracts)<\/li>\n<\/ul>\n\n\n\n<p>These results highlight the strong concentration of contracts in \u00cele-de-France, disparities in premium amounts across regions, and the profiles of insured properties.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Business Impact<\/strong><\/h2>\n\n\n\n<p>Through this project, I developed hands-on skills in database design and SQL querying\u2014essential for any BI Analyst. The insights can help the insurer:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Prioritize tailored offers in high-premium areas (e.g. Paris)<\/li>\n\n\n\n<li>Adjust insurance plans based on declared value distribution<\/li>\n\n\n\n<li>Target prospecting campaigns in under-covered cities<\/li>\n<\/ul>\n\n\n\n<p>Internally, these deliverables (schema, SQL code, screenshots) serve as a reference for future analyses and support data-driven decision-making.<\/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\">Technical document<\/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\">List of analysis<\/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\">Methodology<\/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\">See other projects<\/label>\n  <button id=\"project-toggle\" class=\"custom-select\" type=\"button\">Select<\/button>\n  <div class=\"dropdown-menu\">\n    <a href=\"\/projects\/real%E2%80%91estate-price-prediction\/\">Real-Estate Price Prediction<\/a>\n    <a href=\"\/projects\/market-segmentation-aaa-strategy-uoi-games\/\">Market Segmentation &#038; AAA Strategy<\/a>\n    <a href=\"\/projects\/portfolio-creation-documentation\/\">Portfolio Creation &#038; Documentation<\/a>\n    <a href=\"\/projects\/the-hidden-realities-of-animation-in-france\/\">Personal survey: \u201cthe Hidden Realities of Animation in France\u201d<\/a>\n    <a href=\"\/projects\/power-bi-project-dashboard-sanitoral\/\">Power BI Project Dashboard<\/a>\n    <a href=\"\/projects\/stock-management-data-cleaning-bottleneck\/\">Stock Management &#038; Data Cleaning<\/a>\n    <a href=\"\/projects\/sales-dashboard-recs-bottleneck\/\">Dashboard &#038; Business Recommandations<\/a>\n    <a href=\"\/projects\/customer-satisfaction-tracking-bestmarket\/\">Customer Satisfaction Tracking<\/a>\n    <a href=\"\/projects\/gdpr%E2%80%91compliant-data-collection\/\">GDPR-Compliant Data Collection<\/a>\n    <a href=\"\/projects\/analyze-customer-churn\/\">Analyze Customer Churn<\/a>\n    <a href=\"\/projects\/sql-practice-housing-insurance\/\">SQL Practice : Housing Insurance<\/a>\n    <a href=\"\/projects\/analysis-of-my-business-intelligence-analyst-training\/\">Analysis of my Business Intelligence Analyst training<\/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>\n","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}]}}