baceu2010 | Professional Development

Database Fundamentals

Explore by:

or call us at

About:

About:

Organizations keep their business records within databases. To successfully extract information for use in business decisions, it is important to understand how data is structured and stored. In this course, students will learn the general principles involved in designing a database as it applies to a relational database model. Further, students will learn the terminology, data types, and integrity elements of database design and how queries allow data to be extracted from the database. To complete this course, students are required to have access to Microsoft Access software. This course provides 0.8 continuing education units over two 4-hour workshops.

This non-credit course is 2 weeks To enroll, speak with an Enrollment Representative.

Course details:

Credits: 0
Duration: 2 weeks

topic title goes here

    Data Integrity

    • Identify how to prevent field data errors
    • Understand select queries, calculations queries, and action queries
    • Explore how to test queries to ensure they provide the correct results
    • Examine how to ensure consistent data

    Database Fundamentals

    • Determine the purpose of the database
    • Define the fields for the database
    • Identify what data exists
    • Identify a primary key for each table
    • Examine table relationships
    • Identify how to normalize tables to the first, second, third, and higher normal forms
    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.