Member-only story

Concepts help me to understand the SQL-Databases

Ramesh Ponnusamy
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 |
| |…

--

--

Ramesh Ponnusamy
Ramesh Ponnusamy

Written by Ramesh Ponnusamy

Data-Architect, SQL Master,Python ,Django, Flask dev, AI prompting, Linked-in: https://www.linkedin.com/in/ramesh-ponnusamy/ mail : ramramesh1374@gmail.com

No responses yet