-- Tao table
create table Student2 (
	id int primary key  identity(1,1),
	first_name nvarchar(30),
	last_name nvarchar(30),
	email nvarchar(150),
	phone nvarchar(20)
)
go

-- Xem du lieu
select * from Student2
go

select * from Student
go

-- Chen du lieu vao
insert into Student2(first_name, last_name, email, phone)
values
('A', 'Tran Van', 'a@gmail.com', '123132')
go

insert into Student2(first_name, last_name, email, phone)
values
('B', 'Tran Van', 'a@gmail.com', '123132')
go


insert into Student2(first_name, last_name, email, phone)
values
('C', 'Tran Van', 'a@gmail.com', '123132'),
('D', 'Tran Van', 'a@gmail.com', '123132'),
('E', 'Tran Van', 'a@gmail.com', '123132')
go

File:
	He quan tri CSDL

APP (Java, C#, C/C++, PHP) -> He Quan Tri CSDL -> File

He Quan Tri CSDL:
	- SQL Server -> Hoc tren PM nay
	- MySQL
	- Oracle
	- Access
	...

	SQL:
================================================================
Tai sao???

SQL:
Du an
	-> database (CSDL) -> C2206L
		Quan ly diem:
			Quan sinh vien -> Table (bang) -> SinhVien, sinhvien, Student, student
				id -> int primary -> identity(1,1)
				First Name -> Field (Column) COT -> first_name -> nvarchar(30)
				Last Name -> last_name -> nvarchar(30)
				Email -> email -> nvarchar(150)
				Phone -> phone -> (+84) 967025996 -> nvarchar(20)

				-> Du lieu cu the: row, record, hang, ban ghi
			Quan ky hoc
			Quan mon hoc
			Quan diem

Cai dat moi truong:
Tao CSDL:
	PRIMARY KEY