Data Engineering Study #20 "Introduction to Data Analytics with SQL" Book

.JOFSP"PLJ ͞Βʹ೥ઓ͑Δ͔΋ ͠Εͳ͍σʔλ෼ੳೖ໳ "*ͱ%9ͷ࣌୅Λ͜ͷઌੜ͖ͷ͜Δʹ͸

EJTDMBJNFS ຊηογϣϯͷ಺༰͸ݸਓͷҙݟͰ͋Γɺ ൃදऀ͕ॴଐ͢Δɾॴଐͨ͠૊৫ͷެࣜݟղͰ͸͋Γ·ͤΜ

ࣗݾ঺հ ‣ ੨໦ๆ࿠ʢ͓͖͋ΈͶΖ͏ʣ ‣ ݩ3VCZίϛολʔɺஶॻଟ਺ˠ ‣ લʑ৬ฒྻ3%#.4ϕϯμʔ ‣ ฒྻσʔλϕʔεͱग़ձ͏ ‣
લ৬ΫοΫύου ‣ ෼ੳαʔϏεʮͨ΂ΈΔʯͷ։ൃ ‣ %8)ͷߏங ‣ ݱ৬5SFBTVSF%BUBʢڈ೥͔Βʣ ‣ "QQMJDBUJPOTνʔϜʹͯ$%1ͷ։ൃ

དྷि͔Β%JHEBHΛ΍Γ·͢

೥ຊͷ ͓͞Β͍

ʰ೥ઓ͑Δσʔλ෼ੳೖ໳ʱ ιϑτόϯΫΫϦΤΠςΟϒɺ w લ৬ΫοΫύουͷಉ྅ʹ42-ΛֶΜ Ͱ΋Β͏ͨΊͷςΩετͱͯ͠ॻ͍ͨ w ΤϯδχΞͩͱ0-51ͷ42-͔͠஌Βͳ ͍ਓ͕େ൒Ͱɺલఏ͕߹Θͣۤ࿑ͨ͠ ͷͰɺͦͷ͋ͨΓʹॏ఺Λஔ͍ͨ w
͍ͭͰʹ෼ੳσʔλϕʔεʹ͍ͭͯ ೔ʑࢥ͍ͬͯͨ͜ͱ΋ॻ͍ͨ w ΤϯλʔϓϥΠζ޲͚اۀʹ͍ͨ਎͔ Β͢Δͱ%8)͸͋ͨΓ·͑ͷ஌ࣝͩ ͕ɺ౰࣌͸·ͩ΢Σϒք۾ʹ͸޿·ͬ ͓ͯΒͣɺ஌ࣝͷஅઈ͕͋ͬͨ

ʙ೥͘Β͍ͷঢ়گ ͍ΘΏΔ΢Σϒܥ ৽͍͠اۀ ͍ΘΏΔ ΤϯλʔϓϥΠζاۀ ฏۉతͳ΢ΣϒΤϯδχΞ ϓϥϯφʔɺσΟϨΫλʔɺʜ %8)ʁͳʹͦΕʁ %8)ͬͯΦϯϓϨͰ͠ΐ ͡Ό͋"DUJWF3FDPSEͰʜ
)BEPPQ࢖͑͹͍͍ΑͶ )BEPPQΑ͘Θ͔ΒΜ ϏοάσʔλΑ͘Θ͔ΒΜ Α͘Θ͔ΒΜ͚Ͳ Ϗοάσʔλ͍ͬͯ͏ౕͰ %8)͸Φϫίϯͳͷʁ ͳʹ΋Θ͔Βͳ͍ ဃ཭

ୈ෦42-ʹΑΔσʔλ෼ੳ w ୈষ೥ઓ͑Δσʔλ෼ੳͷٕज़ w ୈষ͞ΘͬͯΈΑ͏3%#.4 w ୈষ؆୯ʂTFMFDUจͰσʔλ୳ࡧ w ୈষ͢΂ͯͷ෼ੳ͸ूܭ͔Β࢝·Δ w
ୈষؔ਺Ͱࣗ༝ࣗࡏʹ৽͍͠ΧϥϜΛ࡞Γग़͢ w ୈষδϣΠϯΛ੍͢Δ΋ͷ͸3%#.4Λ੍͢ʕʕجૅฤ w ୈষδϣΠϯΛ੍͢Δ΋ͷ͸3%#.4Λ੍͢ʕʕԠ༻ฤ w ୈষ஗Εͯདྷͨ෼ੳ42-࠷ڧͷ෢ثʕʕ΢Οϯυ΢ؔ਺ w ୈষॎͱԣ͸೉͍͠ w ୈষΞΫηεϩάͷηογϣϯ෼ੳΛ͢Δ ୈ෦෼ੳγεςϜͷߏங w ୈষ೥ઓ͑Δσʔλ෼ੳγεςϜ w ୈষϏοάσʔλʹཱͪ޲͔͏ w ୈষ42-όονͷٕ๏ w ୈষຊॻΛಡΈऴ͑ͨޙʹ ʰ೥ઓ͑Δσʔλ෼ੳೖ໳ʱ֓ཁ લઆ 42-ͷ࿩ 42-த৺ ΞʔΩςΫνϟ

