The page uses Browser Access Keys to help with keyboard navigation. Click to learn moreSkip to Navigation

Different browsers use different keystrokes to activate accesskey shortcuts. Please reference the following list to use access keys on your system.

Alt and the accesskey, for Internet Explorer on Windows
Shift and Alt and the accesskey, for Firefox on Windows
Shift and Esc and the accesskey, for Windows or Mac
Ctrl and the accesskey, for the following browsers on a Mac: Internet Explorer 5.2, Safari 1.2, Firefox, Mozilla, Netscape 6+.

We use the following access keys on our gateway

n Skip to Navigation
k Accesskeys description
h Help

    Saint Joseph's College: Online Programs
   
 
  Oct 24, 2017
 
 
    
2017-2018 Saint Joseph’s College Online
[Add to Portfolio]

IT 340 - Database Administration


This course focuses of the various tasks, tools, responsibilities, and best practices involved in database administration. Students will learn disaster recovery, performance analysis and tuning, data dictionary maintenance, data modeling and optimization, database and user management, installation, performance monitoring, creation of users and user privileges, backup and recovery, views, partitions, advanced queries, stored procedures, transaction processing, data integrity techniques, advanced modeling and design concepts, implementing a security system, and troubleshooting.

Prerequisites & Notes
IT 100 and IT 240

Assignment Overview
Synchronous term-based course with ten weekly assignments and a final project

Course Learning Objectives
Upon completion of this course, you should be able to do the following:

  • Describe the storage, hardware and memory components of a DBMS architecture.
  • Explain and demonstrate system, application and database performance tuning.
  • Explain various backup types and how to apply various backups to reduce the risk of data loss. 
  • Demonstrate the steps required to restore a database from different backup types.
  • Apply best practices to database reorganization and defragmentation.
  • Identify database security basics and demonstrate the ability to issue Data Control Language (DCL) statements to ensure database security. 


Credits: 3



[Add to Portfolio]