dbm380 | undergraduate

Database Concepts

Explore by:

or call us at

About:

About:

This course covers database concepts. Topics include data analysis, the principal data models with emphasis on the relational model, entity-relationship diagrams, database design, normalization, and database administration.

This undergraduate-level course is 5 weeks This course is available to take individually or 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

    Introduction to the Relational Database Model and Other Database Models

    • Explain the purpose and utility of a database.
    • Identify the database model most commonly used in business today.
    • Distinguish between several commercial relational database management systems.

    Relational Database Design: Entity-Relationship Diagrams and Normalization

    • Explain the purpose of an entity-relationship diagram.
    • Create an entity-relationship diagram for a given business scenario.
    • Explain the purpose of normalization with respect to a relational data model.
    • Given an entity-relationship diagram depicting a non-normalized relational data model, normalize the data model.

    Relational Database Implementation: Creating and Populating Relational Tables

    • Create a multi-table relational database in a relational database management system (RDBMS) such as Microsoft® Access® using Structured Query Language (SQL) statements.
    • Create relational tables within a relational database that correspond to a normalized entity-relationship diagram.
    • Populate relational tables with data using SQL statements.

    Relational Database Use: Querying and Updating Relational Tables

    • Select data from related tables using SQL statements.
    • Update data in related tables using SQL statements.

    Relational Database Administration: Backing Up and Securing Relational Data

    • Summarize the importance of backing up relational data.
    • Evaluate at least three approaches to securing relational data.
    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.