SYBASE 数据库基础
目录
i
目录
课程说明 ....................................................................................................................................... 1
课程介绍 .......................................................................................................................................1
课程目标 .......................................................................................................................................1
第 1 章 Sybase 数据库简介 .......................................................................................................... 2
1.1 什么是数据库 .........................................................................................................................2
1.2 Sybase 数据库的组成 ............................................................................................................2
1.3 Sybase 数据库的版本 ............................................................................................................3
小结 ..............................................................................................................................................4
习题 ..............................................................................................................................................4
第 2 章 Sybase 有关概念 ............................................................................................................. 5
2.1 数据库设备 ............................................................................................................................5
2.2 系统数据库 ............................................................................................................................6
2.2.1 master 数据库 ..............................................................................................................6
2.2.2 model 数据库 ...............................................................................................................7
2.2.3 sybsystemprocs 数据库 ...............................................................................................7
2.2.4 临时数据库 tempdb .....................................................................................................7
2.3 数据库对象 ............................................................................................................................7
2.3.1 表(Tables) ...................................................................................................................7
2.3.2 存储过程 (Stored procedures) .....................................................................................8
2.4 SQL Server 的用户及权限 ................................................................................................... 10
2.4.1 建立 SQL 服务器用户名（登录帐号） ..................................................................... 11
2.4.2 增加数据库用户名 .................................................................................................... 11
小结 ........................................................................................................................................... 13
习题 ........................................................................................................................................... 13
第 3 章 几个实用程序 ................................................................................................................. 14
3.1 isql ....................................................................................................................................... 14
3.1.1 启动 isql ................................................................................................................... 14
3.1.2 退出 isql ................................................................................................................... 15
3.2 bcp ...................................................................................................................................... 15
3.3 showserver .......................................................................................................................... 16
3.4 startserver ........................................................................................................................... 17
小结 ........................................................................................................................................... 17
习题 ........................................................................................................................................... 17
第 4 章 SYBASE 软件的启动与关闭 ......................................................................................... 18
4.1 SYBASE 软件的启动 ........................................................................................................... 18
4.1.1 自动启动 .................................................................................................................. 18
4.1.2 手工启动 .................................................................................................................. 18
VIP享7折，此内容立减4.47元 
