MySQL – Data and Database


Hello and welcome to everyone. Today we will learn about MySQL concepts like what is Data and Database.
Web API 2- .Net Core In depth In 5 Hours click on: https://www.udemy.com/web-api-2-net-core-in-depth-in-5-hrs-with-sagar-jaybhay/

Data
Data is a collection of information. Data means data can be any information. For example, there is an employee and all the information about the employee like employee id, employee name, employee age, employee phone number, employee address, employee salary, employee designation, this is called data or it’s called data elements.

Web API 2- .Net Core In depth In 5 Hours click on: https://www.udemy.com/web-api-2-net-core-in-depth-in-5-hrs-with-sagar-jaybhay/

Database
The database is a systematic collection of data. The database is a set of related data and how it is structured. The database is not just a group of lads and bytes and worthless information, its data that does have a common determination. The data could be for more than one object. For example, if you considering employee, all the information about the employee like employee id, employee name, employee age, employee phone number, employee address, employee salary, employee designation. These all information about an employee it’s called data and organizing that data in a systematic collection of manner then that is called database. Every database has one or more separate apis for creating, access, manage, drop, delete and search data which you want to show. In these days we using relational database management systems to the collection and manage data. The database is working to make some very important divisions about the data elements. So an element, being part of data like id, name, age, phone number, address, salary, designation, etc. Now I have the date format here of May 7th, 2015 that is the date. So that would be a date object and that is working to be separate from a time object. Now the time of 9 pm that is working to consider time, not a date. So these are date and time just data types, that can we roll up to total hours worked.
Different types of database
1.        Relational Databases
2.        Hierarchical Databases
3.        Cloud Databases
4.        Operational Databases
5.        Object-oriented Databases
6.        Network Database
7.        Distributed Databases
8.        Graph Databases
9.        Non-Relational Databases
1.   End-user Databases
We will learn in the next step about types of database.

Web API 2- .Net Core In depth In 5 Hours click on: https://www.udemy.com/web-api-2-net-core-in-depth-in-5-hrs-with-sagar-jaybhay/



Comments

Popular posts from this blog

ALTER statement in MySQL

Order By Clause in MySQL

MySQL Constraint – UNIQUE