NEW YORK CITY COLLEGE OF TECHNOLOGY
DEPARTMENT NAME
COURSE CODE – COURSE NAME
(# class hours, # lab hours, # credits)
Course Description
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.
Course Objectives
Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum:
- Contrary to popular belief, Lorem Ipsum is not simply random text.
- It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old.
- Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source.
- Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of “de Finibus Bonorum et Malorum” (The Extremes of Good and Evil) by Cicero, written in 45 BC.
- This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, “Lorem ipsum dolor sit amet..”
Prerequisites
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.
Required Textbook
Title of Text by Author Full Name. City: Publisher Name (ISBN- 13:978-1-4302-1015-3)
Additional Material
The instructor will identify several additional information resources during the semester including Internet resources and print material (handouts).
Attendance Policy
Attendance is expected at every class meeting. College policy sets that a student may be absent without penalty for 10% of the number of scheduled class meetings during the semester as follows:
Class meets Allowable Absence
1 time/week 2 classes
2 times/week 3 classes
3 times/week 4 classes
Academic Integrity Policy
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.
Grading Procedure
| Midterm | 20% |
| Quizzes | 20% |
| Case Assignment/Project | 25% |
| Homework | 5% |
| Final | 30 |
| TOTAL | 100% |
| Letter Grade | A | A- | B+ | B | B- | C+ | C | D | F |
| Numerical Grade | 93-100 | 90-92.9 | 87-89.9 | 83-86.9 | 80-82.9 | 77-79.9 | 70-76.9 | 60-69.9 | <=59.9 |
Course Outline
Week 1: January 28 – February 2
Reading Chapter 1, 2
-
Database administration – tasks and role
- Review of Database design and modeling
Week 2: February 4 – 9
Reading Chapter 5
Oracle database architecture
- Database structures
- Processes
- Understanding memory structure
Week 3: February 11 – 16
Reading Chapter 6
Tablespaces
- Creating and maintaining
- Uses:
- Storage
- User access and security
- Backup
- Data transfer
Week 4: February 18 – 23
Reading Chapter 7
Schema Management
- Types of SQL statements
- Schemas
- Managing Tables; temporary, index-organized, external, partitioned
Week 5: February 25 – March 2
Chapter 8
Managing Data and Concurrency
- Locking
- Concurrency
- UNDO data
Week 6: March 4 – 9
Reading Chapter 9
Installing, uninstalling and upgrading the DBMS
Week 7: March 11 – 16
Review and Midterm Exam
Week 8: March 18 – 23
Reading: Chapter 10
Creating Database
- Creating parameter file
- Starting and stopping the database
- Log and trace files
Week 9: March 25 – 30
Reading Chapter 12
User management and database security
- Managing users
- Database resource manager
- Controlling database access
- Auditing database usage
Week 10: April 1 – 6
Reading Chapter 13
Loading and transforming data
- Using external tables
- Transforming data in existing tables
Week 11: April 8 – 13
Reading Chapter 19
Improving database and query performance
- Optimizing query processing
Week 12: April 15 – 20
Reading Chapter 20
Performance and tuning
- Tuning memory
- Evaluating system performance
- Measuring I/O performance
Week 13: April 22 – 27
Reading Chapter 15, 16
Backup and Recovery
- Backing up the database
- Recovery manager
- Database corruption detection
- Data protection for disaster recovery
Week 14: April 29 – May 4
Reading Handouts, internet sources
Advanced topics:
- Managing distributed databases
- Managing data warehouse
Week 15: April 15
FINAL
Assessment Criteria
- For the successful completion of this course a student should be able to
- Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.
- Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.
- Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.
- Evaluation methods and criteria
- Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.
- Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.
- Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.
Bibliography
- Title of Text, number edition by Author Name, Author Name and Author Name. City: Publisher, YYYY. ISBN: #############
- Title of Text, number edition by Author Name, Author Name and Author Name. City: Publisher, YYYY. ISBN: #############
- Title of Text, number edition by Author Name, Author Name and Author Name. City: Publisher, YYYY. ISBN: #############
- Title of Text, number edition by Author Name, Author Name and Author Name. City: Publisher, YYYY. ISBN: #############
