SQL Server 2014: From Beginner to Master

Name: SQL Server 2014: From Beginner to Master
ISBN: 9787302453741

王立平 / Liu Xiangmiao / Peng JiTsinghua University Press2017

3.1

Word count: 660K words
Chapters: 20
ISBN: 9787302453741

Report an error Find this book

Summary

SQL Server 2014: From Beginner to Master is an introductory SQL Server database tutorial published by Tsinghua University Press, written by Wang Liping, Liu Xiangmiao, and Peng Ji. The book is divided into 4 parts and 20 chapters. Part 1, Fundamentals (Chapters 1–7), begins with the concepts and architecture of relational databases, then introduces the version features, installation and uninstallation of SQL Server 2014, creating and managing databases, data tables and common constraints, creating and using views, and everyday management and maintenance operations such as bringing databases online and offline, detaching and attaching, importing and exporting, backup and restore, shrinking, and generating scripts. Part 2, Core Techniques (Chapters 8–12), systematically explains T-SQL fundamentals, including data types, variables, and flow-control statements, as well as simple queries, function queries, composite queries, join queries, and subqueries, extending to data manipulation and the implementation of stored procedures and triggers. Part 3, Advanced Applications (Chapters 13–18), covers index operations and maintenance, the use of cursors, and the concept and application of transactions, while also introducing common functions supported by SQL Server 2014 and briefly touching on database performance optimization and the impact of cloud computing and big data on database technology. Part 4, Database in Practice (Chapters 19–20), uses two case studies—an enterprise ERP management system and a personnel management system—to demonstrate the complete process from requirements analysis and database design to system development and deployment. The book integrates over a hundred everyday database management examples, each with illustrated step-by-step implementation and analysis, and provides comments and common-pitfall tips for key code, aiming to let readers learn by doing and master the practical operation of SQL Server 2014.

Editor's review

这是一本“讲得全、也讲得实”的 SQL Server 入门书。全书按“基础知识—核心技术—高级应用—项目实战”四段递进，先把关系数据库的底层概念和 SQL Server 2014 的安装配置讲透，再顺着建库、建表、约束、视图一路推进到 T-SQL 查询、存储过程与触发器，最后落到索引、游标、事务与性能优化，知识链条几乎没有断点。对初学者最友好的一点是案例密度：上百个日常管理数据库的小实例，配图文步骤和逐条解析，遇到容易出错的地方还会单独提示，照着做就能跑通。第19、20章的两个综合项目（ERP 管理系统、人事管理系统）把前面零散的知识点串成完整开发流程，能帮读者建立“数据库如何服务于应用系统”的整体认知。此外，本书还专门辟出章节谈云计算、大数据与数据库的关系，视野不局限于单机操作。适合当作零基础自学的第一本系统教材，也适合作为培训学校与大中专院校的课程用书。需要提醒的是，书中以 SQL Server 2014 为准，新版本界面与语法细节略有差异，学习时以原理与思路为主。

Who it's for

A good fit for

完全没有数据库基础、希望从零系统学习 SQL Server 的读者
在校计算机、信息管理相关专业学生及培训学校学员
需要补强 T-SQL 查询与存储过程能力的初级开发人员
负责数据库日常维护、想系统梳理运维知识的初级 DBA

Not a good fit for

已具备多年 SQL Server 运维经验、希望专攻高可用与集群的资深 DBA
需要学习 PostgreSQL、MySQL 等其他数据库系统的读者
只想查阅语法速查手册、不打算跟做实例的读者

Reading tips

建议配合实际 SQL Server 2014 环境边读边练，每章的小结和实例至少亲手执行一遍。
第二篇 T-SQL 部分是全书重点，可放慢速度，把简单查询、连接查询与子查询彻底吃透。
第19、20章的两个综合案例最好等前面章节全部动手完成后，再独立复现一遍。
本书以 2014 版本为准，若使用更新版本，注意安装向导、部分界面与语法细节的差异，以原理为主。

About the publisher

Tsinghua University Press China · Founded in 1980

Founded in 1980, Tsinghua University Press has 57 titles in our collection, covering popular science, medicine, health, law, philosophy and social sciences. Representative works include medical popular-science books such as Cancer Truth: Doctors Are Reading It Too and New Knowledge on Cancer by Bo Luo (Li Zhizhong), legal titles such as Sunshine Is the Best Preservative: Express Delivery of Major Global Anti-Corruption Cases, and works like Qi Ge's A Brief History of Philosophy with Big Ideas and Liu Yunhao's From the Internet to a New Industrial Revolution. Its authors include science writers, medical researchers, the Renmin University of China anti-corruption master's class and university scholars, reflecting a publishing profile that balances academic seriousness with accessible reading. As public information is limited, this profile is based only on the titles in our collection.

Chapter 1 Introduction to Databases
Chapter 2 Getting Started with SQL Server 2014
Chapter 3 Creating Databases
Chapter 4 Working with Data Tables
Chapter 5 Working with Views
Chapter 6 SQL Server 2014 Database Management
Chapter 7 SQL Server 2014 System Maintenance
Chapter 8 Fundamentals of T-SQL (Including Flow-Control Statements and Common Commands)
Chapter 9 SQL Data Queries
Chapter 10 SQL Data Manipulation
Chapter 11 Stored Procedures
Chapter 12 Triggers
Chapter 13 Indexes
Chapter 14 Cursors
Chapter 15 SQL Functions
Chapter 16 Transactions
Chapter 17 Database Performance Optimization
Chapter 18 Cloud Computing, Big Data, and Databases
Chapter 19 Enterprise ERP Management System
Chapter 20 Personnel Management System

FAQ

这本书适合零基础的人自学吗？

适合。全书从数据库系统和关系模型的基本概念讲起，再进入 SQL Server 2014 的安装、建库、建表，例子配有图文步骤和解析，作者在编写说明中也明确以没有任何数据库学习经历的初学者为主要读者之一。

书中的实例有配套源码吗？

有。出版社在前言中给出了示例数据库和第19、20章两个综合案例压缩包的下载地址，读者可按书首说明获取源码，配合书中步骤练习。

现在学 SQL Server 2014 会不会太旧？

书中讲解的建库建表、T-SQL 查询、视图、存储过程、触发器、索引与事务等核心知识在各版本间基本通用，作为入门打基础依然有效；但安装界面、部分新特性和性能优化细节需结合当前版本另外补充。

全书共多少章、内容如何划分？

全书共 20 章，分为基础知识篇（第1—7章）、核心技术篇（第8—12章）、高级应用篇（第13—18章）和数据库实战篇（第19—20章）四个部分，从概念入门逐步过渡到项目开发部署。

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

Wang Liping is an author about whom limited public information is available. His works mainly span two fields: the compilation of lyric documents and research on academic Chinese. In the area of lyrics, he participated in compiling the multi-volume A Century of Yuefu: A Chronological Anthology of Modern and Contemporary Chinese Lyrics, which systematically arranges Chinese lyrics of the modern and contemporary periods in chronological order and provides primary sources for studying the development of lyric writing and cultural change over time. In language research, he is the author of the Academic Chinese Research Series: Chinese Academic Discourse and Its Teaching Research, a specialized work on the linguistic features of academic discourse and related teaching issues. Available sources do not record his nationality, dates of birth and death, or personal experience, so his biography cannot be described in detail. Judging from his five works in the database, Wang Liping's writing combines documentary compilation with academic research, with topics leaning toward material accumulation and language teaching, and his output has certain reference value.