Beginner guide of Sql
Journey of Sql Hi guys my name sachin sharma how the sql is going trend before we used a file system in file based system have some problem Data redudancy Now the question is what is data redudancy now take an example In a school have class and class have section A and section B in the section have student Now In a school conduct prize ceromoney this task assign the HOD of school and now HOD order the teacher give the top 3 student teacher have maintain the some (sheet or excel sheet) of student it take the name of student to give the hod But Hod also maintain the sheet it write the all the student have top marks in your sheet Now you can same top student data are present in differnt place in my example in teacher sheet and hod sheet this example Data redudancy Data Inconsistancy Now what is Data Inconsistancy if student of section A class said mam if have total mistak i am the top student and teacher see that is right it update the sheet and go to the hod office in this scenrio you think some amount of time hod sheet maintain the wrong data that is called the datainconsistancy Difficult Data Access we can mobile app of show the top student it is diffcult to accees the data Security Problem Now in my example some student goes the hod school and changed the name that any one can access the sheet Now These problem we Discuss the databased what is Databased it is a collection of related databased help to solved Problem of reduancy -Problem of inconsistancy,security But in this databased to managed By DBMS What is Dbms it a type of software to easiy process some data and query some data and acess some data Now Dbms have some relation databased those called relation databased and non relation databased RDMS (Relational databased Management System) They contain the data in the form of table Example - Mysql, PostgresSql In a Table is also called the collection of entity and column represent the Property and Row represent the unique entity Non Relation Databased is Mongodb ,Redis , etc
Journey of Sql
Hi guys my name sachin sharma how the sql is going trend before we used a file system in file based system have some problem
Data redudancy
Now the question is what is data redudancy now take an example
In a school have class and class have section A and section B in the section have student Now In a school conduct prize ceromoney this task assign the HOD of school and now HOD order the teacher give the top 3 student teacher have maintain the some (sheet or excel sheet) of student it take the name of student to give the hod
But Hod also maintain the sheet it write the all the student have top marks in your sheet
Now you can same top student data are present in differnt place in my example in teacher sheet and hod sheet this example Data redudancy
Data Inconsistancy
Now what is Data Inconsistancy if student of section A class said mam if have total mistak i am the top student and teacher see that is right it update the sheet and go to the hod office in this scenrio you think some amount of time hod sheet maintain the wrong data that is called the datainconsistancy
Difficult Data Access
we can mobile app of show the top student it is diffcult to accees the data
Security Problem
Now in my example some student goes the hod school and changed the name
that any one can access the sheet
Now These problem we Discuss the databased
what is Databased
it is a collection of related databased help to solved
- Problem of reduancy -Problem of inconsistancy,security
But in this databased to managed By DBMS
What is Dbms
it a type of software to easiy process some data and query some data and acess some data
Now Dbms have some relation databased those called relation databased and non relation databased
RDMS (Relational databased Management System)
They contain the data in the form of table
Example - Mysql, PostgresSql
In a Table is also called the collection of entity and column represent the Property and Row represent the unique entity
