COIT 342
|
|
1
|
|
Course number:
|
COIT 342
|
Name :
|
Database Administrations
|
|
2
|
|
Credits:
|
3
|
Contact hours:
|
42 Hrs Lecture
|
|
|
|
|
|
|
|
|
3
|
|
Course coordinator’s name:
|
Dr. Abdulaleem Almazroi
|
|
|
|
|
|
|
4
|
|
Textbook:
|
Oracle Database SQL Fundamentals I, Copyright ©
2012, Oracle and/or its affiliates. All rights reserved
|
|
|
|
|
|
|
|
a
|
Other references:
|
C. S. Mullins, "Database Administration: The Complete Guide to Practices and Procedures", Addison-Wesley, 2002. ISBN 0201741296.
|
|
|
|
|
|
|
5
|
a)
|
Synopsis:
|
It is the role of the IT professional to develop, deploy, manage and integrate data and information systems to support the organization. This knowledge area includes the collection, organization, modeling, transformation, presentation, safety and security of the data and information. This course covers a wide range of subjects in Database Administration. The students will have a hands-on training about installation, configuration, administration, performance, backup and recovery, and enterprise services of databases.
|
|
|
|
|
|
|
b)
|
Prerequisites:
|
COIS 342 – Database
|
|
c)
|
Type of course:
|
Core
|
|
|
|
|
|
|
6
|
a)
|
Course Learning Outcomes
Upon finishing this course, the students should be able to:
- Analyze, strategize and plan for selecting a database management system (DBMS) (1.1).
- Design, implement, and manage relational databases using DBMS (1.1, 2.1, 2.2). (j)
- Explain the concepts of database change management, performance management, security, backup and recovery (2.3).
- Function effectively as a member or leader of a database administration (DBA) team to meet the demands of an organization (5.1, 5.3).
|
|
|
b)
|
Course Relationship to Key Student Outcomes
|
STUDENT OUTCOMES
|
|
1
|
2
|
3
|
4
|
5
|
6
|
|
*
|
*
|
|
|
*
|
|
.
|
|
7
|
|
Brief list of topics and their duration
|
Number
|
Description
|
Duration in weeks
|
|
1
|
- Introduction to Database Administration
- Creating the Database Environment.
|
1
|
|
2
|
- Data Modelling and Normalization
- Database Design
|
1
|
|
3
|
- Application Design
- Introduction to Oracle SQL
- SQL:SELECT and WHERE
- SQL:WHERE, ORDER BY, and Intro to Functions
-SQL:FUNCTION AND TRIGGER
|
1
|
|
4
|
-SQL: STORE PROCEDURE
-SQL: PL/SQL Programming
|
1
|
|
5
|
Database Change Management part1
|
1
|
|
6
|
Database Change Management part2
|
1
|
|
7
|
Data Avaibility
Replication
Recovery
|
1
|
|
8
|
Performance Management and System Performance:
- Database Tuning
- System Tuning
- Application Tuning
- Hardware Configuration
- DBMS installation and configuration issues
|
1
|
|
9
|
Database Performance
- Partitioning
- Indexing
- Clustering
- Compression
|
1
|
|
10
|
Application Performance
- Relational Optimization
- SQL Coding and Tuning for efficiency
|
1
|
|
11
|
Data Integrity and Database Security
- Database Structure Integrity
- Semantic Data Integrity
- Data Breaches
- Database Security Basic
- Granting and revoking authority
- Encryption
- SQL Injection
|
1
|
|
12
|
Database Backup and Recover part 1
|
1
|
|
13
|
Database Backup and Recovery part 2
- Full versus Incremental Backups Database Objects and Backups
- General steps for database object recovery
|
1
|
|
14
|
Disaster planning and Data Distribution
- General disaster recovery guideline
- Backup the database for disaster recovery
- Distributed Database
|
1
|
|
|
8
|
|
Class Schedule
Meet 50 minutes three times/week
Lab 50 minutes one time/week
|
|
9
|
|
Assessment Tools with Marks Distribution
|
Assessment Type
|
Percentage of Mark
|
|
Assignment
|
20 %
|
|
Lab exam
|
10 %
|
|
Quizzes
|
10 %
|
|
Mid term exam
|
20 %
|
|
Final Exam
|
40 %
|
|
Total
|
100 %
|
|
|
|
|
|
Last Update
6/16/2022 1:28:55 AM
|
|
|
|