{\rtf1\ansi\ansicpg1252\uc1 \deff0\deflang1033\deflangfe1033{\fonttbl{\f1\fswiss\fcharset0\fprq2{\*\panose 020b0604020202020204}Arial;}{\f2\fmodern\fcharset0\fprq1{\*\panose 02070309020205020404}Courier New;}
{\f3\froman\fcharset2\fprq2{\*\panose 05050102010706020507}Symbol;}{\f4\froman\fcharset0\fprq2{\*\panose 00000000000000000000}Times{\*\falt Times New Roman};}{\f14\fnil\fcharset2\fprq2{\*\panose 05000000000000000000}Wingdings;}
{\f28\fswiss\fcharset128\fprq2{\*\panose 020b0604020202020204}Arial Unicode MS;}{\f89\fswiss\fcharset128\fprq2 @Arial Unicode MS;}{\f98\fswiss\fcharset238\fprq2 Arial CE;}{\f99\fswiss\fcharset204\fprq2 Arial Cyr;}
{\f101\fswiss\fcharset161\fprq2 Arial Greek;}{\f102\fswiss\fcharset162\fprq2 Arial Tur;}{\f103\fswiss\fcharset177\fprq2 Arial (Hebrew);}{\f104\fswiss\fcharset178\fprq2 Arial (Arabic);}{\f105\fswiss\fcharset186\fprq2 Arial Baltic;}
{\f106\fmodern\fcharset238\fprq1 Courier New CE;}{\f107\fmodern\fcharset204\fprq1 Courier New Cyr;}{\f109\fmodern\fcharset161\fprq1 Courier New Greek;}{\f110\fmodern\fcharset162\fprq1 Courier New Tur;}
{\f111\fmodern\fcharset177\fprq1 Courier New (Hebrew);}{\f112\fmodern\fcharset178\fprq1 Courier New (Arabic);}{\f113\fmodern\fcharset186\fprq1 Courier New Baltic;}{\f316\fswiss\fcharset0\fprq2 Arial Unicode MS Western;}
{\f314\fswiss\fcharset238\fprq2 Arial Unicode MS CE;}{\f315\fswiss\fcharset204\fprq2 Arial Unicode MS Cyr;}{\f317\fswiss\fcharset161\fprq2 Arial Unicode MS Greek;}{\f318\fswiss\fcharset162\fprq2 Arial Unicode MS Tur;}
{\f319\fswiss\fcharset177\fprq2 Arial Unicode MS (Hebrew);}{\f320\fswiss\fcharset178\fprq2 Arial Unicode MS (Arabic);}{\f321\fswiss\fcharset186\fprq2 Arial Unicode MS Baltic;}{\f804\fswiss\fcharset0\fprq2 @Arial Unicode MS Western;}
{\f802\fswiss\fcharset238\fprq2 @Arial Unicode MS CE;}{\f803\fswiss\fcharset204\fprq2 @Arial Unicode MS Cyr;}{\f805\fswiss\fcharset161\fprq2 @Arial Unicode MS Greek;}{\f806\fswiss\fcharset162\fprq2 @Arial Unicode MS Tur;}
{\f807\fswiss\fcharset177\fprq2 @Arial Unicode MS (Hebrew);}{\f808\fswiss\fcharset178\fprq2 @Arial Unicode MS (Arabic);}{\f809\fswiss\fcharset186\fprq2 @Arial Unicode MS Baltic;}}{\colortbl;\red0\green0\blue0;\red0\green0\blue255;\red0\green255\blue255;
\red0\green255\blue0;\red255\green0\blue255;\red255\green0\blue0;\red255\green255\blue0;\red255\green255\blue255;\red0\green0\blue128;\red0\green128\blue128;\red0\green128\blue0;\red128\green0\blue128;\red128\green0\blue0;\red128\green128\blue0;
\red128\green128\blue128;\red192\green192\blue192;}{\stylesheet{\ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 \fs24\lang1033\langfe1033\loch\f28\hich\af28\dbch\af28\cgrid\langnp1033\langfenp1033 \snext0 Normal;}{
\s2\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\outlinelevel2\adjustright\rin0\lin0\itap0 \b\fs36\lang1033\langfe1033\loch\f28\hich\af28\dbch\af28\cgrid\langnp1033\langfenp1033 \sbasedon0 \snext2 heading 2;}{
\s3\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\outlinelevel3\adjustright\rin0\lin0\itap0 \b\fs27\lang1033\langfe1033\loch\f28\hich\af28\dbch\af28\cgrid\langnp1033\langfenp1033 \sbasedon0 \snext3 heading 3;}{\*\cs10 \additive 
Default Paragraph Font;}{\s15\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 \fs24\lang1033\langfe1033\loch\f28\hich\af28\dbch\af28\cgrid\langnp1033\langfenp1033 \sbasedon0 \snext15 Normal (Web);}}
{\*\listtable{\list\listtemplateid391701928\listhybrid{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\leveltemplateid1866076\'01\u-3913 ?;}{\levelnumbers;}\f3\fs20\chbrdr
\brdrnone\brdrcf1 \chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li720\jclisttab\tx720 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\leveltemplateid1412987684\'01o;}{\levelnumbers;}
\f2\fs20\chbrdr\brdrnone\brdrcf1 \chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li1440\jclisttab\tx1440 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\leveltemplateid-1777300790
\'01\u-3929 ?;}{\levelnumbers;}\f14\fs20\chbrdr\brdrnone\brdrcf1 \chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li2160\jclisttab\tx2160 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext
\leveltemplateid-872748680\'01\u-3929 ?;}{\levelnumbers;}\f14\fs20\chbrdr\brdrnone\brdrcf1 \chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li2880\jclisttab\tx2880 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0
\levelindent0{\leveltext\leveltemplateid935727494\'01\u-3929 ?;}{\levelnumbers;}\f14\fs20\chbrdr\brdrnone\brdrcf1 \chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li3600\jclisttab\tx3600 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0
\levelstartat1\levelspace0\levelindent0{\leveltext\leveltemplateid-1204678970\'01\u-3929 ?;}{\levelnumbers;}\f14\fs20\chbrdr\brdrnone\brdrcf1 \chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li4320\jclisttab\tx4320 }{\listlevel\levelnfc23\levelnfcn23\leveljc0
\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\leveltemplateid1115566932\'01\u-3929 ?;}{\levelnumbers;}\f14\fs20\chbrdr\brdrnone\brdrcf1 \chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li5040\jclisttab\tx5040 }{\listlevel\levelnfc23
\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\leveltemplateid1755473356\'01\u-3929 ?;}{\levelnumbers;}\f14\fs20\chbrdr\brdrnone\brdrcf1 \chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li5760\jclisttab\tx5760 }
{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\leveltemplateid-1525767344\'01\u-3929 ?;}{\levelnumbers;}\f14\fs20\chbrdr\brdrnone\brdrcf1 \chshdng0\chcfpat1\chcbpat1\fbias0 
\fi-360\li6480\jclisttab\tx6480 }{\listname ;}\listid258415634}{\list\listtemplateid169931338\listhybrid{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\leveltemplateid-1293354984
\'01\u-3913 ?;}{\levelnumbers;}\f3\fs20\chbrdr\brdrnone\brdrcf1 \chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li720\jclisttab\tx720 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext
\leveltemplateid854769580\'01o;}{\levelnumbers;}\f2\fs20\chbrdr\brdrnone\brdrcf1 \chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li1440\jclisttab\tx1440 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0
{\leveltext\leveltemplateid-1381231238\'01\u-3929 ?;}{\levelnumbers;}\f14\fs20\chbrdr\brdrnone\brdrcf1 \chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li2160\jclisttab\tx2160 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1
\levelspace0\levelindent0{\leveltext\leveltemplateid1141690688\'01\u-3929 ?;}{\levelnumbers;}\f14\fs20\chbrdr\brdrnone\brdrcf1 \chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li2880\jclisttab\tx2880 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0
\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\leveltemplateid14582156\'01\u-3929 ?;}{\levelnumbers;}\f14\fs20\chbrdr\brdrnone\brdrcf1 \chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li3600\jclisttab\tx3600 }{\listlevel\levelnfc23\levelnfcn23
\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\leveltemplateid1201063044\'01\u-3929 ?;}{\levelnumbers;}\f14\fs20\chbrdr\brdrnone\brdrcf1 \chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li4320\jclisttab\tx4320 }{\listlevel
\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\leveltemplateid2063382420\'01\u-3929 ?;}{\levelnumbers;}\f14\fs20\chbrdr\brdrnone\brdrcf1 \chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li5040
\jclisttab\tx5040 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\leveltemplateid755113318\'01\u-3929 ?;}{\levelnumbers;}\f14\fs20\chbrdr\brdrnone\brdrcf1 
\chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li5760\jclisttab\tx5760 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\leveltemplateid758036232\'01\u-3929 ?;}{\levelnumbers;}\f14\fs20
\chbrdr\brdrnone\brdrcf1 \chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li6480\jclisttab\tx6480 }{\listname ;}\listid1230458047}{\list\listtemplateid-171549304\listhybrid{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1
\levelspace0\levelindent0{\leveltext\leveltemplateid-1421171440\'01\u-3913 ?;}{\levelnumbers;}\f3\fs20\chbrdr\brdrnone\brdrcf1 \chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li720\jclisttab\tx720 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0
\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\leveltemplateid-191218346\'01o;}{\levelnumbers;}\f2\fs20\chbrdr\brdrnone\brdrcf1 \chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li1440\jclisttab\tx1440 }{\listlevel\levelnfc23\levelnfcn23
\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\leveltemplateid1652864470\'01\u-3929 ?;}{\levelnumbers;}\f14\fs20\chbrdr\brdrnone\brdrcf1 \chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li2160\jclisttab\tx2160 }{\listlevel
\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\leveltemplateid1170532682\'01\u-3929 ?;}{\levelnumbers;}\f14\fs20\chbrdr\brdrnone\brdrcf1 \chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li2880
\jclisttab\tx2880 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\leveltemplateid1109176090\'01\u-3929 ?;}{\levelnumbers;}\f14\fs20\chbrdr\brdrnone\brdrcf1 
\chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li3600\jclisttab\tx3600 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\leveltemplateid19451972\'01\u-3929 ?;}{\levelnumbers;}\f14\fs20\chbrdr
\brdrnone\brdrcf1 \chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li4320\jclisttab\tx4320 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\leveltemplateid1975025640
\'01\u-3929 ?;}{\levelnumbers;}\f14\fs20\chbrdr\brdrnone\brdrcf1 \chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li5040\jclisttab\tx5040 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext
\leveltemplateid1168388496\'01\u-3929 ?;}{\levelnumbers;}\f14\fs20\chbrdr\brdrnone\brdrcf1 \chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li5760\jclisttab\tx5760 }{\listlevel\levelnfc23\levelnfcn23\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0
\levelindent0{\leveltext\leveltemplateid-976737480\'01\u-3929 ?;}{\levelnumbers;}\f14\fs20\chbrdr\brdrnone\brdrcf1 \chshdng0\chcfpat1\chcbpat1\fbias0 \fi-360\li6480\jclisttab\tx6480 }{\listname ;}\listid1837957412}}{\*\listoverridetable
{\listoverride\listid258415634\listoverridecount0\ls1}{\listoverride\listid1837957412\listoverridecount0\ls2}{\listoverride\listid1230458047\listoverridecount0\ls3}}{\info{\title 077463}{\author Angela J. French}{\operator Angela J. French}
{\creatim\yr2002\mo8\dy27\hr9\min41}{\revtim\yr2002\mo8\dy27\hr9\min41}{\version2}{\edmins0}{\nofpages2}{\nofwords479}{\nofchars2733}{\*\company Element K}{\nofcharsws3356}{\vern8269}}
\widowctrl\ftnbj\aenddoc\noxlattoyen\expshrtn\noultrlspc\dntblnsbdb\nospaceforul\formshade\horzdoc\dgmargin\dghspace180\dgvspace180\dghorigin1701\dgvorigin1984\dghshow1\dgvshow1
\jexpand\viewkind5\viewscale100\pgbrdrhead\pgbrdrfoot\splytwnine\ftnlytwnine\htmautsp\nolnhtadjtbl\useltbaln\alntblind\lytcalctblwd\lyttblrtgr\lnbrkrule \fet0\sectd \linex0\endnhere\pgbrdropt32\sectlinegrid360\sectdefaultcl {\*\pnseclvl1
\pnucrm\pnstart1\pnindent720\pnhang{\pntxta .}}{\*\pnseclvl2\pnucltr\pnstart1\pnindent720\pnhang{\pntxta .}}{\*\pnseclvl3\pndec\pnstart1\pnindent720\pnhang{\pntxta .}}{\*\pnseclvl4\pnlcltr\pnstart1\pnindent720\pnhang{\pntxta )}}{\*\pnseclvl5
\pndec\pnstart1\pnindent720\pnhang{\pntxtb (}{\pntxta )}}{\*\pnseclvl6\pnlcltr\pnstart1\pnindent720\pnhang{\pntxtb (}{\pntxta )}}{\*\pnseclvl7\pnlcrm\pnstart1\pnindent720\pnhang{\pntxtb (}{\pntxta )}}{\*\pnseclvl8\pnlcltr\pnstart1\pnindent720\pnhang
{\pntxtb (}{\pntxta )}}{\*\pnseclvl9\pnlcrm\pnstart1\pnindent720\pnhang{\pntxtb (}{\pntxta )}}\pard\plain \s2\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\outlinelevel1\adjustright\rin0\lin0\itap0 
\b\fs36\lang1033\langfe1033\loch\af28\hich\af28\dbch\af28\cgrid\langnp1033\langfenp1033 {\f4 \hich\af4\dbch\af28\loch\f4 Microsoft SQL Server 2000: Querying with Transact-SQL}{\f1 
\par }\pard\plain \s3\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\outlinelevel2\adjustright\rin0\lin0\itap0 \b\fs27\lang1033\langfe1033\loch\af28\hich\af28\dbch\af28\cgrid\langnp1033\langfenp1033 {\f1 \hich\af1\dbch\af28\loch\f1 
Course Specifications
\par }\pard\plain \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 \fs24\lang1033\langfe1033\loch\af28\hich\af28\dbch\af28\cgrid\langnp1033\langfenp1033 {\f1\fs20 \hich\af1\dbch\af28\loch\f1 Course number: 077463\line 
Course length: Two days of training.\line Software: Microsoft_SQL_Server\~2000 
\par }\pard\plain \s3\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\outlinelevel2\adjustright\rin0\lin0\itap0 \b\fs27\lang1033\langfe1033\loch\af28\hich\af28\dbch\af28\cgrid\langnp1033\langfenp1033 {\f1 \hich\af1\dbch\af28\loch\f1 
Course Description
\par }\pard\plain \s15\ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 \fs24\lang1033\langfe1033\loch\af28\hich\af28\dbch\af28\cgrid\langnp1033\langfenp1033 {\f1\fs20 \hich\af1\dbch\af28\loch\f1 
This course teaches you how to use the Transact-SQL language to query a Microsoft SQL Server 2000 database. In addition, this course assists you in preparing for the Microsoft Certified Systems Engineer and Microsoft Certified Database Administrator Exam 
\hich\af1\dbch\af28\loch\f1 #\hich\af1\dbch\af28\loch\f1 70-229, Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition. 
\par }\pard\plain \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 \fs24\lang1033\langfe1033\loch\af28\hich\af28\dbch\af28\cgrid\langnp1033\langfenp1033 {\b\f1\fs20 \hich\af1\dbch\af28\loch\f1 Prerequisites:\~\~}{\f1\fs20 
\hich\af1\dbch\af28\loch\f1 To ensure your success, we recommend you first take any of the following Element K courses or have equivalent knowledge:
\par {\listtext\pard\plain\fs20\loch\af3\hich\af3\dbch\af28 \loch\af3\dbch\af28\hich\f3 \'b7\tab}}\pard \ql \fi-360\li720\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\jclisttab\tx720\aspalpha\aspnum\faauto\ls1\adjustright\rin0\lin720\itap0 {\i\f1\fs20 
\hich\af1\dbch\af28\loch\f1 Windows 2000: Introdu\hich\af1\dbch\af28\loch\f1 ction}{\f1\fs20 
\par {\listtext\pard\plain\fs20\loch\af3\hich\af3\dbch\af28 \loch\af3\dbch\af28\hich\f3 \'b7\tab}}{\i\f1\fs20 \hich\af1\dbch\af28\loch\f1 Windows 2000: Transition from Windows 98}{\f1\fs20 
\par {\listtext\pard\plain\fs20\loch\af3\hich\af3\dbch\af28 \loch\af3\dbch\af28\hich\f3 \'b7\tab}}{\i\f1\fs20 \hich\af1\dbch\af28\loch\f1 Windows Millennium Edition: Introduction}{\f1\fs20 
\par {\listtext\pard\plain\fs20\loch\af3\hich\af3\dbch\af28 \loch\af3\dbch\af28\hich\f3 \'b7\tab}}{\i\f1\fs20 \hich\af1\dbch\af28\loch\f1 Windows 98: Introduction}{\f1\fs20 
\par {\listtext\pard\plain\fs20\loch\af3\hich\af3\dbch\af28 \loch\af3\dbch\af28\hich\f3 \'b7\tab}}{\i\f1\fs20 \hich\af1\dbch\af28\loch\f1 Windows 98: Transition from Windows 3.1}{\f1\fs20 
\par {\listtext\pard\plain\fs20\loch\af3\hich\af3\dbch\af28 \loch\af3\dbch\af28\hich\f3 \'b7\tab}}{\i\f1\fs20 \hich\af1\dbch\af28\loch\f1 Windows 98: Transition from Windows 95}{\f1\fs20 
\par }\pard \ql \li0\ri0\sa240\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 {\f1\fs20 \line }{\b\f1\fs20 \hich\af1\dbch\af28\loch\f1 Delivery Method:\~\~}{\f1\fs20 \hich\af1\dbch\af28\loch\f1 Instructor-led, group-paced, classroom-delive
\hich\af1\dbch\af28\loch\f1 ry learning model with structured hands-on activities. 
\par }\pard\plain \s3\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\outlinelevel2\adjustright\rin0\lin0\itap0 \b\fs27\lang1033\langfe1033\loch\af28\hich\af28\dbch\af28\cgrid\langnp1033\langfenp1033 {\f1 \hich\af1\dbch\af28\loch\f1 
Hardware/Software Requirements
\par }\pard\plain \s15\ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 \fs24\lang1033\langfe1033\loch\af28\hich\af28\dbch\af28\cgrid\langnp1033\langfenp1033 {\f1\fs20 \hich\af1\dbch\af28\loch\f1 You will need:
\par {\listtext\pard\plain\fs20\loch\af3\hich\af3\dbch\af28 \loch\af3\dbch\af28\hich\f3 \'b7\tab}}\pard\plain \ql \fi-360\li720\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\jclisttab\tx720\aspalpha\aspnum\faauto\ls2\adjustright\rin0\lin720\itap0 
\fs24\lang1033\langfe1033\loch\af28\hich\af28\dbch\af28\cgrid\langnp1033\langfenp1033 {\f1\fs20 \hich\af1\dbch\af28\loch\f1 At least 128 MB of RAM for each student computer (256 MB strongly recommended). At least 256 MB for the instructor's computer. 

\par {\listtext\pard\plain\fs20\loch\af3\hich\af3\dbch\af28 \loch\af3\dbch\af28\hich\f3 \'b7\tab}}\pard \ql \fi-360\li720\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\jclisttab\tx720\aspalpha\aspnum\faauto\ls2\adjustright\rin0\lin720\itap0 {\f1\fs20 
\hich\af1\dbch\af28\loch\f1 A 2 GB or larger hard dr\hich\af1\dbch\af28\loch\f1 ive for each of the student computers, and a 4 GB or larger hard drive for the instructor's computer. 
\par {\listtext\pard\plain\fs20\loch\af3\hich\af3\dbch\af28 \loch\af3\dbch\af28\hich\f3 \'b7\tab}\hich\af1\dbch\af28\loch\f1 A Pentium 166 MHz processor or faster.
\par {\listtext\pard\plain\fs20\loch\af3\hich\af3\dbch\af28 \loch\af3\dbch\af28\hich\f3 \'b7\tab}\hich\af1\dbch\af28\loch\f1 A VGA or higher resolution video card and monitor.
\par {\listtext\pard\plain\fs20\loch\af3\hich\af3\dbch\af28 \loch\af3\dbch\af28\hich\f3 \'b7\tab}\hich\af1\dbch\af28\loch\f1 A mouse or compatible tracking device. 
\par {\listtext\pard\plain\fs20\loch\af3\hich\af3\dbch\af28 \loch\af3\dbch\af28\hich\f3 \'b7\tab}\hich\af1\dbch\af28\loch\f1 A 12 X (or faster) CD-R\hich\af1\dbch\af28\loch\f1 OM drive.
\par {\listtext\pard\plain\fs20\loch\af3\hich\af3\dbch\af28 \loch\af3\dbch\af28\hich\f3 \'b7\tab}\hich\af1\dbch\af28\loch\f1 A network adapter and network cabling.
\par {\listtext\pard\plain\fs20\loch\af3\hich\af3\dbch\af28 \loch\af3\dbch\af28\hich\f3 \'b7\tab}\hich\af1\dbch\af28\loch\f1 A licensed copy of Windows 2000 Server or Advanced Server for each student and the instructor. 
\par {\listtext\pard\plain\fs20\loch\af3\hich\af3\dbch\af28 \loch\af3\dbch\af28\hich\f3 \'b7\tab}\hich\af1\dbch\af28\loch\f1 Windows 2000 Service Pack 1 or later.
\par {\listtext\pard\plain\fs20\loch\af3\hich\af3\dbch\af28 \loch\af3\dbch\af28\hich\f3 \'b7\tab}\hich\af1\dbch\af28\loch\f1 A licensed copy of Microsoft SQL Server 2000 Enterprise Edition for each \hich\af1\dbch\af28\loch\f1 student and the instructor. 

\par {\listtext\pard\plain\fs20\loch\af3\hich\af3\dbch\af28 \loch\af3\dbch\af28\hich\f3 \'b7\tab}\hich\af1\dbch\af28\loch\f1 For the instructor's computer only, a display system to project the instructor's computer screen and PowerPoint slides. 
\par }\pard \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 {\f1\fs20 
\par }\pard\plain \s3\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\outlinelevel2\adjustright\rin0\lin0\itap0 \b\fs27\lang1033\langfe1033\loch\af28\hich\af28\dbch\af28\cgrid\langnp1033\langfenp1033 {\f1 \hich\af1\dbch\af28\loch\f1 
Performance-Based Objectives
\par {\listtext\pard\plain\fs20\loch\af3\hich\af3\dbch\af28 \loch\af3\dbch\af28\hich\f3 \'b7\tab}}\pard\plain \ql \fi-360\li720\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\jclisttab\tx720\aspalpha\aspnum\faauto\ls3\adjustright\rin0\lin720\itap0 
\fs24\lang1033\langfe1033\loch\af28\hich\af28\dbch\af28\cgrid\langnp1033\langfenp1033 {\f1\fs20 \hich\af1\dbch\af28\loch\f1 Identify the features of Transact-SQL and use the Transact-SQL \hich\af1\dbch\af28\loch\f1 utilities to query a SQL server. 
\par {\listtext\pard\plain\fs20\loch\af3\hich\af3\dbch\af28 \loch\af3\dbch\af28\hich\f3 \'b7\tab}}\pard \ql \fi-360\li720\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\jclisttab\tx720\aspalpha\aspnum\faauto\ls3\adjustright\rin0\lin720\itap0 {\f1\fs20 
\hich\af1\dbch\af28\loch\f1 Retrieve data by using the SELECT statement.
\par {\listtext\pard\plain\fs20\loch\af3\hich\af3\dbch\af28 \loch\af3\dbch\af28\hich\f3 \'b7\tab}\hich\af1\dbch\af28\loch\f1 Modify data by using the INSERT, UPDATE, and DELETE statements.
\par {\listtext\pard\plain\fs20\loch\af3\hich\af3\dbch\af28 \loch\af3\dbch\af28\hich\f3 \'b7\tab}\hich\af1\dbch\af28\loch\f1 Summarize data by using the TOP, GROUP BY, COMPUTE, and COMPUTE BY clauses. 
\par {\listtext\pard\plain\fs20\loch\af3\hich\af3\dbch\af28 \loch\af3\dbch\af28\hich\f3 \'b7\tab}\hich\af1\dbch\af28\loch\f1 Query multiple tables through the us\hich\af1\dbch\af28\loch\f1 e of joins.
\par {\listtext\pard\plain\fs20\loch\af3\hich\af3\dbch\af28 \loch\af3\dbch\af28\hich\f3 \'b7\tab}\hich\af1\dbch\af28\loch\f1 Design subqueries.
\par {\listtext\pard\plain\fs20\loch\af3\hich\af3\dbch\af28 \loch\af3\dbch\af28\hich\f3 \'b7\tab}\hich\af1\dbch\af28\loch\f1 Work with full-text indexes. 
\par {\listtext\pard\plain\fs20\loch\af3\hich\af3\dbch\af28 \loch\af3\dbch\af28\hich\f3 \'b7\tab}\hich\af1\dbch\af28\loch\f1 Describe the types of programming objects in Transact-SQL.
\par }\pard \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 {\f1\fs20 
\par }\pard\plain \s3\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\outlinelevel2\adjustright\rin0\lin0\itap0 \b\fs27\lang1033\langfe1033\loch\af28\hich\af28\dbch\af28\cgrid\langnp1033\langfenp1033 {\f1 \hich\af1\dbch\af28\loch\f1 
Course Content
\par }\pard\plain \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 \fs24\lang1033\langfe1033\loch\af28\hich\af28\dbch\af28\cgrid\langnp1033\langfenp1033 {\b\f1\fs20 \hich\af1\dbch\af28\loch\f1 Lesson 1: Exploring Transact-SQL}{
\f1\fs20 
\par }\pard \ql \li720\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin720\itap0 {\f1\fs20 \hich\af1\dbch\af28\loch\f1 Topic 1A: An Overview of SQL Server and Transact-SQL
\par \hich\af1\dbch\af28\loch\f1 Topic 1B: Programming in Transact\hich\af1\dbch\af28\loch\f1 -SQL
\par }\pard \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 {\f1\fs20 
\par }{\b\f1\fs20 \hich\af1\dbch\af28\loch\f1 Lesson 2: Querying Data}{\f1\fs20 
\par }\pard \ql \li720\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin720\itap0 {\f1\fs20 \hich\af1\dbch\af28\loch\f1 Topic 2A: Using the SELECT Statement
\par \hich\af1\dbch\af28\loch\f1 Topic 2B: Formatting the Results Set
\par }\pard \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 {\f1\fs20 
\par }{\b\f1\fs20 \hich\af1\dbch\af28\loch\f1 Lesson 3: Changing Data Through Queries}{\f1\fs20 
\par }\pard \ql \li720\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin720\itap0 {\f1\fs20 \hich\af1\dbch\af28\loch\f1 Topic 3A: Inserting Data
\par \hich\af1\dbch\af28\loch\f1 Topic 3B: Deleting Data
\par \hich\af1\dbch\af28\loch\f1 Topic 3C: Updating Data
\par }\pard \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 {\f1\fs20 
\par }{\b\f1\fs20 \hich\af1\dbch\af28\loch\f1 Lesson 4: Summarizing Data}{\f1\fs20 
\par }\pard \ql \li720\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin720\itap0 {\f1\fs20 \hich\af1\dbch\af28\loch\f1 Topic 4A: Working with Aggregate Functions 
\par \hich\af1\dbch\af28\loch\f1 Topic 4B: Grouping Data
\par }\pard \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 {\f1\fs20 
\par }{\b\f1\fs20 \hich\af1\dbch\af28\loch\f1 Lesson 5: Joining Tables }{\f1\fs20 
\par }\pard \ql \li720\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin720\itap0 {\f1\fs20 \hich\af1\dbch\af28\loch\f1 Topic 5A: Querying Multiple Tables 
\par \hich\af1\dbch\af28\loch\f1 Topic 5B: Implementing Advanced Table Joins 
\par }\pard \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 {\f1\fs20 
\par }{\b\f1\fs20 \hich\af1\dbch\af28\loch\f1 Lesson 6: Implementing Subqueries}{\f1\fs20 
\par }\pard \ql \li720\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin720\itap0 {\f1\fs20 \hich\af1\dbch\af28\loch\f1 Topic 6A: Designing Subqueries 
\par }\pard \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 {\f1\fs20 
\par }{\b\f1\fs20 \hich\af1\dbch\af28\loch\f1 Lesson 7:\hich\af1\dbch\af28\loch\f1  Working with Full-text Indexes}{\f1\fs20 
\par }\pard \ql \li720\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin720\itap0 {\f1\fs20 \hich\af1\dbch\af28\loch\f1 Topic 7A: Implementing the Microsoft Search Service
\par \hich\af1\dbch\af28\loch\f1 Topic 7B: Querying Full-text Indexes
\par }\pard \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 {\f1\fs20 
\par }{\b\f1\fs20 \hich\af1\dbch\af28\loch\f1 Lesson 8: Programming Transact-SQL}{\f1\fs20 
\par }\pard \ql \li720\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin720\itap0 {\f1\fs20 \hich\af1\dbch\af28\loch\f1 Topic 8A: Creating and Managing Views
\par \hich\af1\dbch\af28\loch\f1 Topic 8B: Implementing Stored Procedures, Triggers, and User\hich\af1\dbch\af28\loch\f1 -defined Functions 
\par }\pard \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 {\f1\fs20 
\par }{\b\f1\fs20 \hich\af1\dbch\af28\loch\f1 Appendix A: The Movies Database Structure}{\f1\fs20 
\par }\pard \ql \li720\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin720\itap0 {\f1\fs20 \hich\af1\dbch\af28\loch\f1 Table DesignTopic 
\par }\pard \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 {
\par }}