《sqlserver2000 数据库应用技术》
名词:
DBMS:
datebase Mangement System
关系数据库:relation
database
E-R图:
G be combined with the relation
数据仓库:大量的数据集合,是决策支持系统的基础。data
warehouse(dw)
SQL语言的组成:
数据定义语言:data
definition language
数据操纵语言:data
manipulation language
数据控制语言:data
control language
其他语言要素:additional
language elements
创建数据库:create
database testdb
on primary
(name = 'testdb_data',
filename =
'd:\...\data\testdb_data.mdf',
size= 1, maxsize = unlimited ,
filegrowth = 10%)
log on
(name = 'testdb_log',
filename =
'd:\...\data\testdb_log.ldf',
size = 1mb, maxsize = 25mb,
filegrowth = 10%)
删除数据库:
drop
database testdb
创建表:create
table student
(id char(11) not null, name char(8) not null, grend
char(1) not null,
constraint pk_student_id primary key (id)
)
修改表:alter
table student
add score int
-----------------------------
alter
table student
alter column grend int
删除表:drop
table student
表数据的插入:insert
into student values
('****','***','***','***','***')
表数据的修改:update
student
set score=score+5
where id='****'
表数据的删除:delete
from student where score<5
视图的创建:create
view student_view
as
select * from student
where score
>5
删除视图:drop
view student_view
查询:select
* from employee
where
money>3000
关于数据库本身的模式啊,设计啊什么的,有另一门专业课《数据库概论》专门的介绍,所以,对sqlserver2000的复习,基本就放在查询,修改上面。