データ分析力を高めるビジネスパーソンのためのSQL入門

by hikarut

Slide 1

Slide 1 text

ೖ໳ 42-ษڧձ σʔλ෼ੳྗΛߴΊΔ ϏδωεύʔιϯͷͨΊͷ 42-

Slide 2

Slide 2 text

© )JLBSV5BLBIBTIJ ߴڮޫ )JLBSV5BLBIBTIJ ೥ʹ৽ଔͰϠϑʔגࣜձࣾʹೖࣾ͠ɺ8FCΤϯδχΞͱͯ͠αʔϏεͷ։ൃɺӡ༻ɺا ըɺఏҊɺͳͲ෯޿͘αʔϏεʹߩݙɻ೥͔Β͸גࣜձࣾΠʔϒοΫΠχγΞςΟϒδϟύ ϯͰσʔλαΠΤϯεάϧʔϓΛ্ཱͪ͛෦௕ͱͯࣾ͠಺ͷσʔλ׆༻Λଅਐɻ೥͔Β֎ࢿ ܥίϯαϧςΟϯάاۀʹೖࣾ͠ɺ42-Λ࢖ͬͨσʔλ෼ੳͳͲσʔλΛ׆༻ͨ͠ϚʔέςΟϯ άࢧԉΛ࣮ࢪɻ ࣗݾ঺հ 1SPpMF ෳۀͱͯ͠#-&"(6&ͷΫϥϒνʔϜͰɺϚʔέςΟϯάετϥς δετͱͯ͠σʔλ෼ੳͷαϙʔτΛߦͬͨΓɺͦͷଞෳ਺ࣾͰ 42-Λ׆༻ͨ͠σʔλ෼ੳͷαϙʔτܦݧ͋Γɻʰσʔλ෼ੳྗΛ ߴΊΔϏδωεύʔιϯͷͨΊͷ42-ೖ໳ʱͷஶॻɻ MJHIU

Slide 3

Slide 3 text

<13>σʔλ෼ੳྗΛߴΊΔϏδωεύʔιϯͷͨΊͷ42-ೖ໳ ઈࢍൃചத w42-͕શ͘Θ͔Βͳ͍ਓ͕ಡΜͰ΋σʔλ෼ੳͰ ࢖͏جຊతͳ42-͕͜ͷ࡭Ͱֶ΂Δ wϋϯζΦϯܗࣜͰ࣮ફΛҙࣝͨ͠42-ֶ͕΂Δ wϏδωεॻͱͯ͠ಡΈ΍͍͢ϖʔδʹऩ·Δ಺༰ IUUQTXXXBNB[PODPKQEQ ೥݄ൃച

Slide 4

Slide 4 text

wࠓ42-ΛֶͿ΂͖ ͭͷཧ༝ ΞδΣϯμ "HFOEB wຊॻͷ ͭͷັྗ wσʔλ෼ੳͰ࢖͏42-ͷ ͭͷಛ௃

Slide 5

Slide 5 text

wࠓ42-ΛֶͿ΂͖ ͭͷཧ༝ ΞδΣϯμ "HFOEB wຊॻͷ ͭͷັྗ wσʔλ෼ੳͰ࢖͏42-ͷ ͭͷಛ௃

Slide 6

Slide 6 text

Slide 7

Slide 7 text

© )JLBSV5BLBIBTIJ σʔλ෼ੳͰ࢖͏42-ͷಛ௃ 8IBU42- VTFS@JE HFOEFS CJSUI " உੑ " ঁੑ ɾɾɾ ɾɾɾ ɾɾɾ QSPEVDU@JE QSPEVDU@OBNF QSJDF # ͓͍͍͠ਫ # γϟʔϓϖϯ ɾɾɾ ɾɾɾ ɾɾɾ 42- VTFS@JE HFOEFS CJSUI " உੑ ࣮ߦ݁Ռ 4&-&$5'30.VTFST 8)&3&VTFS@JEb"` σʔλϕʔε ςʔϒϧ 42-ͱ͸ʰ4USVDUVSFE2VFSZ-BOHVBHFʱͷུͰʰΤεΩϡʔΤϧʱͱಡΉ 42-͸σʔλϕʔε্ͷςʔϒϧʹ֨ೲ͞ΕͨσʔλΛऔಘ͢Δͱ͖ʹ࢖͏ݴޠ

