D426 - Data Management Foundations

---

About

Data Management Foundations offers an introduction in creating conceptual, logical and physical data models.  Students gain skills in creating databases and tables in SQL-enabled database management systems, as well as skills in normalizing databases. No prerequisites are required for this course.

Objective

Objective

• Explains Database Attributes and SQL Commands
  • The learner explains attributes of databases, database tables, and structured and associated query language (SQL) commands.
• Determines SQL Queries
  • The learner determines how to run queries for creation and manipulation of data in relational databases.
• Defines Primary Keys
  • The learner defines primary and foreign keys in data normalization.

Course Outline

• Introduction to Databases
• Database Management
• Complex Queries
• Database Design
• Database Indexes

Course Pacing

• zyBooks Lessons
  • Lesson 1 (Intro to Databases)
    • notes
    • Quiz: 43/48 = 89%
  • Lesson 2 (Database Management)
    • Notes
    • Labs
    • Quiz: 45/53 = 84%
  • Lesson 3 (Complex Queries)
    • Notes
    • Labs
    • Quiz: 52/59 = 88%
  • Lesson 4 (Database Design)
    • Notes
    • Labs
    • Quiz: 46/60 = 76%
  • Lesson 5 (Indexes)
    • Notes
    • Quiz: 19/28 = 67%
• Review
  • Read all notes
  • Watch supplemental videos
• Pre-assessment
  • Pass: Competent
  • Score: 53/60 = 88%
• Practice Test 1
  • 61/69 = 88%
• Practice Test 2
  • couldn’t track right/wrong totals
  • probably 80-85%
• Final Exam
  • Passed, Exemplary

Resources

• Intro to Databases video:
  • https://www.youtube.com/watch?v=4Z9KEBexzcM
• Data modeling webinar
• Normalization webinar