Intro To SQL And Relational Database Management Systems
Every company in the world has data of some sort. This data could include things such as customer information, product information, and logs. So how can a company safely, store, access, and modify this data? Insert SQL and relational database management systems.
This article will cover
- What is a table
- What is a relational database
- What is SQL
What is a table
We are starting with the smallest building block first. Think of a table as a container that stores related information in a specific format. This format consists of vertical columns and horizontal rows similar to what you see in a spreadsheet. Each row of data or information is a unique record. Each column represents a field in that record. Each table has a unique name that describes the information that is present in the table.
Table: Students
Look at this example of a table above. The table name is students and that will describe the information that is inside the table. From there we have our header for each column which states the…
