Database Principles and Applications (SQL Server Edition) (Second Edition)

Name: Database Principles and Applications (SQL Server Edition) (Second Edition)
ISBN: 9787301282625

毛一梅 / 郭红Aug 2025

3.4

Word count: 163K words
Chapters: 99
ISBN: 9787301282625

Report an error Find this book

Summary

This book introduces database principles and, through the concrete use of Microsoft SQL Server 2012, explains the relevant knowledge of database technology in detail. In terms of overall structure, the book is divided into two major parts and 11 chapters. Part One is the Fundamentals section, comprising Chapters 1–7, and mainly introduces the basic concepts of databases, relational database theory, and the basic operation methods of the typical relational database Microsoft SQL Server 2012. Part Two is the Applications section, comprising Chapters 8–11, and mainly introduces the specific applications and practical techniques of Microsoft SQL Server 2012. The book's distinguishing feature is the close integration of theory and practice; each chapter contains numerous application examples for readers to study and improve with. This book is suitable as a textbook for undergraduate database-related courses, and can also be used by beginner- and intermediate-level readers of database technology for self-study.

Editor's review

This book teaches relational database theory and hands-on SQL Server 2012 operation along a single thread: the Fundamentals section first establishes concepts and the relational model, while the Applications section then moves on to specific techniques and practical development. The structure is clear and avoids the disconnected feel of many textbooks, where theory and operation are taught as separate tracks. Each chapter provides numerous application examples, so readers can grasp abstract content such as normal forms, queries, and transactions through hands-on practice rather than merely memorizing definitions. The second edition retains the complete framework of two major parts and eleven chapters, making it suitable for pacing across a semester. For classroom teaching, it helps instructors arrange labs chapter by chapter; for self-learners, the density of examples supports learning while practicing. Note that the specific environment is based on SQL Server 2012, which is rather old; readers practicing on newer versions may encounter differences in interface and syntax details, and should focus on principles and ideas rather than tool operations. Overall, it is better suited as a systematic introductory and course-companion book than as a quick-reference manual.

Who it's for

A good fit for

Undergraduate students in computer science and related majors who need a database course textbook with accompanying labs
Information management students who want to combine relational theory with SQL Server operations
Beginner readers in database technology who need example-rich, step-by-step self-study material
University instructors looking for a teaching book with a complete chapter structure and decomposable cases

Not a good fit for

Readers seeking the latest SQL Server version features and cloud database content
Practitioners with extensive database experience seeking performance tuning and advanced architecture
Quick-reference readers who only want to look up syntax commands and are unwilling to study theory systematically

Reading tips

Read Chapters 1–3 of the Fundamentals section first to build concepts of the relational model, then move on to the SQL Server operation chapters and learn while practicing.
Work through the examples in each chapter hands-on in a local or lab environment, focusing on how query results correspond to theoretical definitions.
When studying the Applications section, connect knowledge points through the end-of-chapter cases; try designing on your own first, then compare with the book's implementation.
When encountering interface differences between old and new versions, note the differences and focus on understanding the principles rather than getting stuck on tool details.

版权信息
内容简介
第2版前言
第1篇导入篇
第1章绪论
1.1 数据库系统概述
1.2 数据管理技术的产生和发展
1.3 数据库的模式结构
1.4 数据库模型
本章小结
习题1
第2章关系数据理论
2.1 关系的数学定义
2.2 关系代数
2.3 关系的完整性
2.4 关系的规范化
2.5 案例分析
本章小结
习题2
第2篇基础篇
第3章 SQL Server 2012基础
3.1 SQL Server2012 的新特点
3.2 SQL Server2012 的安装与配置
3.3 SQL Server2012 系统数据库
3.4 SQL Server2012 的启动方式
3.5 SQL Server2012 与旧版文件的兼容性操作
3.6 SQL Server2012 管理控制器
3.7 疑难分析
本章小结
习题3
第4章数据库的管理
4.1 用户数据库的创建与管理
4.2 数据的导入与导出
4.3 用户数据库的分离与附加
4.4 实验指导
本章小结
习题4
第5章数据表的管理
5.1 SQL Server2012 的数据类型
5.2 表结构的创建与修改
5.3 表数据的约束
5.4 表数据的操作
5.5 索引操作
5.6 实验指导
本章小结
习题5
第6章数据查询
6.1 基本的SELECT查询
6.2 条件查询
6.3 排序查询
6.4 分组查询
6.5 筛选查询
6.6 联结查询
6.7 嵌套查询
6.8 实验指导
本章小结
习题6
第7章视图
7.1 基本概念
7.2 视图的创建
7.3 视图的查询
7.4 视图的修改
7.5 疑难分析
7.6 实验指导
本章小结
习题7
第8章数据的安全性
8.1 数据库的安全性机制
8.2 SQL Server 的安全策略
8.3 权限管理
8.4 角色管理
8.5 数据的备份与还原
8.6 疑难分析
8.7 实验指导
本章小结
习题8
第3篇应用篇
第9章数据库编程
9.1 T-SQL 概述
9.2 T-SQL 基础
9.3 T-SQL 编程
9.4 事务
9.5 存储过程
9.6 触发器
9.7 实验指导
本章小结
习题9
第10章数据库设计
10.1 数据库设计概述
10.2 需求分析
10.3 概念结构设计
10.4 逻辑结构设计
10.5 物理结构设计
10.6 数据库的实施
10.7 数据库的运行和维护
10.8 综合案例
本章小结
习题10
参考文献

