ࡱ> Root EntryRoot Entry-4,@%FileHeaderDocInfoX BodyText 4,P 4,  !"#$%HwpSummaryInformation.PPrvImage PrvTextDocOptions -4,-4,Scripts -4,-4,JScriptVersion DefaultJScript_LinkDoc  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOQRSTUVWYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~] <mxȐΌ 7 P!  8Ĭ> <1><SQL Ϭݲ(4)> %  HŴ % P!ǩ\ - SQLϬ 1 8| ttX tհX 1D  `  % P! -  : SQL Ϭݲ(4) - P!0 : 2019. 7. 11() ~ 12() 09:30 ~ 18:30 (2|, 16) - P! : }0 ɐ(DB | ɐ ) - P!x : 20 x - P!ǥnj : mxȐΌ 15 P!<0 1X % P!| <| ><8 ><D > <7. 11() 09:30~18:30><%0Ϭ \T - x tt - | Ű tt - IN vs. BETWEEN, SORT, GROUP BY, UNION, ݲ @ % Ϭ \T - JOIN Ϭ ļ ݲ ȵ, JOIN vs. SUBQUERY><@ ((\)> <7. 12() 09:30~18:30><% Ϭ \T - SUBQUERY ļ ݲ ȵ, ݲ @ %T-SQL \ \T - Cursor vs. T-SQL, View ݲ, Ɛ X h ݲ, ݲ @ %ȥ \ \T - ȥ \ ٳ tt, | tt, ȥ \ u 1 8 tt - ݲ )H, ̹ pȌ Ϭ ݲ, ݲ @ > % @  t% <Ȕ %><l><4><D><2008D 09 ~ ֬>< (\ \$4Ѹ/tǬ(DB $)><><2009D 07 ~ ֬>< \ITP!<0, Microsoft SQL Ϭݲ  X><><2009D 06 ~ ֬>< ݲt P!<0, Microsoft SQL Ϭݲ  Ȅ><><2005D 02 ~ 2008D 09>< D|7, $4Ѹ(DB $)><>GIF89aɻxxxkkk]]]PPPCCC555((( d`LH00`Hذ̘`H0|pdXL@`0H `H0`dHL`H0xp`XH@0d LȰ``HH00dLؘȀ`H0xp`XH@d0L `H0d`LH`H0|pdXL@0`$H`dHL00`HذȘdL0xp`XH@0` HdH0ȳ``HHdL0xp`XH@`0H Ը̰ĠऀؘpȈXxHp@h@d8`8X0xT0pH dxddxd`d`p`|``x`p``x`!, H*\ȰÇ#JHŋ3jȱǏ CIɓ(S\ɲ˗0cʜI͛8sɳϟ@ JѣH*]ʴ)GP:PTXx5ׯ`b@ٳhӪ]˶۷pƽrCx˷߿ L+^̸㻇O ne˕39*fϜ7gx=Kuj֫1ov Z&'--3jڳUN]f]wޡwI݁M 8ϲ;gܻgv[}˟Ob!Ͽ֑h`4 6X"e ׄVhAXT܇ ($h((J4/nաH2"08G:t?6Oc 2dqL>P)5$IAf9e+n]quPc҈#)9bV-YeRe$:yT ͙#}y&Ȣ&袌Y裐F*餔Vj饘jVM*9)i:*R'WS*무j뭣e_IW&Lڬzꤳ\J&vڬQ^%-K^+Ӧ$mbfni;nXl'p蒻'Ú/gKPVk2o7l˻*;0+/n@}RY|r95&[-Y}bNo^O\t1GoF-x-E|߱m2({۲ȼ̔q3-q8W6BE0ˁ-ª+wF93,V:ةD'̺=L~tߓc}4OK2^N>JP~1Pu=>{2go#%|ۙ0ֿ5iF2e N5zP`EH̠U8 z Sz0*2a )8Cp aB0cD$NTb gD&Ra.0ÈH2"c &FmR)2GŁEhth4~JKtGbQ_RlRHmNY:֑LlcE.LQ3$@92d(Gbnnv"' IJׅ q擥D8 Vr$eYI?rc)ًY%>Rz4d̶qefG(a29MFdwDef:;Jic2?).mv3yoSڻd_,Y@Qbj/3镏'-yw+]CZAש`Jnl[$ULZ"d: O7 US(=';YTliCԒVQT^,5W֔>uQeFg12loUKխSWOJVu?{>2xj #p[n4n֜җ*X= A ׵βnfz<7&wb2X-ꋝ`vڭmcv=s:(5Y1ͭpMy=op-{d%8|YM-ިXMC,. ]Ƈ `%TҀtm|"fKp3O`YuygV{l%d7L0LJp%6F]5*pK?cd|,>GngW P8|h }ϔbh_q+ _DܬLP;"vG'l~~fzy$9i0d4㬻%|4{ /R ~셧e"ٲyZ(alImmPjKm-䫵%}H7\$Tf0EBČhPY>/l&:#ƿ~6p #p\w?6Mm"KwB2~.kȟ ,ӣ5NQFh7>@hm)DF;rc+4n˔"o(UFhyݖ9'4 Ӆ{49m;ˇ]wVfM>omt}Xd*2BdףNs3̴ϥVY1U$ԣ5=㺣3*>OKhTqz#a*~ |3:D.ېM?X*z=!}2[B˅xcqw'ӮHdf$z#9L{ \{GI} r@1w ;2wٳ&Ȉu$2Dh[cӐCl7Y|[z;(q:z f/H|lmDvy"`I\2h5W̡DoxW[(ǨMJdf\%#WY&&TgzVۡ&6ISI]Օoclmt'4Ok6SvUکkA|>>O-xo=x%֖?MlU'pIK :VrDTJڂ@B9TNEĵDm!q\)AMTU-Cyů}{Sofggf^axZvV 13 0LBx}(>e9qr;aǀ;ab'4b'5$` b4b6 $w٘+;ۍAxQS/ ,$<f Nr ԋئ ĻܥY{> 4 S-rY5w~F1M>VDx-+RHy֓^P\,F8k~f=>DG},6ľGshtGp/y/ BfnbJMGd1J]cJCG8P LC)tbC)P 8zHCմW a©WL*I1# `RR10(1]#&^Uw _~kt{+h/ݜR " OcJaXV Cgu[9J~pdCAh:FO;D:_h_ .[~D$Fy>.*] ?oRvn [_l<(q!eĹ9(:)gl>oldCԞ=!>+& DfiHР/Zh 4LC)N)CҦID!ar-Z^/R߿A79P5w[cc, k?߸D o,;>^JkW"1c- ޯ[1xϛjs,ؕcQUm6K/Gg~#" SEلΪg[=G2Fn.^|Tt?~-.fyw qn;HWP Document Fileu@DO 6C,H,#GB!k0~ 6*7=M*Z:ҙ#?*?ӿT@Y~X+mj3'm[v|:j)%C$Mϼ5#cd߈ Ϭ ݲ, ݲ @ > % @  t% <Ȕ %><l><4><D><2008D 09 ~ ֬>< (\ \$4Ѹ/tǬ(DB $)><><2009D 07 ~ ֬>< \ITP!<0, Microsoft SQL Ϭݲ  X><><2009D 06 ~ ֬>< ݲt P!<0, Microsoft SQL Ϭݲ  Ȅ><><2005D 02 ~ 2008D 09>< D|7, $4Ѹ(DB $)><>oV]LU>wvY`,:XPhAZK"ZZ&Dڤ!)CA>P#$]q_vcR၇ƍxܹ;3;;x'g~=swwd(O*m;jԦ+ E)^&gQ*˾4h[>?[7\~a``BP%/,= %(ٶuTU1hYS1|dUOzFHзť[?D2Aykg^d 'x}N,&qo:_C"{۰uvr_.b >2I8avc(dk7>3Y;afDy یNJ}?*K(^.fSkpIJ = (dqXYzeBD`l9zeX ./JP-C+HmRJG2N& /#"?75wFȐqǠ-Lnxyr9s},fmPj>:F_t Hԝ0]Zٵp#?5W{tfp:Ac&=w=latanKL>G<m3 PѠ>3Cq=&(9Gw;F^3pY nT)WA2l-\J-r͹J⚳o`u-J%Jt+QcȭR͑`@X`Ut{[UDo߮I] |w*jS:/v+JJm+/!ܕHdTV +eЈ3$ 4zc,390(+lwQa@0{l<ھ3r[ 2fX7g)jOaWYar6oNsx<Ы/nwx "X=M b5FC^ c)jk$Dk48 RC`YS=ߩŖ:d 'աZ5r 7ZdFW#i=f@j P-VRs xtog'hr=&p-8?4~-AL t8V10_t8V2 $:mIVڢVD?GΐԶ ҶE(_I"`NLW]hU>wvvwM n چ[M%ɒTjMR-!Bڤ`IGA@)>EiؤniR6ݒZcSЇ:ͮ!)ZI#M]pvDybŠ۰XX9uvE/~SChi"N!v4^, ;x͢}7ZEǻ#0 oo7lA,)0<8AனV{W{HlzUϿjnO}#$$yᨴ_5gfY\[zTqU遷EŎs@R Rv?V n} K`➸d`%M,6+!D",#xXMpa%OnȰHF}EW u: Ʌ>E>]X7 [5iD-ŒI9 MEJ6Ѻ V2Z#7 FfV?GPC xPWF O.|Ց]bU=g-XtƉ&I/؆>«Ր,~,C>9g"vʻx=Ƭ̮S}UeXq XkNk;c/%ru&TLݬH]6VFD5SbahS^fq#ԫs"+>[W]4u&57Pb\c>_5W}y7Ѭ?~ɮ0jTL:p]/$ SFΪV[nئ3!nKXư r]{0{guIh[?1\%DFWo ag<$|WᜂOf鹊@i.M[v 1k 4h=h`2h 1X ]L TZ<Q`^DZ3 0W۱! dg5Ɍ]b0dAfvIY$2dr>l}1Bߟt BbNBb dƚ- U[*ɤά aiܑP`h?, S<{IUZ˳\ZrலxVyE;؋#ݹG+bQ`ԖMhA.! E[!iCl#6ЂZ= 6"9xAC\jn Ribn2;eۗ˸_h[Uܴi06-&ڑuItlaAD'P+B-2䤅! VptL{C`+)U!Ї>LRa~{?]?||w='-9FzNA?ٙ@{FU!/CM'm}\`57oa}=BMp%+~w+%𱑍W'LW3vtDW/>QWAhE g#U-ƽGXR)g4ZIFlHnD~=:O紣jlꖕ01<Cqw~M,[IW7)g9@=ChP{4֮?m]gWSq0d3^[c@\@~=KL5A^)謷z";Q[U38pȰHvd;[jш9.ryWHQ^ѐYl':|I@$NdoX~lW%w[46uϨgATZ\;BW( V ֹ-@SHk@@ Z/ _V̅P/_|J'rcQ[&CtA^G\H ZrCB,(4.aNrQQ(%ÉИ83>[bEzFcI(4]N-eD2]c}wRB-