SQL Server 2019 Database Application Course
Tags
Summary
Editor's review
The book's most prominent feature is its strong integration of theory and practice. Each technical point is accompanied by corresponding operation examples and exercises, and this "practice immediately after learning" arrangement is particularly suited to mastering skill-based knowledge. Although the book does not cover cutting-edge cloud-native or big data integration content, as an introductory tutorial to traditional relational databases, its explanations of core modules such as index optimization, transaction processing, and security management are solid and systematic.
In terms of content depth, the book is better suited as a first SQL Server textbook for vocational college students or self-learners. The author makes complex concepts more accessible, for example by explaining database normalization through analogies and illustrating query execution with flowcharts, lowering the learning threshold. However, for readers who already have a database foundation, some basic chapters may seem redundant.
It is worth noting that the book is clearly practice-oriented, and readers are advised to operate synchronously in a SQL Server environment while reading. Although the introduction to the new features of the 2019 version is limited in length, it captures the most practical parts, such as intelligent query processing, reflecting the textbook's consideration of timeliness.
Who it's for
A good fit for
- Vocational college or lower-year undergraduate students majoring in computer-related fields
- IT professionals transitioning careers who need to systematically learn SQL Server
- Working professionals engaged in data processing but lacking database system knowledge
- Self-learners who wish to master the fundamentals of enterprise-level database management
Not a good fit for
- Database administrators who have already mastered SQL Server and are seeking advanced optimization techniques
- Developers who need to learn cutting-edge technologies such as NoSQL and distributed databases
Reading tips
- It is recommended to read in chapter order, focusing on mastering the core SQL syntax in Chapters 3–5
- Exercises at the end of each chapter should be completed in practice; you can install SQL Server 2019 Developer Edition locally for practice
- While reading, consider real work scenarios and how the book's table design and query optimization methods can be applied to specific projects
About the publisher
Chongqing University Press is a comprehensive university press whose publishing areas span social and cultural studies, industrial technology, finance and economics, medicine, social psychology, and theory. Judging from its catalog, the press publishes both academic works and popular science titles. Representative books include E. H. Gombrich's Shadows: The Depiction of Cast Shadows in Western Art, Magnesium-Based Hydrogen Storage Materials by Pan Fusheng et al., Research on China's Regional Spatial Development Models by Sun Jiuwen, and titles from the Gynecologic Oncology Committee of the Chinese Anti-Cancer Association, such as the Guidelines for Diagnosis and Treatment of Common Gynecologic Malignancies in China (2019) and Bipolar Disorder: What You and Your Family Need to Know. Its authors work in art history, materials science, regional economics, clinical medicine, and social research methods. Public information is limited, but its publishing profile combines academic translation, industrial technology, and practical medical guides.
Contents
- 版权信息
- 第1章 数据库基础知识
- 1.1 计算机数据管理技术的发展
- 1.2 数据库系统概述
- 1.3 数据模型
- 本章小结
- 第2章 关系数据库基础
- 2.1 关系模型概述
- 2.2 关系数据结构
- 2.3 关系的完整性
- 2.4 关系代数
- 2.5 E⁃R模型到关系模型的转换
- 本章小结
- 第3章 关系数据库规范化理论
- 3.1 规范化问题的提出
- 3.2 函数依赖
- 3.3 范式与关系模式的规范化
- 3.4 数据依赖的公理系统
- 3.5 关系模式的分解
- 本章小结
- 第4章 SQLServer2019基础
- 4.1 SQL Server 2019 简介
- 4.2 SQL Server 2019 的安装
- 4.3 SQL Server 2019 管理工具
- 4.4 SSMS的使用方法
- 4.5 SQL Server 2019 数据库种类及文件
- 4.6 SQL Server的命名规则
- 本章小结
- 第5章 SQLServer数据库建立及操作
- 5.1 SQL Server数据库基本操作
- 5.2 数据类型
- 5.3 创建数据库表
- 5.4 表的基本操作
- 5.5 数据库的完整性
- 5.6 数据库关系图
- 本章小结
- 第6章 结构化查询语言SQL
- 6.1 SQL简介
- 6.2 数据查询
- 6.3 数据操纵
- 6.4 SQL数据定义
- 本章小结
- 第7章 索引与视图
- 7.1 索引
- 7.2 视图
- 本章小结
- 第8章 T⁃SQL程序设计
- 8.1 T⁃SQL简介
- 8.2 常量与变量
- 8.3 表达式与运算符
- 8.4 SQL Server函数
- 8.5 流程控制
- 8.6 程序中的批处理
- 8.7 存储过程
- 8.8 触发器
- 本章小结
- 第9章 数据库应用系统开发与设计
- 9.1 软件平台
- 9.2 数据库设计
- 9.3 数据库与数据表创建
- 9.4 应用系统设计与实现
- 9.5 系统调试运行
- 本章小结
- 参考文献
FAQ
How much database background does this book require?
Is the content in the book outdated?
What level can I reach by self-studying 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
Jiang Hui is an author about whom limited public information is currently available, and his identity and background remain unclear. Judging from the three works included in the library—Management Information Systems, SQL Server 2019 Database Application Tutorial, and The Rules of Short Video Operations—his writing spans several fields, including management, computing, and new media operations. These works fall under categories such as management, general computing, and software learning, indicating that he focuses on information system development, the practical application of database technology, and methods for operating short video platforms. Overall, Jiang Hui's writing emphasizes practical operation and knowledge popularization, targeting readers who need to master relevant tools and methods, and offering introductory and reference content in management informatization, database learning, and new media content operations. Because verifiable material is scarce, further details about his personal experience and professional background cannot yet be provided.
Liu Jinmei is an author of Chinese computer books, and publicly available information about the author is limited. To date, one work is known: SQL Server 2019 Database Application Tutorial. The book falls under the general computing category and focuses on the practical application of SQL Server 2019, aimed at students or technical readers who need to learn database fundamentals and operations; its content emphasizes application rather than theoretical exposition. Based on the available information, Liu Jinmei's writing consists mainly of tutorial-style, practical technical books with plain language and a clear structure, suitable for classroom teaching or self-study. Because no reliable public information is available on the author's biography, affiliation, or research focus, no inferences are made here; readers may consult the book's specific chapters to understand the author's approach and professional emphasis.
Yang Huizhu is an author about whom limited public information is available. What can be confirmed is that Yang is a writer of computer books, with one work held in this catalog: SQL Server 2019 Database Application Tutorial, classified on this site under general computing. Judging from the title and category, Yang's writing focuses on database technology and its teaching applications, centering on the specific version SQL Server 2019 and aimed at readers who need to learn database operations and applications systematically. Because information on the author's biography, professional background, and institutional affiliation is lacking, it is difficult to introduce Yang's academic experience or field of work further, nor is it possible to determine whether Yang has other publications. Based on the available work, the book reflects an inclination toward organizing and teaching database software operations, with content emphasizing practical skills and version-specific features, making it suitable as an introductory and classroom reference. Readers considering this work may regard Yang as one of the authors of textbooks on database applications, while the writing style and scope of influence still require more material for a fuller assessment.
Yin Qian is a Chinese-language book author about whom limited public information is available. Only one of her works is currently included in the library: SQL Server 2019 Database Application Tutorial. Judging from the title and its common classification, the book is a computer science textbook that focuses on the practical use of SQL Server 2019 and is intended for readers who need to learn database fundamentals and operations. Because public information is limited, Yin Qian's nationality, dates of birth and death, educational background, and professional positions cannot be confirmed, and no English name has been recorded. Based on the available evidence, her writing follows a technical textbook approach, organizing the application methods of database software into tutorial content suitable for teaching and self-study. Such works typically serve university courses or vocational training, emphasizing operational steps and a complete knowledge framework. Readers who wish to learn the basic use of SQL Server 2019 through a textbook may consider this book as an introductory reference; further details about the author's other experience and achievements await additional public information.
