SQL Server Database Practical Tutorial

Name: SQL Server Database Practical Tutorial
ISBN: 9787113309404

王雪梅 / 李海晨China Railway Publishing House · ChinaDec 2025

3.2

Word count: 51K words
Chapters: 80
ISBN: 9787113309404

Report an error Find this book

Summary

This book is one of the textbooks in the Emerging Engineering Information Technology Course Series for Higher Education. Emphasizing hands-on practice, it takes operations as the main thread, guiding readers from database creation step by step through table creation and management, data insert/delete/update/query, view creation and use, and introduces database security knowledge.

The book covers related concepts, graphical interface database operations, data definition, data insertion, data query, views, and database security.

Alongside theoretical explanations, the book provides operation demonstration videos, and uses a complete sales management database throughout the lab tasks in Chapters 3–6. It is suitable as a textbook for non-computer majors in higher education institutions, and can also be used by database developers for self-study.

Editor's review

This book takes hands-on practice as its main thread, progressing from database creation to table management, data insert/delete/update/query, view usage, and database security, making it suitable as an introductory textbook for non-computer majors. Its most distinctive feature is the use of a complete sales management database throughout the lab tasks in Chapters 3 to 6, giving the operation exercises across chapters a continuous business context and avoiding fragmented knowledge points. The book includes operation demonstration videos that provide intuitive references for graphical interface operations and SQL statement execution, lowering the entry barrier for beginners. Readers can complete each chapter's lab tasks within the same database environment, gradually building an overall understanding of database structure and data flow. For classroom teaching, the chapter arrangement and lab tasks make it easy for instructors to organize hands-on sessions; for self-study readers, the sales management database case also provides a complete object for repeated practice. It should be noted that this book is positioned as a practical tutorial with relatively concise theoretical exposition; readers seeking deeper understanding of the relational model, normalization theory, and similar topics should supplement with other textbooks.

Who it's for

A good fit for

Non-computer major students in higher education institutions who need to complete database course study and hands-on labs
Database development beginners who wish to gradually familiarize themselves with SQL Server through graphical interface operations
Beginners who need to practice table creation, queries, views, and other operations with a complete case study
Instructors teaching basic database courses who need reference lab tasks

Not a good fit for

Readers seeking in-depth study of relational database theory, normalization, and query optimization
Those with considerable database development experience seeking advanced management and performance tuning content
Readers who wish to learn other database products rather than SQL Server

Reading tips

Follow the chapter order to create the sales management database and tables, then proceed to the lab tasks in Chapters 3 to 6
Watch the accompanying demonstration video before each chapter's operations, then independently implement each operation in both the graphical interface and SQL statements
Practice insert/delete/update/query and view operations together within the same sales management database to form an overall understanding
After completing the book, try adding indexes or permission settings to the database to test mastery of database security

About the publisher

China Railway Publishing House China · Founded in 1951

China Railway Publishing House has long centered on railway professional publishing while also covering rail transit, industrial technology, programming and design, finance and economics, and exam preparation, with about 194 relevant titles in the collection. Representative books include the Automated Operation (FAO) System for Urban Rail Transit, Design Innovation and Practice for Urban Rail Transit Vehicle Depots, Analysis and Application Management of the Level-One Maintenance Inspection Robot System for Electric Multiple Units, as well as engineering practice titles such as the Engineering Summary of the Guangdong Section of the Ganzhou–Shenzhen Railway and Safety Risk Control Technology and Typical Cases of Shield Tunneling in Beijing Urban Rail Transit Construction. Beyond technical monographs, the publisher also offers practical titles such as Python Programming Fundamentals and tax and accounting treatment for real estate development enterprises, with authors including He Peng, Tang Tao, Ding Shukui, and Sun Changjun. Based on public information, its publishing strength lies in drawing on line engineering and operational practice while balancing professional textbooks and general-audience titles; more complete details of its publishing structure are limited in public sources.

