ビジネスパーソンがSQLを学ぶべき3つの理由とおすすめのSQL学習方法

by hikarut

Slide 1

Slide 1 text

ߴڮޫ Ϗδωεύʔιϯ͕ 42-ΛֶͿ΂͖ͭͷཧ༝ 42-ษڧձ ʙ͓͢͢Ίͷ42-ֶशํ๏ʙ

Slide 2

Slide 2 text

Slide 3

Slide 3 text

Slide 4

Slide 4 text

© )JLBSV5BLBIBTIJ ߴڮޫ )JLBSV5BLBIBTIJ ϓϩϑΟʔϧʢຊۀɾෳۀʣ Ϡϑʔגࣜձࣾʢʙʣ גࣜձࣾΠʔϒοΫΠχγΞςΟϒδϟύϯʢʙʣ ֎ࢿίϯαϧʢʙʣ ɾϑϩϯτΤϯυαʔόαΠυόοΫΤϯυͳͲϑϧελοΫͰ8FCαʔϏεΛاըઃܭ։ൃӡ༻ ɾΤϯδχΞϚωʔδϟʔΤϯδχΞ࠾༻ ɾϠϑʔ͔Βग़޲ͯ͠σʔλαΠΤϯεάϧʔϓΛθϩ͔Β্ཱͪ͛ʢ෦௕ʣ ɾ#*πʔϧ42-1ZUIPOͳͲ࢖ͬͨσʔλͷՄࢹԽ΍෼ੳ"#ςετޮՌݕূ,1*σʔλར׆༻ଅਐ ɾࣾ಺ϝϯόʔͷσʔλ෼ੳεΩϧΞοϓҭ੒ࣾ಺σʔλར׆༻ϦςϥγʔΞοϓʢ42-ษڧձͳͲʣ ɾ42-΍#*πʔϧΛ׆༻ͨ͠σʔλ෼ੳࢧԉ ɾσδλϧϚʔέςΟϯάྖҬʹ͓͚ΔઓཱུҊɺ,1*ઃܭɺࢪࡦͷϓϥϯχϯάɺࢪࡦͷ࣮ߦ 8FCΤϯδχΞ σʔλΞφϦετϚωʔδϟʔ σδλϧϚʔέςΟϯάίϯαϧλϯτ ɾσʔλ෼ੳࢧԉσδλϧϚʔέςΟϯάࢧԉ ɾσʔλ෼ੳίʔνϯά42-τϨʔχϯά σʔλ෼ੳࢧԉ ෳۀʢʙʣ ߨࢣ঺հ σʔλυϦϒϯίϯαϧλϯτ

Slide 5

Slide 5 text

Slide 6

Slide 6 text

Slide 7

Slide 7 text

© )JLBSV5BLBIBTIJ Ϗδωεύʔιϯ͕42-ΛֶͿ΂͖ͭͷཧ༝ ʰσʔλ෼ੳʱͱ͸σʔλΛ׆༻ͯ͠ҙࢥܾఆ͢Δ͜ͱ TUFQ TUFQ TUFQ TUFQ TUFQ TUFQ TUFQ ՝ ୊ Ծ આ ૝ ఆ ෼ ੳ ݁ Ռ ߟ ࡯ ܾ ఆ σʔλ෼ੳͷͭͷεςοϓ ՝୊ઃఆೳྗ໰୊ղܾྗԾઃྗϩδΧϧγϯ ΩϯάίϛϡχέʔγϣϯೳྗϓϨθϯςʔ γϣϯೳྗ൑அೳྗυϝΠϯ஌ࣝϓϩδΣΫ τϚωδϝϯτ ϏδωεεΩϧ ςΫχΧϧεΩϧ σʔλͷूܭʢ42-ɺ&YDFMɺ1ZUIPOʣ σʔλͷՄࢹԽʢ#*ʣσʔλͷཧղʢσʔλ ϕʔεɺςʔϒϧʣ౷ܭֶػցֶश"*ࣗવ ݴޠॲཧ"#ςετ σʔλ෼ੳͱ͸σʔλΛ׆༻ͯ͠ҙࢥܾఆ͢Δ͜ͱɻσʔλ෼ੳΛ͢ΔͨΊʹ͸ʰϏδωεεΩ ϧʱͱʰςΫχΧϧεΩϧʱͷ྆ํΛߴΊΔ͜ͱ͕ॏཁɻ

