Course Modules

Module 0: Course Basics

Module 0: Course Basics
  • Complete All Items
Module Completed Module In Progress Module Locked
Module 0: Course Basics 4938777  
  • Page
    M0.0: Course Basics M0.0: Course Basics
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete
  • Quiz
    M0.1: Course Basics Quiz M0.1: Course Basics Quiz
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete
  • Quiz
    M0.2: Attendance Requirement (No Show Policy) M0.2: Attendance Requirement (No Show Policy)
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete

Module 1: Introduction to Databases

Module 1: Introduction to Databases
  • Complete All Items
Module Completed Module In Progress Module Locked
Module 1: Introduction to Databases 4938778  
  • Page
    Team activity 1 Team activity 1
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete
  • Page
    M1.0: Lesson Overview M1.0: Lesson Overview
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete
  • Page
    M1.1: What is a Database? M1.1: What is a Database?
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete
  • Page
    M1.2: Why use a Database? M1.2: Why use a Database?
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete
  • Page
    M1.3: History of Databases M1.3: History of Databases
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete
  • Page
    M1.4: Database System Components M1.4: Database System Components
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete
  • Page
    M1.5: Primary Database Models M1.5: Primary Database Models
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete
  • Page
    M1.6: Relational Database Model M1.6: Relational Database Model
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete
  • Quiz
    M1.7: Intro to Databases Quiz M1.7: Intro to Databases Quiz
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete
  • Page
    M1.8: MySQL Installation M1.8: MySQL Installation
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete
  • Assignment
    M1.9: MySQL Install Verification M1.9: MySQL Install Verification
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete
  • Page
    M1.10: DB1 Case Study L1 M1.10: DB1 Case Study L1
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete

Module 2: Database Models and Diagrams

Module 2: Database Models and Diagrams
Prerequisites: Module 1: Introduction to Databases
  • Complete All Items
Module Completed Module In Progress Module Locked
Module 2: Database Models and Diagrams 4938779  
  • Assignment
    Team Activity 2 Team Activity 2
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete
  • Page
    M2.0: Lesson Overview M2.0: Lesson Overview
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete
  • Page
    M2.1: Entity Relationship Diagrams M2.1: Entity Relationship Diagrams
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete
  • Page
    M2.2: Relational Model Diagram M2.2: Relational Model Diagram
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete
  • Page
    M2.3: Data Types M2.3: Data Types
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete
  • Page
    M2.4: Database Terms M2.4: Database Terms
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete
  • Page
    M2.5: Enhanced Entity Relationship Model M2.5: Enhanced Entity Relationship Model
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete
  • Quiz
    M2.6: Database Concepts Quiz M2.6: Database Concepts Quiz
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete
  • Assignment
    M2.8: EER Diagram M2.8: EER Diagram
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete
  • Assignment
    M2.9: DB1 Case Study L2 M2.9: DB1 Case Study L2
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete

Module 3: Database Management System

Module 3: Database Management System
Prerequisites: Module 2: Database Models and Diagrams
  • Complete All Items
Module Completed Module In Progress Module Locked
Module 3: Database Management System 4938780  
  • Page
    Team Activity 3 Team Activity 3
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete
  • Page
    M3.0: Lesson Overview M3.0: Lesson Overview
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete
  • Page
    M3.1: MySql Overview M3.1: MySql Overview
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete
  • Page
    M3.2: Backup and Restore Process M3.2: Backup and Restore Process
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete
  • Page
    M3.3: Explore Real World Databases M3.3: Explore Real World Databases
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete
  • Page
    M3.4: Creating a Database M3.4: Creating a Database
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete
  • Page
    M3.5: Loading Data M3.5: Loading Data
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete
  • Assignment
    M3.6: Database Backup File M3.6: Database Backup File
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete
  • Assignment
    M3.7: DB1 Case Study L3 M3.7: DB1 Case Study L3
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete

Module 4: Basic SQL Queries

Module 4: Basic SQL Queries
Prerequisites: Module 3: Database Management System
  • Complete All Items
