im300 | undergraduate

Data Organization Architecture

Explore by:

or call us at

About:

About:

This course provides an introduction to how data is architected and organized. It discusses the different data models used to store data, it outlines several schemas that drive how data is structured, and provides other database concepts relating to the design and architecture of data.

This undergraduate-level course is 5 weeks To enroll, speak with an Enrollment Representative.

Course details:

Credits: 3
Continuing education units: XX
Professional development units: XX
Duration: 5 weeks

topic title goes here

    Normalizing the Database

    • Describe how real-world database design often requires the reconciliation of conflicting goals.
    • Demonstrate normalization through the third normal form.
    • Identify the advantages and disadvantages of normalization.
    • Explain how Entity Relationship Diagram (ERD) and Unified Modeling Language (UML) components affect database design and implementation.

    Integrity and Constraints

    • Define referential and entity integrity.
    • Perform data manipulation and data definition commands.
    • Apply SQL aggregate functions.

    Optimizing the Database

    • Select indices to improve performance.
    • Explain the query execution plan reported by a Database Management System (DBMS) engine.
    • Describe query optimizer.

    Data Models

    • Describe how data models have evolved.
    • Distinguish between object-relational systems and standard-relational systems.
    • Distinguish between structured and unstructured data.

    Keys

    • Identify primary and foreign keys.
    • Document business rules.
    • Describe naming conventions.
    • Describe data dictionaries and the system catalog.
    • Explain why indexing is important.
    Tuition for individual courses varies. For more information, please call or chat live with an Enrollment Representative.

    Please ask about these special rates:

    Teacher Rate: For some courses, special tuition rates are available for current, certified P-12 teachers and administrators. Please speak with an Enrollment Representative today for more details.

    Military Rate: For some courses, special tuition rates are available for active duty military members and their spouses. Please speak with an Enrollment Representative today for more details.

    The University of Phoenix reserves the right to modify courses.

    While widely available, not all programs are available in all locations or in both online and on-campus formats. Please check with a University Enrollment Representative.

    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.