SQL Server 2008 Database Application Technology cover

SQL Server 2008 Database Application Technology

Rating 3.3
Word count
132K words
Chapters
95
ISBN
9787115491008

Tags

Summary

The book consists of 13 chapters, with case studies running through as the main thread to explain SQL Server 2008. The teaching content is organized around cases and projects. Cases run throughout the entire book's content arrangement: a real development case is used to organize the learning content, and in the final chapter, a real project is used to summarize and review the entire book.

Editor's review

As a textbook for beginners in database technology and applications, SQL Server 2008 Database Application Technology has a clear positioning, and its content arrangement reflects accumulated teaching practice. The author, Zhang Suqing, has frontline teaching experience, which makes the book present knowledge points in a step-by-step manner, covering everything from basic database concepts and T-SQL language to database management and maintenance in a complete structure. For readers who use SQL Server 2008 as the specific environment to learn database principles and operations, this book provides a solid practical path. The book contains numerous examples and exercises, which help consolidate learning. It should be noted that, as a textbook published in a particular technological period, its core value lies in explaining relatively stable database fundamentals and operational paradigms, knowledge that has a long shelf life. For readers who wish to gain a deeper understanding of relational database design, master the basics of T-SQL programming, and practice in a specific database management system, this book is a reliable stepping stone. When reading it in the current technological environment, readers can focus on absorbing its methodology and core principles, while being aware that some management tools and peripheral features may have been updated with version iterations.

Who it's for

A good fit for

  • Students majoring in computer-related fields at higher education institutions who are currently taking database courses
  • IT beginners who need to systematically learn SQL Server 2008 operations and management
  • Practitioners engaged in database management or development who wish to solidify their foundational knowledge
  • Enthusiasts interested in relational database principles who want to practice with a specific database system

Not a good fit for

  • Senior engineers seeking cutting-edge features and best practices of the latest SQL Server versions (such as 2022)
  • Developers who only need to quickly look up SQL syntax or solve specific advanced technical problems

Reading tips

  1. It is recommended to study in chapter order, paying particular attention to the foundational theory in the early chapters on database design normal forms and the E-R model
  2. For the sample code in each chapter, be sure to practice hands-on in an installed SQL Server 2008 or higher compatible environment
  3. Use the end-of-chapter exercises as periodic knowledge checks, and try to apply what you learn to the design of a simple personal project

About the publisher

