it261 | undergraduate

Advanced Desktop Databases

Explore by:

or call us at

About:

About:

This course is a continuation in the study of desktop database software. Emphasis is placed on database design, reporting, queries and data analysis using desktop database software.

This undergraduate-level course is 9 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: 9 weeks

topic title goes here

    Using Reports to Create Business Intelligence

    • Create advanced reports using the Design view.
    • Create reports using the Report Wizard.
    • Sort and filter data within a report.

    Designing Advanced Queries

    • Explain when to use crosstab and action queries.
    • Create a subquery.
    • Create a query using multiple tables.

    Normalizing a Relational Database

    • Normalize a database through the fifth normal form.
    • Explain the purpose of normalization.
    • Describe the stages of the normalization process.

    Extended Entity Relationship Diagram (ERD)

    • Provide rationale in selecting primary keys.
    • Create an Extended Entity Relationship Diagram (ERD).

    Advanced Tables

    • Create advanced tables.
    • Use the Table Analyzer to improve the efficiency of a table.

    Introduction to SQL

    • Explain when to use each SQL data definition command.
    • Use SQL data manipulation commands to create queries.
    • Use aggregate functions in an SQL query.

    Data and Business Intelligence

    • Explain the need for data analysis.
    • Define business intelligence.
    • Differentiate between operational data and decision support data.

    Advanced Reports

    • Organize data in a report using group headers.
    • Create aggregate fields in a report.
    • Use print layout to improve the appearance of a report.

    Data Warehousing

    • Define a data warehouse.
    • Compare and contrast the different decision support architectural styles.
    • Explain how a data warehouse is implemented.
    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.