http://www.phoenix.edu
Advanced Desktop Databases –
it261
(3 credits)
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.
To enroll, speak with an Enrollment Advisor.
-
Normalizing a Relational Database
- Explain the purpose of normalization.
- Describe the stages of the normalization process.
- Normalize a database through the fifth normal form.
-
Extended Entity Relationship Diagram (ERD)
- Create an Extended Entity Relationship Diagram (ERD).
- Provide rationale in selecting primary keys.
-
Advanced Tables
- Create advanced tables.
- Use the Table Analyzer to improve the efficiency of a table.
-
Designing Advanced Queries
- Explain when to use crosstab and action queries.
- Create a subquery.
- Create a query using multiple tables.
-
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.
-
Using Reports to Create Business Intelligence
- Create reports using the Report Wizard.
- Create advanced reports using the Design view.
- Sort and filter data within a report.
-
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.
- 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.
We're here to help
Learn more today
Find out how we can help you meet your goals. Not all courses are available to residents of all states. Ask your Enrollment Advisor for details.
Loading...
It looks like you are using
Enhance your Phoenix.edu experience
You're using an older browser (a software program used to explore the web) which is not optimal for viewing the University of Phoenix website. Consider downloading a new browser to maximize your experience on this and other websites. Your new browser should display web pages properly, increase your web surfing speed and enhance your security.
Upgrade your browser