| |
May 01, 2024
|
|
|
|
|
2022-2023 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 MIN: 3
LECTURE HOURS MIN: 2
LAB HOURS MIN: 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)
|
|
