Step by step React, NodejS and MySQL Simple Full Stack Application 2018 (part: 1)

in this article I describe about databases and type of them and installation of MySQL Database for backend development.

* What is database?

database is a collection of information with Regular structure that can be easily accessed, managed and updated.

* What are database elements?

Tables are elements of database. A database table is composed of records and fields that hold data. Tables are also called datasheets. Each table in a database holds data about a different, but related, subject.

* What are the different types of databases?

1- Relational databases(RDBMS) or SQL data structure: * databases like MySQL, Oracle, PostgreSQL use structured query language (SQL) for defining and manipulating data. * It is a safe choice and especially great for complex queries, but it can be restrictive. * It uses predefined schemas to determine the structure of your data before you work with it and all of your data must follow the same structure.
2- non-relational #NoSQL data structure: * A non-relational database like MongoDB, BigTable, Redis, RavenDB Cassandra, HBase, Neo4j and CouchDB have dynamic schema for unstructured data, and data is stored in many ways: it can be column-oriented, document-oriented, graph-based or organized as a KeyValue store

how to start work with MySQL database?

installation:
- Open https://dev.mysql.com/downloads/mysql/ link and download mysql:
After download and start installation in choosing a setup type use custom item because we need only install MySQL as a database:
Make sure your configuration should be like below information:
For Authentication Method insert your selected password and push add user button:
open up below link to download and install MySQL workbench to have visual MySQL database: https://dev.mysql.com/downloads/workbench/
After installation open up MySQL 8.0 command line client from MySQL folder in start menu and enter your MySQL’s password and press enter button
run MySQL Workbench Press local instance MySQL in the gray square and insert password of database:

now MySQL is running and we are ready to make database and tables.