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?
- Open https://dev.mysql.com/downloads/mysql/ link and download mysql:
open up below link to download and install MySQL workbench to have visual MySQL database: https://dev.mysql.com/downloads/workbench/