Mysql basis:

Advantages of database:

1. Persist data locally

2. Structured query

Datebase: A ‘warehouse’ for storing data, holding a series of organized data.

Datebase Management System: A database is a container created and manipulated by a DBMS

Common DBMS: MySql, oracle, DB2, sqlserver

Structure Query Language (STRUCTURED Query Language) : A language designed to communicate with databases

1. Not a language specific to a particular database vendor, almost all DBMSS support SQL

2. Easy to learn

3, powerful language, flexible use of its language elements, can be very complex and advanced database operations

1. Put data into tables and tables into libraries

2, a database can have multiple tables, table names are unique

3. Tables have some properties.

4. A table is made up of columns, also known as fields. All tables are made up of one or more columns

5. Data in a table is stored in rows