Paperback. Pub Date:2016-08-01 Pages:276 Language: Publisher: Chinese Electronics Industry Press. the main content of the book includes the needs of the project. and based on the demand analysis based on the database design. table design. database design. the main foreign key constraint design. write a SQL statement to manipulate data and statistical query and view design.

Seller Inventory # DN053328

Contact seller

Report this item

Bibliographic Details

Title: Development and application of Server SQL 2014 database design(Chinese Edition)
Publisher: ???????
Publication Date: 2016
Language: Chinese
ISBN 10: 7121296810
ISBN 13: 9787121296819
Binding: paperback
Condition: New

About this title

Synopsis

本书主要内容包括项目需求介绍，并在基于需求分析的基础上进行数据库的设计、表的设计、主外键的设计、数据库约束的设计、编写SQL语句操纵数据和统计查询、视图的设计及开发、存储过程的设计及开发、触发器的设计及开发、游标的设计及开发；使用VisualStudio开发基于SQLServer的数据库项目，每章后面均配有实训和习题。第1章SQLServer2014简介11．1SQLServer2014入门11．1．1数据库用来做什么11．1．2SQLServer是什么11．2SQLServerManagementStudio21．2．1SQLServerManagementStudio简介21．2．2SQLServerManagementStudio操作入门2第2章网上购物系统及其数据库简介52．1网上购物系统介绍52．1．1网上购物系统功能介绍52．1．2为什么通过网上购物系统学习SQLServer52．2运行网上购物系统52．2．1准备网上购物系统所需数据库52．2．2运行网上购物系统72．2．3网上购物系统功能介绍102．3网上购物系统使用的数据库eShop192．3．1初步认识网上购物系统使用的数据库eShop192．3．2数据库中表之间的关系21第3章创建数据库263．1创建数据库263．1．1数据库文件263．1．2文件组273．1．3使用SSMS创建数据库283．1．4使用命令创建数据库353．1．5系统数据库373．2管理数据库383．2．1重新命名数据库383．2．2删除数据库40实训41第4章创建表、数据维护424．1表及其相关概念424．1．1什么是表424．1．2数据类型424．1．3空值（NULL）434．1．4使用SSMS创建、删除表444．1．5使用SQL命令创建、修改、删除表514．1．6分区表534．2数据维护：录入、修改、删除记录544．2．1使用SSMS录入、修改、删除记录554．2．2使用SQL命令录入、修改、删除数据58实训62第5章表设计：主键、默认值、CHECK645．1如何设计表645．1．1表的初步设计645．1．2为什么要创建这些表645．2主键（PRIMARYKEY）655．2．1主键概述655．2．2创建主键并认识其作用655．3默认值675．3．1默认值概述675．3．2创建默认值并认识其作用675．4CHECK约束715．4．1CHECK约束概述715．4．2创建CHECK约束并认识其作用71实训75第6章表设计：外键、触发器766．1外键FOREIGNKEY766．1．1外键的作用766．1．2创建外键并理解其作用766．1．3关系图826．2触发器846．2．1触发器的作用846．2．2创建触发器并理解其作用84实训92第7章索引和全文检索937．1索引简介937．1．1什么是索引937．1．2索引的分类937．1．3聚集索引和非聚集索引937．2索引设计947．2．1创建索引并理解其作用947．2．2实例观察查询优化器如何使用索引977．3全文检索987．3．1全文检索的作用987．3．2全文检索演练99实训

"About this title" may belong to another edition of this title.

Store Description

Thank you for visiting My bookstore! We are an online bookstore, and Is the China's largest online book sales. Generally our books are from China, with reasonable price and decent printing quality. We are always trying our best to satisfy customer's needs!

Visit Seller's Storefront

Seller's business information

NAN JING SHI JIANG NING QU NING YUAN DIAN ZI SHANG WU ZHONG XIN
Room 264, Oujiang Shopping Center, No. 1 Dongxin South Road, Dongshan Street, Jiangning District, NanJing, Nanjing, JS, 211100, China

Sale & Shipping Terms

Terms of Sale

We guarantee the condition of every book as it's described on the Abebooks web sites. If you're dissatisfied with your purchase (Incorrect Book/Not as Described/Damaged) or if the order hasn't arrived, you're eligible for a refund within 30 days of the estimated delivery date. If you've changed your mind about a book that you've ordered, please use the Ask bookseller a question link to contact us and we'll respond within 2 business days. Please Note:We don't sell any international Edition to you...

More Information

Shipping Terms

Most orders are shipped within 24 hours. We will delivery these items to you by SAL, EUB, EMS, FEDEX etc.

Shipping rates from China to U.S.A.

Shipping rates from China to U.S.A.
Order quantity	16 to 30 business days	8 to 16 business days
First item	US$ 18.00	US$ 30.00

Delivery times are set by sellers and vary by carrier and location. Orders passing through Customs may face delays and buyers are responsible for any associated duties or fees. Sellers may contact you regarding additional charges to cover any increased costs to ship your items.