Slide 8

Slide 8 text

© )JLBSV5BLBIBTIJ σʔλ෼ੳͰ࢖͏42-ͷಛ௃ 8IBU42- Ϗδωεύʔιϯ͕࢖͏42-ͱΤϯδχΞ͕࢖͏42-͸ҧ͏ wσʔλ෼ੳͰ͸جຊతʹ͸σʔλͷऔಘʢ4&-&$5ʣΛ ֮͑Ε͹Α͍ w42-ͷॲཧ଎౓ʹ͍ͭͯҙࣝ͢Δඞཁੑ͕௿͍ wجຊతͳߏจΛ֮͑Ε͹ͣͬͱ࢖͍ଓ͚Δ͜ͱ͕Ͱ͖Δ wΞϓϦέʔγϣϯ։ൃʹඞཁͳ42-ʢ4&-&$5ɹ */4&35%&-&5&61%"5&$3&"5&ʣΛ֮͑Δ ඞཁ͕͋Δ wϛϦඵ୯ҐͰॲཧ଎౓Λҙࣝ͢Δඞཁ͕͋ΔʢͦͷͨΊ ΠϯσοΫεͳͲͷσʔλϕʔεͷ஌ࣝ΋ඞཁʹͳΔʣ w৽͍͠42-ͷߏจΛ֮͑ͯΑΓޮ཰తͳ42-Λॻ͘ඞཁ ͕͋Δ Ϗδωεύʔιϯ͕࢖͏42- ΤϯδχΞ͕࢖͏42-

Slide 9

Slide 9 text

wࠓ42-ΛֶͿ΂͖ ͭͷཧ༝ ΞδΣϯμ "HFOEB wຊॻͷ ͭͷັྗ wσʔλ෼ੳͰ࢖͏42-ͷ ͭͷಛ௃

Slide 10

Slide 10 text

© )JLBSV5BLBIBTIJ ᶃσʔλ෼ੳʹ͓͚Δ 42-͸ίεύ͕Α͍ ᶄ࣮຿Ͱ෯޿͘࢖͑Δ ᶅֻ͚ࢉͷεΩϧͱͯ͠ ໾ཱͭ σʔλ෼ੳͰֶͿ42-͸ֶशίετ ͕௿͘ɺҰ౓ֶ΂͹ීวతʹ׆Ͱ͖ ΔεΩϧ 42-͸৬छΛ໰Θͣ͋ΒΏΔ৬छͰ σʔλ෼ੳͰ׆༻Ͱ͖ΔͨΊ൚༻ੑ ͕ߴ͍εΩϧ σʔλநग़ΛΤϯδχΞʹཔΒͣɺ 42-Λ࢖͏͜ͱͰࣗ෼ͷཉ͍͠σʔ λΛૉૣ͘ूܭ͢Δ͜ͱ͕Ͱ͖Δ ࠓ42-ΛֶͿ΂͖ͭͷཧ༝ 8IZ42-

Slide 11

Slide 11 text

