DEV Community

loading...

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

Maryam Keshavarz
Updated on ・2 min read

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:

  • 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.

10.31.2018
resources:

Discussion (0)