| 失效链接处理 |
|
数据库技术及应用（第3版）实验教程 PDF 下载
下载地址：
版权归出版社和原作者所有，链接已删除，请购买正版
用户下载说明：
电子版仅供预览，下载后24小时内务必删除，支持正版，喜欢的请购买正版书籍：
https://product.dangdang.com/11736994848.html
相关截图：  资料目录：
第 1 章 SQL Server 2012 入门 ················· 2
1.1 SQL Server 2012 简介 ···················· 2
1.1.1 SQL Server 2012 发展历史 ········ 2
1.1.2 SQL Server 2012 的版本 ··········· 3
1.2 SQL Server 2012 的安装 ················ 3
1.2.1 SQL Server 2012 的运行环境
要求 ······································· 3
1.2.2 安装 SQL Server 2012 ·············· 4
1.2.3 SSMS 的使用 ························ 15
1.3 数据库相关操作 ·························· 16
1.3.1 数据库的组成 ······················· 16
1.3.2 数据库的创建、修改与删除 ··· 17
1.3.3 数据库的附加和分离 ············· 20
1.4 表的相关操作 ······························ 21
1.4.1 创建表 ································· 21
1.4.2 设计表 ································· 22
1.4.3 一个实例 ······························ 24
1.4.4 表的查询 ······························ 27
第 2 章 Oracle 11g 入门 ·························· 28
2.1 Oracle 发展史 ······························· 28
2.1.1 Oracle 版本发展 ····················· 28
2.1.2 Oracle 11g 新特性 ·················· 29
2.2 Oracle 11g 的安装 ························ 29
2.2.1 安装前的准备知识 ················· 29
2.2.2 Windows 平台安装 Oracle 11g ···· 30
2.3 Oracle 11g 的基本使用 ················ 35
2.3.1 Oracle 11g 的启动与关闭 ········ 35
2.3.2 数据库存储结构 ···················· 36
2.4 常用 Oracle 系统管理工具 ·········· 37
2.4.1 Net Manager ·························· 37
2.4.2 SQL*Plus ······························ 39
2.4.3 OEM ···································· 40
2.5 用户数据库对象的创建与管理 ··· 41
2.5.1 用户表空间、数据文件的创建
与管理 ·································· 41
2.5.2 用户管理 ······························ 41
习题 ······················································· 42
第 2 篇 实 验
实验 1 熟悉 SQL Server 2008 环境 ······· 44
实验 2 数据库与数据表的创建、删除
与修改 ············································ 48
实验 3 单表 SQL 查询语句 ····················· 49
实验 4 数据汇总查询语句 ······················· 51
实验 5 多表 SQL 查询语句 ····················· 52
实验 6 嵌套查询和集合查询 ··················· 53
实验 7 数据定义和数据更新 ···················· 54
实验 8 SQL Server 2008 中视图
的创建和使用 ······························· 55
实验 9 SQL Server 2008 中数据的控制
与维护 ··········································· 56
附录 A edu_d 数据库的数据表结构 ········ 62 ·VIII·
第 3 篇 知识要点与习题
第 1 章 绪论 ·············································· 64
1.1 知识要点 ······································ 64
1.2 习题 ·············································· 67
1.3 习题参考答案 ······························ 76
1.4 主教材习题参考答案··················· 79
第 2 章 关系数据库 ·································· 83
2.1 知识要点 ······································ 83
2.2 习题 ·············································· 84
2.3 习题参考答案 ······························ 91
2.4 主教材习题参考答案··················· 93
第 3 章 数据库设计 ·································· 94
3.1 知识要点 ······································ 94
3.2 习题 ·············································· 96
3.3 习题参考答案 ···························· 108
3.4 主教材习题参考答案·················· 116
第 4 章 SQL Server 2008 数据库管理
系统 ············································ 120
4.1 知识要点 ···································· 120
4.2 习题 ············································ 122
4.3 习题参考答案 ···························· 126
4.4 主教材习题参考答案 ················· 126
第 5 章 关系数据库标准语言 SQL ········ 130
5.1 知识要点 ···································· 130
5.2 习题 ············································ 133
5.3 习题参考答案 ····························· 144
5.4 主教材习题参考答案 ················· 150
第 6 章 数据库保护 ································ 154
6.1 知识要点 ···································· 154
6.2 习题 ············································ 157
6.3 习题参考答案 ····························· 168
6.4 主教材习题参考答案 ················· 172
第 7 章 数据库新技术及国产数据库
介绍 ············································ 177
7.1 知识要点 ···································· 177
7.2 习题 ············································ 178
7.3 习题参考答案 ····························· 181
7.4 主教材习题参考答案 ················· 181
参考文献 ···················································· 184
|
| Java1234官方群25： | 
|
| Java1234官方群25： | 838462530 |
苏公网安备 32061202001004号