Module Completed Module In Progress Module Locked
Module 4: Basic SQL Queries 4938781  
  • Page
    M4.0: Lesson Overview M4.0: Lesson Overview
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete
  • Page
    M4.1: Introduction to SQL & Queries M4.1: Introduction to SQL & Queries
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete
  • Page
    M4.2: SQL SELECT Statement M4.2: SQL SELECT Statement
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete
  • Page
    M4.3: The WHERE Clause M4.3: The WHERE Clause
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete
  • Page
    M4.4: The ORDER BY Clause M4.4: The ORDER BY Clause
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete
  • Page
    M4.5: Basic SQL Functions M4.5: Basic SQL Functions
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete
  • Quiz
    M4.6: Basic Query Quiz M4.6: Basic Query Quiz
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete
  • Assignment
    M4.7: Basic Query Lab M4.7: Basic Query Lab
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete
  • Assignment
    M4.8: DB1 Case Study L4 M4.8: DB1 Case Study L4
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete

Module 5: Aggregate SQL Queries

Module 5: Aggregate SQL Queries
Prerequisites: Module 4: Basic SQL Queries
  • Complete All Items
Module Completed Module In Progress Module Locked
Module 5: Aggregate SQL Queries 4938782  
  • Page
    M5.0: Lesson Overview M5.0: Lesson Overview
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete
  • Page
    M5.1: GROUP BY Clause M5.1: GROUP BY Clause
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete
  • Page
    M5.2: Aggregate Functions M5.2: Aggregate Functions
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete
  • Quiz
    M5.3: GROUP BY Quiz M5.3: GROUP BY Quiz
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete
  • Assignment
    M5.4: GROUP BY Query Lab M5.4: GROUP BY Query Lab
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete
  • Assignment
    M5.5: DB1 Case Study L5 M5.5: DB1 Case Study L5
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete

Module 6: Multi-Table Queries

Module 6: Multi-Table Queries
Prerequisites: Module 5: Aggregate SQL Queries
  • Complete All Items
Module Completed Module In Progress Module Locked
Module 6: Multi-Table Queries 4938783  
  • Page
    M6.0: Lesson Overview M6.0: Lesson Overview
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete
  • Page
    M6.1: Introduction to Joins M6.1: Introduction to Joins
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete
  • Page
    M6.2: INNER Joins M6.2: INNER Joins
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete
  • Page
    M6.3: OUTER Joins M6.3: OUTER Joins
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete
  • Quiz
    M6.4: JOINs Quiz M6.4: JOINs Quiz
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete
  • Assignment
    M6.5: DB1 Case Study L6 M6.5: DB1 Case Study L6
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete

Module 7: Multi-Table Aggregate Queries

Module 7: Multi-Table Aggregate Queries
Prerequisites: Module 6: Multi-Table Queries
  • Complete All Items
Module Completed Module In Progress Module Locked
Module 7: Multi-Table Aggregate Queries 4938784  
  • Page
    M7.0: Lesson Overview M7.0: Lesson Overview
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete
  • Page
    M7.1: Multi-Table GROUP BY Statements M7.1: Multi-Table GROUP BY Statements
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete
  • Page
    M7.2: Multi-Table Aggregate Functions M7.2: Multi-Table Aggregate Functions
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete
  • Assignment
    M7.4: Multi-Table Query Lab M7.4: Multi-Table Query Lab
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete
  • Assignment
    M7.5: DB1 Case Study L7 M7.5: DB1 Case Study L7
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete

Module 8: Query Views

Module 8: Query Views
Prerequisites: Module 7: Multi-Table Aggregate Queries
  • Complete All Items
Module Completed Module In Progress Module Locked
Module 8: Query Views 4938785  
  • Page
    M8.0: Lesson Overview M8.0: Lesson Overview
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete
  • Page
    M8.1: Introduction to Views M8.1: Introduction to Views
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete
  • Page
    M8.2: Creating a View M8.2: Creating a View
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete
  • Page
    M8.3: Testing a View M8.3: Testing a View
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete
  • Assignment
    M8.4: Query Views Lab M8.4: Query Views Lab
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete
  • Assignment
    M8.5: DB1 Case Study L8 M8.5: DB1 Case Study L8
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete

Final Project

Final Project
Module Completed Module In Progress Module Locked
Final Project 4938786  
  • Assignment
    Final Database Final Database
    Score at least   Must score at least   to complete this module item Scored at least   Module item has been completed by scoring at least   Score at least  % Must score at least  % to complete this module item Scored at least  % Module item has been completed by scoring at least  % View Must view in order to complete this module item Viewed Module item has been viewed and is complete Mark done Must mark this module item done in order to complete Marked done Module item marked as done and is complete Contribute Must contribute to this module item to complete it Contributed Contributed to this module item and is complete Submit Must submit this module item to complete it Submitted Module item submitted and is complete
 
minimum score must view must submit must contribute