INFO707 – Cloud Server Databases

Print
Module code
INFO707
Module title
Cloud Server Databases
Prescription
To enable students to gain an in-depth knowledge of cloud server database concepts, fundamentals and essentials. They will apply practical skills to install, setup, configure, manage and maintain a cloud server database and deploy cloud database services to support database applications.
Programmes
  • BI1601
  • BI1804
NZQA Level
Level 7
NZQA Credits
15
Delivery method
  • Web-Supported
Learning hours
Directed hours
48
Self directed hours
102
Total learning hours
150
Resources required
Learning Outcomes
1. Investigate cloud characteristics and service levels for database systems

2. Apply administration tasks to setup and configure a cloud server databases

3. Perform administration tasks to manage cloud server database services to support
database application development
Content
- Cloud characteristics and service levels for database systems
- Cloud computing concepts
- Cloud services such as XaaS, DBaaS, SaaS, PaaS and IaaS
- Investigate service level agreements
- Investigate database migration to the cloud
- Rationalize and evaluate reasons for cloud databases to support business operations
- Current cloud architectures, tools, platforms or technology
- Administration tasks for cloud server databases
- Analyse and apply best practices
- Install and configure database server software or middleware software
- Create and manage storage structures
- Install and configure 3rd tier software or database tools
- Backup and recovery
- Monitor and optimise performance
- Administration tasks to manage cloud database services to support database application development
- Create physical and logical storage structures
- Create schemas, users, privileges and implement security
- Create physical and logical data structures
- Manage and troubleshoot common problems
Assessment Criteria
In order to receive a passing grade, students must achieve a minimum 40% average over all supervised tests and achieve 50% overall for the module.

Teaching and Learning Strategy
Teaching methods will involve theoretical and practical classes which may include but not limited to lectures, class discussions, tutorials, case studies, simulations, computer laboratory work, group activities, face-to-face and online activities.
Learning and Teaching Resource
Computer laboratory with administration rights
Networking configuration
Server software
Wintec Learning Management Systems
Required Textbooks
An extended reading list will be supplied by the tutor at commencement of the module. This will be updated annually.