Member-only story
Concepts help me to understand the SQL-Databases
2 min readDec 2, 2022
As a beginner, everyone needs known examples to understand the language.
Since I know the excel basics and I Can relate the SQL to that. Hope most of them know excel fundamentals.
Excel : Database:(ignore schema now)
Consider Excel as a database
- Excel can store a lot of data in the form of Table(Columns and Rows)
- In the same way, SQL-Database also can store a lot of data in the form of columns and rows
Excel-Sheet: Database Tables
Excel can have multiple sheets, Consider those sheets are tables in SQL-Database
+--------------------------------+--------------------------------------+
| Excel | SQL-Database |
+--------------------------------+--------------------------------------+
| Excel can have multiple sheet | Database can have multiple table |
| ------------------------------ | ---------------------------------- |
| Each sheet has a unique name | Each Table has the unique name |
| ----------------------------- | ------------------------------------ |
| Sheets columns and rows | Table has the rows and columns |
| |…