Relational Databases and SQL

Applications often need to store and retrieve large amounts of information. Relational databases have been popular for storing data since the 1970s due to the relative simplicity and efficiency that relational databases offer.

A relational database stores data about entities. An entity is any object that an application wants to store information about. Ex: A university database may need to store data about student, faculty, and course entities. The term "relation" in "relational database" refers to the relationship of data that is stored in a relational database.

TIP

This module will take an estimated 7 - 9 hours to complete.

Module Assignments

• Complete the textbook reading assignments that are linked in canvas
• There are no textbook labs for this module
• Complete the end of module quiz on canvas
• Complete the end of module reflection on canvas(flip grid)

Important topics

• Relational Databases
• Structured Query Language (SQL)
• Basic database operations

Objectives

By the end of this module, you will be able to:

• Use a database such as mongo to store data
• Display data from a database on a website
• Understand basic data base operations and terminology