COMP07073 2011 Database Administration
The student will acquire an intermediate set of skills in Database Administration.
On completion of this module the learner will/should be able to;
plan for and install a database.
configure and manage database files
plan, configure and implement database security
plan, manage and implement database reliability
automate administrative tasks
import, export and transform data
monitor and maintain database performance
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
|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
|Laboratory Practical||Computer Laboratory||Laboratory Practical||2||Weekly||2.00|
Inside SQL Server, Delaney, Microsoft Press, 0-7356-0998-5