ビジネスサイドのためのSQL入門

ϏδωεαΠυͷͨΊͷ 42-ೖ໳ 'JOEZക઒ ˞ઐ໳తͳํʑ͔Βͷࡉ͔͍͝ࢦఠ͸͝༰͍ࣻͩ͘͞ɺɺɺX

Ε֮͑͑͞Ε͹ ͜ #JH2VFSZ౳Ͱ͍͍ͩͨཉ͍͠ σʔλͷࢀরूܭ͕Ͱ͖·͢

ͱ͑͹ ͨ TFMFDU [JQ@DPEFTQSFGFDUVSF@DPEF [JQ@DPEFTDJUZ@OBNF DBTFXIFOUBCMF$7਺JTOPUOVMMUIFOTVN UBCMF$7਺ XIFOUBCMF$7਺JTOVMMUIFOFOEBT݅਺ $7݄
GSPN[JQ@DPEFTMFGUKPJO TFMFDUDBTFXIFOOFX@[JQ@DPEFJTOPUOVMMUIFOOFX@[JQ@DPEF XIFOOFX@[JQ@DPEFJTOVMMUIFO[JQ@DPEFFOEBT༣ศ൪߸ QSFGFDUVSF@DPEFBT౎ಓ෎ݝ DPVOU OBNF BT$7਺ TVCTUSJOH@JOEFY DSFBUFE@BU BT$7݄ GSPNDPOUBDUT XIFSFQSFGFDUVSF@DPEFJO PSOFX@QSFGFDUVSF@DPEFJO BOEDSFBUFE@BUCFUXFFOBOE HSPVQCZ༣ศ൪߸ $7݄ BTUBCMF PO[JQ@DPEFT[JQ@DPEFUBCMF༣ศ൪߸DPMMBUFVUG@HFOFSBM@DJ XIFSF[JQ@DPEFTQSFGFDUVSF@DPEFJO HSPVQCZ[JQ@DPEFTDJUZ@OBNF $7݄ PSEFSCZ݅਺EFTD MJNJU ˡͨͱ͑͹ɺ͜Μͳײ͡Ͱॻ͘ͱ ๲େͳϢʔβʔσʔλ͔Β ΤϯδχΞʹґཔ͠ͳͯ͘΋ ࢢ۠ொଜ͝ͱͷ ݄ผͷ ݅਺ਪҠ͕ग़ͤͨΓ͠·͢ ੜσʔλΛࣗ෼Ͱ޷͖ʹՃ޻Ͱ͖ΔΑ͏ʹͳΔ

2-ͷצॴ 4 42-͸จষߏ଄೺Ѳͱ ςʔϒϧߏ੒ͷ೺Ѳ͕͢΂ͯ

4 جຊจষߏ଄ 4FMFDU˔˔˔˔Λࢀর͢Δ ɹˠͲͷΧϥϜΛࢀর͢Δ 'SPN˙˙˙˙͔Β ɹˠͲͷςʔϒϧ͔Β " # ςʔϒϧB 4FMFDU"
# 'SPNςʔϒϧB ςʔϒϧB͔Β" #Λࢀর͢Δ 2-ͷצॴ

2-ͷจষߏ଄ 4 ଟͯ͘΋͜ͷ̒෼ྨʹऩ·Δ 4FMFDU˔˔ ˔˔Λࢀর͢Δ 'SPN˙˙ ˙˙͔Β 8IFSF˛˛ ˛˛ͷ৔߹ʹ (SPVQCZ˗˗
˗˗Ͱ·ͱΊΔ ूܭ͢Δ 0SEFSCZ˘˘ ˘˘Ͱฒ΂Δ MJNJU✖✖ ✖✖݅·Ͱ

2-ʙΤΫηϧʹஔ͖׵͑Δͱ 4 4FMFDU˔˔ ྻΛඇදࣔʹ͢Δ 'SPN˙˙ Ͳͷγʔτ͔ 8IFSF˛˛ ΦʔτϑΟϧλ (SPVQCZ˗˗ TVNJG
DPVOUJG 0SEFSCZ˘˘ ঢॱɺ߱ॱ MJNJU✖✖ Կߦ໨Ҏ߱ඇදࣔʹ͢Δ શવ೉͍͜͠ͱ΍ͬͯͳ͍

2-ͷߏจ 4 ͓֮͑ͯ͘ͱศར 8IFSFzΧϥϜ໊z `"` ϑΟʔϧυ͕"ͷ৔߹ MJLF"#$ ϑΟʔϧυ͕"ͷจࣈྻؚ͕·Ε͍ͯΔ ৔߹ JO
" # $ ϑΟʔϧυ͕"PS#PS$ͷ৔߹ CFUXFFO`"`BOE`#` ϑΟʔϧυ͕"ʙ#ͷؒͷ৔߹ `"` ϑΟʔϧυ͕"Ҏ֎ͷ৔߹ ʙɹBOEʙ ͦͷ·· ʙɹPSʙ ͦͷ·· 0SEFSCZzΧϥϜ໊z EFTD ߱ॱ BTD ঢॱ

/P ళฮ໊ ୲౰ऀ ച্ ඼໊ ौ୩ ࢁా "
ޒ൓ా ࠤ౻ # ৽ڮ ླ໦ # ޒ൓ా ക઒ " ޒ൓ా ക઒ # 4 4FMFDU 4FMFDU 4FMFDUళฮ໊ TVN ച্ 'SPNςʔϒϧB 8IFSFച্ (SPVQCZళฮ 0SEFSCZച্EFTD -JNJU 2-ͷΠϝʔδ 'SPNςʔϒϧB 8IFSF /P ళฮ໊ ച্ ޒ൓ా ौ୩ (SPVQCZ ళฮ͝ͱʹूܭ 0SEFSCZച্େ͖͍ॱ -JNJUߦ·Ͱදࣔ͢Δ

/P ళฮ໊ ୲౰ऀ ച্ ඼໊ ौ୩ ࢁా "
ޒ൓ా ࠤ౻ # ৽ڮ ླ໦ # ޒ൓ా ക઒ " ޒ൓ా ക઒ # 4 4FMFDU 4FMFDU 2-ͷΠϝʔδ 'SPNςʔϒϧB 8IFSF /P ళฮ໊ ച্ ޒ൓ా ौ୩ (SPVQCZ ళฮ͝ͱʹूܭ 4FMFDU 'SPN 8IFSF (SPVQCZ 0SEFSCZ -JNJU ళฮ໊ͱച্ ςʔϒϧB͔Β ച্͕ԁҎ্ ళฮ͝ͱʹूܭ େ͖͍ॱʹฒͼସ͑ ߦ·Ͱදࣔ ݴ༿Ͱ੔ཧ͢Δͱ 0SEFSCZച্େ͖͍ॱ -JNJUߦ·Ͱදࣔ͢Δ

2-ʙྫ 4 TFMFDU [JQ@DPEFTQSFGFDUVSF@DPEF [JQ@DPEFTDJUZ@OBNF DBTFXIFOUBCMF$7਺JTOPUOVMMUIFOTVN UBCMF$7਺ XIFOUBCMF$7਺JTOVMMUIFOFOEBT݅਺ $7݄
GSPN[JQ@DPEFTMFGUKPJO TFMFDUDBTFXIFOOFX@[JQ@DPEFJTOPUOVMMUIFOOFX@[JQ@DPEF XIFOOFX@[JQ@DPEFJTOVMMUIFO[JQ@DPEFFOEBT༣ศ൪߸ QSFGFDUVSF@DPEFBT౎ಓ෎ݝ DPVOU OBNF BT$7਺ TVCTUSJOH@JOEFY DSFBUFE@BU BT$7݄ GSPNDPOUBDUT XIFSFQSFGFDUVSF@DPEFJO PSOFX@QSFGFDUVSF@DPEFJO BOEDSFBUFE@BUCFUXFFOBOE HSPVQCZ༣ศ൪߸ $7݄ BTUBCMF PO[JQ@DPEFT[JQ@DPEFUBCMF༣ศ൪߸DPMMBUFVUG@HFOFSBM@DJ XIFSF[JQ@DPEFTQSFGFDUVSF@DPEFJO HSPVQCZ[JQ@DPEFTDJUZ@OBNF $7݄ PSEFSCZ݅਺EFTD MJNJU

4 TFMFDU [JQ@DPEFTQSFGFDUVSF@DPEF [JQ@DPEFTDJUZ@OBNF DBTFXIFOUBCMF$7਺JTOPUOVMMUIFOTVN UBCMF$7਺ XIFOUBCMF$7਺JTOVMMUIFOFOEBT݅਺ $7݄ GSPN[JQ@DPEFTMFGUKPJO
TFMFDUDBTFXIFOOFX@[JQ@DPEFJTOPUOVMMUIFOOFX@[JQ@DPEF XIFOOFX@[JQ@DPEFJTOVMMUIFO[JQ@DPEFFOEBT༣ศ൪߸ QSFGFDUVSF@DPEFBT౎ಓ෎ݝ DPVOU OBNF BT$7਺ TVCTUSJOH@JOEFY DSFBUFE@BU BT$7݄ GSPNDPOUBDUT XIFSFQSFGFDUVSF@DPEFJO PSOFX@QSFGFDUVSF@DPEFJO BOEDSFBUFE@BUCFUXFFOBOE HSPVQCZ༣ศ൪߸ $7݄ BTUBCMF PO[JQ@DPEFT[JQ@DPEFUBCMF༣ศ൪߸DPMMBUFVUG@HFOFSBM@DJ XIFSF[JQ@DPEFTQSFGFDUVSF@DPEFJO HSPVQCZ[JQ@DPEFTDJUZ@OBNF $7݄ PSEFSCZ݅਺EFTD MJNJU 4FMFDU 'SPN 8IFSF (SPVQCZ 0SEFSCZ -JNJU 2-ʙྫ

4 TFMFDU TVCTUSJOH@JOEFY DSFBUFE@BU JOUFSWBMIPVS
BTDW@ZFBS TVCTUSJOH@JOEFY TVCTUSJOH@JOEFY DSFBUFE@BU JOUFSWBMIPVS BTDW@NPOUI TVCTUSJOH@JOEFY TVCTUSJOH@JOEFY DSFBUFE@BU JOUFSWBMIPVS BTDW@EBUF TVCTUSJOH@JOEFY TVCTUSJOH@JOEFY DSFBUFE@BU JOUFSWBMIPVS JOUFSWBM 8&&,%":DSFBUFE@BU JOUFSWBM IPVS IPVS BTDW@XFFL TVCTUSJOH@JOEFY TVCTUSJOH@JOEFY DSFBUFE@BU JOUFSWBMIPVS BTDW@NPOUI@EBUF DPVOU BT$7਺ DPVOU DBTFXIFOMFBE@DPOUBDUT@WJFX֬ఆεςʔλεJTOPUOVMMUIFO XIFOTUBUVTPSTUBUVTUIFO XIFOTUBUVT@SFBTPOBOETUBUVT@SFBTPOUIFO FMTFFOE PSOVMM DPVOU BT༗ޮ཰ DPVOU DBTFXIFOMFBE@DPOUBDUT@WJFX֬ఆεςʔλεJTOPUOVMMUIFO XIFOTUBUVTPSTUBUVTUIFO XIFOTUBUVT@SFBTPOBOETUBUVT@SFBTPOUIFO FMTFFOE PSOVMM BT༗ޮ਺ DPVOU DBTFXIFOMFBE@DPOUBDUT@WJFX֬ఆεςʔλεJTOPUOVMMUIFOFMTFFOE PSOVMM DPVOU DBTFXIFOMFBE@DPOUBDUT@WJFX֬ఆεςʔλεJTOPUOVMMUIFO XIFOTUBUVTPSTUBUVTUIFO XIFOTUBUVT@SFBTPOBOETUBUVT@SFBTPOUIFO FMTFFOE PSOVMM BTૹ٬཰ DPVOU DBTFXIFOMFBE@DPOUBDUT@WJFX֬ఆεςʔλεJTOPUOVMMUIFOFMTFFOE PSOVMM BTૹ٬਺ TVN ࿈བྷࡁΈPSOVMM DPVOU DBTFXIFOMFBE@DPOUBDUT@WJFX֬ఆεςʔλεJTOPUOVMMUIFOFMTFFOE PSOVMM BT࿈བྷ཰ TVN ࿈བྷࡁΈPSOVMM BTA࿈བྷࡁΈA DPVOU ๚໰༧ఆ೔PSOVMM DPVOU DBTFXIFOMFBE@DPOUBDUT@WJFX֬ఆεςʔλεJTOPUOVMMUIFOFMTFFOE PSOVMM BTA๚໰཰A DPVOU ๚໰༧ఆ೔PSOVMM BTA๚໰༧ఆ਺A DPVOU ޻ࣄ༧ఆ೔PSOVMM BTA޻ࣄड஫਺A DPVOU ޻ࣄ׬ྃ೔PSOVMM BTA੒໿A DPVOU DBTFXIFOMFBE@DPOUBDUT@WJFX֬ఆεςʔλεJTOPUOVMMUIFOFMTFFOE PSOVMM DPVOU BT$7ˠૹ٬཰ DPVOU ๚໰༧ఆ೔PSOVMM DPVOU DBTFXIFOMFBE@DPOUBDUT@WJFX֬ఆεςʔλεJTOPUOVMMUIFO XIFOTUBUVTPSTUBUVTUIFO XIFOTUBUVT@SFBTPOBOETUBUVT@SFBTPOUIFO FMTFFOE PSOVMM BT༗ޮˠ๚໰཰ GSPNDPOUBDUT MFGUKPJOMFBE@DPOUBDUT@WJFX POJEMFBE@DPOUBDUT@WJFXDPOUBDU@JE XIFSFDSFBUFE@BU JOUFSWBMIPVS HSPVQCZDW@NPOUI@EBUF PSEFSCZDSFBUFE@BUEFTD MJNJU 2-ʙྫ

4 ௕ͬɺɺɺ 2-ʙྫ TFMFDU TVCTUSJOH@JOEFY DSFBUFE@BU JOUFSWBMIPVS
BTDW@ZFBS TVCTUSJOH@JOEFY TVCTUSJOH@JOEFY DSFBUFE@BU JOUFSWBMIPVS BTDW@NPOUI TVCTUSJOH@JOEFY TVCTUSJOH@JOEFY DSFBUFE@BU JOUFSWBMIPVS BTDW@EBUF TVCTUSJOH@JOEFY TVCTUSJOH@JOEFY DSFBUFE@BU JOUFSWBMIPVS JOUFSWBM 8&&,%":DSFBUFE@BU JOUFSWBM IPVS IPVS BTDW@XFFL TVCTUSJOH@JOEFY TVCTUSJOH@JOEFY DSFBUFE@BU JOUFSWBMIPVS BTDW@NPOUI@EBUF DPVOU BT$7਺ DPVOU DBTFXIFOMFBE@DPOUBDUT@WJFX֬ఆεςʔλεJTOPUOVMMUIFO XIFOTUBUVTPSTUBUVTUIFO XIFOTUBUVT@SFBTPOBOETUBUVT@SFBTPOUIFO FMTFFOE PSOVMM DPVOU BT༗ޮ཰ DPVOU DBTFXIFOMFBE@DPOUBDUT@WJFX֬ఆεςʔλεJTOPUOVMMUIFO XIFOTUBUVTPSTUBUVTUIFO XIFOTUBUVT@SFBTPOBOETUBUVT@SFBTPOUIFO FMTFFOE PSOVMM BT༗ޮ਺ DPVOU DBTFXIFOMFBE@DPOUBDUT@WJFX֬ఆεςʔλεJTOPUOVMMUIFOFMTFFOE PSOVMM DPVOU DBTFXIFOMFBE@DPOUBDUT@WJFX֬ఆεςʔλεJTOPUOVMMUIFO XIFOTUBUVTPSTUBUVTUIFO XIFOTUBUVT@SFBTPOBOETUBUVT@SFBTPOUIFO FMTFFOE PSOVMM BTૹ٬཰ DPVOU DBTFXIFOMFBE@DPOUBDUT@WJFX֬ఆεςʔλεJTOPUOVMMUIFOFMTFFOE PSOVMM BTૹ٬਺ TVN ࿈བྷࡁΈPSOVMM DPVOU DBTFXIFOMFBE@DPOUBDUT@WJFX֬ఆεςʔλεJTOPUOVMMUIFOFMTFFOE PSOVMM BT࿈བྷ཰ TVN ࿈བྷࡁΈPSOVMM BTA࿈བྷࡁΈA DPVOU ๚໰༧ఆ೔PSOVMM DPVOU DBTFXIFOMFBE@DPOUBDUT@WJFX֬ఆεςʔλεJTOPUOVMMUIFOFMTFFOE PSOVMM BTA๚໰཰A DPVOU ๚໰༧ఆ೔PSOVMM BTA๚໰༧ఆ਺A DPVOU ޻ࣄ༧ఆ೔PSOVMM BTA޻ࣄड஫਺A DPVOU ޻ࣄ׬ྃ೔PSOVMM BTA੒໿A DPVOU DBTFXIFOMFBE@DPOUBDUT@WJFX֬ఆεςʔλεJTOPUOVMMUIFOFMTFFOE PSOVMM DPVOU BT$7ˠૹ٬཰ DPVOU ๚໰༧ఆ೔PSOVMM DPVOU DBTFXIFOMFBE@DPOUBDUT@WJFX֬ఆεςʔλεJTOPUOVMMUIFO XIFOTUBUVTPSTUBUVTUIFO XIFOTUBUVT@SFBTPOBOETUBUVT@SFBTPOUIFO FMTFFOE PSOVMM BT༗ޮˠ๚໰཰ GSPNDPOUBDUT MFGUKPJOMFBE@DPOUBDUT@WJFX POJEMFBE@DPOUBDUT@WJFXDPOUBDU@JE XIFSFDSFBUFE@BU JOUFSWBMIPVS HSPVQCZDW@NPOUI@EBUF PSEFSCZDSFBUFE@BUEFTD MJNJU

4 TFMFDU TVCTUSJOH@JOEFY DSFBUFE@BU JOUFSWBMIPVS
BTDW@ZFBS TVCTUSJOH@JOEFY TVCTUSJOH@JOEFY DSFBUFE@BU JOUFSWBMIPVS BTDW@NPOUI TVCTUSJOH@JOEFY TVCTUSJOH@JOEFY DSFBUFE@BU JOUFSWBMIPVS BTDW@EBUF TVCTUSJOH@JOEFY TVCTUSJOH@JOEFY DSFBUFE@BU JOUFSWBMIPVS JOUFSWBM 8&&,%":DSFBUFE@BU JOUFSWBM IPVS IPVS BTDW@XFFL TVCTUSJOH@JOEFY TVCTUSJOH@JOEFY DSFBUFE@BU JOUFSWBMIPVS BTDW@NPOUI@EBUF DPVOU BT$7਺ DPVOU DBTFXIFOMFBE@DPOUBDUT@WJFX֬ఆεςʔλεJTOPUOVMMUIFO XIFOTUBUVTPSTUBUVTUIFO XIFOTUBUVT@SFBTPOBOETUBUVT@SFBTPOUIFO FMTFFOE PSOVMM DPVOU BT༗ޮ཰ DPVOU DBTFXIFOMFBE@DPOUBDUT@WJFX֬ఆεςʔλεJTOPUOVMMUIFO XIFOTUBUVTPSTUBUVTUIFO XIFOTUBUVT@SFBTPOBOETUBUVT@SFBTPOUIFO FMTFFOE PSOVMM BT༗ޮ਺ DPVOU DBTFXIFOMFBE@DPOUBDUT@WJFX֬ఆεςʔλεJTOPUOVMMUIFOFMTFFOE PSOVMM DPVOU DBTFXIFOMFBE@DPOUBDUT@WJFX֬ఆεςʔλεJTOPUOVMMUIFO XIFOTUBUVTPSTUBUVTUIFO XIFOTUBUVT@SFBTPOBOETUBUVT@SFBTPOUIFO FMTFFOE PSOVMM BTૹ٬཰ DPVOU DBTFXIFOMFBE@DPOUBDUT@WJFX֬ఆεςʔλεJTOPUOVMMUIFOFMTFFOE PSOVMM BTૹ٬਺ TVN ࿈བྷࡁΈPSOVMM DPVOU DBTFXIFOMFBE@DPOUBDUT@WJFX֬ఆεςʔλεJTOPUOVMMUIFOFMTFFOE PSOVMM BT࿈བྷ཰ TVN ࿈བྷࡁΈPSOVMM BTA࿈བྷࡁΈA DPVOU ๚໰༧ఆ೔PSOVMM DPVOU DBTFXIFOMFBE@DPOUBDUT@WJFX֬ఆεςʔλεJTOPUOVMMUIFOFMTFFOE PSOVMM BTA๚໰཰A DPVOU ๚໰༧ఆ೔PSOVMM BTA๚໰༧ఆ਺A DPVOU ޻ࣄ༧ఆ೔PSOVMM BTA޻ࣄड஫਺A DPVOU ޻ࣄ׬ྃ೔PSOVMM BTA੒໿A DPVOU DBTFXIFOMFBE@DPOUBDUT@WJFX֬ఆεςʔλεJTOPUOVMMUIFOFMTFFOE PSOVMM DPVOU BT$7ˠૹ٬཰ DPVOU ๚໰༧ఆ೔PSOVMM DPVOU DBTFXIFOMFBE@DPOUBDUT@WJFX֬ఆεςʔλεJTOPUOVMMUIFO XIFOTUBUVTPSTUBUVTUIFO XIFOTUBUVT@SFBTPOBOETUBUVT@SFBTPOUIFO FMTFFOE PSOVMM BT༗ޮˠ๚໰཰ GSPNDPOUBDUT MFGUKPJOMFBE@DPOUBDUT@WJFX POJEMFBE@DPOUBDUT@WJFXDPOUBDU@JE XIFSFDSFBUFE@BU JOUFSWBMIPVS HSPVQCZDW@NPOUI@EBUF PSEFSCZDSFBUFE@BUEFTD MJNJU Ͱ΋ɺ ΄΅4FMFDU΍Μɺɺɺ 'SPN 8IFSF (SPVQCZ 0SEFSCZ MJNJU 2-ʙྫ

ͲΕ͚ͩ௕͘ͳͬͯ΋ جຊతʹ͸͜Ε͚ͩ

2-͸ා͘ͳ͍ 4 ௕ͯ͘΋ා͘ͳ͍ 4FMFDU͕௕͍ ͨ͘͞ΜΧϥϜग़͍͚ͨͩ͠ 'SPN͕௕͍ ͍ͬͺ͍ςʔϒϧܨ͍͚͛ͨͩ 8IFSF͕௕͍ ΍ͨΒ৚݅ઃఆ͍͚ͨͩ͠ (SPVQCZ͕௕͍
جຊ୹͍ 0SEFSCZ͕௕͍ جຊ୹͍ MJNJU͕௕͍ جຊ୹͍

2-ʙͪΐͬͱԠ༻ 4 ৭ʑ৚͕݅ՃΘΔ͔Β ௕͘ͳͬͯΔ͚ͩ

2-ʙͪΐͬͱԠ༻ߏจ 4 ࢛ଇԋࢉ DPVOU TVN BWH Χ΢ϯτɺ߹ܭɺฏۉ $BTFXIFO
UIFOʜ ৚݅Λઃఆ 4VCTUSJOH@JOEFY จࣈΛऔΓग़͢ +PJO ςʔϒϧΛܨ͛Δ %JTUJODU ॏෳσʔλΛআ֎நग़ GPSNBU@EBUF ೔෇σʔλ 5JNFTUBNQ@EJ⒎ ೔࣌ͷࠩ෼Λग़͢ ৚݅Ճ͍͑ͨͱ͖͸ ͜ͷล͕͋Ε͹େମ΍Γ͍ͨ͜ͱͰ͖Δ͸ͣ ௐ΂Ε͹Θ͔ΔͷͰͱΓ֮͋͑ͣ͑Δඞཁ͸ͳ͠ʂ ˞.Z42-ͰͷߏจͰ#JH2VFSZͰ͸࢖͑ͳ͍ ˞

2-ʙΤΫηϧͩͱ 4 ͦͷ·· DPVOU TVN BWH ͦͷ·· $BTFXIFO
UIFOʜ JG 4VCTUSJOH@JOEFY MFGU SJHIU NJE +PJO WMPPLVQ %JTUJODU ॏෳͷ࡟আ Ͱ΋҆৺ ͦΜͳ೉͍͠΋ͷͰ͸ͳ͍ʂ ˞.Z42-ͰͷߏจͰ#JH2VFSZͰ͸࢖͑ͳ͍ ˞

4 ࢖͑Δͱศར DPVOU TVN BWH (SPVQCZͱηοτͰ࢖͏ $BTFXIFO"UIFOB XIFO#UIFOCFOE "ͷ࣌B #ͷ࣌C
4VCTUSJOH@JOEFY `ΧϥϜ໊` `ࢦఆͷจࣈྻ` O ΧϥϜ໊͔ࢦఆͷจࣈྻͷࠨ͔ ΒO൪໨·ͰΛநग़ Oͷ࣌͸ӈ͔Β +PJO ޙ΄Ͳઆ໌ˣ 4VCTUSJOH@JOEFY `` ˠ FY 2-ʙͪΐͬͱԠ༻ߏจ ˞

2-ʙԠ༻ɿ෭໰͍߹Θͤ 4 ΋͏ͻͱͭศརͳ΍ͭ ෭໰͍߹Θͤ αϒΫΤϦ TFMFDU [JQ@DPEFTQSFGFDUVSF@DPEF [JQ@DPEFTDJUZ@OBNF DBTFXIFOUBCMF$7਺JTOPUOVMMUIFOTVN UBCMF$7਺
XIFOUBCMF$7਺JTOVMMUIFOFOEBT݅਺ $7݄ GSPN[JQ@DPEFTMFGUKPJO TFMFDUDBTFXIFOOFX@[JQ@DPEFJTOPUOVMMUIFOOFX@[JQ@DPEF XIFOOFX@[JQ@DPEFJTOVMMUIFO[JQ@DPEFFOEBT༣ศ൪߸ QSFGFDUVSF@DPEFBT`౎ಓ෎ݝ DPVOU OBNF BT$7਺ TVCTUSJOH@JOEFY MQHBT@DPOUBDUTDSFBUFE@BU BT$7݄ GSPNDPOUBDUT XIFSFQSFGFDUVSF@DPEFJO PSOFX@QSFGFDUVSF@DPEFJO BOEDSFBUFE@BUCFUXFFOBOE HSPVQCZ༣ศ൪߸ $7݄ BTUBCMF PO[JQ@DPEFT[JQ@DPEFUBCMF༣ศ൪߸DPMMBUFVUG@HFOFSBM@DJ ͜͜ɺจதʹ·ͨTFMFDU͕ग़ͯ͘Δ

2-ʙԠ༻ɿ෭໰͍߹Θͤ 4 4FMFDU 'SPNʜ 8IFSFʜ " 4FMFDU 'SPN
TFMFDU " 8IFSFʜ (SPVQCZʜ ςʔϒϧ" ෭໰͍߹Θͤ αϒΫΤϦ ઌʹҰݸςʔϒϧ࡞͓͍ͬͯͯ ͔ͦ͜ΒऔΓग़ͯ͠ूܭͤͨ͞Γ ৚݅ઃఆͨ͠Γ 4FMFDU 'SPN 8IFSF TFMFDU " (SPVQCZʜ WMPPLVQ΍ΒJGͩΒ͚ͰΘ͚Θ͔ΒΜ͠ɺ ͜͜͸ςʔϒϧ෼͚ͨ·Μ·Ͱ΍ͬͨΒ͔͑͑ɺతͳ

2-ʙ͖ͬ͞ͷྫΛղಡ 4 ͭऔΓग़͍ͨ͠ Ұݸ৚݅ʹΑͬͯҧ͏ΧϥϜ ݱॅॴPS৽ॅॴ ͔Βग़͠෼͚͍ͨ ໰͍߹ΘͤҰཡ͔Β ݱॅॴ͋Δ͍͸৽ॅॴ͕ ෱Ԭݝ͔ࠤլݝͰ ೥݄ʙ೥݄ͷؒ
ͷ΋ͷΛ ༣ศ൪߸ͱ$7݄Ͱ$7਺Λूܭ͍ͨ͠ TFMFDU [JQ@DPEFTQSFGFDUVSF@DPEF [JQ@DPEFTDJUZ@OBNF DBTFXIFOUBCMF$7਺JTOPUOVMMUIFOTVN UBCMF$7਺ XIFOUBCMF$7਺JTOVMMUIFOFOEBT݅਺ $7݄ GSPN[JQ@DPEFTMFGUKPJO TFMFDUDBTFXIFOVTFSTOFX@[JQ@DPEFJTOPUOVMMUIFOVTFSTOFX@[JQ@DPEF XIFOVTFSTOFX@[JQ@DPEFJTOVMMUIFOVTFST[JQ@DPEFFOEBT༣ศ൪߸ QSFGFDUVSF@DPEFBT`౎ಓ෎ݝ DPVOU OBNF BT$7਺ TVCTUSJOH@JOEFY MQHBT@DPOUBDUTDSFBUFE@BU BT$7݄ GSPNVTFST XIFSFVTFSTQSFGFDUVSF@DPEFJO PSVTFSTOFX@QSFGFDUVSF@DPEFJO BOEVTFSTDSFBUFE@BUCFUXFFOBOE HSPVQCZ༣ศ൪߸ $7݄ BTUBCMF PO[JQ@DPEFT[JQ@DPEFUBCMF༣ศ൪߸DPMMBUFVUG@HFOFSBM@DJ XIFSF[JQ@DPEFTQSFGFDUVSF@DPEFJO HSPVQCZ[JQ@DPEFTDJUZ@OBNF $7݄ PSEFSCZ݅਺EFTD MJNJU

2-ʙ͖ͬ͞ͷྫΛղಡ 4 ༣ศ൪߸ ౎ಓ෎ݝ $7਺ $7݄ ͜Μͳςʔϒϧ࡞ͬͯ શࠃ༣ศ൪߸Ұཡͱͭͳ͛ͯ ूܭ ·͋׳Ε͖ͯͨΒνϟϨϯδ͢ΔͰ0,
TFMFDU [JQ@DPEFTQSFGFDUVSF@DPEF [JQ@DPEFTDJUZ@OBNF DBTFXIFOUBCMF$7਺JTOPUOVMMUIFOTVN UBCMF$7਺ XIFOUBCMF$7਺JTOVMMUIFOFOEBT݅਺ $7݄ GSPN[JQ@DPEFTMFGUKPJO TFMFDUDBTFXIFOVTFSTOFX@[JQ@DPEFJTOPUOVMMUIFOVTFSTOFX@[JQ@DPEF XIFOVTFSTOFX@[JQ@DPEFJTOVMMUIFOVTFST[JQ@DPEFFOEBT༣ศ൪߸ QSFGFDUVSF@DPEFBT`౎ಓ෎ݝ DPVOU OBNF BT$7਺ TVCTUSJOH@JOEFY MQHBT@DPOUBDUTDSFBUFE@BU BT$7݄ GSPNVTFST XIFSFVTFSTQSFGFDUVSF@DPEFJO PSVTFSTOFX@QSFGFDUVSF@DPEFJO BOEVTFSTDSFBUFE@BUCFUXFFOBOE HSPVQCZ༣ศ൪߸ $7݄ BTUBCMF PO[JQ@DPEFT[JQ@DPEFUBCMF༣ศ൪߸DPMMBUFVUG@HFOFSBM@DJ XIFSF[JQ@DPEFTQSFGFDUVSF@DPEFJO HSPVQCZ[JQ@DPEFTDJUZ@OBNF $7݄ PSEFSCZ݅਺EFTD MJNJU

΋͏̍ͭେࣄͳ ςʔϒϧߏ੒ͷ೺Ѳ

6TFST .BUDIFT $PNQBOJFT શ͕ͯͻͱͭͷςʔϒϧʹ·ͱ·ͬͯͳ͍ Ͳ͜ʹԿͷσʔλ͕͋Δ͔Λ೺Ѳ͢Δ͜ͱ͕ॏཁ 2-ʙςʔϒϧߏ଄೺Ѳ 4

͋ͱ͸΋͏ݟͯ׳Εͯ೺Ѳ͢Δ͔͠ͳ͍ 2-ʙςʔϒϧߏ଄೺Ѳ 4 ֤ςʔϒϧ͸ #JH2VFSZͷ ͜͜ʹ·ͱ·ͬͯ·͢

͋ͱ͸΋͏ݟͯ׳Εͯ೺Ѳ͢Δ͔͠ͳ͍ 2-ʙςʔϒϧߏ଄೺Ѳ 4 ֤ςʔϒϧͷத਎͸͜͜

ྫ͑͹ɺ ʮVTFSTʯͱʮVTFS@QSPpMFTʯ ͸ͲͷΧϥϜͰܨ͛ΒΕΔʁ ܨ͛Δɹʹɹ̎ͭͷΤΫηϧγʔτ͕͋Θͬͯ͞େ͖ͳγʔτ͕Ͱ͖·͢ ͲͷςʔϒϧͷͲΜͳΧϥϜ͕͋ͬͯɺ ͲͷΧϥϜಉ͕࢜ಉ߲͡໨Ͱܨ͛ΒΕΔͷ͔ 2-ʙςʔϒϧΛͭͳ͛Δ 4

͖ͬͱΤϯδχΞͷํ͕·ͱΊͯ͘Ε͍ͯ·͢ ͜ΕΛΈΕ͹Ͳ͜ͱͲ͕ͭ͜ͳ͕͍ͬͯΔ͔ ͱͯ΋ཧղ͕͠΍͍͢ ʔϒϧߏ੒ ς

ͲͷςʔϒϧʹͲΜͳΧϥϜ͕͋ͬͯɺ ͲͷΧϥϜಉ͕࢜ಉ߲͡໨Ͱܨ͛ΒΕΔͷ͔ ͜ͷͭ 2-ʙςʔϒϧΛͭͳ͛Δ 4

KPJOͰܨ͛·͠ΐ͏ 4FMFDU 'SPNAVTFSTABTV MFGUKPJOAVTFS@QSPpMFTABTVQ POVJEVQVTFS@JE 'SPNςʔϒϧ" MFGUJOOFS KPJOςʔϒϧ#POςʔϒϧ"Bςʔϒϧ#C ʮςʔϒϧ"ͱςʔϒϧ#ʯΛʮςʔϒϧ"ͷΧϥϜBʯͱʮςʔϒϧ#ͷΧϥϜCʯͰܨ͛·͢
ͭ·Γɺ 2-ʙKPJO 4 ˞KPJOͷछྨ͸͍͔ͭ͋͘Γ·͕͢͜͜Ͱ͸આ໌ΛׂѪ

ϢʔβʔJEҰཡ ϢʔβʔϓϩϑΟʔϧҰཡ +PJO JE VTFS@JE VTFS@JE JE ʹ ͕ͭܨ͕ͬͨେ͖͍ςʔϒϧ͕Ͱ͖·͢ ໰͍߹ΘͤҰཡݟੵ΋ΓҰཡ
2-ʙKPJO 4

2-ʙॻ͖࢝ΊΔલʹ 4 ·ͣ͸೔ຊޠͰԼهΛॻ͍ͯ੔ཧ͠·͠ΐ͏ʂ 4FMFDU˔˔ ˔˔Λࢀর͢Δ 'SPN˙˙ ˙˙͔Β 8IFSF˛˛ ˛˛ͷ৔߹ʹ (SPVQCZ˗˗
˗˗Ͱ·ͱΊΔ ूܭ͢Δ 0SEFSCZ˘˘ ˘˘Ͱฒ΂Δ MJNJU✖✖ ✖✖݅·Ͱ ͋ͱ͸຋༁͢Ε͹0, ٯʹ೔ຊޠͰ੔ཧͰ͖ͳ͚Ε͹42-Ͱ΋ॻ͚·ͤΜʂ

͜ΕͰ΋͏͋Δఔ౓ॻ͚Δ͸ͣʂ ͋ͱ͸͍Ζ͍Ζॻ͍ͯɺࣗ૸ֶͯ͠ͼ·͠ΐ͏

๻΋·ͩ·ͩษڧதͰ͢ Ұॹʹ੒௕͍͖ͯ͠·͠ΐ͏ ॓ͷ໨త ߹ ʮ΍Γ͍͚ͨͲΑ͘Θ͔ΒΜʂʯ ͱ͔͋Ε͹͍ͭͰ΋ฉ͍͍ͯͩ͘͞

ビジネスサイドのためのSQL入門

ビジネスサイドのためのSQL入門

More Decks by umek_0524

Other Decks in Business

Featured

Transcript