Skip to Main Content Skip to bottom Skip to Chat, Email, Text
"Degrees & Programs"

DAT/380

Advanced Database Architecture

Online

Format

$1194

Estimated Tuition

credits

Total credits

weeks

Course length

Start when you're ready

Choose an upcoming start date:

23 Nov 2021

Enroll by 1pm Central: 19 Nov 2021 09:00:00 AM

Enroll by 1pm Central: 07 Jan 2022 09:00:00 AM

Enroll by 1pm Central: 11 Feb 2022 09:00:00 AM

Enroll by 1pm Central: 18 Mar 2022 09:00:00 AM

Please Note: Attendance and participation are mandatory in all University courses, and specific requirements may differ by course. If attendance requirements are not met, a student may be removed from the course. Please review the Course Attendance Policy in the Catalog for more information.

University of Phoenix reserves the right to modify courses. While widely available, not all programs are available to residents of all states. Please check with a University Enrollment Representative.

Advanced Database Architecture

Course level: Undergraduate

This course covers DDBMS architectures, data structures, schemas and standards in addition to centralized and client server systems, server system architectures, parallel systems, distributed systems.

Prerequisites

None

What you'll learn

Course skills and outcomes

Distributed Database Systems 

  • Discuss database systems, including architecture types, data languages, and data models.
  • Evaluate different types of distributed database system architectures in relation to business needs and data types.
  • Diagram and explain conceptual, logical, and physical database designs.
  • Develop data models for distributed database architecture.

Object-Oriented Database Systems 

  • Describe object-oriented database systems architecture.
  • Develop data models for object-oriented database systems. 
  • Evaluate advanced database architectures. 
  • Build database table structures in Structured Query Language (SQL) for Distributed Database Management Systems (DDBMS). 

Distributed Database Systems Development, Implementation, and Optimization 

  • Determine the most effective distributed database operation and recovery strategies. 
  • Evaluate distributed database operation and recovery strategies. 
  • Demonstrate the appropriate use of data replication. 
  • Determine the memory and processing component needs of a distributed database system. 
  • Determine the best performing and scalable hardware and storage architectures of a distributed database system. 

Business Reporting and Data Analytics 

  • Model how data warehousing works within a distributed database system environment. 
  • Describe the interactions of Online Analytical Processing (OLAP) and data mining with business intelligence applications. 
  • Execute Structured Query Language (SQL) scripts to a distributed database.
  • Create a distributed database to support defined business needs and requirements.  

Managing Distributed and Object-Oriented Databases 

  • Recommend a management plan for a new distributed database management system. 
  • Evaluate business requirements for storage, retrieval, and security for advanced distributed database management systems.
  • Incorporate current and emerging security, legal, and ethical trends into database architectures management. 

Prerequisite details

Prerequisites details

A prerequisite is required for this course. The purpose of a prerequisite is to ensure students have the knowledge and/or skills needed to be successful in the course. Students are required to provide proof of prerequisite during the enrollment/registration process.

To meet a course prerequisite requirement, a student must meet one of the following criteria:

  • Successfully completed the prerequisites course at University of Phoenix

  • Provide proof via transcript of completing a comparable course (at least 75% match) or higher level course with at least a grade of C at another institution.

  • Have a University of Phoenix approved Student Appeal on file with the University.

Prepare your documents

During the checkout process you will be prompted to provide proof of the requirement(s). If you completed the prerequisite at another institution, be prepared to upload an official/unofficial transcript.

Still have questions?

Speak to an enrollment representative.
(866) 354-1800

Speak to an enrollment representative.
(866) 354-1800

MON – THU: 5AM to 7PM MST
FRI: 5AM to 5PM MST
SAT: 6AM to 5PM MST

Why UOPX

Why take courses at
University of Phoenix

Accreditation that matters

We’ve been accredited by the Higher Learning Commission (hlcommission.org) or its predecessor for more than 40 years.

Real-world instructors

Learn from instructors who bring an average of 25 years of working experience to the classroom.

Affordable and potentially reimbursable

Our tuition and fees are competitive and fixed. Also, check to see if your employer will cover you for this course.

 

Next steps

Start a conversation about your future with an enrollment representative today.

Start a conversation about your future with an enrollment representative today.

Transfer credit

Credit Transfer

Need to transfer credits to another college or university?

Before you enroll in a course, check with your school of choice to make sure they will accept our transfer credits and to understand any requirements or limitations. Then you can complete your course, and request your official transcript be sent to your school. That’s it!

How to request your transcripts

Transferability of credit is at the discretion of the receiving institution. It is the student’s responsibility to confirm whether or not credits earned at University of Phoenix will be accepted by another institution of the student’s choice. If you have a question contact us at (866) 354-1800.

The University of Phoenix reserves the right to modify courses. Although our continuing teacher education courses are accepted by some state agencies in the United States toward teacher certifications and endorsements, this may not be the case in all states or foreign jurisdictions. If you plan to use courses for certification or endorsement, please check with your own state agency and your school district for applicability. Continuing teacher education courses are not eligible to apply to degree programs at University of Phoenix. These courses are not eligible for federal financial aid. Transferability of credit is at the discretion of the receiving institution. It is the student’s responsibility to confirm whether or not credits earned at University of Phoenix will be accepted by another institution of the student’s choice. While widely available, not all programs are available to residents of all states. Please check with a University Enrollment Representative. If you have a question contact us at (866) 354-1800.

/** TEMPORARY String.prototype.replaceAll() polyfill */ if (!String.prototype.replaceAll) { String.prototype.replaceAll = function(str, newStr){ // If a regex pattern if (Object.prototype.toString.call(str).toLowerCase() === '[object regexp]') { return this.replace(str, newStr); } // If a string return this.replace(new RegExp(str, 'g'), newStr); }; }