This course will cover server database management, configuration and administration, security mechanisms, backup and recovery; transact SQL Programming, and an introduction to database web-application development and security.

Learning Objectives and Outcomes:

By the end of this course students will be able to:

1. Examine server database management and its attributes
2. Distinguish between configuration and administration of database systems
3. Describe database security mechanisms used to protect data
4. Understand backup and recovery procedures and apply to an active database
5. Apply transact SQL Programming to solve applied business problems
6. Describe database web-application development.
7. Apply Hyper Structured Query Language (SQL) statements to manipulate both data structures and data within a database system

Course Schedule and Topics

This course will cover the following topics in eight learning sessions, with one Unit per week. The Final Exam will take place during Week/Unit 9 (UoPeople time).

Week 1: Unit 1 – Introduction to Data models

Week 2: Unit 2 -Transaction Management

Week 3: Unit 3 – Application Development and Admin

Week 4: Unit 4 – Security Mechanisms

Week 5: Unit 5 – Backup and Recovery

Week 6: Unit 6 -Transact SQL Programming

Week 7: Unit 7 -Database Web-Application Development

Week 8: Unit 8 -Technology trends and databases

Week 9: Unit 9 -Course Review and Final Exam

Learning Guide

The following is an outline of how this course will be conducted, with suggested best practices for students.

Unit 1: Principles: Introduction to Data models

• Read the Learning Guide and the Reading Assignment
• Participate in the Discussion Assignment (post, comment, and rate in the Discussion Forum)
• Complete and submit the Written Assignment
• Make entries to the Learning Journal
• Take the Self-Quiz

Unit 2: Principles: Transaction Management

• Peer assess Unit 1 Written Assignment
• Read the Learning Guide and the Reading Assignment
• Participate in the Discussion Assignment (post, comment, and rate in the Discussion Forum)
• Complete and submit the Written Assignment
• Make entries to the Learning Journal
• Take the Self-Quiz

Unit 3: Application Development and Admin

• Peer assess Unit 2 Written Assignment
• Read the Learning Guide and the Reading Assignment
• Participate in the Discussion Assignment (post, comment, and rate in the Discussion Forum)
• Make entries to the Learning Journal
• Take the Self-Quiz
• Take the Graded Quiz

Unit 4: Security Mechanisms

• Read the Learning Guide and the Reading Assignment
• Participate in the Discussion Assignment (post, comment, and rate in the Discussion Forum)
• Complete and submit the Written Assignment
• Make entries to the Learning Journal
• Take the Self-Quiz

Unit 5: Backup and Recovery

• Peer assess Unit 4 Written Assignment
• Read the Learning Guide and the Reading Assignment
• Participate in the Discussion Assignment (post, comment, and rate in the Discussion Forum)
• Complete and submit the Written Assignment
• Make entries to the Learning Journal
• Take the Self-Quiz

Unit 6: Transact SQL Programming

• Peer assess Unit 5 Written Assignment
• Read the Learning Guide and the Reading Assignment
• Participate in the Discussion Assignment (post, comment, and rate in the Discussion Forum)
• Make entries to the Learning Journal
• Take the Self-Quiz
• Take the Graded Quiz

Unit 7: Database Web-Application Development

• Read the Learning Guide and the Reading Assignment
• Participate in the Discussion Assignment (post, comment, and rate in the Discussion Forum)
• Complete and submit the Written Assignment
• Make entries to the Learning Journal
• Take the Self-Quiz

Unit 8: Technology trends and databases

• Peer assess Unit 7 Written Assignment
• Read the Learning Guide and the Reading Assignment
• Participate in the Discussion Assignment (post, comment, and rate in the Discussion Forum)
• Complete and Submit the Learning Journal
• Take the Self-Quiz
• Read the Unit 9 Learning Guide carefully for instructions on the Final Exam
• Take the Review Quiz

Unit 9: Course Review and Final Exam

• Read the Learning Guide and take the Review Quiz, if you haven’t already done so
• Prepare for, take, and submit the Final Exam
• The Final Exam will take place during Week/Unit 9 (UoPeople time); exact dates, times, and other details will be provided accordingly by your instructor