Introduction to SQL

What is Database

  • A “Database” is a “Collection” of “Data” and “Holds” the “Data” in the “Form” of “Tables”.
  • Apart from “Storing” the “Data”, a “Database” also provides the “Capability” to “Access” and “Manipulate” the “Stored Data”.

What is Table

  • A “Table” is an “Entity” that “Holds” the “Data” in the “Form” of “Rows” and “Columns”.
  • A “Table” is similar to an “Excel Spreadsheet”.

Different Types of Databases

  • MySQL
  • SQL Server
  • PostgreSQL
  • SQLite
  • MariaDB
  • As a “Key-Value Pair”, or
  • As a “Document”, or
  • As a “Graph” etc.
  • HBase
  • MongoDB
  • Cassandra

What is SQL

  • “Insert” the “Data”
  • “Update” the “Record”
  • “Retrieve” the “Record”, and so on.

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Oindrila Chakraborty

I have 10+ experience in IT industry. I love to learn about the data and work with data. I am happy to share my knowledge with all. Hope this will be of help.