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

DBM/380

Database Concepts

Online

Format

$1194

Estimated Tuition

credits

Total credits

weeks

Course length

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.

Course level: Undergraduate

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.

Prerequisites

None

What you'll learn

Course skills and outcomes

Week 1

  • 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

Week 2

  • 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

Week 3

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

Week 4

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

Week 5

  • Summarize the importance of backing up relational data.
  • Evaluate at least three approaches to securing relational data.  

Why UOPX

Why take courses at University of Phoenix

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.

Next Steps

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

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

Call (844) 937-8679

Transfer Credits

Credit Transfer

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