DAT/390: Database Integration with Other Systems
Course Information
Description
This course addresses the main standards for data integration, movement or replication and federation. Students will investigate transparency and emulation, cleaning, archiving and information preservation across systems.
Credits
3
Course Learning Outcomes
In this course you will learn to: Where you will demonstrate your learning:
Develop queries that optimize results and efficiencies. Wk 3 – Apply: Labs
Design database models which align with business requirements. Wk 4 – Apply: Labs
Utilize ongoing and appropriate query optimization and rewriting for database systems. Wk 5 – Apply: Labs
Materials
Textbook
zyBooks. DAT/390: Database Integration with Other Systems
Course Tools
This course uses zyBooks. Textbooks delivered through zyBooks provide opportunities for students to review and engage with material while also assessing their mastery of the concepts presented.
Third-Party Trademarks That Appear in This Course
Blackboard and SafeAssign are registered trademarks of Blackboard Inc.
Pluralsight is a registered trademark of Pluralsight.
University of Phoenix is a registered trademark of The University of Phoenix, Inc. in the United States and/or other countries.
zyBooks is a registered trademark of Zyante, Inc.
All other company and product names are trademarks or registered trademarks of their respective companies. Use of these marks is not intended to imply endorsement, sponsorship, or affiliation.
Schedule Overview
Note: Practice assignments are due Day 5 and Apply assignments are due Day 7 unless indicated otherwise. Initial discussion posts are due Day 3 and the 2 required responses are due Day 7.
Wk and Topic Activities Assignments and Points
Wk 1 – Data Storage Learn: SQL Server: Why Physical Database Design Matters by Kimberly L. Tripp Discussion – 40 points
Practice: Reading – 50 points
Apply: Labs – 90 points
Wk 2 – Transaction Management Learn: Managing SQL Server Database Concurrency by Gerald Britton Discussion – 40 points
Practice: Reading – 50 points
Apply: Labs – 100 points
Wk 3 – Database Architecture Learn: Enterprise Data Modeling: Getting Started by Joseph Cline Discussion – 40 points
Practice: Reading – 70 points
Apply: Labs – 100 points
Wk 4 – Advanced SQL Learn: SQL: Using Joins, Constraints, Normalization, and Subqueries (Interactive) by Gregg Pollack Discussion – 40 points
Practice: Reading – 70 points
Apply: Labs – 100 points
Wk 5 – Database Programming Discussion – 40 points
Practice: Reading – 70 points
Practice: Developing SQL Server Databases Skill Assessment – 5 points
Apply: Labs – 95 points
For this short paper activity, you will learn about the three delays model, which explains…
Topic : Hospital adult medical surgical collaboration area a. Current Menu Analysis (5 points/5%) Analyze…
As a sales manager, you will use statistical methods to support actionable business decisions for Pastas R Us,…
Read the business intelligence articles: Getting to Know the World of Business Intelligence Business intelligence…
The behaviors of a population can put it at risk for specific health conditions. Studies…