%PDF-1.6
%
1 0 obj
<>
endobj
2 0 obj
<>stream
2021-02-25T06:13:35-05:00
2021-02-25T06:13:35-05:00
2021-02-25T06:13:35-05:00
Adobe Acrobat 21.0
application/pdf
Microsoft Transact-SQL Training | T-SQL Programming Course | Learn T-SQL
uuid:128d5451-d8cb-4dd0-b77c-2563bc357bd4
uuid:49caf3c9-3cd0-42f7-bcf9-c9ab3996f9f5
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 40 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/Canada/CoursesPDF/Transact-\
SQL-Programming-Courses.htm)Tj
46.855 0 Td
([2/25/2021 6:13:35 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
( 5 Days )Tj
/TT4 1 Tf
9.48 0 Td
(\(Face-to-Face & Remote-Live\))Tj
/TT3 1 Tf
15.164 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
-31.658 -2.214 Td
(Price:)Tj
0 g
/TT3 1 Tf
3.227 0 Td
( CDN$3,275 )Tj
/TT4 1 Tf
6.462 0 Td
(\(Face-to-Face & Remote-Live\))Tj
/TT3 1 Tf
15.164 0 Td
(, or CDN$1,995 )Tj
/TT4 1 Tf
8.211 0 Td
(\(On-Demand\))Tj
0.137 0.322 0.486 rg
/TT2 1 Tf
-33.064 -2.214 Td
(Discounts:)Tj
0 g
/TT3 1 Tf
5.916 0 Td
( We offer multiple discount options. )Tj
0.137 0.322 0.486 rg
18.297 0 Td
(Click here)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 315.9854 561.75 cm
0 0 m
52.105 0 l
h
S
Q
Q
BT
0 g
10.5 0 0 10.5 368.0906 562.5 Tm
( for more info.)Tj
0.137 0.322 0.486 rg
/TT2 1 Tf
0.429 Tw -29.175 -2.214 Td
[(Delivery )1 (Options:)]TJ
0 g
/TT3 1 Tf
0.441 Tw [( )0.9 (Atten)0.8 (d )0.9 (face-to-face )3.1 (in )0.8 (the )1.3 (classroom, )]TJ
0.137 0.322 0.486 rg
0 Tw 32.218 0 Td
(remote-live)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 400.0432 538.5 cm
0 0 m
60.713 0 l
h
S
Q
Q
BT
0 g
0.464 Tw 10.5 0 0 10.5 460.7566 539.25 Tm
( or )Tj
0.137 0.322 0.486 rg
0 Tw 2.665 0 Td
(on-demand)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 488.7432 538.5 cm
0 0 m
60.288 0 l
h
S
Q
Q
BT
10.5 0 0 10.5 61.75 526.5 Tm
(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 61.75 525.75 cm
0 0 m
40.518 0 l
h
S
Q
Q
BT
0 g
10.5 0 0 10.5 102.2683 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
(|Xঀ|=b)
endobj
36 0 obj
<>/Filter/FlateDecode/Height 110/Length 35579/Name/X/Subtype/Image/Type/XObject/Width 650>>stream
HST[[5a
$#P1fEOE}怘0y憙;=g*G~>NۧO_~!B!B!B!B!B!B!B!B!B!B!B!B!B![,k'BȒb&!BȒ"B!diIBYZ8)B!,-2.!BN&C!%B!diI;XI[zv{ct3z]dzk7c"_ª`MT-H @[3\?KzkoX ?8 .3PL#RT/Gٜhz/-lEjb[7_hO
.(>c.YW/!%_pKr8OXNZ,lj'u.p݂k&R
!- I'-")2X "ca9=e'тUkE[.Z^d
]x[!k6\fK2|zU3dQ)lo%)lC7{*:iHپH YB%-
݅f<.z
(fJQ8$}d9U%D=p
/esa.8WbOOH<#qܒ o:*]k=%b#y$=@-X/ДOLOi,TB̤V SA##ŭQ
8
-^6ќic-
T;M<wFr
ks =L9{hC.U`