SQL Server 2008 Practical Tutorial (3rd Edition)
Tags
Summary
Editor's review
Who it's for
A good fit for
- College students in computer-related majors, especially as a companion textbook for database principles or SQL Server courses.
- Career changers or IT beginners who want to learn SQL Server database technology systematically from scratch.
- Technical personnel who need to maintain or develop projects in existing SQL Server 2008/2008 R2 environments.
- Developers with a basic understanding of database operations who wish to consolidate and standardize their T-SQL coding skills.
Not a good fit for
- Experienced developers seeking the latest features of SQL Server 2016 and above (such as JSON support and in-memory OLTP).
- Readers who only want to quickly look up syntax and find solutions to problems without needing systematic theoretical knowledge.
Reading tips
- Follow the chapter order in the book; do not skip the early installation and basic concept sections, as they are the foundation for later understanding.
- Be sure to practice every example code in the book and complete the chapter exercises independently—practice is key to mastering database operations.
- When studying the query and programming chapters, combine online resources or newer official documentation to compare and understand the evolution and best practices of T-SQL statements.
About the publisher
Posts & Telecom Press is known for its strengths in science and technology, computing, and information and communications titles, and has extended its publishing into photography, art, software learning, and inspirational growth, giving it a fairly diverse range. Its catalog includes computing and communications works such as Refactoring and Patterns (Revised Edition) and Huawei Switch Learning Guide (Second Edition), alongside bilingual collector's editions such as The Little Prince (Chinese-English-French illustrated collector's edition), The Great Gatsby, and Three Days to See. Beijing Ten Years: 1980-1990 and Ghost Blade: WLOP Personal Illustration Collection reflect its presence in photography and art. Its authors include Antoine de Saint-Exupéry, Helen Keller, Joshua Kerievsky, Wang Da, Zhang Zhaozeng, and WLOP.
Contents
- 版权信息
- 内容提要
- 前言
- 第1章 数据库基础
- 1.1 数据库技术概述
- 1.1.1 什么是数据库
- 1.1.2 数据库管理系统
- 1.1.3 数据库系统
- 1.2 常用数据库管理系统
- 1.2.1 SQL Server简介
- 1.2.2 Oracle 简介
- 1.2.3 MySQL简介
- 1.3 数据库岗位需求分析
- 1.3.1 职业岗位需求分析
- 1.3.2 课程定位
- 1.4 数据库设计
- 1.4.1 关系数据库设计原则
- 1.4.2 关系规范化
- 1.5 SQL Server 2008的安装
- 1.5.1 系统要求
- 1.5.2 安装SQL Server 2008
- 1.5.3 安装示例数据库
- 1.6 使用SQL Server Management Studio(SSMS)
- 1.6.1 启动和停止SQL Server服务器
- 1.6.2 SSMS基本操作
- 1.7 配置SQL Server 2008服务
- 1.7.1 SQL Server 2008的服务组件
- 1.7.2 数据库引擎服务的控制
- 本章小结
- 本章习题
- 实验1 安装、使用SQL Server 2008
- 第2章 SQL Server 2008数据类型
- 2.1 系统数据类型
- 2.1.1 字符串数据类型
- 2.1.2 精确数字类型
- 2.1.3 近似数字类型
- 2.1.4 日期和时间数据类型
- 2.1.5 Unicode字符串
- 2.1.6 二进制字符串
- 2.1.7 其他数据类型
- 2.1.8 NULL值
- 2.2 用户自定义数据类型
- 本章小结
- 本章习题
- 第3章 数据库和表
- 3.1 创建和管理数据库
- 3.1.1 数据库简介
- 3.1.2 创建数据库
- 3.1.3 管理数据库
- 3.1.4 分离与附加数据库
- 3.2 创建和管理表
- 3.2.1 表简介
- 3.2.2 创建表
- 3.2.3 设置约束
- 3.2.4 管理表
- 3.2.5 表操作
- 3.3 数据完整性
- 3.3.1 域完整性
- 3.3.2 实体完整性
- 3.3.3 引用完整性
- 本章小结
- 本章习题
- 实验2 创建数据库和表
- 第4章 数据库的查询
- 4.1 SELECT语句结构
- 4.2 基本子句查询
- 4.2.1 SELECT子句
- 4.2.2 FROM子句
- 4.2.3 WHERE子句
- 4.2.4 ORDER BY子句
- 4.2.5 INTO子句
- 4.3 数据汇总
- 4.3.1 使用聚合函数
- 4.3.2 使用GROUP BY子句
- 4.3.3 使用HAVING子句
- 4.3.4 使用COMPUTE和COMPUTE BY子句
- 4.4 多表联接查询
- 4.4.1 联接简介
- 4.4.2 联接的类型
- 4.5 联合查询
- 4.6 嵌套查询
- 本章小结
- 本章习题
- 实验3 查询数据库
- 第5章 索引
- 5.1 索引
- 5.1.1 索引的概念
- 5.1.2 索引的建立
- 5.1.3 索引的删除
- 5.2 索引的分析与维护
- 本章小结
- 本章习题
- 实验4 创建和使用索引
- 第6章 视图
- 6.1 视图的概念
- 6.2 创建视图
- 6.2.1 使用图形化工具创建视图
- 6.2.2 使用Transact-SQL语句创建视图
- 6.3 修改视图
- 6.3.1 使用图形化工具修改视图
- 6.3.2 使用Transact-SQL语句修改视图
- 6.4 使用视图管理表中的数据
- 6.4.1 使用视图查询数据
- 6.4.2 使用视图插入、更新或删除数据
- 本章小结
- 本章习题
- 实验5 创建和使用视图
- 第7章 Transact-SQL程序设计
- 7.1 Transact-SQL基础
- 7.2 Transact-SQL要素
- 7.2.1 批处理
- 7.2.2 注释语句
- 7.2.3 标识符
- 7.2.4 全局变量与局部变量
- 7.2.5 运算符和表达式
- 7.2.6 流程控制语句
- 7.3 使用游标
- 7.3.1 游标的声明
- 7.3.2 打开和读取游标
- 7.3.3 关闭和释放游标
- 本章小结
- 本章习题
- 实验6 Transact-SQL程序设计
- 第8章 存储过程
- 8.1 存储过程简介
- 8.1.1 存储过程的优点
- 8.1.2 存储过程的类别
- 8.2 创建存储过程
- 8.2.1 使用图形化工具创建存储过程
- 8.2.2 使用Transact-SQL创建存储过程
- 8.3 执行存储过程
- 8.3.1 使用EXECUTE语句执行存储过程
- 8.3.2 使用图形化工具执行存储过程
- 8.4 修改和删除存储过程
- 8.4.1 使用图形化工具查看和修改存储过程
- 8.4.2 使用Transact-SQL查看和修改存储过程
- 本章小结
- 本章习题
- 实验7 创建和使用存储过程
- 第9章 触发器
- 9.1 触发器简介
- 9.1.1 触发器的概念
- 9.1.2 触发器的类型和触发操作
- 9.1.3 触发器的功能
- 9.2 创建触发器
- 9.2.1 使用图形化工具创建DML触发器
- 9.2.2 使用CREATE TRIGGER语句创建DML触发器
- 9.2.3 使用Transact-SQL创建DDL触发器
- 9.3 修改触发器
- 9.3.1 使用图形化工具查看和修改DML触发器
- 9.3.2 使用Transact-SQL查看和修改DML触发器
- 9.3.3 禁用或启用DML触发器
- 9.3.4 修改DDL触发器
- 9.4 删除触发器
- 9.4.1 通过图形化工具删除触发器
- 9.4.2 使用Transact-SQL删除触发器
- 本章小结
- 本章习题
- 实验8 创建触发器
- 第10章 用户自定义函数与事务
- 10.1 用户自定义函数简介
- 10.2 创建用户自定义函数
- 10.2.1 标量函数
- 10.2.2 表值函数
- 10.2.3 用户自定义聚合函数
- 10.3 事务处理
- 10.3.1 事务简介
- 10.3.2 管理事务
- 10.4 锁
- 10.4.1 锁的概念
- 10.4.2 死锁及其排除
- 本章小结
- 本章习题
- 实验9 用户自定义函数与事务
- 第11章 SQL Server 2008管理
- 11.1 安全管理
- 11.1.1 SQL Server 2008的身份验证
- 11.1.2 账户管理
- 11.1.3 角色管理
- 11.1.4 权限管理
- 11.1.5 SQL安全管理的经验
- 11.2 数据的导入导出
- 11.2.1 数据的导出
- 11.2.2 数据的导入
- 11.3 数据库备份
- 11.3.1 备份设备
- 11.3.2 备份策略
- 11.3.3 执行数据库备份
- 11.4 数据库恢复
- 本章小结
- 本章习题
- 实验10 SQL Server 2008管理
- 第12章 数据库综合开发应用
- 12.1 系统需求分析
- 12.2 系统总体设计
- 12.2.1 功能设计
- 12.2.2 建立系统对象类图
- 12.2.3 系统数据库设计
- 12.3 系统具体实现
- 12.3.1 确定系统架构及开发技术
- 12.3.2 系统数据库的实现
- 12.3.3 基于ASP.NET技术操作数据库
- 12.3.4 基于ASP.NET技术教师信息管理系统的具体实现
- 本章小结
FAQ
Is this book suitable for readers with absolutely zero background?
SQL Server versions are now much newer—is learning the 2008 edition outdated?
What are the main features of this book compared with similar introductory books?
Comments
Find this book
This site is an index: you start “Search all sources” in your browser, and the entries it lists all point to third-party sites; please judge their availability yourself.
About the author
Jiang Wenpei is an author for whom limited public information is available; what can be confirmed centers on the work published under this name, SQL Server 2008 Practical Tutorial (3rd Edition). The book is a computer science textbook that addresses the learning and application of database technology, covering the basic operations and practical skills of SQL Server 2008 and serving as a reference for classroom teaching or self-study. Judging from the book's positioning, the author took part in writing a technical tutorial aimed at beginners and general readers, with a practical and standard style that emphasizes hands-on operation of key concepts rather than theoretical exposition. Because only this one work is held in the collection and no further biographical or background material is available, the author's research field, professional position, and personal experience cannot be confirmed, so any introduction must remain centered on this textbook. As an introductory database reader, the book can support teaching in related courses and training, and it reflects the author's involvement in database application instruction or technical writing.
Wei Shanzhou is an author of computer books about whom limited public information is available. What is known is that the author's representative work is SQL Server 2008 Practical Tutorial (3rd Edition), the only title held in the collection, commonly classified under general computing. Judging from the title and category, the book is aimed at learners of database technology and uses SQL Server 2008 as its subject. It belongs to the practical tutorial genre, focusing on explaining the basic operations and everyday applications of the software rather than on theory or cutting-edge research. Tutorials of this kind usually emphasize a step-by-step approach and clear procedures, making them suitable for classroom teaching and for self-study with hands-on practice. Because no reliable records of the author's biography, nationality, position, or awards are available, any judgment about writing style or professional background can only be made cautiously from the subject matter of the work, and should not be extended further. Overall, Wei Shanzhou is known in the collection for one practical database textbook, with a contribution that lies mainly in the writing of introductory computing teaching materials.
Liang Fan is the author of Chinese computer books, though publicly available information about the author is limited: basic details such as biography, nationality, and dates of birth and death have not been clearly recorded. The library holds one work by this author, SQL Server 2008 Practical Tutorial (3rd Edition), which is classified under general computer topics. Judging from the title and edition, it is a practical textbook aimed at database learners, covering the basic operations and applications of SQL Server 2008. That it was revised and reissued suggests the content has had some continuity in teaching or self-study settings. Owing to limited materials, it is not yet possible to confirm specific features of the author's writing style or broader influence; readers may consult the book itself to learn about the author's actual approach to writing computer textbooks.
Huang Shumo is an author about whom limited public information is available; the verifiable details center on the book SQL Server 2008 Practical Tutorial (3rd Edition). Classified under general computing, the book appears from its title and edition to be a practical textbook for database learners, covering the basic operations and real-world applications of SQL Server 2008 in a tutorial format that guides readers step by step. The existence of a third edition suggests the book has been revised and updated, giving it a degree of continuity and established use in teaching. As no reliable records of the author's biography, nationality, or professional positions are available, this profile makes no speculation and describes the writing focus only from the work in the database: introductory and hands-on database technology, emphasizing practicality and readability for course use or self-study.
Nong Danhua: publicly available information is limited, and verifiable details about this author's identity and personal background are currently unavailable. Within the library, only one work is listed under this name: SQL Server 2008 Practical Tutorial (3rd Edition), classified under general computer science. It can therefore be inferred that the author is engaged in database technology or related teaching and writing, and is familiar with SQL Server 2008 installation and configuration, database design, query statements, stored procedures, and routine administration. Positioned as a practical tutorial, the book is typically aimed at university students and beginners, emphasizing step-by-step operations and hands-on examples, with plain language and a clear structure that supports learning by doing. As other background details are lacking, no further inferences are made here; readers may consult the book itself to understand the author's technical focus and teaching approach.
Wan Rongze: publicly available information is limited. He is currently known only as the author of SQL Server 2008 Practical Tutorial (3rd Edition), a work classified under general computer science. Judging from the title and edition information, it is a practical textbook for database learners, covering the basic operations and applications of SQL Server 2008 and suitable for classroom teaching or self-study. The author appears to adopt a step-by-step approach, emphasizing worked examples and the connection between concepts so that readers can build an overall understanding of database management systems. Although Wan Rongze's nationality, dates of birth and death, educational background, and professional experience are not clearly recorded, and only this one work is held in the collection, the fact that the book reached a third edition suggests a degree of continuity and demand in relevant teaching or training settings. Overall, Wan Rongze is an author whose visible output centers on computer database textbooks, with his contribution concentrated on organizing and conveying introductory and practical SQL Server teaching content.