Slide 8

Slide 8 text

© )JLBSV5BLBIBTIJ σʔλ෼ੳʹ͓͍ͯʰ42-ʱ͕ॏཁͰ͋Δͭͷཧ༝ Ϗδωεύʔιϯ͕42-ΛֶͿ΂͖ͭͷཧ༝ 42-Λཧղ͢ΔաఔͰσʔλϕʔε΍ςʔ ϒϧͷߏ଄Λཧղ͢Δඞཁ͕͋Δɻσʔλ ෼ੳʹ͓͍ͯ͸ͲΜͳσʔλ͕ͲͷΑ͏ͳ ܗࣜͰอଘ͞Ε͍ͯΔ͔σʔλͷߏ଄Λཧ ղ͢Δ͜ͱ͕ॏཁɻ 42-͸ϚʔέλʔɾӦۀɾΤϯδχΞͳͲ ͋ΒΏΔ৬छͰ׆༻Ͱ͖Δɻ࠷ۙͰ͸ࣗࣾ Ͱ%8)Λ׆༻͢Δاۀ΋ଟ͘ɺͦͷ৔߹ 42-͕࢖͑Δ͚ͩͰ೔ʑͷۀ຿Λσʔλυ Ϧϒϯʹ͢Δ͜ͱ͕Ͱ͖Δɻ +BWB΍1ZUIPOͳͲͷϓϩάϥϛϯάݴޠ ʹൺ΂ͯσʔλ෼ੳͰ࢖͏42-͸ֶश೉қ ౓͕௿͍ɻجຊతͳ42-ͷߏจΛ֮͑Δ͜ ͱͰσʔλ෼ੳͰ࢖͏͜ͱ͕Ͱ͖ɺ͔ͭ௕ ظʹΘͨͬͯ׆༻Ͱ͖Δɻ ᶃσʔλϕʔε΍ςʔϒϧͳͲ σʔλߏ଄ͷཧղ͕Ͱ͖Δ ᶄ৬छʹ͔͔ΘΒ࣮ͣ຿Ͱ෯޿ ͘׆༻Ͱ͖Δ ᶅֶशίετ͕௿͘Ұ౓֮͑Δ ͱ௕ظͰ࢖͑ΔεΩϧ σʔλ෼ੳʹ͓͍ͯ࠷΋ॏཁͳεΩϧͷ͕ͭ42-ɻ42-͕࢖͑ΔΑ͏ʹͳΔ͜ͱͰσʔλͷߏ଄ Λཧղ͠σʔλʹج͍ͮͨҙࢥܾఆ͕Ͱ͖ΔΑ͏ʹͳΔɻ

Slide 9

Slide 9 text

Slide 10

Slide 10 text