FAQ

Can the SQL Server 2012 content in this book still be used on newer versions?

Core SQL syntax, relational theory, queries, transactions, and similar content are largely universal in newer versions and can be studied normally. The main differences lie in the layout of management tools, some wizard workflows, and a few version-specific features. It is advisable to follow the book's principles and statements as the main line; when practicing in a newer environment and encountering interface differences, prioritize understanding the purpose of the operation rather than memorizing click steps.

Can I read this book directly without any database background?

Yes. The Fundamentals section starts from basic database concepts and relational database theory, making it suitable for zero-background readers to progress chapter by chapter. However, it is advisable not to skip the theory and jump straight to operations; otherwise, you may only learn to click buttons without understanding the underlying relational model and query logic. Hands-on practice with each chapter's examples will make the introduction more solid.

Is this book suitable as exam preparation or course review material?

It is more suitable as a course-companion textbook, with a complete chapter system and many examples that facilitate reviewing concepts and operations alongside classroom progress. However, it is not a dedicated exercise book or exam-point memorization manual. For exam cramming, it is advisable to use past papers and outlines alongside it, treating the theory chapters as a foundation for organizing concepts and the operation chapters as aids to understanding.

When self-studying, should I read the theory first or start with hands-on operations?

Alternating is recommended: first read the concepts and relational theory in the Fundamentals section to form a basic understanding of tables, keys, normal forms, and queries, then move on to the SQL Server operation chapters and use examples to verify the theory. After learning each operation topic, return to the theory chapters to compare and understand; this is more effective than one-way reading or pure operation practice, and makes it easier to remember.

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

毛一梅 Author

Mao Yimei: publicly available information about this author is currently limited, and their identity and background have not yet been clearly established in the existing materials. The database contains one work by this author, namely Database Principles and Applications (SQL Server Edition) (2nd Edition), commonly classified under exam preparation. Judging from the subject matter, the book is a teaching text on database principles and SQL Server applications, covering basic database theory and practical operations in the SQL Server environment, and is intended for course study and exam preparation. The author undertook the writing of this book, and the writing style emphasizes combining principle explanations with hands-on practice, making it suitable for use as a textbook or exam study aid. Because public information is insufficient, the author's nationality, dates of birth and death, educational background, institutional affiliation, and other works cannot currently be confirmed. This introduction is compiled solely from facts available in the database and may be further supplemented and improved as more information becomes available.

郭红 Author

Guo Hong is an author about whom limited public information is available. The only confirmed work under this name is Database Principles and Applications (SQL Server Edition), 2nd Edition. The book is a database technology textbook that explains database principles and practical applications in the SQL Server environment. It is commonly classified as an exam-preparation title, suggesting that its writing emphasizes a structured knowledge framework and the needs of test preparation. Because only this one work is included in the database and basic biographical details such as nationality, dates of birth and death, and professional background are unavailable, no further account of the author's life can be given at present. Based on the available work, Guo Hong's writing focuses on technical textbooks, covering both the fundamentals of database theory and hands-on practice, with clear language intended for teaching and suitable as a reference for course study or exam review.