CIT 111: Introduction to Databases

Course Home

Week Midweek End of Week
01 - Understanding Data
  1. Prepare: Understanding Data
  2. Activity: Data Gathering
  3. Activity: Data to Decisions
  4. Activity: Setup MySQL Workbench
  5. Activity: Group Signup
  1. Assignment: Tabular Data
  2. Assignment: Explore mySQL Workbench
  3. W01 Prove Quiz
  4. W01 60-second Status Update
02 - Data Storage/Relational Databases
  1. Prepare: Data Storage and Relational Databases
  2. Activity: ERD and Databases
  3. Activity: SQL Overview Hands-On
  4. Activity: Database Design
  5. Activity: Big Data
  1. Assignment: SQL Overview
  2. Assignment: Database Design
  3. W02 Prove Quiz
  4. W02 60-second Status Update
03 - Database Design and Creation
  1. Prepare: Database Design and Creation
  2. Activity: Movie Database Design and CRUD
  3. Activity: CRUD in Practice
  1. Assignment: Design and Populate Art Database
  2. W03 Prove Quiz
  3. W03 60-second Status Update
04 - Data Retrieval
  1. Prepare: Data Retrieval
  2. Activity: Querying Databases
  3. Activity: MySQL Workbench Errors
  4. Activity: Querying Company Data
  1. Assignment: Single Table Queries
  2. W04 Prove Quiz
  3. W04 60-second Status Update
05 - Joining and Summarizing Data
  1. Prepare: Joining and Summarizing Data
  2. Activity: Joining Tables and Aggregating Data
  3. Activity: SQL Select Practice
  1. Assignment:Joining and Summarizing Data
  2. W05 Prove Quiz
  3. W05 60-second Status Update
06 - Review Project
  1. Prepare: Subqueries and Indexes
  1. Assignment: Review Project
  2. W06 60-second Status Update
  3. W06 Student Evaluation of Instructor
07 - Final Exams
  1. W07 Final Exam: Coding
  2. W07 Final Exam: Questions
  3. W07 End of Course Evaluation
Terms Quizlet
Items marked with are group activities.