Tóm tắt kiến thức:
1) Tạo cấu trúc database
	- Tạo CSDL (create database, use) - drop database
	- Tables
		- Tạo bảng (create table)
			- primary key
			- foreign key
			- unique
			- check
			- default
			- not null
			- identity
			...
		- Alter table
			- add column
			- modify column
			- drop column
			- change datatype
			- add constraint (PK, FK, Unique, Check, ...)
			- drop constraint
		- drop table
2) Dữ liệu
	- insert into
	- update
	- delete
	- select
		- Lẫy dữ liệu từ 1 bảng
		- Lấy dữ liệu từ nhiều bảng
			- join (inner join)
			- left join
			- right join
			- full outer join
		- Where
			- like
			- equal
			- in
			- between ... and
			- like in
			...
3) View & Procedure
	- View (Create, Alter, Drop)
	- Procedure (Create, Alter, Drop)
	- Index (clustered index & nonclustered index)
=================================================================================

Phân tích website nettruyenco.vn

Phân tích thiết kế dự án:
1) Users
	id -> PK -> identity(1,1)
	fullname
	email
	phone_number
	address
	gender
	birthday
	password -> bcrypt (md5 ~~)
	username
	role_id -> FK -> Roles (id)
2) Roles
	id -> PK -> identity(1,1)
	name
3) Danh mục truyện (Category)
	- id -> PK -> identity (1,1)
	- name
	- parent_id -> FK -> Category (id)

	1 'Danh Muc A' 0
	2 'Danh Muc A - 1' 1
	3 'Danh Muc A - 2' 1

4) Truyện (Story)
	id -> PK -> identity (1,1)
	tiêu đề
	tác giả
	tình trạng
	lượt view
	rating
	mô tả

5) CategoryStore
	category_id -> FK -> Category (id)
	store_id -> FK -> Story (id)
	PK (category_id, story_id)

6) Chương (Chapter)
	-id ->PK ->identity(1,1)
	-title
	-content
	-story_id -> FK -> storey (id)
7) comment_story
	-id ->PK ->identity(1,1)
	-user_id
	-comment
	-created_at
	-story_id
8) comment_chapter
	-id ->PK ->identity(1,1)
	-user_id
	-comment
	-created_at
	-chapter_id