ClassInfo

CSC 454 Database Administration and Management

Marco Chou

Summer II 2020-2021
Class number: 40055
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.  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

Windows 10 



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