图书介绍
实用数据库技术PDF|Epub|txt|kindle电子书版本网盘下载
- 王振海主编 著
- 出版社： 济南：山东人民出版社
- ISBN：9787209067553
- 出版时间：2012
- 标注页数：160页
- 文件大小：53MB
- 文件页数：176页
- 主题词：数据库系统－高等学校－教材
PDF下载
下载说明
实用数据库技术PDF格式电子书版下载
下载的文件为RAR压缩包。需要使用解压软件进行解压得到PDF格式图书。建议使用BT下载工具Free Download Manager进行下载,简称FDM(免费,没有广告,支持多平台）。本站资源全部打包为BT种子。所以需要使用专业的BT下载软件进行下载。如BitComet qBittorrent uTorrent等BT下载工具。迅雷目前由于本站不是热门资源。不推荐使用！后期资源热门了。安装了迅雷也可以迅雷进行下载！
（文件页数 要大于 标注页数，上中下等多册电子书除外）
注意：本站所有压缩包均有解压码： 点击下载压缩包解压工具
图书目录
君子务本，本立而道生——《临沂大学优秀校本教材》总序 韩延明1
Introduction to SQL Server 20051
Unit 1 What Makes Up a SQL Server Database？1
1.1 An Overview of Database Objects1
1.2 The Database Object2
1.3 SQL Server Identifiers for Objects10
Summary11
Exercises11
Unit 2 How to Use Tools of SQL Server12
2.1 Creating a Database in Microsoft SQL Server 200513
2.2 The Query Editor17
2.3 Entering a SQL Query or Statement24
2.4 The Scripts of SQL Server2005_load.sql27
Review Questions43
Exercises43
Uint 3 The Foundation Statements of T-SQL44
3.1 Getting Started with a Basic SELECT Statement45
3.2 Adding Data with the INSERT Statement52
3.3 Changing What You've Got with the UPDATE Statement53
3.4 The DELETE Statement54
Summary54
Review Questions55
Exercise56
Unit 4 Joins58
4.1 INNER JOIN58
4.2 The OUTER JOIN62
4.3 CROSS JOINs63
Summary63
Review Questions63
Exercises64
Unit 5 Subquery67
5.1 What Is a Subquery？67
5.2 Introducing Set Operations71
Summary73
Review Questions73
Exercises74
Unit 6 Creating and Altering Tables81
6.1 Object Names in SQL Server81
6.2 CREATE DATABASE82
6.3 Data Types in SQL Server 200586
6.4 Creating a Table88
6.5 The ALTER TABLE Command89
Summary90
Review Questions90
Exercises91
Unit 7 Functions93
7.1 Aggregate Functions94
7.2 Row-Level Functions95
7.3 Other Functions96
Summary104
Review Questions105
Exercises106
Unit 8 Indexes and Constraints on Tables110
8.1 Indexes110
8.2 How Data Is Accessed in SQL Server110
8.3 CREATE INDEX111
8.4 Constraints112
Summary118
Review Questions118
Exercises119
Unit 9 Views122
9.1 Creating views123
9.2 Using views123
Summary124
Review Questions125
Exercises125
Unit 10 Programming Basics and Stored Procedures127
10.1 Declaring Variables128
10.2 Control-of-Flow Statements128
10.3 Stored Procedures132
Summary137
Exercises137
Unit 11 Triggers139
11.1 What Is a Trigger？139
11.2 Using Triggers140
11.3 Dropping Triggers150
Summary150
Exercises150
Unit 12 User Defined Functions151
12.1 What a UDF Is151
12.2 Using UDF152
Summary154
Unit 13 Transactions156
13.1 What is a Transaction？156
13.2 Transactions156
Summary158
Exercises159
References160