© )JLBSV5BLBIBTIJ ᶃσʔλ෼ੳͷ42-͸ίεύ͕Α͍ ׆ ༻ ͷ ෯ ͕ ڱ ͍ ׆ ༻ ͷ ෯ ͕ ޿ ͍ ֶशίετ͕௿͍ ֶशίετ͕ߴ͍ 42- Ұൠతͳϓϩάϥϛϯ άݴޠʹൺ΂ֶͯशί ετ͕௿͘ɺҰ౓ֶश ͢Ε͹௕ظؒ࢖͑Δε Ωϧͱͯ͠໾ཱͭ शಘͰ͖Ε͹σʔλ෼ ੳ΍ιϑτ΢ΣΞ։ൃ ͳͲ෯޿͘࢖͑ΔϝϦ οτ͸͋Δֶ͕शίε τ͕ඇৗʹߴ͍ Ұൠతͳ ϓϩάϥϛϯάݴޠ ୭Ͱ΋ѻ͍΍͘͢σʔ λ෼ੳͰ΋׆༻Ͱ͖Δ ͕ɺѻ͑Δσʔλͷྔ ʹݶք͕͋Γෳࡶͳ෼ ੳ͕͠ʹ͍͘ ΤΫηϧ ˞ॾઆ͋Γ ࠓ42-ΛֶͿ΂͖ͭͷཧ༝

Slide 12

Slide 12 text

Slide 13

Slide 13 text

Slide 14

Slide 14 text

© )JLBSV5BLBIBTIJ ᶄ࣮຿Ͱ෯޿͘࢖͑Δ ࠓ42-ΛֶͿ΂͖ͭͷཧ༝ খن໛ɾݸਓͰߦ͏σʔλ෼ੳ؀ڥ 42- ϑΝΠϧΛ μ΢ϯϩʔυ ϑΝΠϧ͔Βࣗ ෼ͷ1$ʹσʔλ Λొ࿥ ෼ੳ݁Ռ w 1ZUIPOͳͲͷϓϩάϥϛϯάݴޠͰσʔλΛѻ͏ʹ͸೉қ౓͕ߴ͍ w ΤΫηϧΛ࢖͏ͱѻ͑Δσʔλͷྔ͕ݶΒΕΔσʔλͷॲཧʹ͕͔͔࣌ؒΔ σʔλ෼ੳ؀ڥ͕੔͍ͬͯͳͯ͘΋ɺݩσʔλΛࣗ෼ͷ1$ʹೖΕΔ ͜ͱͰखݩͰ42-Λ࢖ͬͯσʔλ෼ੳ͕Ͱ͖Δ جװγεςϜ ݩσʔλʢDTWϑΝΠϧͳͲʣ ࣗ෼ͷ1$

Slide 15

Slide 15 text

© )JLBSV5BLBIBTIJ ᶅֻ͚ࢉͷεΩϧͱͯ͠໾ཱͭ ࠓ42-ΛֶͿ΂͖ͭͷཧ༝ 42- ϚʔέςΟϯά σʔλΞφϦετ ܦӦاը Ӧۀ w &$αΠτͷߦಈ෼ੳ w ސ٬ͷߪങ෼ੳ w ޿ࠂ΍ΩϟϯϖʔϯͷޮՌݕূ w ೥౓ผച্ w ࢛൒ظ͝ͱͷച্ w ސ٬ηάϝϯτ෼ੳ w %8)͔ΒσʔλΛநग़ w #*πʔϧ͔Βσʔλ઀ଓ w σʔλͷલॲཧ w ചΕے঎඼ͷ෼ੳ w ੒໿݅਺෼ੳ w ஍Ҭผ෼ੳ ༷ʑͳ৬छͰ࣮຿ͱ ͯ͠׆༻͠΍͍͢ 42-͸୭Ͱ΋࣮຿Ͱ࢖͍΍͍͢εΩϧͳͷͰͲΜͳ৬छͰ΋෯޿͘׆༻Ͱ͖Δ

Slide 16

Slide 16 text

wࠓ42-ΛֶͿ΂͖ ͭͷཧ༝ ΞδΣϯμ "HFOEB wຊॻͷ ͭͷັྗ wσʔλ෼ੳͰ࢖͏42-ͷ ͭͷಛ௃

Slide 17

Slide 17 text

Slide 18

Slide 18 text

Slide 19

Slide 19 text

Slide 20

Slide 20 text

Slide 21

Slide 21 text

Slide 22

Slide 22 text

