CSC 454 Database Administration and Management
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. Each student needs to use individual Windows 10 laptop to install and manage Oracle Database. For Mac user, Virtual Box or VMware Fusion can be used to run Windows 10.
Texts
Textbook (FREE online): Oracle Database Administrator's Guide
https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/index.html
Grading
Grading Homework 30% Lab 30% Midterm 15% Final 15% 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 19c database enterprise edition (evaluation copy)
OS/Platform
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
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.
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.
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.
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 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