Southern Polytechnic State University



Southern Polytechnic State UniversityInformation Technology Department IT 6733 – Database AdministrationCourse SyllabusSummer 2021 onlineInstructor: Svetlana Peltsverger Phone: (470) 578-3813 Email: speltsve@kennesaw.edu Office: Atrium Building J378cOffice Hours: open door and by appointment both in person and via web conferencing softwareCatalog DescriptionPrerequisite: IT5433This course covers data administration and management, backup/recovery, security, access control, performance monitoring and tuning, data warehousing, data mining, online analytical processing, centralized versus distributed environments, client server and world-wide-web database integration.Course OutcomesStudents who complete this course successfully will be able toDescribe tasks commonly performed by DBAs. Analyze performance characteristics of a DB system and justify necessary changes. Write programs to perform maintenance and user support operations. Explain the concept of database security and backup/recovery TextbookThere is no textbook assigned. All readings are assigned in weekly modules. I require that you read the relevant papers and tutorials each week as a way to prepare you for assigned lab/quiz. Knowledge of the readings will reduce the time it takes you to finish lab assignments.Required MaterialsI will provide all instructions assuming that you have Windows computer. We will use open source software that is available for Linux/Unix/MAC.You must have2 GHz or faster processor minimum 4GB RAM free disk space minimum 40GBadministrative rights to your PC owner's permission to install course software if you are not the owner of the system.web camera for testsAbout the CoursePeople learn through interactions, to facilitate interactive learning this course will use Discussions feature of D2L. Discussions will take place in an asynchronous manner.There are 13 content modules in this course. Proctored exam (picture ID required)The exam will be offered at scheduled time through Respondus Lockdown Browser with Monitor.Please contact the instructor during the first week of the semester if you cannot take the test at the scheduled time.Preparation of work for this courseYou must run all the code examples from each module before you attempt to complete assigned lab. All assignments must be submitted through D2L before the corresponding deadline. No assignments will be accepted via email. Each module contains:Assigned reading and additional reading for students who want to read further on the week's topicOnline content.Assigned hands-on exercises.Discussion topic OR quiz.Apply your knowledge section.For each content module you should: Read the on-line content and the assigned sections from the text.Post questions, corrections, or comments about the content in the discussion area designated for the module. Do assigned hands-on activities. Use the discussion area, or email to the instructor or classmates, to ask for help with any exercises that give you difficulty. If applicable, take a quiz and review your results. Read and respond to the assigned discussion topic. Do assigned lab.Throughout the course, you should log in regularly to check for announcements and email. The course calendar posted on D2L contains all important dates. Any changes of dates will be publicized by post in discussion area and/or email.Home & Lab Assignments and DiscussionsAll Assignments will be posted on D2L . All assignments, discussions and quizzes are due at specified on D2L. If for some reason you have not been able to submit assignment by deadline, then you have 24 hours to submit your work with a 20% penalty (quizzes cannot be submitted later) unless student has had an extension approved prior to the day an assignment is due. No reports will be accepted after that.All work turned in for this class must meet the style and submission guidelines Work that does not meet the submission criteria will not be graded. Every effort will be made to return your graded assignments to you within 2-3 days. Scoring rubric will be provided for each assignment.Grading Policy Your grade will be based: Your grading scale will be as follows:Proctored Test: 30Score ≥ 90 ALabs Reports, QuizzesScore ≥ 80 & Score < 90B& Discussions: 50 Score ≥ 70 & Score < 80CGroup Project 20Score ≥ 60 & Score < 70DTotal: 100Score < 60FCommunications and AnnouncementsTo communicate with you through e-mail I will use your D2L e-mail. Any changes of dates and announcements will be publicized by post in news area on D2L and/or email.Contact meD2L Email or speltsve@kennesaw.edu (checked every regular school day). For faster response use speltsve@kennesaw.edu email. I can reply from the phone.Use the Discussion tool for the course in D2L (checked at least twice a week).Call me (470) 578-3813Stop by my office J378c during business hours or schedule an appointment to meet face to face or via web conferencing software.Important DatesClasses Begin – Wed, June 2, 2021Students must log into course to confirm attendance - Wed, June 2, 2021. Students are solely responsible for managing their enrollment status in a class; nonattendance does not constitute a withdrawal.SQL quiz – Tuesday, June 8, 2021 (10pm). NOTE: You are not ready to successfully complete this course if you have difficulty with this quiz.Drop/Add – June 8, 2021Weekly mandatory 5 min office hours attendance via MS Teams. Will be scheduled based on your availability during the first week of classes. Last day to withdraw – Thursday, June 24, 2021Last day of classes – Tuesday, July 27, 2021Proctored Exam – one on one 15 min exam via MS Teams July 19-23 I will ask you questions about your submitted lab reports and projects. Will be scheduled by July 12 based on your availability.No “extra credit” work will be given to improve one’s grade. Copies of your class work and test will be kept for record.Course Calendar (subject to change)SundayMondayTuesdayWednesdayThursdayFridaySaturday1June 1June 2 First day of classStart Module 1 reviewJune 3June 4June 52June 6June 7June 8Drop/addModule 0 OrientationModule 1 sql quiz due dateJune 9June 10June 11Module 1 SQL review lab due date Lab due dateJune 1231314 Mod 2 Due date discussion15Module 2 Overview of Database Administration16Mod 2 Due date lab1718 Module 3 DB &Application Performance Lab due date19 42021 22Module 4 Database Security: user administration OracleLab due date2324Interim survey due Last day to withdraw25 Module 5 Database Security: user administration SQl ServerLab due date2652728 29Module 6 Data WarehouseStrat ETL projectLab due date & Discussion30 July 1Form groups for the group projectJuly 2Module 7 Database Backup and Recovery Lab due date July 3 6July 456Module 8 NoSQL databases Lab due date & Discussion78Define ETL project9Module 9 Metadata Lab due date107111213Module 10 ETL Project141516Group Project Due date1781819Test slots available20Module 11 SnowflakeLab due dateTest slots available21Test slots available22Test slots available23Module 12 T-SQLTest slots available249252627Module 12 T-SQLLab due dateLast day of classes282930Mod 13 PythonLab due date319Aug 1Aug 2Final grades dueAcademic conductEvery KSU student is responsible for upholding the provisions of the Student Code of Conduct, as published in the Undergraduate and Graduate Catalogs. Section 5c of the Student Code of Conduct addresses the university’s policy on academic honesty, including provisions regarding plagiarism and cheating, unauthorized access to university materials, misrepresentation/falsification of university records or academic work, malicious removal, retention, or destruction of library materials, malicious/intentional misuse of computer facilities and/or services, and misuse of student identification cards. Incidents of alleged academic misconduct will be handled through the established procedures of the Department of Student Conduct and Academic Integrity (SCAI), which includes either an “informal” resolution by a faculty member, resulting in a grade adjustment, or a formal hearing procedure, which may subject a student to the Code of Conduct’s minimum one semester suspension requirement. See also EtiquetteCommunication in an online class takes special consideration. Please read the short list of tips below.Be sensitive and reflective to what others are saying.Don't use all caps. It is the equivalent of screaming.Don't flame - These are outbursts of extreme emotion or opinion.Think before you hit the post (enter/reply) button. You can't take it back!Don't use offensive language.Use clear subject lines.Don't use abbreviations or acronyms unless the entire class knows them.Be forgiving. Anyone can make a mistake.Keep the dialog collegial and professional.Attendance?PolicyOnline Students must log into D2L courses by 11:59pm of the day classes begin to confirm their attendance. If you fail to log into your courses by 11:59pm of the day classes begin, or fail to complete course activities within a two-week period at any time during the semester, the instructor will consider your lack of activity as an indication of your intention not to continue in the course. Failure to participate without officially withdrawing from the course will result in a grade of F. Be sure to submit all assigned work on time. If you are not able to participate in assigned class activities, contact your instructor immediately.Attendance and participation in class are expected. If you have any problems with attendance (or something else), contact me BEFORE they become a problem.If you must miss an exam due to illness you must e-mail or call me before the scheduled time and perhaps something can be arranged to avoid a zero for this exam. Failure to notify me prior to the scheduled time will produce an automatic zero for the exam. No makeup test except for emergencies with proof ( e.g. doctor’s slip)Students with disabilitiesStudents with qualifying disabilities under the Americans with Disabilities Act (ADA) and/or Section 504 of the Rehabilitation Act who require “reasonable accommodation(s)” to complete the course may request those from Office of Student Disability Services. Students requiring such accommodations are required to work with the University’s Office of Student Disability Services rather than engaging in this discussion with individual faculty members or academic departments. If, after reviewing the course syllabus, a student anticipates or should have anticipated a need for accommodation, he or she must submit documentation requesting an accommodation and permitting time for a determination prior to submitting assignments or taking course quizzes or exams. Students may not request retroactive accommodation for needs that were or should have been foreseeable. Students should contact the office as soon as possible in the term for which they are seeking accommodations. Student Disability Services is located in the Carmichael Student Center in Suite 267. Please visit the Student Disabilities Services website at for more information, or call the office at 470-578-2666. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download