Relational Database Fundamentals


As a beginner working with data in relational databases, there are some key concepts to understand before you get going with writing SQL queries. These are the things I found most useful when getting started querying databases.

The Relational Model

Relationship Categories in Databases


Primary Key v Foreign Key

To make the most of the structure of a database, and to avoid storing expensive spreadsheets, we need to abide by rules to keep data clean, organised and in a logical structure.

To help do this we can use a Primary Key. This is a column that best identifies one unique row, and identifies each record as unique, like an ID.


SQL Statements

SQL is a standardised language for querying, manipulating and modifying relational databases. The basic SQL statements used to transform the data into more segmented tables fall into four main groups.

Retrieve data with SELECT

Add new data with INSERT

Remove data with DELETE

Modify data with UPDATE


There are plenty of new concepts to get your head around with writing SQL and understanding the structure of a database. These are the relational database fundamentals I feel are most important for complete beginners to grasp the basics.

 

Photo by Medhat Ayad from Pexels

 

# # #

August 3, 2018

Bitnami