Step by step React, NodejS and MySQL Simple Full Stack Application 2018 (part: 1)
Tags: intro, mysql, database
Published: 2018-10-31 07:27:51

---
title: Step by step React, NodejS and MySQL Simple Full Stack Application 2018 (part: 1)
published: true
description: in this article I describe about databases and type of them and installation of MySQL Database for backend development.
tags: # intro #MySQL #database
---
<h4>in this article I describe about databases and type of them and installation of MySQL Database for backend development.</h4>
<h4>* What is database?</h4><p>database is a collection of information with Regular structure that can be     easily accessed, managed and updated.</p>
<h4>* What are database elements?</h4><p>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.</p>
    <img src="https://thepracticaldev.s3.amazonaws.com/i/c62r5bjfbqo1d71w8338.png"/>

<h4>* What are the different types of databases?</h4>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.
<br/>
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
<h4>how to start work with MySQL database?</h4>
* installation:
    * Open <a href="https://dev.mysql.com/downloads/mysql/">https://dev.mysql.com/downloads/mysql/</a> link and download mysql:
<img src="https://thepracticaldev.s3.amazonaws.com/i/hspefmzo65ypl0ainjv2.png"/>

* After download and start installation in choosing a setup type use custom item because we need only install MySQL as a database:
<img src="https://thepracticaldev.s3.amazonaws.com/i/yykkrwax1ztr5btite9c.png"/>
<img src="https://thepracticaldev.s3.amazonaws.com/i/w0n7o18vx1a8359sfz2g.png"/>
* Make sure your configuration should be like below information: 
<img src="https://thepracticaldev.s3.amazonaws.com/i/cr99c6ah2bunz8d8gvo8.png"/>
* For Authentication Method insert your selected password and push add user button:
<img sre="https://thepracticaldev.s3.amazonaws.com/i/udagfdjyfguu0rtcd8wc.png"/>
* open up below link to download and install MySQL workbench to have visual MySQL database: <a href="https://dev.mysql.com/downloads/workbench/">https://dev.mysql.com/downloads/workbench/</a>
<img src="https://thepracticaldev.s3.amazonaws.com/i/phhtws61kec4bf7idzkg.png"/>
* 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
<img src="https://thepracticaldev.s3.amazonaws.com/i/2vwosjrelf5bocxkm0a7.png"/>
* run MySQL Workbench Press local instance MySQL in the gray square and insert password of database:
<img src="https://thepracticaldev.s3.amazonaws.com/i/rv2vwgr3kp808ptz09a3.png"/>
now MySQL is running and we are ready to make database and tables.

10.31.2018
 resources:
* http://www.dataversity.net/review-pros-cons-different-databases-relational-versus-non-relational/
* https://drive.google.com/drive/folders/18gas0zVtkClhD_83mQ_Q1TFFxERxa20k?usp=sharing
* https://www.cengage.com/school/corpview/RegularFeatures/DatabaseTutorial/db_elements/db_elements2.htm
* https://dev.mysql.com