%PDF-1.6
%
1 0 obj
<>
endobj
2 0 obj
<>stream
2021-02-25T06:38:17-05:00
2021-02-25T06:38:17-05:00
2021-02-25T06:38:17-05:00
Adobe Acrobat 21.0
application/pdf
Microsoft Transact-SQL Training | T-SQL Programming Course | Learn T-SQL
uuid:bbcdb38d-13be-4797-badc-8e730fc665e8
uuid:5e994eb0-c7b1-4912-99ef-13c21e0fcb7a
Acrobat Web Capture 15.0
endstream
endobj
5 0 obj
<>
endobj
6 0 obj
<>
endobj
3 0 obj
<>
endobj
7 0 obj
<>
endobj
8 0 obj
<>
endobj
16 0 obj
<>>>
endobj
17 0 obj
<>
endobj
18 0 obj
<>
endobj
20 0 obj
[19 0 R 19 0 R]
endobj
21 0 obj
[19 0 R 19 0 R]
endobj
22 0 obj
[19 0 R 19 0 R]
endobj
23 0 obj
[19 0 R 19 0 R]
endobj
19 0 obj
<><><><><><>]/P 17 0 R/Pg 12 0 R/S/Article>>
endobj
12 0 obj
<>/Font<>/ProcSet[/PDF/Text/ImageC]/XObject<>>>/StructParents 0/Type/Page>>
endobj
24 0 obj
[37 0 R 38 0 R 39 0 R]
endobj
25 0 obj
<>stream
BT
/Artifact <>BDC
/TT0 1 Tf
9 0 0 9 5 779 Tm
(Microsoft Transact-SQL Training | T-SQL Programming Course | Learn T-SQL\
)Tj
EMC
/Artifact <>BDC
0 -86 TD
(file:///INSTSERVER/TrainingHottSite/HOTT-NEW/UK/CoursesPDF/Transact-SQL-\
Programming-Courses.htm)Tj
45.301 0 Td
([2/25/2021 6:38:17 AM])Tj
EMC
ET
1 g
10 36 591.75 729.75 re
f
q
65.5 513 m
63.429 513 61.75 511.321 61.75 509.25 c
61.75 509.25 l
61.75 302.25 l
61.75 300.179 63.429 298.5 65.5 298.5 c
65.5 298.5 l
545.5 298.5 l
547.571 298.5 549.25 300.179 549.25 302.25 c
549.25 302.25 l
549.25 509.25 l
549.25 511.321 547.571 513 545.5 513 c
545.5 513 l
h
W n
0.976 g
61.75 513 487.5 -214.5 re
f
0.867 g
61.75 513 487.5 -214.5 re
65.5 512.25 m
545.5 512.25 l
547.157 512.25 548.5 510.907 548.5 509.25 c
548.5 302.25 l
548.5 300.593 547.157 299.25 545.5 299.25 c
65.5 299.25 l
63.843 299.25 62.5 300.593 62.5 302.25 c
62.5 509.25 l
62.5 510.907 63.843 512.25 65.5 512.25 c
f*
Q
q
10 36 592 730 re
W n
0.137 0.322 0.486 rg
q 1 0 0 1 69.25 508.5 cm
0 0 m
472.5 0 l
474.157 0 475.5 -1.343 475.5 -3 c
475.5 -17.25 l
475.5 -18.907 474.157 -20.25 472.5 -20.25 c
0 -20.25 l
-1.657 -20.25 -3 -18.907 -3 -17.25 c
-3 -3 l
-3 -1.343 -1.657 0 0 0 c
f
Q
q 1 0 0 1 64.75 285 cm
0 0 m
481.5 0 l
483.157 0 484.5 -1.343 484.5 -3 c
484.5 -20.25 l
484.5 -21.907 483.157 -23.25 481.5 -23.25 c
0 -23.25 l
-1.657 -23.25 -3 -21.907 -3 -20.25 c
-3 -3 l
-3 -1.343 -1.657 0 0 0 c
f
Q
q 1 0 0 1 64.75 71.25 cm
0 0 m
481.5 0 l
483.157 0 484.5 -1.343 484.5 -3 c
484.5 -20.25 l
484.5 -21.907 483.157 -23.25 481.5 -23.25 c
0 -23.25 l
-1.657 -23.25 -3 -21.907 -3 -20.25 c
-3 -3 l
-3 -1.343 -1.657 0 0 0 c
f
Q
/Article <>BDC
EMC
/Article <>BDC
Q
q
61.75 677.25 487.5 82.5 re
W n
q
/GS0 gs
487.5 0 0 -82.5 61.75 759.75 cm
/Im0 Do
Q
Q
BT
0.608 0.169 0 rg
/TT1 1 Tf
19.5 0 0 19.5 61.75 636.75 Tm
(Microsoft Transact-SQL Programming)Tj
0.137 0.322 0.486 rg
/TT2 1 Tf
10.5 0 0 10.5 61.75 609 Tm
(Duration:)Tj
0 g
/TT3 1 Tf
( )Tj
/TT4 1 Tf
(\(Face-to-Face & Remote-Live\))Tj
/TT3 1 Tf
20.821 0 Td
(, or 35 Hours )Tj
/TT4 1 Tf
7.014 0 Td
(\(On-Demand\))Tj
0.137 0.322 0.486 rg
/TT2 1 Tf
-27.835 -2.214 Td
(Price:)Tj
0 g
/TT3 1 Tf
3.227 0 Td
( \2431,945 )Tj
/TT4 1 Tf
4.246 0 Td
(\(Face-to-Face & Remote-Live\))Tj
/TT3 1 Tf
15.164 0 Td
(, or \2431,145 )Tj
/TT4 1 Tf
5.995 0 Td
(\(On-Demand\))Tj
0.137 0.322 0.486 rg
/TT2 1 Tf
-28.63 -2.214 Td
(Discounts:)Tj
0 g
/TT3 1 Tf
5.916 0 Td
( For multiple course purchases, please )Tj
0.137 0.322 0.486 rg
19.712 0 Td
(contact us)Tj
ET
q
10 36 592 730 re
W n
0.137 0.322 0.486 RG
0.75 w
q 1 0 0 1 330.8484 561.75 cm
0 0 m
54.346 0 l
h
S
Q
Q
BT
0 g
10.5 0 0 10.5 385.1941 562.5 Tm
( for applicable discounts.)Tj
0.137 0.322 0.486 rg
/TT2 1 Tf
-30.804 -2.214 Td
(Delivery Options:)Tj
0 g
/TT3 1 Tf
( Perform training at your own pace via our )Tj
0.137 0.322 0.486 rg
31.514 0 Td
(on-demand training)Tj
ET
q
10 36 592 730 re
W n
0.137 0.322 0.486 RG
0.75 w
q 1 0 0 1 392.6436 538.5 cm
0 0 m
104.498 0 l
h
S
Q
Q
BT
0 g
0.036 Tw 10.5 0 0 10.5 497.1411 539.25 Tm
[( )0.7 (option )0.6 (or)]TJ
0 Tw -41.466 -1.214 Td
(attend regularly scheduled live courses via )Tj
0.137 0.322 0.486 rg
21.844 0 Td
(remote-live attendance)Tj
ET
q
10 36 592 730 re
W n
0.137 0.322 0.486 RG
0.75 w
q 1 0 0 1 291.1094 525.75 cm
0 0 m
123.103 0 l
h
S
Q
Q
BT
0 g
10.5 0 0 10.5 414.2126 526.5 Tm
(.)Tj
1 g
/T1_0 1 Tf
14.25 0 0 14.25 69.25 494.25 Tm
(Students Will Learn)Tj
ET
q
81.25 303 231.75 174 re
W n
0 g
81.25 471.75 3 -3 re
f
0.75 w
q 1 0 0 1 81.25 471.75 cm
0 0 m
3 0 l
3 -3 l
0 -3 l
h
S
Q
BT
/TT3 1 Tf
10.5 0 0 10.5 91 467.25 Tm
(Designing normalized table structures)Tj
-0.929 -1.214 Td
(for relational databases)Tj
ET
81.25 438.75 3 -3 re
f
q 1 0 0 1 81.25 438.75 cm
0 0 m
3 0 l
3 -3 l
0 -3 l
h
S
Q
Q
BT
0 g
/TT3 1 Tf
10.5 0 0 10.5 91 434.25 Tm
(Creating databases and tables)Tj
ET
q
81.25 303 231.75 174 re
W n
81.25 418.5 3 -3 re
f
0.75 w
q 1 0 0 1 81.25 418.5 cm
0 0 m
3 0 l
3 -3 l
0 -3 l
h
S
Q
Q
BT
10.5 0 0 10.5 91 414 Tm
(Using primary and foreign keys)Tj
ET
q
81.25 303 231.75 174 re
W n
81.25 398.25 3 -3 re
f
0.75 w
q 1 0 0 1 81.25 398.25 cm
0 0 m
3 0 l
3 -3 l
0 -3 l
h
S
Q
Q
BT
10.5 0 0 10.5 91 393.75 Tm
(Writing SQL queries)Tj
ET
q
81.25 303 231.75 174 re
W n
81.25 378 3 -3 re
f
0.75 w
q 1 0 0 1 81.25 378 cm
0 0 m
3 0 l
3 -3 l
0 -3 l
h
S
Q
Q
BT
10.5 0 0 10.5 91 373.5 Tm
(Using inner and outer joins)Tj
ET
q
81.25 303 231.75 174 re
W n
81.25 357.75 3 -3 re
f
0.75 w
q 1 0 0 1 81.25 357.75 cm
0 0 m
3 0 l
3 -3 l
0 -3 l
h
S
Q
Q
BT
10.5 0 0 10.5 91 353.25 Tm
(Using set operators \()Tj
/TT5 1 Tf
10.604 0 Td
(UNION)Tj
/TT3 1 Tf
(,)Tj
ET
q
81.25 303 231.75 174 re
W n
BT
/TT5 1 Tf
10.5 0 0 10.5 81.25 340.5 Tm
(INTERSECT)Tj
ET
Q
BT
10.5 0 0 10.5 137.9592 340.5 Tm
(, )Tj
/TT5 1 Tf
0.715 0 Td
(EXCEPT)Tj
/TT3 1 Tf
3.601 0 Td
(\))Tj
ET
q
81.25 303 231.75 174 re
W n
81.25 324.75 3 -3 re
f
0.75 w
q 1 0 0 1 81.25 324.75 cm
0 0 m
3 0 l
3 -3 l
0 -3 l
h
S
Q
Q
BT
10.5 0 0 10.5 91 320.25 Tm
(Using DML for )Tj
/TT5 1 Tf
7.393 0 Td
(SELECT)Tj
/TT3 1 Tf
3.601 0 Td
(, )Tj
/TT5 1 Tf
0.715 0 Td
(INSERT)Tj
/TT3 1 Tf
3.601 0 Td
(,)Tj
ET
q
81.25 303 231.75 174 re
W n
BT
/TT5 1 Tf
10.5 0 0 10.5 81.25 307.5 Tm
(UPDATE)Tj
ET
Q
BT
10.5 0 0 10.5 119.0562 307.5 Tm
(, )Tj
ET
q
81.25 303 231.75 174 re
W n
BT
/TT5 1 Tf
10.5 0 0 10.5 126.5671 307.5 Tm
(DELETE)Tj
ET
Q
q
328 303 216.751 174 re
W n
328 471.75 3 -3 re
f
0.75 w
q 1 0 0 1 328 471.75 cm
0 0 m
3 0 l
3 -3 l
0 -3 l
h
S
Q
BT
10.5 0 0 10.5 337.75 467.25 Tm
(Using subqueries)Tj
ET
328 451.5 3 -3 re
f
q 1 0 0 1 328 451.5 cm
0 0 m
3 0 l
3 -3 l
0 -3 l
h
S
Q
Q
BT
10.5 0 0 10.5 337.75 447 Tm
(Using triggers and stored procedures)Tj
ET
q
328 303 216.751 174 re
W n
328 431.25 3 -3 re
f
0.75 w
q 1 0 0 1 328 431.25 cm
0 0 m
3 0 l
3 -3 l
0 -3 l
h
S
Q
Q
BT
10.5 0 0 10.5 337.75 426.75 Tm
(Using aggregate functions to return)Tj
-0.929 -1.214 Td
(totals and subtotals)Tj
ET
q
328 303 216.751 174 re
W n
328 398.25 3 -3 re
f
0.75 w
q 1 0 0 1 328 398.25 cm
0 0 m
3 0 l
3 -3 l
0 -3 l
h
S
Q
Q
BT
10.5 0 0 10.5 337.75 393.75 Tm
(Programming features of T-SQL)Tj
ET
q
328 303 216.751 174 re
W n
328 378 3 -3 re
f
0.75 w
q 1 0 0 1 328 378 cm
0 0 m
3 0 l
3 -3 l
0 -3 l
h
S
Q
Q
BT
10.5 0 0 10.5 337.75 373.5 Tm
(Table expressions)Tj
ET
q
328 303 216.751 174 re
W n
328 357.75 3 -3 re
f
0.75 w
q 1 0 0 1 328 357.75 cm
0 0 m
3 0 l
3 -3 l
0 -3 l
h
S
Q
Q
BT
10.5 0 0 10.5 337.75 353.25 Tm
(T-SQL specific data types and)Tj
-0.929 -1.214 Td
(functions)Tj
ET
q
328 303 216.751 174 re
W n
328 324.75 3 -3 re
f
0.75 w
q 1 0 0 1 328 324.75 cm
0 0 m
3 0 l
3 -3 l
0 -3 l
h
S
Q
Q
BT
10.5 0 0 10.5 337.75 320.25 Tm
(T-SQL cursors)Tj
1 g
/T1_0 1 Tf
14.25 0 0 14.25 64.75 267.75 Tm
(Course Description)Tj
0 g
/TT3 1 Tf
0.054 Tw 10.5 0 0 10.5 61.75 238.5 Tm
[(This Transact-SQL )2.5 (programming )2.1 (course )1.7 (teaches )2 (students )1.4 (relational )1.2 (database )2.3 (fundamentals)]TJ
0.286 Tw 0 -1.214 TD
[(and )1.3 (SQL )1.4 (programming )2 (skills in )0.5 (the )1.2 (Microsoft )1.3 (SQL )1.4 (Server )2.4 (environment. )2.5 (Topics covered)]TJ
0.389 Tw 0 -1.214 TD
[(include relational )0.9 (database )1.9 (architecture, )2.2 (database )1.9 (design )0.6 (techniques, )1.5 (and )1.1 (simple and)]TJ
0.484 Tw 0 -1.214 TD
[(complex )0.8 (query )1.1 (skills. The )0.6 (course )1.1 (also covers )1.1 (Microsoft-specific )0.7 (T-SQL )0.6 (programming)]TJ
0.344 Tw 0 -1.214 TD
[(constructs, )1.1 (creation )1 (and )0.9 (use )0.8 (of )0.7 (stored )0.8 (procedures )1.6 (and )0.8 (user-defined )1.6 (functions, )1.1 (use )0.8 (of)]TJ
0 Tw 0 -1.214 TD
(cursors and updateable views.)Tj
0.184 Tw 0 -2.214 TD
[(This class )0.8 (is intended )1.2 (for )1.5 (analysts, )1.7 (developers, )]TJ
0.191 Tw 25.099 0 Td
[(designers, )1.7 (administrators, )1.7 (and )1.6 (managers)]TJ
0.036 Tw -25.099 -1.214 Td
[(new )0.9 (to )0.7 (the )1.1 (SQL )1.4 (programming )2 (language. )]TJ
0.043 Tw 20.751 0 Td
[(Upon )0.9 (completion, )0.8 (participants )0.9 (will )-1.1 (understand )2 (SQL)]TJ
0 Tw -20.751 -1.214 Td
(functions, join techniques, )Tj
13.631 0 Td
(database objects and constraints, and will be able to write useful)Tj
-13.631 -1.214 Td
(stored )Tj
0.286 Tw 3.733 0 Td
[(procedures )2 (and )1.2 (views )0.5 (as )1.1 (well as )1.1 (complex )1.2 (queries )1.2 (and )1.3 (updates. )1.7 (Comprehensive)]TJ
0.377 Tw -3.733 -1.214 Td
[(hands )1.6 (on )1 (exercises )1.8 (are )1.7 (integrated )1.7 (throughout )1.8 (to )0.8 (reinforce)1.4 ( )0.8 (learning )1.3 (and )1.3 (develop )]TJ
0 Tw 44.53 0 Td
(real)Tj
-44.53 -1.214 Td
(competency.)Tj
1 g
/T1_0 1 Tf
14.25 0 0 14.25 64.75 54 Tm
(Course Prerequisites)Tj
ET
EMC
endstream
endobj
26 0 obj
<>
endobj
27 0 obj
(Lse"f_Gp )
endobj
36 0 obj
<>/Filter/FlateDecode/Height 110/Length 36528/Name/X/Subtype/Image/Type/XObject/Width 650>>stream
His8ʫE>@^8'qU @`c9e,qSGGb8u>n<3EU?fgz=3[=EQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQEQW+(2l4EQEQT#EQEQfz(("EQEY4"EQEQfa((ʌEQEY4!B:~DQP7_yH3UدQ#DMAٯMưd D.e KrKF@іV&?GdU}L}t`'D6rv~(.eO)GiIcT-fdBۂvsӠRCh>NaMRv%E|y˾+i5俩hvȻDPGPb'jZϝ (o$Y..Xy4n
.P..fF3bKRL_sy#N`H_`#
2г
$^Bp%ʁ?̌yJ͎ cD*]Ml5̐@FPfb3~h潠V(eb_[$@28k,g<0K!1C˂sR0%eؙ 2Y3&9db``R?قIWٮ\FX䁢:Bֿ&L^ڪwvғ- Gm> \HMRRguΪh4qK Sw(LI6nezX"{C3S. {Ų[l\6J#*ꜮKKpȁ2Mi/"lLٙDXdj'sy*/n+1-DC3ŊwvL<}b~k5[Woc'(~)a%(.O2Coxc$XI5u{ނN.q(eG%0dAK2S
F|4)XlI:4<=>|Zb&q4'>l)rDAP7Mݔ[
<3<]&V}k9`%VOw'_["O8,e*ɛƕ&ʛV{
0{:77LnD1IV<"ǵMبLNȋJ枏d:OR
: |b4xűtc+OLeJ9,Ⱥ~RoV[OjBNWJ~R`]F˞q4FCXJl,G'HIqPm
dy1awz+9LRi
BYD6֖?VN&bH(*lC3H2ry6~X
Gl
[mq$e
%m9X$
s]]uwvuΝ~=珟am+.ULf+@p\PR.נS`kdQXY.5SI{yMd|VX$!}4F*,0><.,+ہ52Rel8-<]"oy/Km( ١l9!ov/
.~k\Ryk2*̼lbt\*{UY;NMRIuZBQsOxp`P"OzA 2bF3,Ϟ:toigC*HaH"KNb9mHX!y++D#qKrSE}dxMR l]3x'ιbUyҜVNz8pђ[_NAFrǎnݶ.]|nz<0UɥsLшvN}-.F4#G^>&]4j
NLq
}59"WV(+t9b"d@y0:fBŕW+ 4'.T:|yݟb$]pRF`"~ɭϯ
m1_PI/S TZ}9lKT~R
HwMᢥb'30U c$DJRX caWɋщ
1OhYИTfV%@b8_d621_4:9-+,Aǧ
; hɗk+I2.%."̽y*$Qr̨e'kͥUBE 9_^w|8u9e|ɝr[, c)e` es5r0F\>Bpт;Gtz#N}.\|t"̞+t;]ABoCG_ʡbKЕ.R[Do0/ڻO9X
G:;7x,O^ xs\vq
ED
QLhUs|ݟ?ᑬ
2#}h
.뷐Ȟawq x(.y&r6?;?T7i+ˮŋ>[lcj7n]g*?v}GJfXv==+`tYϬ%v۰vo6~:_Os^u,sӓ\ҳ0fD><9 #ϫ^&r㛷nnKsE]_/V.=W(/qrK"/KWYy9xCl0tl XbpߑѶ[3#'N
\[0>}rjv$RC؏Ï
"Qda|/x6^v3.@ƳOI@yhTLٰi_fA]Wg(F+F
h[:&6t111("('9K2FA<\Ǿ^ZuüRTu@PP+;&Ɇ pcU5iV֖XIL>S *(m*MICVT#F~VeH 6{M I$K͖3sfzoȘxN)
oIYگ03[GOGdv;9 Fr:Bu<3
@Wo,Y&?mOLN>2&yS+Fgm&T,Zl
hwOԟ'o__0!,iX--/z2]y[6!Y
Y&b3
\ܜzɂ?C/@,w{d߬[
)LNhO~m=tvB?or6[vV!GO1G4O*4otNNW?ӆ~Ssgqal@N579,jߏ;m,qkwɇ\A8 0K%
Q癘wr.
.]pvq,ŕҲ]1N{=ӕ#@~mn^6AFyzѐ4JnӲQ&$q /&@ĞC!: ouh2?o8C?伸&Nwꡩ5wAQrij<>v,R ;Bsm]C='|I4|ĈQ 3ࡲ%rD3F)I9 2%4qH `oyEު}4Q`ujZKRs/
IE`%Ki(3묢6ǟ76>\h:|NEm_9*|e#GE=_54#@D
@ᣍ43~h1g|18sh2EޮoL
j ja?t'#fuǗUaNΝ7(i%E߾,#6
ND5=+a5bm8~
cP2Z]@D-Z+C]zP`NL#|22L~IPHc:ɓ'ѮnN]DD{=<<&&&rrr***''';;;751iOZb&z
tdd~~~㣣...ÇEǎ~M~~>LkroHHȞ={s300Ѷ6|mggm``ch`0>Bx%-
Xy$ҥK"cyy9"If{{;ocGGaOYY>bB{ff&VKr