COMP07073 2011 Database Administration

General Details

Full Title
Database Administration
Transcript Title
Database Administration
Code
COMP07073
Attendance
N/A %
Subject Area
COMP - Computing
Department
INFO - Information Systems
Level
07 - NFQ Level 7
Credit
05 - 05 Credits
Duration
Semester
Fee
Start Term
2011 - Full Academic Year 2011-12
End Term
9999 - The End of Time
Author(s)
Padraig Harte, John Carter
Programme Membership
SG_KSYST_B07 201100 Bachelor of Science in Computing in Systems and Networking L7 SG_KSYSN_B07 201200 Bachelor of Science in Computing in Systems and Networking L7 SG_KCMPT_B07 201300 Bachelor of Science in Computing SG_KSYSN_B07 201500 Bachelor of Science in Computing in Systems and Networking L7 SG_KSYSN_B07 201700 Bachelor of Science in Computing in Systems and Networking L7
Description

The student will acquire an intermediate set of skills in Database Administration.

Learning Outcomes

On completion of this module the learner will/should be able to;

1.

plan for and install a database.

2.

configure and manage database files

3.

plan, configure and implement database security

4.

plan, manage and implement database reliability

5.

automate administrative tasks

6.

import, export and transform data

7.

monitor and maintain database performance

Module Dependencies

Prerequisites
COMP07062 000000 Database Development 1 COMP06087 201100 Introduction to Database Management

Indicative Syllabus

1.  Installing and Configuring a RDBMS                                                                    

•§  Determine hardware requirements for a database server

•§  Describe various methods of installing an instance of a database management system.

•§  Verify the installation of a database management systems

•§  Configure a database management system.

2.  Creating Databases                                                                                                            

•§  Describe how a database management system stores data and handles transactions

•§  Create a database, including specifying options during and after database creation

•§  Grow, shrink, or delete a database

•§  Determine the placement of database files and log files for performance and fault tolerance.

•§  Expand and shrink a database.

•§  Estimate the amount of space that a database requires.

3.  Managing, Monitoring, and Troubleshooting a RDBMS                                    

•§  Monitor index statistics

•§  Administer data storage.

•§  Modify the database schema.

•§  Carry out backups and recovery.

•§  Manage the log file.

•§  Troubleshooting concurrency problems

•§  Configure alerts and operators.

•§  Optimise and monitor hardware resource usage.

•§  Optimise, monitor and troubleshoot system activity.

 4.  Extracting and Transforming Data                                                                                 

•§  Import and export data.

•§  Manage OLE DB Providers.

•§  Convert data types.

5.  Managing and Monitoring Database Security                                                    

•§  Create and manage RDBMS access.

•§  Create and manage database users.

•§  Create and manage security roles.

•§  Manage permissions in a database.

•§  Manage security auditing.

6.  Performing Administrative Tasks                                                                                   

•§  Perform common Database configuration tasks

•§  Automate routine maintenance tasks by creating and scheduling jobs

•§  Configure alerts and operators.

•§  Troubleshoot automated jobs, alerts, or notifications

7.  Backing up and Restoring a Database                                                                

•§  Create backup files and backup sets.

•§  Backup up databases that are created on multiple files and file-groups.

•§  Use the BACKUP LOG statement to back up and clear transaction logs.

•§  Execute the database recovery process.

•§  Verify backups and perform specific tasks that enable the restore process

•§  Use the RESTORE statement to get information about a backup file before you restore a database, file, or transaction log.

•§  Restore backups from different backup types and use the appropriate options

8.  Monitoring Database Performance                                                                                 

•§  Use the tools available for monitoring a database management system.

•§  Perform common monitoring and tuning tasks by using counters and appropriate tools

 9.  Transferring Data                                                                                                

•§  Use the database management system tools for importing and exporting data

•§  Transform data by using Data Transformation Services

   

Coursework & Assessment Breakdown

Coursework & Continuous Assessment
100 %

Coursework Assessment

Title Type Form Percent Week Learning Outcomes Assessed
1 Practical Evaluation Creation of databases Continuous Assessment UNKNOWN 30 % Week 4 1,2
2 Practical Evaluation Security Continuous Assessment UNKNOWN 30 % Week 8 3
3 Practical Evaluation Performance and Backup Continuous Assessment UNKNOWN 40 % Week 12 4,5,6,7

Full Time Mode Workload


Type Location Description Hours Frequency Avg Workload
Lecture Lecture Theatre Lecture 1 Weekly 1.00
Laboratory Practical Computer Laboratory Laboratory Practical 2 Weekly 2.00
Total Full Time Average Weekly Learner Contact Time 3.00 Hours

Module Resources

Non ISBN Literary Resources

Inside SQL Server, Delaney, Microsoft Press, 0-7356-0998-5

Other Resources

None

Additional Information

None