Lesson 1
Relational databases
Relational databases take extra consideration when you are learning about how databases work.
Relational databases let you work with information in much the same way you do with other things in your life, organizing similar information into groups and then trying to eliminate duplicates of information wherever possible.
We'll cover relational databases in this module. At the end of this module, you should understand what it means to have a normalized database and what that means to the queries you create using SQL.
Relational databases let you work with information in much the same way you do with other things in your life, organizing similar information into groups and then trying to eliminate duplicates of information wherever possible.
We'll cover relational databases in this module. At the end of this module, you should understand what it means to have a normalized database and what that means to the queries you create using SQL.
A relational database matches data by using common characteristics found within the data set. The resulting groups of data are organized and are
easier for humans to understand. For example, a data set containing all the stock transactions for a person can be grouped by the date range in
which the transactions occurred, or it can be grouped by the price range of the transactions. Such a grouping uses the relational model (a
technical term for this is schema). Hence, such a database is called a "relational database." The software used to do this grouping is
called a relational database management system (RDBMS) and the term "relational database" often refers to this type of software.
