Compare and contrast the different decision support architectural styles.
Define a data warehouse.
Use print layout to improve the appearance of a report.
Create aggregate fields in a report.
Organize data in a report using group headers.
Using Reports to Create Business Intelligence
Sort and filter data within a report.
Create advanced reports using the Design view.
Create reports using the Report Wizard.
Data and Business Intelligence
Differentiate between operational data and decision support data.
Define business intelligence.
Explain the need for data analysis.
Introduction to SQL
Use aggregate functions in an SQL query.
Use SQL data manipulation commands to create queries.
Explain when to use each SQL data definition command.
Designing Advanced Queries
Create a query using multiple tables.
Create a subquery.
Explain when to use crosstab and action queries.
Use the Table Analyzer to improve the efficiency of a table.
Create advanced tables.
Extended Entity Relationship Diagram (ERD)
Provide rationale in selecting primary keys.
Create an Extended Entity Relationship Diagram (ERD).
Normalizing a Relational Database
Normalize a database through the fifth normal form.
Describe the stages of the normalization process.
Explain the purpose of normalization.
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 Advisor.
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.