Getting started with MySQL is simple-learning notes-Chapter 1st database Overview

1.1. Data Storage Methods

1. manual management stage

2. File System Phase

3. Database System stage

 

1.2. Database generic

Database generics are the rules that databases should follow. Database generics are also known as paradigms. Currently, the four most common paradigms of relational databases are:

1nf, 2nf, 3nf, and bcnf)

 

1.3. SQL language

The full name of structuredquery language is the Structured Query Language. The database management system uses the SQL language to manage data in the database.

The SQL language consists of three parts:

Data Definition Language (DDL ),

Data manipulation language (DML)

And Data Control Language (DCL ).

DDL statement: Create Table...

DML statement: Select, insert, update, delete

DCL statement: Grant, revoke

 

1.4 why MySQL

1. MySQL is openSource codeDatabase

2. cross-platform MySQL

3. Price advantages

4. Powerful and easy to use

 

1.5. Common Database Systems

1. Oracle

2. IBM DB2

3. Microsoft Access and SQL Server

4. Open-source PostgreSQL

5. Open-source MySQL

6. File database SQLite,

7. Memory Database hql