DataBase Management System

数据库

- Database Design

- MySQL

- NoSQL

Relational Database Management System Design

RDBMS

  • 数据存储在列和表中
  • 通过数据表示关系
  • 数据操纵语言
  • 数据定义语言
  • 从物理层抽象
  • 应用指定需求而非实现方式
  • 物理层可以更改
    • 创建索引以支持查询
    • 内存数据库

01-Entity-Relationship-Model-Modeling

02-Entity-Relationship-Model-Constraints

03-Entity-Relationship-Model-Extended-Features

04-Design-Issues

05-Logical-Design

06-Key-Concept

07-Relational-Database-Design-Purpose-&-First-Normal-Form

08-Relational-Database-Design-Functional-Dependency

09-Relational-Database-Design-BCNF

10-Relational-Database-Design-3rd-Normal-Form

SQL

01-Basic-MySQL

02-Cross-table-Query

03-Join

04-Aggregation

05-Data-Definition

06-Data-Modification

07-Null-Subquery

08-Set-Operation-&-Where-Subquery

09-Division-and-Correlated-Subquery

10-Advanced-SQL

NoSQL

图数据库

文档数据库

键值数据库

列族数据库

Table Of Contents
DataBase Management System
数据库
- Database Design
- MySQL
- NoSQL
Relational Database Management System Design
01-Entity-Relationship-Model-Modeling01-Entity-Relationship-Model-Modeling
02-Entity-Relationship-Model-Constraints02-Entity-Relationship-Model-Constraints
03-Entity-Relationship-Model-Extended-Features03-Entity-Relationship-Model-Extended-Features
04-Design-Issues04-Design-Issues
05-Logical-Design05-Logical-Design
06-Key-Concept06-Key-Concept
07-Relational-Database-Design-Purpose-&-First-Normal-Form07-Relational-Database-Design-Purpose-&-First-Normal-Form
08-Relational-Database-Design-Functional-Dependency08-Relational-Database-Design-Functional-Dependency
09-Relational-Database-Design-BCNF09-Relational-Database-Design-BCNF
10-Relational-Database-Design-3rd-Normal-Form10-Relational-Database-Design-3rd-Normal-Form
SQL
01-Basic-MySQL01-Basic-MySQL
02-Cross-table-Query02-Cross-table-Query
03-Join03-Join
04-Aggregation04-Aggregation
05-Data-Definition05-Data-Definition
06-Data-Modification06-Data-Modification
07-Null-Subquery07-Null-Subquery
08-Set-Operation-&-Where-Subquery08-Set-Operation-&-Where-Subquery
09-Division-and-Correlated-Subquery09-Division-and-Correlated-Subquery
10-Advanced-SQL10-Advanced-SQL
NoSQL
图数据库图数据库
文档数据库文档数据库
键值数据库键值数据库
列族数据库列族数据库