© )JLBSV5BLBIBTIJ σʔλ෼ੳͰ࢖͏42-ͷಛ௃ ᶃσʔλϕʔε΍ςʔϒϧͳͲσʔλߏ଄ͷཧղ͕Ͱ͖Δ 42- VTFS@JE HFOEFS CJSUI " உੑ ࣮ߦ݁Ռ 4&-&$5'30.VTFST 8)&3&VTFS@JEb"` σʔλϕʔε ςʔϒϧ VTFS@JE HFOEFS CJSUI " உੑ " ঁੑ ɾɾɾ ɾɾɾ ɾɾɾ QSPEVDU@JE QSPEVDU@OBNF QSJDF # ͓͍͍͠ਫ # γϟʔϓϖϯ ɾɾɾ ɾɾɾ ɾɾɾ 42-͸ デ ʔλ ベ ʔε্ͷςʔ ブ ϧʹ֨ೲ͞Εͨ デ ʔλΛऔಘ͢Δͱ͖ʹ࢖͏ݴޠɻ42-Λֶश͢Δ ͜ͱͰσʔλϕʔε΍ςʔϒϧͳͲͷσʔλ෼ੳͰॏཁͳ֓೦ΛֶͿࣄ͕Ͱ͖Δɻ Ϣʔβʔ ྻ ߦ

Slide 11

Slide 11 text

© )JLBSV5BLBIBTIJ σʔλ෼ੳʹ͓͍ͯʰ42-ʱͷֶश͕zηϯλʔϐϯzͰ͋Δ ᶃσʔλϕʔε΍ςʔϒϧͳͲσʔλߏ଄ͷཧղ͕Ͱ͖Δ 42- EBUBCBTF #* ࿦ཧతࢥߟྗ UBCMF SPXEBUB ౷ܭֶ ίϛϡχέʔγϣϯ ػցֶश &YDFM ਺஋ཧղ ϏδωεεΩϧ ςΫχΧϧεΩϧ 42-Λֶश͢Δ͜ͱͰ࿦ཧతࢥ ߟྗ͕͖ͭɺ਺஋ཧղͳͲͷϏ δωεεΩϧ޲্͕ݟࠐΊΔɻ ·ͨ42-ͷ஌͕ࣝ͋Δ͜ͱͰΤ ϯδχΞͱͷίϛϡχέʔγϣ ϯ͕εϜʔζʹͳΔϝϦοτ΋ ͋Δɻ 42-Λֶश͢Δ͜ͱͰσʔλ ϕʔεͷ஌ࣝ΍ςʔϒϧͷ஌ࣝ ΋߹ΘͤͯशಘͰ͖ΔɻͦΕʹ Αͬͯσʔλߏ଄ͷཧղ͕ਂ· ΓɺσʔλΛѻ͍΍͘͢ͳΔɻ ·ͨ42-͕࢖͑Δͱ#*πʔϧͳ Ͳ΋ѻ͍΍͘͢ͳΔͨΊՄࢹԽ ΋ؚΊͨσʔλ෼ੳ͕Մೳɻ 42-Λֶश͢Δ͜ͱͰσʔλߏ଄ͷཧղ͕ਂ·Γ͞·͟·ͳσʔλ෼ੳʹඞཁͳεΩϧΛऔಘ͢Δ ͖͔͚ͬͱͳΔɻͦͷͨΊσʔλ෼ੳྗΛߴΊΔηϯλʔϐϯͱͯ͠42-͕ଘࡏ͢Δɻ

Slide 12

Slide 12 text

Slide 13

Slide 13 text

© )JLBSV5BLBIBTIJ 42-Λ਎ʹ͚ͭΔ͜ͱͰ৬छΛ໰Θͣ෯޿͘׆༻͕Ͱ͖Δɻ͔ͩΒͦ͜શͯͷϏδωεύʔιϯ͕ ֶͿ͜ͱͰۀ຿ʹޮՌΛൃش͢Δࣄ͕Ͱ͖Δɻ σʔλ෼ੳྗΛߴΊΔͨΊͷ಺੡Խ͕ॏཁ ᶄ৬छʹ͔͔ΘΒ࣮ͣ຿Ͱ෯޿͘׆༻Ͱ͖Δ 42- ༷ʑͳ৬छͰ࣮຿ͱ ͯ͠׆༻͠΍͍͢ ϚʔέςΟϯά σʔλΞφϦετ ܦӦاը Ӧۀ w &$αΠτͷߦಈ෼ੳ w ސ٬ͷߪങ෼ੳ w ޿ࠂ΍ΩϟϯϖʔϯͷޮՌݕূ w ೥౓ผച্ w ࢛൒ظ͝ͱͷച্ w ސ٬ηάϝϯτ෼ੳ w %8)͔ΒσʔλΛநग़ w #*πʔϧ͔Βσʔλ઀ଓ w σʔλͷલॲཧ w ചΕے঎඼ͷ෼ੳ w ੒໿݅਺෼ੳ w ஍Ҭผ෼ੳ

Slide 14

Slide 14 text

© )JLBSV5BLBIBTIJ 42-ͷ׆༻͕ਁಁ͍ͯ͠ΔςοΫاۀ ᶄ৬छʹ͔͔ΘΒ࣮ͣ຿Ͱ෯޿͘׆༻Ͱ͖Δ ࣾһͷ໿ׂ͕42-Λ࢖͍ͬͯΔ ਓதਓ͕#JH2VFSZΛ࢖͍ͬͯΔʢ˞೥࣌఺ʣ ࣾһͷ໿ׂ͕42-Λ࢖͍ͬͯΔ ΤϯδχΞҎ֎ʹ΋ϓϩδΣΫτϚωʔδϟʔ΍Χελ Ϛʔαϙʔτ΋ࣗΒσʔλϕʔεΛ৮ΔɻඇΤϯδχΞ Ͱ΋42-จΛࣗΒୟ͘จԽ͕ਁಁ͍ͯ͠Δɻ Ϛʔέλʔʹ͸େྔσʔλΛૢΔ42-εΩϧͱ౷ܭֶͷ ஌͕ࣝඞਢͱ͍͏จԽɻͦΕҎ֎ʹ΋޿ใ΍αϙʔτ୲ ౰ࣾһͰ΋42-͕࢖͑Δͷ͕౰ͨΓલͷঢ়ଶɻ IUUQTXXXCVTJOFTTJOTJEFSKQQPTU IUUQTNBSLF[JOFKQBSUJDMFEFUBJM ࢀߟ IUUQTGPSCFTKBQBODPNBSUJDMFTEFUBJM ࢀߟ ʻ42-ͷ׆༻͕ࣾ಺ʹਁಁ͍ͯ͠Δࣄྫʼ ٸ੒௕͍ͯ͠ΔςοΫاۀͰ͸42-Λ࢖͑Δਓࡐ͕ଟ͍ɻΤϯδχΞͰͳͯ͘΋42-Λ࢖͏͜ͱ Ͱձࣾͱͯ͠σʔλυϦϒϯͳ૊৫ʹ͍͍ۙͮͯΔɻ

Slide 15

Slide 15 text

Slide 16

Slide 16 text

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

Slide 17

Slide 17 text

© )JLBSV5BLBIBTIJ ᶅֶशίετ͕௿͘Ұ౓֮͑Δͱ௕ظͰ࢖͑ΔεΩϧ σʔλ෼ੳͰ࢖͏ʰ42-ʱ͸ֶशޮ཰͕ྑ͍ ׆ ༻ ͷ ෯ ͕ ڱ ͍ ׆ ༻ ͷ ෯ ͕ ޿ ͍ ֶशίετ͕௿͍ ֶशίετ͕ߴ͍ 42- Ұൠతͳϓϩάϥϛϯά ݴޠʹൺ΂ֶͯशίετ ͕௿͘ɺҰ౓ֶश͢Ε͹ ௕ظؒ࢖͑ΔεΩϧͱ͠ ͯ໾ཱͭ शಘͰ͖Ε͹σʔλ෼ੳ ΍ιϑτ΢ΣΞ։ൃͳͲ ෯޿͘࢖͑ΔϝϦοτ͸ ͋Δֶ͕शίετ͕ඇৗ ʹߴ͍ Ұൠతͳ ϓϩάϥϛϯάݴޠ ୭Ͱ΋ѻ͍΍͘͢σʔλ ෼ੳͰ΋׆༻Ͱ͖Δ͕ɺ ѻ͑Δσʔλͷྔʹݶք ͕͋Γෳࡶͳ෼ੳ͕͠ʹ ͍͘ &YDFM 42-͸ϓϩάϥϛϯάݴޠʹൺ΂ֶͯशίετ͕௿͘ɺ&YDFMΑΓ΋׆༻ͷ෯͕޿͍ɻͭ·Γ਺͋ Δσʔλ෼ੳεΩϧͷதͰ42-͕࠷΋ֶशޮ཰͕ྑ͍ɻ

Slide 18

Slide 18 text

© )JLBSV5BLBIBTIJ σʔλ෼ੳʹ͓͚Δ42-ͷඞཁੑ ᶅֶशίετ͕௿͘Ұ౓֮͑Δͱ௕ظͰ࢖͑ΔεΩϧ σʔλ෼ੳ؀ڥʹ͓͍ͯطଘͷσʔλϕʔεʢ%8)ʣ͔ΒσʔλΛऔಘ͢Δ৔߹΍ɺ#*Λ࢖ͬͯ σʔλΛՄࢹԽ͢Δ৔߹ͳͲɺσʔλ෼ੳʹ͓͍ͯ42-ͷ׆༻͸ඞਢʹͳΔɻ 5BCMFBV 1PXFS#* -PPLFS 4UVEJP %0.0 2MJDL 4FOTF (PPHMF #JH2VFSZ "NB[PO 3FETIJGU 3FEBTI 4OPX fl BLF "[VSF4ZOBQTF "OBMZUJDT %##SPXTFS GPS42-JUF %#FBWFS %#1JMPU 4FRVFM1SP .Z42- 8PSLCFODI .Z42- 1PTUHSF42- 0SBDMF 42-JUF %VDL%# #* 42-$MJFOU %8) %BUBCBTF 42- 42- 42-

Slide 19

Slide 19 text

Slide 20

Slide 20 text

© )JLBSV5BLBIBTIJ σʔλ෼ੳͰ࢖͏42-ͷֶशํ๏ 42-ͷֶशํ๏ σʔλ෼ੳͰ࢖͏42-ͷجૅ͸୹࣌ؒͰֶशՄೳɻ·ͣ͸جૅతͳ42-ͷߏจΛ֮͑ͯɺ͋ͱ͸ࣗ ෼Ͱ42-Λॻ͍࣮ͯ຿Ͱ࢖͑ΔΑ͏ʹԿ౓΋Կ౓΋܁Γฦ͢͜ͱ͕ॏཁɻ 42-Λ֮͑ΔͨΊʹ͸ࣗ෼Ͱ 42-Λॻ͍࣮ͯߦ͢Δ͜ͱͰ ΠϯϓοτͱΞ΢τϓοτΛҙ ࣝ͠ͳ͕Βֶश͢Δͷ͕ޮ཰త ·ͣ͸جຊతͳ42-ͷߏจΛֶ Ϳɻσʔλ෼ੳͰΑ͘࢖͏ߏจ ͸ͦΜͳʹଟ͘ͳ͍ͷͰ୹࣌ؒ ͰΠϯϓοτ ׳Ε͖ͯͨΒඞཁԠͯ͡Ԡ༻త ͳ42-ߏจʢXJOEPXؔ਺΍૬ ؔαϒΫΤϦͳͲʣΛֶͿ ࣮ࡍͷ࢓ࣄͷதͰ42-Λ࢖ͬͨ σʔλ෼ੳΛ΍ͬͯΈΔɻ࢓ࣄͰ Ͱ͖ͳ͚Ε͹ΦʔϓϯσʔλͳͲ Λ׆༻ͯࣗ͠෼Ͱ෼ੳΛͯ͠ΈΔ ߏจΛ ֶͿ 42-Λ ࣮ߦ͢Δ ࣮ફͰ ࢖͏

Slide 21

Slide 21 text

Slide 22

Slide 22 text

Slide 23

Slide 23 text

© )JLBSV5BLBIBTIJ ຊॻͷಛ௃ 42-ͷֶशํ๏ Ұൠతͳ42-ͷೖ໳ॻ͸ΤϯδχΞΛର৅ʹ͍ͯ͠Δ಺༰͕ଟ͘ϘϦϡʔϜ΋ଟ͍ɻϋϯζΦϯܗ ࣜͰޮ཰Α͘σʔλ෼ੳͰ࢖͏42-ʹಛԽֶͯ͠΂Δͷ͕ຊॻͷಛ௃ɻ ຊॻ Ұൠతͳ42-ೖ໳ॻ σʔλ෼ੳ༻ͷ42-ຊ ର৅ऀ Ϗδωεύʔιϯ ΤϯδχΞ Ϗδωεύʔιϯ ຊͷ಺༰ σʔλ෼ੳ ΞϓϦέʔγϣϯ։ൃ σʔλ෼ੳ ຊͷಛ௃ ϋϯζΦϯܗࣜͰ࣮຿ͷσʔλ෼ ੳͰΑ͘࢖͏ߏจʹಛԽ ໢ཏతʹ42-ͷߏจΛઆ໌ ϋϯζΦϯܗࣜʹͳ͍ͬͯͳ͍ ໢ཏతʹ42-ͷߏจΛઆ໌ ϖʔδ਺ ʙ ʙ

Slide 24

Slide 24 text

© )JLBSV5BLBIBTIJ ͦͷଞͷ͓͢͢Ίͷຊͱֶशͷεςοϓ 42-ͷֶशํ๏ ຊॻ͸σʔλ෼ੳͰ࢖͏42-ΛֶͿࡍͷ࠷ॳͷ࡭ͱ͓ͯ͢͢͠Ίɻ͞Βʹਂֶ͘श͍ͨ͠৔߹͸ ΑΓৄࡉʹॻ͔Ε͍ͯΔຊͰֶशՄೳɻ໨తʹԠͯ͡ෳ਺ಡΉͷ͕͓͢͢Ίɻ 42-ͷجૅΛֶश 42-ͷجૅ࣮ફΛֶश ෼ੳͷԠ༻Λֶश IUUQTXXXBNB[PODPKQEQ IUUQTXXXBNB[PODPKQ EQ IUUQTXXXBNB[PODPKQ EQ IUUQTXXXBNB[PODPKQ EQ9 IUUQTXXXBNB[PODPKQ EQ ྔ ೉ қ ౓ ର ৅ 1 1 1 1 1 ௿ த த த ߴ Ϗδωεύʔιϯ σʔλΤϯδχΞ Ϗδωεύʔιϯ σʔλΤϯδχΞ ˒ˑˑ ˒˒ˑ ˒˒ˑ ˒˒ˑ ˒˒˒ ˒ˑˑ ˒˒ˑ ˒˒˒ ˒˒˒ ˒˒˒

Slide 25

Slide 25 text

Slide 26

Slide 26 text

Slide 27

Slide 27 text

Slide 28

Slide 28 text

Slide 29

Slide 29 text

Slide 30

Slide 30 text

Slide 31

Slide 31 text

© )JLBSV5BLBIBTIJ 42-ݚमʢ42-&WFSZPOFʣͷ಺༰ σʔλ෼ੳྗΛߴΊΔ42-ݚमʹ͍ͭͯ σʔλ෼ੳʹඞཁͳ42-Λجૅ͔ΒֶͿɻσʔλ෼ੳʹඞཁͳ42-͸ΤϯδχΞ͕ΞϓϦέʔ γϣϯ։ൃͰ࢖͏42-ΑΓ΋ֶश೉қ౓͕௿͘جૅֶशͰ࣮ફ·Ͱ࢖͑ΔεΩϧ͕ಘΒΕΔɻ 4&-&$5 -*.*5 03%&3#: (3061#: %*45*/$5 8)&3& )"7*/( +0*/ 6/*0/ $"4& 8*5) σʔλ෼ੳʹඞཁͳ42-ͷجૅΛֶश θϩϕʔεͰͷֶशͳͷͰࣄલ஌ࣝෆཁͰඇΤϯδχΞͰ΋ֶशՄೳ $06/5

Slide 32

Slide 32 text

© )JLBSV5BLBIBTIJ 42-ݚमʢ42-&WFSZPOFʣͷର৅اۀʢର৅ऀʣ σʔλ෼ੳྗΛߴΊΔ42-ݚमʹ͍ͭͯ σʔλ෼ੳ૊৫͕͋Δاۀ͸΋ͪΖΜɺ͜Ε͔Βσʔλ෼ੳ૊৫Λ࡞Ζ͏ͱࢥ͍ͬͯΔاۀͳͲશ ͯͷϏδωεύʔιϯ͕ର৅ɻ ͳͲͳͲ ର৅اۀ ର৅ऀ σʔλ෼ੳ૊৫͸͋Δ͕ɺ42-Λ࢖͑Δਓࡐͷҭ੒͕Ͱ͖͍ͯͳ͍اۀ ͜Ε͔Βσʔλ෼ੳ૊৫Λ࡞Ζ͏ͱ͓ͯ͠Γɺσʔλ෼ੳਓࡐͷҭ੒͕ඞཁͳاۀ ΋ͬͱޮ཰తʹσʔλ׆༻Λݕ౼͍ͨ͠اۀɻσʔλ෼ੳΛ಺੡Խ͍ͨ͠اۀ 42-ॳֶऀʢ৽ೖࣾһɺϚʔέλʔɺӦۀɺσʔλΞφϦετɺίʔϙϨʔτʣ ˞ΤϯδχΞ͕ΞϓϦέʔγϣϯ։ൃͰ࢖͏42-Ͱ͸ͳ͘ɺ͋͘·Ͱσʔλ෼ੳͰ࢖͏42-ͷֶशΛର৅ͱ͍ͯ͠·͢ɻ

Slide 33

Slide 33 text

© )JLBSV5BLBIBTIJ 42-ݚमʢ42-&WFSZPOFʣϓϥϯ σʔλ෼ੳྗΛߴΊΔ42-ݚमʹ͍ͭͯ 42-ݚमϓϥϯ͸ඪ४ϓϥϯͱΧελϚΠζϓϥϯͷύλʔϯɻඪ४ϓϥϯ͸ࣗ਎͕ग़൛ͨ͠ຊ Λڭࡐʹͨ͠ݚमɻΧελϚΠζϓϥϯ͸اۀ༷ͷ؀ڥʹ߹ΘͤͨڭࡐΛݕ౼ɻ ඪ४ϓϥϯ ΧελϚΠζϓϥϯ ର৅ 42-ॳֶऀ 42-ॳֶऀ ڭࡐ ຊ ʢσʔλ෼ੳྗΛߴΊΔϏδωεύʔιϯͷͨΊͷ42-ೖ໳ʣ اۀ༷ͷ؀ڥʹ߹ΘͤͯΧελϚΠζ ܗࣜ ΦϯϥΠϯΦϑϥΠϯ ΦϯϥΠϯΦϑϥΠϯ ࣌ؒ ࣌ؒʙ࣌ؒ ʢ˞χʔζʹ߹Θͤͯ૿ݮՄೳʣ ཁ૬ஊ ਓ਺ ੍ݶͳ͠ ੍ݶͳ͠ ࣄޙ ϲ݄ؒͷΞϑλʔϑΥϩʔ ʢ࠷ऴडߨޙϲ݄ؒ͸42-ʹؔ͢Δ࣭໰ʹճ౴ʣ ϲ݄ЋͷΞϑλʔϑΥϩʔ ֹۚ ཁ૬ஊ ཁ૬ஊ ˞ֹۚʹؔͯ͠͸ʮਓࡐ։ൃࢧԉॿ੒ۚʯ΍ʮ%9ϦεΩϦϯάॿ੒ۚʯΛ׆༻ͯ͠཈͑Δ͜ͱ͕Ͱ͖Δ৔߹͕͋Γ·͢ɻ

Slide 34

Slide 34 text

© )JLBSV5BLBIBTIJ 42-ݚमʢ42-&WFSZPOFʣͷֶशྫ σʔλ෼ੳྗΛߴΊΔ42-ݚमʹ͍ͭͯ 42-ͷجૅཧղ͔Βελʔτ͢ΔɻϋϯζΦϯܗࣜͰͷݚमͷͨΊ1$Ͱ42-Λ࣮ߦ͢ΔͨΊͷ؀ ڥߏஙΛߦ͏ɻͦͷޙɺઆ໌ͱԋशͰ42-Λ࣮ߦ͠ͳ͕ΒֶशΛਐΊ͍ͯ͘ɻ ˞ελϯμʔυϓϥϯͷྫɻ࣌ؒ΍ݚम಺༰ʹ͍ͭͯ΋ΧελϚΠζՄೳͰ͢ɻ 45&1 45&1 45&1 σʔλ෼ੳ͕ॏཁͳཧ༝ σʔλ෼ੳʹ͓͚Δ42-ͱ͸ 42-ͷجຊతͳ֓೦ 42-֓ཁઆ໌ 42-؀ڥߏங 42-JUFΛ࢖ͬͨσʔλ෼ੳ؀ڥ 42-࣮ߦͷͨΊͷ؀ڥߏங 42-࣮ߦπʔϧͷ࢖͍ํ 42-ߏจͷཧղ 4&-&$5 -*.*5 03%&3#: ू໿ؔ਺ (3061#: %*45*/$5 8)&3& )"7*/( +0*/ 6/*0/ $"4& αϒΫΤϦ 8*5) ໿࣌ؒ ໿࣌ؒ ໿࣌ؒ આ໌ԋश جૅ͔Β࣮ફ·Ͱֶश

Slide 35

Slide 35 text

© )JLBSV5BLBIBTIJ 42-ݚमʢ42-&WFSZPOFʣͷͭͷಛ௃ σʔλ෼ੳྗΛߴΊΔ42-ݚमʹ͍ͭͯ σʔλ෼ੳʹಛԽͨ͠42-ݚमΛϋϯζΦϯܗࣜͰ࣮ࢪɻ୯७ʹઆ໌Λฉ͚ͩ͘Ͱ͸ͳࣗ͘͝਎ͷ 1$Ͱ42-Λ࣮ߦͯ͠ΠϯϓοτͱΞ΢τϓοτΛ࣮ײ͠ͳ͕ΒֶशΛਐΊΔɻ ͨͩઆ໌Λฉ͚ͩ͘Ͱ͸ͳ͘1$Ͱ42-Λ࣮ߦͰ͖Δ؀ڥΛ༻ҙ࣮ͯ͠ࡍʹ 42-Λ࣮ߦ͠ͳ͕ΒਐΊΔɻʢ؀ڥߏங΋αϙʔτʣ ࣭ٙԠ౴ʹ౴͑ͳ͕Βෆ໌఺͕͋Ε͹ͦͷ৔ͰαϙʔτɻҰํతʹͳΒͣʹΠϯ λϥΫςΟϒʹֶशɻݚमޙͷΞϑλʔϑΥϩʔ΋࣮ࢪɻ σʔλ෼ੳʹಛԽͨ͠42-ݚमʹ͢Δ͜ͱͰ୹ظؒͰֶश͕Մೳɻߨࢣͷ࣮ ମݧΛ΋ͱʹ࣮ࡍͷσʔλ෼ੳͰ࢖͏42-ͷ5JQTͳͲ΋ࠞͥͳ͕Βֶशɻ

Slide 36

Slide 36 text

© )JLBSV5BLBIBTIJ 42-ݚमʢ42-&WFSZPOFʣͷΰʔϧ σʔλ෼ੳྗΛߴΊΔ42-ݚमʹ͍ͭͯ 42-ݚमͷΰʔϧ͸࣮຿ͷσʔλ෼ੳͰ42-Λ࢖͑ΔΑ͏ʹͳΔ͜ͱɻͦͷͨΊʹϋϯζΦϯܗࣜ Ͱ࣮ࢪͯ͠ɺ࣮ࡍͷσʔλ෼ੳۀ຿Λҙࣝ͠ͳ͕ΒਐΊΔɻ·ͨܧଓతͳֶशࢧԉ΋Մೳɻ ܧଓతͳֶशʹΑ࣮ͬͯ຿ͷσʔλ෼ੳͰ42-͕࢖͑ΔΑ͏ʹͳΔ ʢݚमऴྃޙͷ಺੡Խʹ޲͚ͨࢧԉ΋࣮ࢪՄೳʣ ຊݚमΛ௨ͯ͠ɺσʔλ෼ੳͰ࢖͏42-Λ࣮ࡍʹମײͯ͠΋Β ͍ɺ42-͸ܾͯ͠೉͘͠ͳ͍͜ͱΛཧղͯ͠΋Β͏ ࣮຿ͷதͰܧଓతʹ42-Λ׆༻͢Δ͖͔͚ͬͱ͢Δ

Slide 37

Slide 37 text

ʰશͯͷਓʹσʔλ෼ੳྗΛʱ SQL Everyone

Slide 38

Slide 38 text

ແྉ૬ஊͷ͓໰͍߹Θͤ IUUQTGPSNTHMFXRG[G-NV/BLB[ MJHIU IUIJLBSVUBLBIBTIJ!HNBJMDPN