The course focuses on database management systems from a managerial perspective. Emphasis is placed on developing a strategy for managing and organizing corporate data, including data warehousing, to support the business activities of the organization.
Create an entity-relationship diagram that models an organizations data architecture.
Design normalized database tables based on the definitions in an entity-relationship diagram.
Data Population, Manipulation, and Retrieval
Apply SQL to populate, manipulate, and retrieve data within databases.
Retrieve information from databases using applications and reports.
Data Warehouses
Apply techniques for managing the design, development, and maintenance of large database systems and data warehouses.
Analyze how business intelligence and data mining support organizational goals.
Data and Database Administration
Analyze data quality and integration.
Explain database administration and the responsibilities of a database administrator.
Analyze the importance of database and information security in an organization.
Database Fundamentals
Explain the database environment, information management, and development processes.
Differentiate among the roles of database development and administration team members.
Create a simple database.
Making Decisions about Databases and Database Management Systems
Evaluate the role of database management systems in IT infrastructure.
Evaluate how database management systems support an organizations business goals, objectives, and needs.
Outline the decisions an organization must make in selecting a database and database management tools.
Recommend strategies for overcoming limitations of the relational model.
Analyze current trends and likely future developments in database models.
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.
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.