Link Cài

Sql Server Express

Sql Server Management Studio 2019

web dong:
	- frontend: html/css/js/...
	- backend: php/laravel, asp, java ...
	- sql server/mysql/oracle -> sql

Xay dung CSDL du lieu -> quan ly thong tin sinh vien cua Aptech -> chia ra nhom doi tuong -> FILE de luu tru du lieu cua du an -> database file -> CSDL file -> Thiet ke gom nhieu bang
- Thong tin sinh vien (ten, msv, tuoi, email, ...) -> CSDL -> table
- thong tin mon hoc ...
- thong ky hoc
- thong tin diem thi
- thong thay giao
- ...

- row | record | ban ghi | hang du lieu
- column | field
- Lam the nao de tao dc table du lieu nhu hinh tren
	- Tao ra cau truc cua bang
	- Them du lieu vao bang

---------------------------------------------------------
Tao CSDL -> tao bang tools (Buoi hoc sau se tao bang lenh) -> C2108G3
Tao table:
	- Tao bang tools -> DONE
	- Tao bang lenh
Them du lieu vao bang
	- Them bang tools -> DONE
	- Them bang lenh

Luu y: 90% su dung lenh de viet.

create table OrderDetails (
	OrderId nvarchar(10),
	InvoiceNo nvarchar(10),
	OrderDate nvarchar(20)
)
go -- Ket thuc lenh

-- Them du lieu vao bang dung sql
insert into OrderDetails(OrderId, InvoiceNo, OrderDate)
values
('R001', 'I001', '09/20/2021')
go

insert into OrderDetails(OrderId, InvoiceNo, OrderDate)
values
('R002', 'I002', '09/12/2007')
go

insert into OrderDetails(OrderId, InvoiceNo, OrderDate)
values
('R003', 'I003', '09/15/2009')
go