Types of Database


Hello and welcome to everyone. Today we will learn about MySQL concept like Database types in details.

C# basic course click on: https://www.udemy.com/learn-csharp-with-sagar-jaybhay/ 
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/

There are different types of databases uses in these days. Following are the 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
10.   End-user Databases

C# basic course click on: https://www.udemy.com/learn-csharp-with-sagar-jaybhay/ 
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/

1.        Relational Databases
The data is saved in the database tables, which is have relations to each other and for that relational database are very popular.

2.        Hierarchical Databases
The data is saved in this Hierarchical database for the tree-like structure or parent-child relation.

3.        Cloud Databases
The cloud database designed to run on many servers and in some cases even multiple data centers, on there you can be saved your data.

4.        Operational Databases
In this Operational database generated huge popularity from different organizations. In that database include customer database, personal database, and inventory database.

5.        Object-Oriented Databases
The object-oriented database is a collection of OOPs. The object-oriented database takes more than the storage of programming language objects. Object-oriented programming languages like C++ or Java which can be stored in relational databases.

6.        Network Databases
In this network database, we create relationships between entities using network structure.

7.        Distributed Databases
The Distributed database is intended for those organizations that have separate workplace locations and need to have a different database for each location.

8.        Graph Databases
Graph database represents data as a network related objects in order to simplify data. There are newly added databases like Datastax Enterprise Graph and Neo4j.

9.        Non-Relational Databases
Non-Relational Database developed as a standard alternative to relational databases. Web applications became progressively intricate.

10.   End-user Databases
The end user database is used to meet the requests of the end users of an association.

C# basic course click on: https://www.udemy.com/learn-csharp-with-sagar-jaybhay/ 
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

Post a Comment

Popular posts from this blog

ALTER statement in MySQL

Image
Hello and welcome everyone. In this article, we will learn about the ALTER table statement in MySQL. Let’s go. MongoDB with .Net Core course link => https://www.udemy.com/mongodb-with-net-core-sagar-jaybhay/ C# basic course click on: https://www.udemy.com/learn-csharp-with-sagar-jaybhay/  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/ MySQL ALTER command is used to modify the table, view an existing database. When you have completed your database design and after that, you realize some of the information was left out when creating a database. You want to change without losing existing data, and then you can change data using ALTER command. MySQL ALTER command is used to add a column with an existing table, add multiple columns, drop a column, modify a column, rename a column, and rename the table. ALTER command also used to add and drop constraints on the existing table. ...
Read more

Order By Clause in MySQL

Image
Hello and welcome everyone. In this article, we will learn about the Order By Clause in MySQL. Let’s go. MongoDB with .Net Core course link => https://www.udemy.com/mongodb-with-net-core-sagar-jaybhay/ C# basic course click on: https://www.udemy.com/learn-csharp-with-sagar-jaybhay/  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/ MySQL Order by clause is used to sort the records or data in ascending or descending order. Order by clause allows us to sort records or data by a single column or multiple columns in ascending or descending order. There are two key using in Order by clause:          ASC: - sorting data or records by ascending order.          DESC: - sorting data or records by descending order. Syntax:          SELECT column_name_1, column_n...
Read more

MySQL Constraint – PRIMARY KEY

Image
C# basic course click on: https://www.udemy.com/learn-csharp-with-sagar-jaybhay/  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/ Hello everyone in the previous article we learn about MySQL Constraint – UNIQUE and in this article, we will learn PRIMARY KEY constraint with example. Let’s go. MongoDB with .Net Core course link => https://www.udemy.com/mongodb-with-net-core-sagar-jaybhay/ What is the PRIMARY KEY? MySQL PRIMARY KEY constraint uniquely identifies each row in a table and also it creates a unique index for accessing the table will access faster. The columns of a Primary Key cannot have null values in MySQL and it must contain unique values. A Primary key has only one on a table, if the primary key used with multiple fields, then they are called a Composite Key. Syntax 1 for creating PRIMARY KEY with CREATE table statement.      ...
Read more