Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
SQL勉強会用
Search
Ryo Tsukahara
December 04, 2018
0
60
SQL勉強会用
社内の非エンジニア向けSQL勉強会の資料です。
Ryo Tsukahara
December 04, 2018
Tweet
Share
More Decks by Ryo Tsukahara
See All by Ryo Tsukahara
モジュラモノリスのモジュール間通信の話
trrrrrys
4
2.2k
マイクロサービス・モジュラモノリス化によるシステム負債の解消プロジェクト
trrrrrys
0
410
Featured
See All Featured
Building Your Own Lightsaber
phodgson
100
5.7k
The MySQL Ecosystem @ GitHub 2015
samlambert
244
12k
[RailsConf 2023] Rails as a piece of cake
palkan
28
4k
The Power of CSS Pseudo Elements
geoffreycrofte
62
5k
4 Signs Your Business is Dying
shpigford
176
21k
The Pragmatic Product Professional
lauravandoore
26
5.8k
Reflections from 52 weeks, 52 projects
jeffersonlam
345
19k
Making the Leap to Tech Lead
cromwellryan
125
8.5k
VelocityConf: Rendering Performance Case Studies
addyosmani
321
23k
How GitHub Uses GitHub to Build GitHub
holman
468
290k
Adopting Sorbet at Scale
ufuk
69
8.6k
Why You Should Never Use an ORM
jnunemaker
PRO
51
8.7k
Transcript
ඇΤϯδχΞ͚ 42-ษڧձ 1
!2 /BNF3ZP5TVLBIBSB !USSSSSZT !USSSSSZT -BOHBHF(P 1ZUIPO ओʹαʔόαΠυΞϓϦέʔγϣϯ ͷ։ൃΛ͍ͯ͠·͢
42-ͬͯԿʁ !3
lσʔλϕʔεzʹରͯ͠σʔλͷૢ࡞ఆٛΛ͢ΔͨΊʹ ༻͍Δ ߏԽ͞Ε͍ͨ߹Θͤݴޠ 4&26&- 4USVDUVSFE&OHMJTI2VFSZ-BOHVBHF ͕༝དྷΒ͍͠ ओʹ3%#.4 ؔσʔλϕʔεཧγεςϜ ͱݺΕΔ
%#ͷૢ࡞ͷͨΊʹ༻͍ΒΕΔ !4 42-ͬͯԿʁ
3%#.4ʁ !5
σʔλϕʔεʹ େ͖͘छྨ͋Γ·͢ !6
ɾ3%#.4 ɾ/P42- !7
SFMBUJPOBMEBUBCBTFNBOBHFNFOUTZTUFN σʔλΛදͷܗࣜͰӬଓԽ͠ɺ͔ͭσʔλؒͷؔ࿈· ͨදͷܗࣜͰӬଓԽͰ͖Δ%#.4 8JLJQFEJB͔ΒҾ༻ දతͳ3%#.4 ɾ0SBDMF%BUBCBTF ɾ1PTUPHSF42- ɾ.Z42- !8
3%#.4
!9 Πϝʔδ ຊΛआΓΔγεςϜͷ߹
!10 Πϝʔδ ຊΛआΓΔγεςϜͷ߹ ςʔϒϧ Ϩίʔυ ΧϥϜ ϑΟʔϧυ
!11 Πϝʔδ ຊΛआΓΔγεςϜͷ߹
/PUPOMZ42- ͦͷ໊ͷ௨Γ 3%#.4Ҏ֎ͷ%#ͷ૯শ ࠷ۙϏοάσʔλ׆༻ʹΑΔղੳ "* %FFQ-FBSOJOH ֶ शʹ༻͞ΕΔͨΊधཁ͕ߴ·͍ͬͯΔ දతͳ/P42- ɾ3FEJT
ɾ%BUB4UPSF (PPHMF ɾ%ZOBNP%# "NB[PO FUD !12 /P42-
42-ͬͯ ͍͠ΜͰ͠ΐʁ
ਖ਼ղͰ͋Γ ෆਖ਼ղͰ͋Δ
σʔλղੳతͰͷ42- ˠൺֱత؆୯ αʔϏε࡞తͷ42- ˠνϣοτϜζΧγΠ㷉◔ϖ◔㷊 େنαʔϏεʹ͓͚ΔύϑΥʔϚϯε্తͷ42- ˠ͔ͳΓϜζΧγΠ㷉◔ϖ◔㷊 !15
Ͳ͏͍͏໘Ͱ ׆༻Ͱ͖Δͷ͔ !16
ɾ%"6 ɾ8"6 ɾ."6 ͱ͍ͬͨαʔϏεͷར༻ঢ়گΛਤΔࢦඪ αʔϏεͰͷΛ༧ଌͨ͠Γ ϏδωεઓུΛ࿅ΔͷʹඞਢͳใΛऔಘ͢Δ !17
ΤϯδχΞ໊͕Ͱɺ42-Λ༻ͯ͠Ϣʔβʔ֫ಘΛ୲ͬ ͍ͯΔϓϩϞʔγϣϯνʔϜ͋Γ·͢ ༗໊اۀ IUUQTUFDIHVOPTZJPFOUSZTRMUVUPSJBMGDBD !18
σʔλղੳʹඞཁͳߏ จΛܰ͘հ͠·͢ !19
4&-&$5 !20
4&-&$5શ݅औಘ !21 4&-&$5ͱ͍͏ߏจΛ༻ l'30.IPHFzͰͲͷςʔϒϧ ද ͔Βσʔ λΛऔಘ͢Δ͔Λࢦఆ
4&-&$5݅ࢦఆ !22 l8)&3&IPHFGVHBzͰऔಘ͢Δσʔλ ͷ݅Λࢦఆ
4&-&$5Ձ݁߹ !23 PS
4&-&$5֎෦݁߹ !24
Ͳ͏ͬͯษڧ͢Ε ྑ͍ͷʁ !25
ɾ1SPHBUF ɾ6EFNZ ɾυοτΠϯετʔϧ ͷֶश༻8FCαʔϏεΛͬͯษڧ !26
ˣͷαΠτΦεεϝͰ͢ IUUQTTRM[PPOFUXJLJ42-@5VUPSJBM !27
ຊͳΒ͜Ε͕Φεεϝ IUUQTXXXBNB[PODPKQFYFDPCJEPT"4*/ IBUFOBCMPH !28
❌ςΩετΛಡΜͰ֮͑Δ ⭕࣮ࡍʹಈ͔ͯ͠z͍ํzΛײ֮Ͱ֮͑Δ େࣄͳͷٕज़ͷΠϯσοΫεΛ࡞Δ͜ͱ !29 डݧ༻ͷษڧͱҧ͍·͢