© )JLBSV5BLBIBTIJ ຊॻͷಛ௃ɹଞͷຊͱͷൺֱ ຊॻͷಛ௃ɹᶄ42-Λશ͘஌Βͳ͍ਓͰ΋ϋϯζΦϯΛத৺ͱ࣮ͨ͠ફͰ࢖͑Δ42-ֶ͕΂Δ ϋϯζΦϯܗࣜͰޮ཰Α͘σʔλ෼ੳͰ࢖͏42-Λֶ΂Δͷ͕ຊॻͷಛ௃ ຊॻ Ұൠతͳ42-ೖ໳ॻ σʔλ෼ੳ༻ͷ42-ຊ ର৅ऀ Ϗδωεύʔιϯ ΤϯδχΞ Ϗδωεύʔιϯ ຊͷ಺༰ σʔλ෼ੳ ΞϓϦέʔγϣϯ։ൃ σʔλ෼ੳ ຊͷಛ௃ ϋϯζΦϯܗࣜͰ࣮຿ͷσʔλ෼ ੳͰΑ͘࢖͏ߏจʹಛԽ ໢ཏతʹ42-ͷߏจΛઆ໌ ϋϯζΦϯܗࣜʹͳ͍ͬͯͳ͍ ໢ཏతʹ42-ͷߏจΛઆ໌ ϖʔδ਺ ʙ ʙ

Slide 23

Slide 23 text

Slide 24

Slide 24 text

© )JLBSV5BLBIBTIJ ຊॻͷߏ੒ ຊॻͷಛ௃ɹᶅ࣮຿ͷσʔλ෼ੳʹඞཁͳ಺༰ʹಛԽ͢Δ͜ͱͰޮ཰Αֶ͘΂Δ ͳͥ42-͕ඞཁ͔ʁ 42-ͱ͸Կ͔ʁ 42-࣮ߦ؀ڥͷߏங ϋϯζΦϯͷ४උ 42-ͷߏจ ཧղ w σʔλ෼ੳ͕ॏཁͳཧ༝ w σʔλ෼ੳʹ͓͚Δ42-ͱ͸ w 42-ͷجຊతͳ֓೦ ୈষ ୈষ ୈʙষ w 42-JUFΛ࢖ͬͨσʔλ෼ੳ؀ڥ w 42-࣮ߦͷͨΊͷ؀ڥߏங w 42-࣮ߦπʔϧͷ࢖͍ํ 4&-&$5-*.*503%&3#:ू ໿ؔ਺(3061#:%*45*/$5 8)&3&)"7*/(+0*/6/*0/ $"4&αϒΫΤϦ8*5)

Slide 25

Slide 25 text

© )JLBSV5BLBIBTIJ wΤϯδχΞͱͯ͠Ͱ͸ͳ͘Ϗδωεύʔιϯͱ͠ ͯσʔλ෼ੳʹඞཁͳ42-ͷ஌ࣝ w42-ͷಡΈղ͖͕Ͱ͖ΔೳྗΛ਎ʹ͚ͭΔ wΤϯδχΞͱͯ͠ඞཁͳ42-ͷ஌ࣝ ʢ*/4&35%&-&5&61%"5&$3&"5&ʣ wσʔλ෼ੳͰར༻ස౓ͷগͳ͍׬શ֎෦݁߹ͱΫ ϩε݁߹ wॳֶऀʹ͸೉қ౓ͷߴ͍8*/%08ؔ਺ ຊॻͰ৮ΕΔ಺༰ɾ৮Εͳ͍಺༰ ຊॻͷಛ௃ɹᶅ࣮຿ͷσʔλ෼ੳʹඞཁͳ಺༰ʹಛԽ͢Δ͜ͱͰޮ཰Αֶ͘΂Δ ৮ΕΔ಺༰ ৮Εͳ͍಺༰

Slide 26

Slide 26 text

ຊॻͷັྗ 4VNNBSZ 42-Λֶͼ͍ͨͱࢥͬͨਓ͕࠷ॳʹखʹऔΔ࡭ σʔλ෼ੳͰ࢖͏

Slide 27

Slide 27 text

&/%