Posts & Telecom Press China · Founded in 1953

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. 版权信息
  2. 内容提要
  3. 前言
  4. 第1章 数据库系统概述
  5. 1.1 数据库技术的基本概念
  6. 1.2 数据库系统的基本特点
  7. 1.3 常见的数据库
  8. 1.4 数据模型
  9. 1.5 关系数据库
  10. 1.6 数据库设计
  11. 1.7 数据库设计的实例
  12. 本章小结
  13. 实训项目
  14. 第2章 SQL Server 2008概述
  15. 2.1 SQL Server 2008简介
  16. 2.2 SQL Server 2008的安装
  17. 2.3 SQL Server的管理工具
  18. 本章小结
  19. 实训项目
  20. 第3章 数据库管理
  21. 3.1 SQL Server 2008数据库概述
  22. 3.2 创建数据库
  23. 3.3 管理数据库
  24. 本章小结
  25. 实训项目
  26. 第4章 数据库表的管理
  27. 4.1 表相关的几个概念
  28. 4.2 设计表
  29. 4.3 创建表
  30. 4.4 表的管理和维护
  31. 4.5 表数据的添加、修改和删除
  32. 4.6 导入和导出数据
  33. 本章小结
  34. 实训项目
  35. 第5章 数据查询
  36. 5.1 SELECT语句
  37. 5.2 简单SELECT语句
  38. 5.3 SELECT语句的统计功能
  39. 5.4 多表连接查询
  40. 5.5 合并结果集
  41. 5.6 子查询
  42. 本章小结
  43. 实训项目
  44. 第6章 视图和索引
  45. 6.1 视图的概述
  46. 6.2 定义视图
  47. 6.3 视图的维护
  48. 6.4 通过视图操纵表数据
  49. 6.5 索引
  50. 本章小结
  51. 实训项目
  52. 第7章 Transact-SQL编程
  53. 7.1 批处理
  54. 7.2 注释
  55. 7.3 常量和变量
  56. 7.4 运算符和表达式
  57. 7.5 函数
  58. 7.6 流程控制语句
  59. 7.7 用户自定义函数
  60. 本章小结
  61. 实训项目
  62. 第8章 存储过程
  63. 8.1 存储过程概述
  64. 8.2 创建和执行存储过程
  65. 8.3 管理存储过程
  66. 本章小结
  67. 实训项目
  68. 第9章 触发器
  69. 9.1 触发器概述
  70. 9.2 创建和应用触发器
  71. 9.3 管理触发器
  72. 本章小结
  73. 实训项目
  74. 第10章 Transact-SQL高级应用
  75. 10.1 事务
  76. 10.2 游标
  77. 本章小结
  78. 实训项目
  79. 第11章 安全管理
  80. 11.1 安全管理结构
  81. 11.2 服务器安全管理
  82. 11.3 数据库安全管理
  83. 11.4 权限管理
  84. 本章小结
  85. 实训项目
  86. 第12章 数据库的备份和恢复
  87. 12.1 备份与恢复的基本概念
  88. 12.2 备份数据库
  89. 12.3 恢复数据库
  90. 12.4 建立自动备份的维护计划
  91. 本章小结
  92. 实训项目
  93. 第13章 综合项目案例
  94. 13.1 案例分析
  95. 13.2 项目设计

FAQ

Is this book suitable for readers with absolutely no background?
This book is positioned as a textbook and assumes readers have basic computer operation knowledge, but it is suitable for those with zero database background. It starts from basic database concepts and proceeds step by step.
Do I need to install SQL Server 2008 in advance to study this book?
Installation is strongly recommended. This book is a highly practical technical textbook, and most of the knowledge needs to be mastered through hands-on operation. SQL Server 2008 Express or a higher compatible version will work.
Is the knowledge in the book outdated in the latest versions of SQL Server?
Most of the content, such as core database principles, basic T-SQL syntax, and database design concepts, is not outdated and is highly universal. The main differences lie in some graphical management tool interfaces, certain advanced management features, and performance optimization features, which can be supplemented through official documentation after mastering the basics in this book.

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

Zhang Suqing, about whom limited public information is available, focuses her writing on the teaching and application of database technology. Judging from the two works held in the library, MySQL Database Technology and Applications and SQL Server 2008 Database Application Technology, the author attends to the fundamentals and practical operation of mainstream relational database management systems. The topics fit the teaching needs of computer-related courses in higher education and are also suitable as introductory reading for beginners and as reference material for practitioners. The two works cover MySQL and SQL Server, two common database platforms, reflecting an approach that addresses different technical paths in organizing database course content. Overall, the writing emphasizes clear explanation of technical concepts combined with hands-on practice, in a textbook-style, systematic manner. Since no reliable records are available on birth and death dates, nationality, education, or professional positions, no speculation is made here; the portrait is based solely on the existing works, for readers' reference.

王利 Author

Wang Li: publicly available information about this author is limited, and what can be confirmed comes chiefly from the two works held in the library catalog. The range of these works spans social psychology and computer technology, indicating a relatively uncommon cross-disciplinary writing interest. "FBI Psychological Profiling Techniques" is aimed at general readers and explores the subject of psychological analysis, placing it within popular writing on social psychology. "SQL Server 2008 Database Application Technology" addresses the study and practical use of database technology, reflecting a technical and applied side to the author's writing. Although the two books target quite different readerships, both are oriented toward conveying knowledge and supporting practical application. As no reliable records are available for birth and death dates, nationality, education, or professional career, this note makes no speculation and offers only a brief account of the subject matter and writing orientation of the existing works, leaving further personal details to be supplied later.

