ClassInfo

CSC 454 Database Administration and Management

Marco Chou

Summer II 2021-2022
Class number: 42300
Section number: 520
-
OLASY NCH00 Online Campus

Summary

Oracle DBAs manage the industry's most advanced information systems. Career opportunity and higher income are great reasons to start learning database administration. This course is your first step towards success as an Oracle professional, designed to give you a firm foundation in basic database tasks. This course provides students with the knowledge and skills required to install, configure, administer, and troubleshoot Oracle. Students will gain a conceptual understanding of Oracle server, instance, and database architecture. Students will use administration tools to start and shut down an instance, create a database, manage database storage, and manage database security. Students will also learn how to create an operational database and properly manage the various structures in an effective and efficient manner in order to have a well designed and operational database. Loading and transporting for databases, backing up and recovering database objects, and the utilities used to perform these activities are described. Note: This is an online only class.



Texts

Textbook (optional): Oracle Database 11g DBA Hand Book ISBN: 978-0-07-149663-6



Grading

Grading Homework 50% Midterm 20% Final 30% No late homework will be accepted after one week from the due date. Any late homework will lose 20% credit. If you can not attend the test, you must present certain document to show that you have a valid reason. Exam material will be drawn from lecture notes and homework assignments. Grading Scale: A : 93-100 A-: 90- 92 B+: 87- 89 B : 83- 86 B-: 80- 82 C+: 77- 79 C : 73- 76 C-: 70- 72 D : 60- 69 F : 0- 59



Prerequisites

CSC451, CSC453, or equivalent



Software

Oracle 11g database enterprise edition (evaluation copy)



OS/Platform

Windows7, 8 or 10 Professional Edition or Enterprise Edition



DBA Introduction, Oracle Overview

Oracle Architecture, Managing an Oracle Instance Oracle Installation, Creating a database Managing Tablespace & Datafile SQL Loader Control File, Redo Log, Undo Tablespace, Security Import/Export & DataPump, Archivelog Backup & Recovery Flashback Technology Cloud database, Big Data

School policies:

Changes to Syllabus

This syllabus is subject to change as necessary during the quarter. If a change occurs, it will be thoroughly addressed during class, posted under Announcements in D2L and sent via email.

Online Course Evaluations

Evaluations are a way for students to provide valuable feedback regarding their instructor and the course. Detailed feedback will enable the instructor to continuously tailor teaching methods and course content to meet the learning goals of the course and the academic needs of the students. They are a requirement of the course and are key to continue to provide you with the highest quality of teaching. The evaluations are anonymous; the instructor and administration do not track who entered what responses. A program is used to check if the student completed the evaluations, but the evaluation is completely separate from the student’s identity. Since 100% participation is our goal, students are sent periodic reminders over three weeks. Students do not receive reminders once they complete the evaluation. Students complete the evaluation online in CampusConnect.

Academic Integrity and Plagiarism

This course will be subject to the university's academic integrity policy. More information can be found at http://academicintegrity.depaul.edu/ If you have any questions be sure to consult with your professor.

All students are expected to abide by the University's Academic Integrity Policy which prohibits cheating and other misconduct in student coursework. Publicly sharing or posting online any prior or current materials from this course (including exam questions or answers), is considered to be providing unauthorized assistance prohibited by the policy. Both students who share/post and students who access or use such materials are considered to be cheating under the Policy and will be subject to sanctions for violations of Academic Integrity.

Academic Policies

All students are required to manage their class schedules each term in accordance with the deadlines for enrolling and withdrawing as indicated in the University Academic Calendar. Information on enrollment, withdrawal, grading and incompletes can be found at http://www.cdm.depaul.edu/Current%20Students/Pages/PoliciesandProcedures.aspx.

Students with Disabilities

Students who feel they may need an accommodation based on the impact of a disability should contact the instructor privately to discuss their specific needs. All discussions will remain confidential.
To ensure that you receive the most appropriate accommodation based on your needs, contact the instructor as early as possible in the quarter (preferably within the first week of class), and make sure that you have contacted the Center for Students with Disabilities (CSD) at:
Lewis Center 1420, 25 East Jackson Blvd.
Phone number: (312)362-8002
Fax: (312)362-6544
TTY: (773)325.7296