Skip to Main Content Skip to bottom Skip to Chat, Email, Text

DAT/390

Database Integration with Other Systems

Course level: Undergraduate

Information Technology

Online

Format

$1,194

Estimated Tuition

3 credits

Total credits

5 weeks

Course length

Take this course on its own, or as part of a degree or certificate program.

Start when you're ready

Choose an upcoming start date:

Enroll by 1pm Central:

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.

This course addresses the main standards for data integration, movement or replication and federation. Students will investigate transparency and emulation, cleaning, archiving and information preservation across systems.

Prerequisites

None

Required materials

The materials required for this course are covered in your resource fees.

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.

Earn these career-relevant skills in weeks, not years.

  • Prepare a schema matching and mapping appropriate for a business case.
  • Develop appropriate metadata for a database system.
  • Resolve conflicts between heterogeneous data sources.
  • Resolve schematic discrepancies.
  • Validate data quality and provenance for use in a distributed database system.

  • Identify the appropriate optimization strategy that incorporates best practices and design considerations of a database system.
  • Evaluate queries for distributed data sources, source descriptions, and limitations.
  • Develop appropriate Schema SQL statements.

  • Recommend the appropriate database connectivity technology for given business scenario.
  • Transform data structured under a source schema into data structured under a different target schema.
  • Evaluate data relationships across data sources.
  • Prepare a database for integration with an Internet application.

  • Prepare data, including data cleaning, for integration into a data warehouse environment.
  • Evaluate database incompleteness, inconsistency, nulls, and consistent query answers.
  • Recommend the appropriate data exchange option using appropriate source-to-target dependencies.
  • Develop appropriate data preservation strategy for a data warehouse.

  • Assess semi-structured data in relational DBMS.
  • Apply appropriate analytic techniques for data sets in a given business scenario.
  • Integrate the appropriate business intelligence tools into the data warehouse given selection considerations in a business case.
  • Utilize ongoing and appropriate query optimization and rewriting for a given database system.

Why take courses at University of Phoenix?

University of Phoenix serves busy adults

Accreditation that matters

We’ve been accredited by the Higher Learning Commission (hlcommission.org) 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.

Transfer-friendly courses

Before you enroll in a course, check with your school of choice to make sure they will accept your transfer credits and to understand any requirements or limitations. Then you can 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.

Enrollment representative Sarah P.

Enrollment Rep. Sarah P.

Start a conversation about your future today.

Speak with an enrollment representative.

Call 844-937-8679 or chat with us 7 days a week.

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. 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.