版权信息
内容简介
前言
第1章相关概念
第2章图形界面操作数据库
2.1 创建和管理数据库
2.1.1 创建数据库
2.1.2 修改数据库
2.1.3 删除数据库
2.1.4 打开数据库
2.1.5 分离数据库
2.1.6 附加数据库
2.2 创建和管理表
2.2.1 创建表
2.2.2 修改表
2.2.3 删除表
2.3 插入、修改、删除数据
2.4 查询数据
实验1 SSMS图形界面创建数据库和学生表
实验2 SSMS图形界面管理数据库和课程表、成绩表
习题
第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 数据定义
习题
第4章数据更新
4.1 插入数据
4.2 修改数据
4.3 删除数据
实验4 数据更新
习题
第5章数据查询
5.1查询数据语法
5.2 数据准备
5.3 单表数据
5.4 连接查询
5.5 嵌套查询
5.6 集合查询
5.7 基于派生表的查询
实验5 单表查询（一）
实验6 单表查询（二）
实验7 连接查询
实验8 嵌套查询
实验9 多种方式多表查询
习题
第6章视图
6.1 创建视图
6.2 修改视图
6.3 删除视图
6.4 使用视图
实验10 视图的使用
习题
第7章数据库安全
7.1身份验证模式
7.2 登录账户管理
7.2.1 创建登录账户
7.2.2 修改登录账户属性
7.3 数据库用户管理
7.3.1 添加数据库用户
7.3.2 删除数据库用户
7.4 权限管理
7.4.1 设置数据库权限
7.4.2 设置数据库对象权限
7.5 角色管理
实验11 权限设置
实验12 SQL综合练习
习题
附录
附录A SQL Server中常用的函数
附录B SQL Server中常用的数据类型
附录C SQL Server中常用的运算符
参考文献

FAQ

Can I read this book without any database background?

Yes. The book starts from database creation, takes graphical interface operations as the main thread with step-by-step progression, and includes operation demonstration videos, making it suitable for zero-foundation readers to practice in chapter order. If you encounter theoretical concepts such as the relational model, you can supplement your understanding with other textbooks.

Do I need to prepare my own data for the lab tasks in the book?

The lab tasks in Chapters 3 to 6 revolve around a complete sales management database. Readers simply follow the book's steps to complete table creation, data operations, and view exercises within that database; there is no need to design a separate business scenario.

Is this book suitable for self-study?

It is suitable for introductory self-study. The operation steps and demonstration videos make it easy to follow along, and the sales management database case provides a continuous practice object. However, the theoretical explanations are concise; for deeper understanding of database principles during self-study, supplementary theoretical materials should be used.

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 Xuemei — public information about her is limited, and no confirmed biographical details are available. Judging from the nine works held in the library, her writing and editorial work span several fields. She has produced academic studies grounded in broadcast literature and the history of radio drama, such as Research on the Theory of Chinese Broadcast Literature and Art and A History of Radio Drama, and has also addressed media education and talent development, as seen in Research on the Multidimensional Integration Paths of "Dual Innovation" Education for Media Talent in the Intelligent Media Era and Building a Platform for Industry-Education Integration. These works show a sustained interest in industry change and teaching practice. In addition, she has contributed to practical textbooks such as the SQL Server Database Practice Tutorial and Service Etiquette (2nd Edition), and has touched on economic thought, film and television storytelling, and language and writing. Overall, her works are mainly textbooks and thematic studies that combine theoretical review with practical application, are aimed at teaching and professional readers, and adopt a plain style that seeks to explain specialist issues clearly and usefully, offering some reference value in relevant teaching and industry settings.

李海晨 Author

Li Haichen: publicly available information is limited, and no systematic disclosure of this person's identity details or personal background has been found. It is known that Li Haichen has one work in this library, SQL Server Database Practice Tutorial, classified under general computer science. Judging from the title and classification, the book likely focuses on hands-on operations with SQL Server and is intended for readers who need practical exercises, making it a technical tutorial oriented toward practice. Tutorials of this kind generally emphasize clear operational steps and a smooth connection between examples and key concepts, so that readers can learn while doing. Based on the materials currently available, Li Haichen's writing leans toward teaching and applied scenarios rather than theoretical exposition. Because background information about the author is insufficient, the full scope of their work, other publications, and industry influence are difficult to assess. This profile is therefore based only on the single work held in the library and its common classification, and may be supplemented if more reliable information becomes available.