Nov 21, 2024  
2018-2019 Saint Joseph’s College Online Catalog 
    
  Catalog Home
  College Home Website
  Admissions
  General Information
  Graduate Programs
  Graduate Policies
  Graduate Courses
  Undergraduate Programs
  Undergraduate Policies
  Undergraduate Courses
  Continuing Education Courses
  Summer Programs
  Summer Tuition and Fees
  Policies and Procedures
  Consumer Grievance Policy
  Student Resources
  Textbook and Materials
  Graduation
  Brightspace Login
  Distance Learning
  Contact Information
  On-Campus Programs at a Glance
  Tuition and Fees
  My Portfolio
HELP
2018-2019 Saint Joseph’s College Online Catalog [Archived Catalog]

Facebook this Page (opens a new window)
Tweet this Page (opens a new window)
Add to Portfolio (opens a new window)

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


Facebook this Page (opens a new window)
Tweet this Page (opens a new window)
Add to Portfolio (opens a new window)