Introduction to relational databases

Introduction to Importing Data in Python

Hugo Bowne-Anderson

Data Scientist at DataCamp

What is a relational database?

  • Based on relational model of data
  • First described by Edgar “Ted” Codd
Introduction to Importing Data in Python

Example: Northwind database

ch_3_1.006.png

Introduction to Importing Data in Python

Example: Northwind database

ch_3_1.007.png

Introduction to Importing Data in Python

Example: Northwind database

ch_3_1.008.png

Introduction to Importing Data in Python

Example: Northwind database

ch_3_1.009.png

Introduction to Importing Data in Python

The Orders table

ch_3_1.011.png

Introduction to Importing Data in Python

The Orders table

ch_3_1.012.png

Introduction to Importing Data in Python

The Orders table

ch_3_1.013.png

Introduction to Importing Data in Python

The Orders table

ch_3_1.014.png

Introduction to Importing Data in Python

Tables are linked

ch_3_1.016.png

Introduction to Importing Data in Python

Tables are linked

ch_3_1.017.png

Introduction to Importing Data in Python

Tables are linked

ch_3_1.018.png

Introduction to Importing Data in Python

Relational model

  • Widely adopted
  • Codd’s 12 Rules/Commandments
    • Consists of 13 rules (zero-indexed!)
    • Describes what a Relational Database Management System should adhere to to be considered relational
Introduction to Importing Data in Python

Relational Database Management Systems

ch_3_1.025.png

Introduction to Importing Data in Python

Relational Database Management Systems

ch_3_1.026.png

Introduction to Importing Data in Python

Relational Database Management Systems

ch_3_1.027.png

Introduction to Importing Data in Python

Relational Database Management Systems

ch_3_1.028.png

Introduction to Importing Data in Python

Let's practice!

Introduction to Importing Data in Python

Preparing Video For Download...