Scribd
Upload
2 views1 page

SQL Notes

Uploaded by

harshitanese
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
2 views1 page

SQL Notes

Uploaded by

harshitanese
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

 Database – way to store data in a format to make accessible

(especially big data)


 Queries – command to the data base (by following a syntax)

Primary operations your database can - CRUD – create, read, update,


read

 DBMS – Database Management System - whenever we interact


with the database, we first interact with DBMS
Eg DMS – MySQL, PostgreSQL, MS SQL
1. Relational DBMS
- Data organized into structured rows and columns
- Follows fixed and predefined schema
- Uses SQL for defining and manipulation data
2. Non-Relational DBMS
- Provides flexible data storage and modelling
- No fixed or consistent schema
- Not necessary to use SQL for data manipulation and querying
- Ideal for Read Operations
- Platforms like – MongoDB, Cassandra, redis, neo4j

You might also like