ŠĻą”±į>ž’ OQž’’’N’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’ģ„Į7 ųæ¶bjbjUU 0,7|7|“’’’’’’l>>>>>>>RŲ Ų Ų 8 $ <Rv:¶l l l l l l ¬ l„ 8–6˜6˜6˜6cū6rm8rß9$,; L=˜:->¼ l l ¼ ¼ :ś >>l l 0:ś ś ś ¼ >l >l –6ś ¼ –6ś –ś ¦30>>–6l ` € ęAµ‡ĄR†Ų Ņ "24$–6F:0v:V4@ä=ō ä=–6ś RR>>>>ŁCIP Code:  FORMTEXT 11.0201 METROPOLITAN STATE COLLEGE OF DENVER Omnibus Course Syllabus School of  FORMTEXT Letters, Arts, and Sciences Department:  FORMTEXT Mathematical and Computer Sciences Instructor:  FORMTEXT Robert Pfeifle Prefix and Course Number:  FORMTEXT CSS 190 Semester/year offered:  FORMTEXT Fall 2001 Banner Number (for Academic Affairs use):__________________________ Course Title:  FORMTEXT SQL Server Administration Credit Hours:  FORMTEXT 4 Contact Hours-students:  FORMTEXT 60 Total Other Hours*:  FORMTEXT       Contact Hours-faculty:  FORMTEXT       Meeting Times/Dates:  FORMTEXT TR 7:00-8:50 pm Grading Mode(s):  FORMTEXT Letter Schedule Type(s):  FORMTEXT Lecture Prerequisites/Corequisites: CSS 1247 or 1607 or CSI 1300 or MTH 1510 or prior programming experience Required Reading Materials (author, title, publisher, copyright date): Inside Microsoft SQL Server 2000, by Karen Delaney, Microsoft Press, 2000 Evaluation of Student Performance: 1. Homework and programming assignments 2. Examination 3. Final examination Specific (measurable) Student Behavioral Learning Objectives: Upon completion of this course student should be able to: Employ basic database concepts in system design Design a database system adhering to principles of security, permissions, backups, and performance Effectively utilize tools to design, analyze, and trouble shoot database systems Use SQL Server as a tool to perform data-warehousing, including advanced select and querying capabilities Detailed outline of course content (major topics and subtopics) or outline of field experience/ internship (experience, responsibilities and supervision): Database Concepts I. Database Concepts Define Key elements of a database Understand how SQL Server stores databases Installing SQL Server II. Security and Backups Theoretical foundation of SQL Server security Add login accounts Assign permissions and manage users through groups Develop and maintain backup procedures III. Database Development Database design Database programming fundamentals Tools for table design Transformation service functionality IV. Data Manipulation Data retrieval tools Using SQL Modify data with queries using, Insert, Update, and Delete statements Unions, Joins and aggregate functions V. Performance Tuning Indexing for performmance Determine when to use an index Differentiate between clustered, non-clustered, and SQL Server indexes VI. System design Developing systems with Visual Basic Using the Active X data object of Visual Basic Creating N-Tier projects Approved - Omnibus course: _________________________________________________________ __________________ Department Chair Date _________________________________________________________ __________________ Dean of School Date _________________________________________________________ __________________ Associate Vice President for Academic Affairs Date Approved - Field Experience/Internship Only: ______________________________________________________________________________ Location of Internship _________________________________________________________ __________________ Faculty Evaluation Group Date _________________________________________________________ __________________ Field Supervisor** Date **Approval by the Field Supervisor is required and must be indicated by the original signature of that supervisor on the syllabus. Guidelines as set forth in the omnibus course section of the Bulletin must be followed. An accurate copy of each course syllabus must be on file in the Office of Academic Affairs prior to the listing of such course in any semester schedule.   !`jkuvw’“””¢¬­®ŠŃįāģķīüżž$%&-.GHRST]^_²³½¾æŲŁŚéźōõö÷ųł÷ķłåł÷÷ł÷Ūłåł÷ł÷Ńłåłł÷Ēłåł÷ł÷½łåłł÷³łåł÷ł÷©łåł÷ł÷Ÿłåłj>*Ujt>*Ujī>*Ujl>*UjÜ>*Uj$>*Uj„>*U>*mHnHuj>*U>* j>*U>!"G_`”•ž’_£¤ŚŪ–ģīVXöųabcŖōõśśõõõõóóóóóóóóóķóóóóóóóóóóó„@ `„@ $a$$a$“µżżų$&:<>BDnp„†ˆ’”ÄĘŚÜŽčź.02RTz|’” ¢ŹĢąāäņōUV^xĻū?bmĀĆ³¶ł÷ķłåłł÷ŪłĻłł÷ÅłĻłł÷»łåłł÷±łåłł÷§łåł÷££ œ – 56CJ>*CJCJ56j >*Ujˆ>*Ujņ>*Uj|>*Uj>*UmHnHuj>*U>*mHnHuj>*U>* j>*U7õö B R h i j k © ć  v Ē 2 3 4 5 Š Ń ć ł żżżżżżżżżżųųųųżżżŌŌŌŌ#$d%d&d'dNĘ’’’OĘ’’’PĘ’’’QĘ’’’ & Fł  F \ ] w „ ø ė   . ŲŲŲ°ŒeeeeŒŒ' & F $d%d&d'dNĘ’’’OĘ’’’PĘ’’’QĘ’’’#$d%d&d'dNĘ’’’OĘ’’’PĘ’’’QĘ’’’'„Š$d%d&d'dNĘ’’’OĘ’’’PĘ’’’QĘ’’’^„Š' & F $d%d&d'dNĘ’’’OĘ’’’PĘ’’’QĘ’’’ . ? a x  ž µ Ź Ō @AXŲŲŲŲ““““' & F $d%d&d'dNĘ’’’OĘ’’’PĘ’’’QĘ’’’#$d%d&d'dNĘ’’’OĘ’’’PĘ’’’QĘ’’’' & F $d%d&d'dNĘ’’’OĘ’’’PĘ’’’QĘ’’’ Xr‘ŲŁķB[]^yŲŲŲ““““f&dh$d%d&d'dNĘOĘPĘQĘ' & F$d%d&d'dNĘ’’’OĘ’’’PĘ’’’QĘ’’’#$d%d&d'dNĘ’’’OĘ’’’PĘ’’’QĘ’’’' & F$d%d&d'dNĘ’’’OĘ’’’PĘ’’’QĘ’’’ yĘć0K˜ĪĻüKbÆÓ ?ĀĆŪ“Ū“ŪŪ“Ū“Ū“ŪŪ#$d%d&d'dNĘ’’’OĘ’’’PĘ’’’QĘ’’’&dh$d%d&d'dNĘOĘPĘQĘ#$d%d&d'dNĘOĘPĘQĘĆ“µ¶ŪŁŪ#$d%d&d'dNĘ’’’OĘ’’’PĘ’’’QĘ’’’. 00P°Š/ °ą=!° "° # $ %°° ° „D’’’’Text1511.0201 D’’’’Letters, Arts, and SciencesøD’’’’Text2"Mathematical and Computer SciencesD’’’’Text3Robert Pfeifle‚D’’’’Text4CSS 190†D’’’’Text5 Fall 2001¦D’’’’Text6SQL Server AdministrationvD’’’’Text74xD’’’’Text860tD’’’’Text9vD’’’’Text10–D’’’’Text11TR 7:00-8:50 pm‚D’’’’Text12Letter„D’’’’Text13Lecture i<@ń’< Normal1$CJ_HhmH sH tH <A@ņ’”< Default Paragraph Font4&@¢ń4 Footnote Reference,, Header  ĘąĄ!, , Footer  ĘąĄ!¶,’’’’!"G_`”•ž’_£¤ŚŪKvw«¬ūüabcŖōõöBRhijk©ćvĒ2345ŠŃćłF\]w„øė.?axžµŹŌ @ A X r ‘ Ų Ł ķ  B [ ] ^ y Ę ć 0 K ˜ Ī Ļ ü K b Æ Ó ? Ā Ć ·˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜ 0€€˜ 0€€˜ 0€€˜ 0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜ 0€€˜ 0€€˜ 0€€˜0€€˜0€€˜ 0€€˜ 0€€˜ 0€€˜ 0€€˜0€€˜0€€˜ 0€€˜ 0€€˜ 0€€˜ 0€€˜0€€˜0€€˜ 0€€˜ 0€€˜ 0€€˜ 0€€˜0€€˜0€€˜ 0€€˜ 0€€˜ 0€€˜0€€˜0€€˜ 0€€˜ 0€€˜ 0€€š0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€ų¶ õł . Xyƶ µ jv’”­Šįķü%-GS]²¾Ųéõ÷!7CIbntŒ˜©½ÉŠåńł¶F“’•€F“’•€F“’•€F“’•€F“’•€F“’•€F“’•€F“’•€F“’•€FŌ’•€FŌ’•€F“’•€F“’•€F“’•€’’ Text15Text2Text3Text4Text5Text6Text7Text8Text9Text10Text11Text12Text13 ¢āH³ź8c¾ę· Ńż.^Łų"JuŖŃś·e q ·‡‰[ ] ·3 j“”Ńįż.G^²Łéų"7JbuŒŖ½ŃåśōõBiF[xX r [ \ ^ y ·’’Metro State College'C:\sdrivecurr.word\omnibus syllabus.docMetro State College'C:\sdrivecurr.word\omnibus syllabus.docMetro State College'C:\sdrivecurr.word\omnibus syllabus.docMetro State College.C:\sdrivecurr.word\omnibus syllabus.june00.docPreinstalled UserA:\omnibus syllabus.june00.docinfotech4C:\TEMP\AutoRecovery save of omnibus syllabus.june00infotechA:\omnibus syllabus.june00.docPreinstalled User+C:\Syllabus\CSS\omnibus syllabus.june00.docPreinstalled User+C:\Syllabus\CSS\omnibus syllabus.june00.docPreinstalled User+C:\Syllabus\CSS\omnibus syllabus.june00.doc"$<=ŠŠ’’’’’’’’’k:ģŖv;’’’’’’’’’Įq’ŗ$xŠ’’’’’’’’’ŪCŗ$xŠ’’’’’’’’’JÖ&L› …’’’’’’’’’ŽA':ĻĪĶ’’’’’’’’’V0ø^˜5’’’’’’’’’ā3z6J X+’’’’’’’’’ @‘KJ‡’’’’’’’’’pQOF­l`’’’’’’’’’:A2T&|’’’’’’’’’¤=3U¤ō­’’’’’’’’’ńCGh¦·†P’’’’’’’’’™|ÄlL› …’’’’’’’’’Š2.yņšņa’’’’’’’’’h„Š„˜žĘŠ^„Š`„˜ž.h„ „˜žĘ ^„ `„˜ž.’h„p„L’Ęp^„p`„L’.h„@ „˜žĘ@ ^„@ `„˜ž.h„„˜žĘ^„`„˜ž.’h„ą„L’Ęą^„ą`„L’.h„°„˜žĘ°^„°`„˜ž.h„€„˜žĘ€^„€`„˜ž.’h„P„L’ĘP^„P`„L’.„8„˜žĘ8^„8`„˜žo(.€„„˜žĘ^„`„˜ž.‚„Ų „L’ĘŲ ^„Ų `„L’.€„Ø „˜žĘØ ^„Ø `„˜ž.€„x„˜žĘx^„x`„˜ž.‚„H„L’ĘH^„H`„L’.€„„˜žĘ^„`„˜ž.€„č„˜žĘč^„č`„˜ž.‚„ø„L’Ęø^„ø`„L’.„Š„˜žĘŠ^„Š`„˜žo(.€„ „˜žĘ ^„ `„˜ž.‚„p„L’Ęp^„p`„L’.€„@ „˜žĘ@ ^„@ `„˜ž.€„„˜žĘ^„`„˜ž.‚„ą„L’Ęą^„ą`„L’.€„°„˜žĘ°^„°`„˜ž.€„€„˜žĘ€^„€`„˜ž.‚„P„L’ĘP^„P`„L’.h „Š„˜žĘŠ^„Š`„˜žOJQJo(·š€„ „˜žĘ ^„ `„˜ž.‚„p„L’Ęp^„p`„L’.€„@ „˜žĘ@ ^„@ `„˜ž.€„„˜žĘ^„`„˜ž.‚„ą„L’Ęą^„ą`„L’.€„°„˜žĘ°^„°`„˜ž.€„€„˜žĘ€^„€`„˜ž.‚„P„L’ĘP^„P`„L’.h „„˜žĘ^„`„˜žOJQJo(·š€„Ų „˜žĘŲ ^„Ų `„˜ž.‚„Ø „L’ĘØ ^„Ø `„L’.€„x„˜žĘx^„x`„˜ž.€„H„˜žĘH^„H`„˜ž.‚„„L’Ę^„`„L’.€„č„˜žĘč^„č`„˜ž.€„ø„˜žĘø^„ø`„˜ž.‚„ˆ„L’Ęˆ^„ˆ`„L’.„8„˜žĘ8^„8`„˜žo(.€„„˜žĘ^„`„˜ž.‚„Ų „L’ĘŲ ^„Ų `„L’.€„Ø „˜žĘØ ^„Ø `„˜ž.€„x„˜žĘx^„x`„˜ž.‚„H„L’ĘH^„H`„L’.€„„˜žĘ^„`„˜ž.€„č„˜žĘč^„č`„˜ž.‚„ø„L’Ęø^„ø`„L’.„8„˜žĘ8^„8`„˜žo(.€„„˜žĘ^„`„˜ž.‚„Ų „L’ĘŲ ^„Ų `„L’.€„Ø „˜žĘØ ^„Ø `„˜ž.€„x„˜žĘx^„x`„˜ž.‚„H„L’ĘH^„H`„L’.€„„˜žĘ^„`„˜ž.€„č„˜žĘč^„č`„˜ž.‚„ø„L’Ęø^„ø`„L’.„8„˜žĘ8^„8`„˜žo(.„p„0żĘp^„p`„0żo(.‚„Ų „L’ĘŲ ^„Ų `„L’.€„Ø „˜žĘØ ^„Ø `„˜ž.€„x„˜žĘx^„x`„˜ž.‚„H„L’ĘH^„H`„L’.€„„˜žĘ^„`„˜ž.€„č„˜žĘč^„č`„˜ž.‚„ø„L’Ęø^„ø`„L’.„Š„˜žĘŠ^„Š`„˜žo(.€„ „˜žĘ ^„ `„˜ž.‚„p„L’Ęp^„p`„L’.€„@ „˜žĘ@ ^„@ `„˜ž.€„„˜žĘ^„`„˜ž.‚„ą„L’Ęą^„ą`„L’.€„°„˜žĘ°^„°`„˜ž.€„€„˜žĘ€^„€`„˜ž.‚„P„L’ĘP^„P`„L’.„Š„˜žĘŠ^„Š`„˜žo(.„„0żĘ^„`„0żo(.‚„p„L’Ęp^„p`„L’.€„@ „˜žĘ@ ^„@ `„˜ž.€„„˜žĘ^„`„˜ž.‚„ą„L’Ęą^„ą`„L’.€„°„˜žĘ°^„°`„˜ž.€„€„˜žĘ€^„€`„˜ž.‚„P„L’ĘP^„P`„L’.h„Š„˜žĘŠ^„Š`„˜ž.h„ „˜žĘ ^„ `„˜ž.’h„p„L’Ęp^„p`„L’.h„@ „˜žĘ@ ^„@ `„˜ž.h„„˜žĘ^„`„˜ž.’h„ą„L’Ęą^„ą`„L’.h„°„˜žĘ°^„°`„˜ž.h„€„˜žĘ€^„€`„˜ž.’h„P„L’ĘP^„P`„L’.„8„˜žĘ8^„8`„˜žo(.€„„˜žĘ^„`„˜ž.‚„Ų „L’ĘŲ ^„Ų `„L’.€„Ø „˜žĘØ ^„Ø `„˜ž.€„x„˜žĘx^„x`„˜ž.‚„H„L’ĘH^„H`„L’.€„„˜žĘ^„`„˜ž.€„č„˜žĘč^„č`„˜ž.‚„ø„L’Ęø^„ø`„L’.h„Š„˜žĘŠ^„Š`„˜ž.h„ „˜žĘ ^„ `„˜ž.’h„p„L’Ęp^„p`„L’.h„@ „˜žĘ@ ^„@ `„˜ž.h„„˜žĘ^„`„˜ž.’h„ą„L’Ęą^„ą`„L’.h„°„˜žĘ°^„°`„˜ž.h„€„˜žĘ€^„€`„˜ž.’h„P„L’ĘP^„P`„L’.„Ų „˜žĘŲ ^„Ų `„˜žo(.€„Ø „˜žĘØ ^„Ø `„˜ž.‚„x„L’Ęx^„x`„L’.€„H„˜žĘH^„H`„˜ž.€„„˜žĘ^„`„˜ž.‚„č„L’Ęč^„č`„L’.€„ø„˜žĘø^„ø`„˜ž.€„ˆ„˜žĘˆ^„ˆ`„˜ž.‚„X „L’ĘX ^„X `„L’.„8„˜žĘ8^„8`„˜žo(.€„„˜žĘ^„`„˜ž.‚„Ų „L’ĘŲ ^„Ų `„L’.€„Ø „˜žĘØ ^„Ø `„˜ž.€„x„˜žĘx^„x`„˜ž.‚„H„L’ĘH^„H`„L’.€„„˜žĘ^„`„˜ž.€„č„˜žĘč^„č`„˜ž.‚„ø„L’Ęø^„ø`„L’.Įq’ŪCńCGh™|ÄlJÖ& @‘KpQO"$:A2Tā3z6Š2.yk:¤=3UŽA'V0’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’         ž Čķ                                   2ŸČŌ        6²ŌŅ        €,s9                 āćÖ                 ć|                          ŲVŽ        ’@HP LaserJet 4000 Series PCL 6\\Si141a-hp4000@mth@mscd-scolasHPBXLBHP LaserJet 4000 Series PCL 6HP LaserJet 4000 Series PCL 6d”Žöųü’*ˆļūż.„‡zzs°±“ Ö²p×ŲŚŁŪÜŻŽ ß ą į d(Untitled)*HP LaserJet 4000 Series PCL 6d”Žöųü’*ˆļūż.„‡zzs°±“ Ö²p×ŲŚŁŪÜŻŽ ß ą į d(Untitled)*€\ \ ”X·\ \ (¶@@@@@’’Unknown’’’’’’’’’’’’G‡:’Times New Roman5€Symbol3& ‡:’Arial"Aˆ ņŠhSŅQ¦^ŅQ¦LŅQ¦  Ń ņŃ2dā[ 2ƒQ ņŃß’’CIP Code:______________Charlotte BakerPreinstalled Userž’ą…ŸņłOh«‘+'³Ł0Œ˜øÄÜčų   < H T `lt|„äCIP Code:______________IP Charlotte BakerharNormaltPreinstalled User__4eiMicrosoft Word 9.0_@ @H_¶²‡Ą@2¶°³‡Ą@4:µ‡Ą  ž’ÕĶ՜.“—+,ł®0 hp€ˆ˜  Ø°ø Ą ääMSCDeā  CIP Code:______________ Title ž’’’ž’’’ !"#$%&'()*+,-./0123456789:;<=ž’’’?@ABCDEž’’’GHIJKLMž’’’ż’’’PSž’’’UTž’’’ž’’’WXYZ[\]^_`abcdefghijklmnž’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’Root Entry’’’’’’’’ ĄFpÅćŠæõÖR€Data ’’’’’’’’’’’’1Table’’’’’’’’ä=WordDocument’’’’0,SummaryInformation(’’’’’’’’’’’’>DocumentSummaryInformation8’’’’’’’’FCompObj’’’’jObjectPool’’’’’’’’`ÖöAµ‡Ą`ÖöAµ‡Ąž’’’ž’’’ ž’’’ ž’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’’ž’ ’’’’ ĄFMicrosoft Word Document MSWordDocWord.Document.8ō9²qDocumentLibraryFormDocumentLibraryFormDocumentLibraryForm This value indicates the number of saves or revisions. The application is responsible for updating this value after each revision.