| |
Jul 01, 2025
|
|
|
|
|
2021-2022 Catalog [ARCHIVED CATALOG]
|
DBMS 120 - Database Server Installation and the Virtual Environment
PREREQUISITES/COREQUISITE: DBMS 110 - Introduction to Data Analytics and ITSP 135 - Hardware / Software Support or (ITSP 132 - IT Support Essentials I and ITSP 134 - IT Support Essentials II )
PROGRAM: Data Analytics
CREDIT HOURS: 3
LECTURE HOURS: 2
LAB HOURS: 2
DATE OF LAST REVISION: Spring, 2014
Introduces students to terminology, concepts, theory, and practice of installing, implementing, and maintaining a database server. Discussion will include the relationships between network servers and database servers. Students will explore server virtualization and using data servers in virtual environments. Students will be introduced to database and database server security concepts.
MAJOR COURSE LEARNING OBJECTIVES: Upon successful completion of this course the student will be expected to:
- Demonstrate the ability to install/create a virtual server for a database management system.
- Explain the concepts of server, network, and storage virtualization.
- Discuss the advantages and disadvantages of server virtualization.
- Identify the software components required for an installation such as applications, drivers, libraries, and supporting utilities.
- Identify hardware requirements for an installation - storage space, memory, processor speed.
- Install and configure a database management system within a virtual environment.
- Import, Export and Replicate a virtual server instance between multiple virtual environments.
- Discuss the considerations for installing updates and patches to the server and the virtual environment.
- Implement a backup and recovery strategy for the virtual environment.
- Discuss security and licensing issues related to virtualized systems.
COURSE CONTENT: Topical areas of study include -
Virtualization
Virtual Environment Installation
Network Configuration
Storage Allocation
Hardware requirements
Software Requirements
Operating System Requirements
Storage Requirements
Device Drivers
Performance Monitoring
Oracle Database Server
Microsoft SQL Server
Virtual Environments
Software Licensing
Version Control
Updates and Patches
Backup and Recovery
Access Control
Course Addendum - Syllabus (Click to expand)
|
|