42-Ͱ෼ੳ͠Α͏ σʔλΛϲॴʹूΊΑ͏ σʔλΛ૚ߏ଄ʹฤ੒͠Α͏ 42-த৺ΞʔΩςΫνϟ ݸผʹ࠶ݕ౼͢Δ

೥ຊͷ͓͞Β͍ʢຊηΫγϣϯʣ ࠷ۙͷ42-ʹ͍ͭͯ 42-͸͍ͭࢮ͵ͷ͔ ͜Ε͔Βͷ෼ੳσʔλϕʔεͱ͸ σʔλ͸ҰϲॴʹूΊΔ΂͖͔
σʔλΛͲͷΑ͏ʹฤ੒͢Δ͔ ·ͱΊ ຊ೔ͷ಺༰

࠷ۙͷ42- ʹ͍ͭͯ

w 42- w ࠷ॳͷ42-ඪ४ w 42-ʢ42-ʣ w ͍͍ͩͨͲͷํݴͰ΋࣮૷͞Ε͍ͯΔൣғ w 42-ʢ42-ʣ
w ਖ਼نදݱϚονɺ࠶ؼΫΤϦʔɺ഑ྻɺߏ଄ମɺετΞυϓϩ γʔδϟ w 42- w ΢Οϯυ΢ؔ਺ɺγʔέϯεɺ*EFOUJUZΧϥϜ ීٴͨ͠42-ඪ४

৽͠Ίͷ42-ඪ४ ඪ४ ओͳ௥Ճػೳ 42- 42-9.- 42- 5SVODBUFTUBUFNFOU 42- 5FNQPSBM 42-
3PXQBUUFSONBUDIJOH +40/PQFSBUJPOT 1PMZNPSQIJDUBCMFGVODUJPO MJTUBHH 42- ଟ࣍ݩ഑ྻ 42- +40/UZQF 6OEFSTDPSFTJOOVNFSJDMJUFSBMT   1SPQFSUZHSBQIRVFSJFT