茹兴旺 Author

Ru Xingwang: publicly available information is limited, and at present it is known only that he has one work, SQL Server 2008 Database Application Technology, commonly classified under general computer science. Judging from the title and classification, the book addresses the study and application of database technology, centering on SQL Server 2008, a relational database management system, and belongs to the teaching or technical-practice strand of computer writing. The author has left little verifiable information in this field, making it difficult to outline his life, professional background, or full body of work, and it is not possible to confirm his education, positions, or institutional affiliations. On the evidence available, Ru Xingwang's writing tends toward practical technical knowledge, likely aimed at students learning database operations or technical staff doing related work. His output is small, and the reach of his work awaits more public information; assessments should rest mainly on this known book rather than on speculation about his life.

方跃胜 Author

Fang Yuesheng is the author of Chinese books on computer technology. Public information about the author is limited, and the only confirmed work is SQL Server 2008 Database Application Technology, which is classified under the general computer category. Judging from the title and subject matter, the writing focuses on the basic applications and operational practices of a database management system, aimed at readers who need to learn how to use SQL Server 2008, with an orientation toward technical introductions and practical guidance. Because only this one work is included in the collection, it is not yet possible to assess the author's full body of writing, stylistic development, or other professional background. Based on the available information, Fang Yuesheng's work centers on the applied technology of a specific software version and falls within the scope of computer teaching materials and reference books, suitable as a resource for understanding the basic functions of that database platform.

降华 Author

Jiang Hua is an author of Chinese computer books, about whom publicly available information is limited; no clear record of his or her life, nationality, or educational background has been found. As far as the library's holdings show, Jiang Hua currently has only one work, SQL Server 2008 Database Application Technology, which is classified under general computer topics. The book focuses on the practical application of SQL Server 2008 and is a technical title aimed at database management and development. Judging from the subject matter, Jiang Hua's writing emphasizes the operational and applied aspects of database technology and serves readers who need to master the basic use of SQL Server. Because verifiable information is very limited, it is difficult to make a full assessment of the overall character of Jiang Hua's writing style, and no other works or long-term writing direction can be confirmed. The available material can only show that Jiang Hua has contributed one practical work in the field of popular computer technology publishing, whose influence lies mainly in its reference use by readers of introductory database and technical application books.

邓小飞 Author

Deng Xiaofei is an author about whom limited public information is available. Judging from the existing works, his writing focuses on computer technology application and development books, with representative titles including HTML5+CSS3 Development in Practice and SQL Server 2008 Database Application Technology. These two books address front-end web development and database applications respectively, indicating that the author attends to the practical operation and project implementation of specific technical tools rather than general theoretical exposition. Books of this kind are usually aimed at university students and beginning developers, emphasizing step-by-step exercises and understanding concepts through hands-on practice. Classified under general computing, the works also reflect a combination of front-end and back-end fundamentals, making them suitable as course companions or self-study references. Because the available information is limited, the author's personal background, professional experience, and other aspects of his writing style cannot be confirmed; readers may learn more about his editorial approach and scope by consulting the two works mentioned above.

张超 Author

Zhang Chao is a Chinese book author whose works span a notably wide range of subjects. Public information about him is limited, and details of his life remain unclear. The collection includes 24 of his titles, covering categories such as photography, software learning, popular science, personal growth, programming and design, and law. Representative works include popular science and photography books such as A Cloud a Day and Starlight Collector: A Brief History of Small Astronomical Telescopes, technical hands-on titles such as Circuit Simulation with Multisim and Elasticsearch Source Code Analysis and Optimization in Practice, as well as growth-oriented themes in Networking Is Designed and legal practice content in Equity Structure Design. His writing is generally practical and accessible, focused on turning specialized knowledge into actionable introductory guidance.

More by the same author

Top rated in the same category