NBUDI@SFDPHOJ[F 42- SPXQBUUFSONBUDIJOH

w ߦͷฒͼʹରͯ͠ਖ਼نදݱϚ ονΛ͢Δ͜ͱ͕Ͱ͖Δ w Ϛονͨ͠෦෼ΛऔΓग़ͨ͠ Γूܭͨ͠ΓͰ͖Δ w 1SFTUP 4OPX fl
BLF 0SBDMF ͳͲ͕࣮૷͍ͯ͠Δ ߦͷฒͼʹର͢ΔύλʔϯϚον NBUDI@SFDPHOJ[F TFMFDU GSPNXFC@BDDFTT NBUDI@SFDPHOJ[F QBSUJUJPOCZVTFS@JE PSEFSCZFWFOU@UJNF NFBTVSFT TVN BNPVOU BTUPUBM@BNPVOU QBUUFSO 7 $# EF fi OF 7BTFWFOUWJFX $BTFWFOUDBSU #BTFWFOUCVZ

w ͓ͦΒ͘NBUDI@SFDPHOJ[Fͷ ݩωλ w Ϋϥελʔ಺ʹ)BEPPQ͕ಈ͍ ͍ͯͯ.BQ3FEVDFͰॲཧ w "TUFS%BUB͸ޙʹ5FSBEBUBʹ ങऩ͞Εͨ "TUFS%BUBͷO1BUI
TFMFDU GSPNOQBUI POXFC@BDDFTT   QBSUJUJPOCZVTFS@JE   PSEFSCZFWFOU@UJNF VTJOHNPEF OPOPWFSMBQQJOH QBUUFSO 7 $# TZNCPMT FWFOUWJFXBT7 FWFOUDBSUBT$ FWFOUCVZBT# SFTVMU TVN BNPVOU PG# BTU

ΦϥΫϧຊࣾ αϯΧϧϩεۭߓ ݩ"TUFS%BUBΦϑΟε 42-ۭߓ

w +40/PQFSBUJPOT 42- w +40/Ͱ͋ΔจࣈྻΛύʔεͯ͠ॲཧ͢Δؔ਺܈ɻ w +40/1BUIͰ஋ΛऔΓग़ͨ͠ΓͰ͖Δɻ w +40/5ZQF
42- w ʢύʔεࡁΈͷʣ+40/஋Λσʔλϕʔεʹอଘͯ͠ɺؔ਺Ͱ͸ͳ͘ߏจͰΞΫ ηεͰ͖Δɻ w จࣈྻॲཧͰ͸ͳ͘ɺ42-ͷߏจͰ+40/Λߏஙͯ͠ฦ͢͜ͱ΋Ͱ͖Δɻ +40/UZQFͱ+40/PQFSBUJPO

w 1PMZNPSQIJD5BCMF'VODUJPO 42- w ςʔϒϧؔ਺͔Βɺಈతʹܕ͕มΘΔϦϨʔγϣϯΛฦ͢͜ͱ ͕Ͱ͖Δɻ w ଞͷσʔλϕʔεʹ೚ҙͷΫΤϦʔΛ౤͛ͨ݁ՌΛฦ͢Α͏ͳ ؔ਺͕࡞ΕΔɻ
1PMZNPSQIJD5BCMF'VODUJPO

w 6OEFSTDPSFTJO/VNFSJD-JUFSBMT 42- w @@ͱॻ͚Δɻ w 1PTUHSF42-΍࠷৽ͷ5SJOPͳͲ͕αϙʔτ͢ΔΒ͍͠ɻ ੔਺ϦςϥϧʹԼઢ

w 1SPQFSUZ(SBQI2VFSJFT 42- w ςʔϒϧʹอଘ͞Εͨάϥϑʢσʔλߏ଄ʣʹର͢ΔΫΤϦʔ͕ॻ͚Δɻ 1SPQFSUZ(SBQI2VFSJFT $3&"5&1301&35:(3"1) fi OBODJBM@USBOTBDUJPOT
7&35&95"#-&4 1FSTPOT-"#&-1FSTPO1301&35*&4 OBNF $PNQBOJFT-"#&-$PNQBOZ1301&35*&4 OBNF "DDPVOUT-"#&-"DDPVOU1301&35*&4 OVNCFS &%(&5"#-&4 5SBOTBDUJPOT 4063$&,&: GSPN@BDDPVOU 3&'&3&/$&4"DDPVOUT OVNCFS %&45*/"5*0/,&: UP@BDDPVOU 3&'&3&/$&4"DDPVOUT OVNCFS -"#&-USBOTBDUJPO1301&35*&4 BNPVOU "DDPVOUT"41FSTPO0XOFS 4063$&,&: OVNCFS 3&'&3&/$&4"DDPVOUT OVNCFS %&45*/"5*0/1FSTPOT -"#&-PXOFS/01301&35*&4 "DDPVOUT"4$PNQBOZ0XOFS 4063$&,&: OVNCFS 3&'&3&/$&4"DDPVOUT OVNCFS %&45*/"5*0/$PNQBOJFT -"#&-PXOFS/01301&35*&4 1FSTPOT"4XPSLT'PS 4063$&,&: JE 3&'&3&/$&41FSTPOT JE %&45*/"5*0/$PNQBOJFT /01301&35*&4 4&-&$5 PXOFSOBNF"4BDDPVOU@IPMEFS 46. UBNPVOU "4UPUBM@USBOTBDUFE@XJUI@/JLJUB '30. ."5$) Q1FSTPO <PXOFS> BDDPVOU"DDPVOU ."5$) BDDPVOU <UUSBOTBDUJPO> BDDPVOU ."5$) BDDPVOU"DDPVOU <PXOFS> PXOFS1FSTPOc$PNQBOZ 8)&3& QOBNF/JLJUB (3061#: PXOFS 'SPNIUUQTQHRMMBOHPSH

w RVBMJGZ۟ w ΢Οϯυ΢ؔ਺͕࣮ߦ͞Εͨ͋ͱʹධՁ͞ΕΔ8)&3&۟ɻ w ΢Οϯυ΢ؔ਺Λ࢖͏ͱߴ֬཰Ͱൃੜ͢ΔαϒΫΤϦʔΛ๾໓Ͱ͖Δɻ w ݩ͸5FSBEBUBͷಠ֦ࣗு͕ͩɺ͍·͸#JH2VFSZɺ4OPX fl BLF΋αϙʔτͯ͠
͍Δɻ w ϥςϥϧࢀর w BTͰ෇͚ͨผ໊ΛɺXIFSF۟΍HSPVQCZ͔۟ΒࢀরͰ͖Δɻ w ྫʹΑͬͯ5FSBEBUB͕࣮૷͍͕ͯͨ͠3FETIJGUɺ)JWFʹ΋͍ͭͷ·ʹ͔ೖͬ ͨɻ w ϥϜμࣜ w ֤छϓϩάϥϛϯάݴޠʹ͋ΔΞϨɻແ໊ͷؔ਺Λॻ͘͜ͱ͕Ͱ͖Δɻ w 5SJOP͕࣮૷͍ͯ͠Δɻ 42-ඪ४Ͱ͸ͳ͍͕ศརͳߏจ

w 42-ʹ͸׆ൃʹػೳ͕௥Ճ͞Ε͓ͯΓɺ·ͩ·ͩਐԽத w ϦϨʔγϣφϧσʔλͷൣᙝΛӽ͑ͯର৅ྖҬ͕֦େ͍ͯ͠Δ ৽͍͠42-ඪ४·ͱΊ

42-͸͍ͭ ·Ͱ༗ޮ͔ʁ

42-Ͱ෼ੳ͠Α͏ σʔλΛϲॴʹूΊΑ͏ σʔλΛ૚ߏ଄ʹฤ੒͠Α͏ 42-த৺ΞʔΩςΫνϟ

w %#ݻ༗ͷ֦ு͕ଟ͗ͯ͢ඪ४42-͚ͩͰ͸Կ΋ॻ͚ͳ͍ w ʮ͓·͑͸ࠓ·Ͱʹ࢖ͬͨ%#ݻ༗֦ுͷ਺Λ͍֮͑ͯΔͷ͔ʁʯ w ֦ுੑօແͳ೥୅ͷจ๏ w ʮӳޠʹࣅͯΔ͔ΒಡΈ΍͍͢ʯͱ͍͏Ϋιཧ࿦ w େจࣈΛ࢖͍͕ͨΔ
w ͱͯ΋֮͑ΒΕͳ͍਺ͷ༧໿ޠ w ͳ͔ͥ'30.͕۟ೋ൪໨ w ॻ͘ऀΛࠞཚͤ͞Δ࠷௿ͳػೳͷ਺ʑ w ΏΔ;Θࣗಈܕม׵ w /6-- 42-ͳΜͯݏ͍ͩ

ਖ਼௚ɺ໓ͼͯ΄͍͠ʜ

w ओཁ3%#.4͕͢΂ͯผͷݴޠΛαϙʔτͨ͠Βࢮ͵ʁ w 0SBDMF 42-4FSWFS .Z42- 1PTUHSF42- #JH2VFSZ 4OPX fl
BLF 5FSBEBUB %#͕͢΂ͯ42-Ͱ͸ͳ͍ಉ͡ݴޠΛαϙʔτ͢Δ͜ͱ͸͋Γ͏Δ ͔ʁ w 3%#.4͕ࢮΜͩΒ42-΋ࢮ͵ʁ w ೥୅ͷ,74ϒʔϜ͸3%#.4Λࡴ͢࠷େͷνϟϯεͩͬͨ͸͕ͣͩɺ݁ Ռͱͯ͠ࡴ͔ͤͨʁ w ਓؒͱओཁ#*πʔϧ͕ἧͬͯҧ͏ݴޠΛ࢖͍࢝ΊͨΒࢮ͵ʁ w ਓؒ͸$IBU(15͕ॻ͍ͯ͘ΕΔ͔΋͠Εͳ͍ w #*πʔϧͷݴޠΛม͑Δಈػ͕ͦ͜·Ͱ͋Δ͔ʁ Ͳ͏ͳͬͨΒ42-͸ࢮ͵͔

42-͸ෆ໓ େม࢒೦ͳ͓஌ΒͤͰ͕͢

w 42-Λࡴͦ͏ͱͨ͠ʢʁʣ.BQ3FEVDFɺ4BX[BMMɺ1JHɺͳΜͱ ͔2-ͦͷଞ͍Ζ͍Ζ͸ٯʹ͢΂ͯࡴ͞Εͯ͠·ͬͨ w &5-΍όον΋͢΂ͯ42-ʹ౷߹͞ΕΔ͔΋͠Εͳ͍ʢޙड़ʣ w ετϦʔϜॲཧ͸·ͩະདྷ͕ݟ͑ͳ͍͕42-͕੮ר͢ΔՄೳੑ͕ ͋Δ 42-ੈʹጨΔ

42-͸ΤλʔφϧϑΥʔε   ϒϦβʔυʢ˞૬ख͸ࢮ͵ʣ

΋͔ͯ͠͠ ਓྨΑΓ௕ੜ͖͢ΔͷͰ͸ʜʜʁ

w ࢒೦ͳ͕Β42-͸ෆࢮ਎ɻ w ͏͔ͬΓࡴͦ͏ͱ͢Δͱࡴ͠ฦ͞ΕΔɻ w ਓྨͷखʹ༨ΔͷͰఘΊΑ͏ɻ ηΫγϣϯ·ͱΊ

͜Ε͔Βͷ෼ ੳσʔλϕʔε ͸Ͳ͏ͳΔ͔

೥ޙͷ෼ੳ%#͸Ͳ͏ͳΔʁ աڈͷྲྀΕΛݩʹߟ͑Δ

աڈ೥ͷ෼ੳ%#ͷྲྀΕ %8)ઐ༻ػ )BEPPQͱ/P42- ৽͍͠ฒྻ3%#.4 ʙ 5FSBEBUB૑ۀ (SFFOQMVN૑ۀ
('4࿦จ )BEPPQ 5FSBEBUB 0SBDMF&YBEBUB $BTTBOESBϦϦʔε )JWFϦϦʔε #JH2VFSZ(" "NB[PO3FETIJGU )BEPPQ 1SFTUP044Խ 5%1MB[NB4OPX fl BLF )BEPPQ 3FETIJGU3"

w %8)ઐ༻ػͷ࣌୅ w ΦϯϓϨTIBSFEOPUIJOH w 42-ϕʔεͰτϥϯβΫγϣϯΛαϙʔτ͢Δ w )BEPPQͱ/P42-ͷ࣌୅ w ΦϯϓϨ·ͨ͸Ϋϥ΢υͷTIBSFEOPUIJOHͰϩʔΧϧ)%%ʹ
σʔλΛอଘ w 42-EPFTOUTDBMF w OPX৽͍͠ฒྻ3%#.4ͷ࣌୅ w Ϋϥ΢υલఏͰDPNQVUFͱTUPSBHFΛ෼཭ w ࠶ͼ42-ϕʔεͰτϥϯβΫγϣϯΛαϙʔτ͢Δ աڈ೥ͷ෼ੳ%#ͷྲྀΕ

DPNQVUFͱTUPSBHFͷ෼཭ τϥϯβΫγϣϯͷαϙʔτ ୯ҰΠϯελϯε΁ͷճؼ ͜ͷηΫγϣϯͷτϐοΫ

DPNQVUFͱTUPSBHFͷ෼཭

3FETIJGUͷྫ %4OPEFUZQF &UIFSOFU MFBEFS OPEF DPNQVUF DPNQVUF DPNQVUF DPNQVUF MPDBM
EJTL MPDBM EJTL MPDBM EJTL MPDBM EJTL w γϯϓϧͳTIBSFEOPUIJOHΞʔΩςΫνϟ w σʔλ͸͢΂ͯFQIFNFSBMEJTLʹ഑ஔ w ϊʔυΛ௥Ճ͢Δͱશσʔλͷ࠶෼ࢄ͕ඞཁ Ͱ೔୯Ґͷ͕͔͔࣌ؒΔ

3FETIJGUͷྫ 3"OPEFUZQF &UIFSOFU MFBEFS OPEF DPNQVUF DPNQVUF DPNQVUF DPNQVUF 4
w σʔλ͸͢΂ͯ4ʹ഑ஔ w σʔλͱ͸·ͬͨؔ͘܎ͳ͘DPNQVUFϊʔυ Λ૿ݮͰ͖Δ w ݁Ռͱͯ͠EZOBNJDͳ૿ݮ΍ɺΫϥελʔؒ Ͱͷσʔλڞ༗ͳͲ͕ՄೳʹͳΔ

w ࣮ࡍʹࢼͯ͠Έͨͱ͜Ζ࠷େ͍ͯͲͷ଎౓௿ԼͰࡁΜͩ w 4QFDUSVNʢޙड़ʣͷΑ͏ͳ4ΞΫηεΛଟ༻͍ͯ͠Δͱࠩ ͸΄΅ग़ͳ͍ w 3FETIJGU"26"ͷΑ͏ͳΩϟογϡΛ݉ͶͨετϨʔδ૚ ΛೖΕΔͱΉ͠Ζ଎͘ͳΔ৔߹΋͋Δ w എܠͱͯ͠ɺੲʹൺ΂ͯετϨʔδͱωοτϫʔΫͷ଎౓ࠩ
͕ॖ·͍ͬͯΔ఺͕͋Δ σʔλ͕཭ΕͨΒ஗͘ͳΒͳ͍ʁ

w γϟοϑϧʢ࠶෼ࢄʣઐ༻ͷผΫϥελʔ w 1SFTUP΍#JH2VFSZʹ࣮૷͞Ε͍ͯΔ w ωοτϫʔΫసૹ͸͍ͩͿ૿͑Δ͕ɺXSJUFBNQMJ fi DBUJPOΛ ๷͍Ͱߴ଎ԽͰ͖Δʢέʔε͕͋Δʣ γϟοϑϧΫϥελʔ

5SFBTVSF%BUB1MB[NB 4 1MB[NB NFUBEBUB 1SFTUP $PPSEJOBUPS 1SFTUP 8PSLFS 1SFTUP 8PSLFS
1SFTUP 8PSLFS 1SFTUP 8PSLFS &UIFSOFU w DPNQVUFTUPSBHF෼཭ΞʔΩςΫνϟ w σʔλ͸͢΂ͯ4ʹ഑ஔ w ϝλσʔλ͸1PTUHSF42-ʹஔ͍͍ͯΔͷͰ τϥϯβΫγϣϯ͕࢖͑Δ

5FSBEBUB7 #:/&5JOUFSDPOOFDU /PEF /PEF /PEF /PEF /PEF 4UPSBHF"SSBZ 1& ".1
1& ".1 1& ".1 1& ".1 1& ".1 'JCSF$IBOOFM w ϘτϧωοΫʹͳΓ΍͍͢ϊʔυؒ௨৴ʹಠࣗϋʔ υ΢ΣΞ#:/&5Λ࢖͏͜ͱͰϦχΞʹεέʔϧ w MFBEFS૬౰͕֤ϊʔυʹ͍ΔϚϧνϚελʔ w ͓ߴ͍ετϨʔδΞϨΠΛෳ਺ϊʔυؒͰڞ༗͢Δ ͜ͱͰϨϓϦ΍OPEFGBJM࣌ͷ࠶෼ࢄΛճආ

τϥϯβΫγϣϯͷαϙʔτ

w ͜Ε·Ͱ͸ࢀরॏࢹͩͬͨ෼ੳγεςϜʹߋ৽ܥͷ೾͕དྷ͍ͯΔ w τϥϯβΫγϣϯͷαϙʔτ͸ඞવ w ετϨʔδ͕ެ։͞Ε͍ͯΔ͔Ͳ͏͔Ͱ೉қ౓͕มΘΔ w "QBDIF*DFCFSHͳͲ͸جຊతʹ͸ެ։ετϨʔδΛ૝ఆͨ͠ϑΥʔϚοτ ʢ༷ʑͳγεςϜ͕ΞΫηεͰ͖Δʣ w
3FETIJGU΍1MB[NBͷετϨʔδ͸4Ͱ͋ͬͯ΋ઐ༻όέοτΛ࢖͏ͷͰτϥ ϯβΫγϣϯͷ࣮૷͕γεςϜʹด͡Δ w ύϑΥʔϚϯε͔Βߟ͑Δͱઐ༻ετϨʔδΛ࣋ͭ΄͏͕༗ར w σʔλϨΠΫͰ͢΂ͯΛ·͔ͳ͏ํ޲ʹ͸ߦ͔ͳ͍ͱ༧૝ w ઐ༻ετϨʔδ 0CKFDU4UPSBHF"DDFTTʢޙड़ʣʹͳΔͷͰ͸ʁ τϥϯβΫγϣϯͷαϙʔτ

୯ҰΠϯελϯε΁ͷճؼ

IUUQTNPUIFSEVDLDPNCMPHCJHEBUBJTEFBE

w େ൒ͷاۀ͸ϏοάσʔλΛ͍࣋ͬͯͳ͍ʢϛυϧσʔλͰ͋ Δʣ w ετϨʔδ͸࣌ؒʹൺྫͯ͠ඞཁྔ͕૿͍͕͑ͯ͘ɺίϯϐϡʔ τ͸͍ͨͯ͠૿͑ͳ͍ w Ϛγϯύϫʔ͸·ͩ૿Ճ͠ଓ͚͓ͯΓɺͭ·Γίϯϐϡʔλʔ ୆ͰॲཧͰ͖Δσʔλྔ͸૿͑ଓ͚͍ͯΔ #*(%"5"*4%&"%
VUCYMBSHF୆ͰࡁΉͷͰ͸ʁ

%VDL%#ʹΑΔ෼ੳ%#ͷߏ੒ ΫισΧ Πϯελϯε %VDL%# 4

w ࠶෼ࢄ͸ϘτϧωοΫͰͳ͘ ͳΔ w Ϛϧνςφϯτͷ෼ࢄ%#ϕϯ μʔʹ͸Өڹ͕͋Δʁ มΘΔ͜ͱͱมΘΒͳ͍͜ͱ w ෼ੳγεςϜͷத৺ʹίΞͱͳ Δฒྻσʔλϕʔε͕ඞཁ
w ΫΤϦʔ࠷దԽͷखஈ w ར༻ଆͷϝϯςίετ มΘΔ มΘΒͳ͍

΋͔ͯ͠͠ʜʜ

w DPNQVUFͱTUPSBHFͷ෼཭͸࣌୅ͷ਼੎ w ॲཧͷ಺༰͝ͱʹΫϥελʔΛ෼͚ΔΞʔΩςΫνϟͷొ৔ w τϥϯβΫγϣϯαϙʔτ΋࣌୅ͷ਼੎ w τϥϯβΫγϣϯͷ࣮૷ʹ͸ઐ༻ετϨʔδ͕͋Δ΄͏͕༗ར w ͋͑ͯ෼ࢄ͠ͳ͍બ୒ࢶ΋ొ৔ͨ͠
ηΫγϣϯ·ͱΊ

෼ੳαʔϏεϕϯμʔͷಓ Ϣʔβʔاۀͷಓ ϚϧνςφϯτͰΫϥελʔΛ ॏͶͯεέʔϧΞ΢τͩυʔϯ ͜͏͍͏͜ͱʜʜ͔ʁ γϯάϧςφϯτͷϊʔυͰ ίϯύΫτʹղܾͩ

σʔλ͸ϲॴ ʹूΊΔ΂͖͔

w ॻ੶Λॻ͍ͨ࣌఺Ͱ͸ɺ҆ఆੑͱ଎౓Λߟ͑Δͱ·ͩ෺ཧతʹҰ ϲॴʹूΊΔ΄͏͕Α͍ͱ͍͏൑அͩͬͨ w ͦͷޙʹීٴͨͭ͠ͷػೳ w 0CKFDU4UPSBHF"DDFTT w 'FEFSBUFE2VFSZ w
%BUB4IBSJOH σʔλΛͭͷ%#ʹूΊΔ

w 4΍$MPVE4UPSBHFͷΑ͏ͳΦϒδΣΫτετϨʔδ্ͷΦϒ δΣΫτΛ௚઀ΫΤϦʔ͢Δػೳʢ3FETIJGU4QFDUSVNͳͲʣ 0CKFDU4UPSBHF"DDFTT 3FETIJGU 4 ΫΤϦʔ

w ଞͷσʔλϕʔεΛ௚઀ΫΤϦʔ͢Δػೳʢ3FETIJGU 'FEFSBUFE2VFSZͳͲʣ w ੓࣏తʹ&5-ΑΓָͩͬͨΓ͢Δ͜ͱ΋͋ΔΒ͍͠ 'FEFSBUFE2VFSZ 3FETIJGU .Z42- ΫΤϦʔ

w ଞͷσʔλϕʔεͷςʔϒϧΛಁաతʹࢀরͰ͖Δ %BUB4IBSJOH 3FETIJGU ΫΤϦʔ 4 3FETIJGU 4

w 'FEFSBUFE2VFSZ͸αΠζͰ࢖͍෼͚Δͷ͕ݱ࣮త w খ͍͞ςʔϒϧ͸&-5ͰऔΓࠐΉΑΓ'FEFSBUFE2VFSZ w ڊେͳςʔϒϧ͸Ҿ͖ଓ͖&-5 w 0CKFDU4UPSBHF"DDFTT͸τϥϯβΫγϣϯ༗ແʹΑΔ w ΞΫηεϩάͳͲͷڊେ͕ͩ௥ՃΦϯϦʔͷςʔϒϧ͸0CKFDU4UPSBHF
"DDFTT w Ϛελʔ΍αϚϦʔςʔϒϧ͸಺෦ςʔϒϧ w %BUB4IBSJOH͸Ϋϥελʔ෼ׂΛ໨తʹ͢ΔͱΑ͍ w ྫ͑͹ࢠձࣾͷσʔλΛผΫϥελʔʹ෼͚ͭͭάϧʔϓͰ౷߹͢Δέʔεͳ Ͳ σʔλ࿈ܞػೳͷ࢖͍Ͳ͜Ζ

෺ཧతʹͭͷ%#΁ σʔλΛूΊΔඞཁ͸ͳ͍͕ɺ 42-Ͱಁաతʹ ΞΫηεՄೳʹ͸͢΂͖

w 3FETIJGUͷ"VSPSB;FSP&5- w "VSPSBͷςʔϒϧ͕ඵ͍ͯͲͰ3FETIJGUʹϨϓϦ͞ΕɺΞΫηεՄೳʹͳ Δ w 4OPX fl BLFͷ6OJTUPSF w
0-51ΞΫηεʹ޲͍ͨ)ZCSJE5BCMFΛ࡞Δ͜ͱ͕Ͱ͖Δ w ෼ੳΫΤϦʔ͔Β΋ී௨ͷςʔϒϧͷΑ͏ʹΞΫηεͰ͖Δ 0-51ͱͷ౷߹ ʢ௥Ճʣ;FSP&5-ͱ6OJTUPSF

ࠓޙ͸σʔλϕʔε୯ମΑΓ΋ ෼ੳγεςϜશମͷઃܭ͕໰୊

σʔλΛͲͷ Α͏ʹฤ੒͢Δ͔

&5-ΑΓ&-5 w ୈ૚ΛʮιʔεσʔλΛͦͷ··ϩʔυ͢ΔεΩʔϚʯͱఆٛ͢Δ͜ͱͰɺ ඞવతʹ&-5ʹͳΔ ෺ཧσʔλϚʔτΑΓԾ૝σʔλϚʔτ w ୈ૚Λ഑ஔͨ͜͠ͱͰɺඞવతʹԾ૝σʔλϚʔτʹͳΔ w
ˡˠ0-51%#ͰσʔλϚʔτΛ࡞Δ σʔλͷྲྀΕ͸Ұํ޲ w ୈ૚͔Β૚ɺ૚΁ͷํ޲Ͱσʔλ͸ྲྀΕΔ΂͖ ૊৫ͷ੾Ε໨ʹରԠ͍ͯ͠Δʢ͜ͱ΋͋Δʣ w σʔλऔΓࠐΈͱ%8)ߏங͸σʔλϚʔτߏஙͱ͸ผͷνʔϜʹͳΔ͜ͱ͕ ଟ͍ͷͰɺͦ͜Ͱ੾͓ͬͯ͘ ૚ߏ੒ͷഎܠ

w جຊతʹ͸͜ͷ··ͰΑͦ͞͏ w ७ਮͳσʔλͷ࿩୊͸ٕज़ͷਐาͰมΘΓʹ͍ͨ͘Ί w ͕ͩɺ΋ͬͱڧௐ͢΂͖ͩͬͨ͜ͱͳΒ͋Δ ૚ߏ੒Λม͑Δ༨஍͸͋Δ͔

w ෼ੳσʔλϕʔεʹ͸σʔλͷྲྀΕ͕͋Δ w 0-51σʔλϕʔεʹ͸͜Μͳʹ͸͖ͬΓͨ͠ྲྀΕ͸ͳ͍ w ෼ੳσʔλετϦʔϜʹ͸ग़ޱ͕͋Δ w ͭ·Γ׆༻ઌ͕͋Δ w ׆༻͕σʔλసૹͷ৔߹͸BDUJWBUJPOɺSFWFSTF&5-ͳͲͱݺ͹ΕΔ
w ͢΂ͯͷσʔλॲཧ͸BDUJWBUJPOͷͨΊʹ͋Δ w ͳͥͳΒՁ஋ΛੜΉͷ͸BDUJWBUJPO͔ͩΒ w ෼ੳγεςϜશମΛޙΖ͔Β࡞Δ΂͖ w ׆༻ࢪࡦˠBDUJWBUJPOˠʢσʔλϚʔτʣˠιʔεσʔλ ΑΓڧௐ͢΂͖ͩͬͨ͜ͱ

·ͱΊ

w 42-͸·ͩ·ͩਐԽ͓ͯ͠Γɺਰୀͷؾ഑΋ͳ͘ɺద༻ྖҬ͸޿ ͕͓ͬͯΓɺॏཁ౓͸ߴ·ΔҰํͰ͋Δ w σʔλ͸42-ʹΑͬͯಁաతʹΞΫηεͰ͖Δ৔ॴʹूΊΔ΂͖ Ͱ͋Δ w ෼ࢄ%#͔Ͳ͏͔͸Θ͔Βͳ͍͕ɺத৺ʹίΞͱͳΔ෼ੳ%#Λஔ ͘͜ͱ͸ࠓޙ΋มΘΒͳ͍ w
Ͳͷσʔλϕʔε͔ΑΓ΋ɺ෼ੳγεςϜશମΛͲͷΑ͏ʹߏ੒ ͢Δ͔͕ࠓޙ͸໰୊ʹͳΓͦ͏ w ෼ੳγεςϜ͸ޙΖʢ׆༻ࢪࡦʣ͔Β࡞Δ΂͖ ·ͱΊ

͝ਗ਼ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠

Data Engineering Study #20 "Introduction to Dat...

Data Engineering Study #20 "Introduction to Data Analytics with SQL" Book

More Decks by Minero Aoki

Other Decks in Technology

Featured

Transcript