Paperback. Pub Date:2016-07-01 Pages:276 Language: Publisher: Chinese Electronic Industry Press Textbook Based on careful analysis of the current situation of occupation demand and the ability of students on the overall planning and reconstruction of teaching content. reasonable arrangement of teaching unit order. divided into 8 units: experience and trial of SQL Server 2 database application.

Seller Inventory # DN053326

Contact seller

Report this item

Bibliographic Details

Title: Application. management and design of Server SQL 2014 database(Chinese Edition)
Publisher: ???????
Publication Date: 2016
Language: Chinese
ISBN 10: 7121289903
ISBN 13: 9787121289903
Binding: paperback
Condition: New

About this title

Synopsis

本教材在认真分析职业岗位需求和学生能力现状的基础上全面规划和重构教材内容，合理安排教学单元的顺序，划分为8个单元：体验数据库应用与试用SQLServer2014→创建与操作SQLServer数据库→创建与维护数据表→检索与操作数据表数据→以SQL语句方式操作SQLServer数据库及其对象→以程序方式处理数据表中的数据→维护SQLServer数据库安全→分析与设计数据库。本教材以真实工作任务为载体组织教学内容，强化技能训练，提升动手能力；围绕“图书管理”数据库和60项操作任务展开，采用“任务驱动、案例教学、精讲多练、理论实践一体化”的教学方法，全方向促进数据库应用、管理与设计技能的提升；充分考虑教学实施需求，面向教学全过程科学设置5个必要的教学环节，即教学导航→操作准备→知识导读→操作实战→单元习题。引导学生主动学习、高效学习、快乐学习。本教材可以作为普通高等院校、高等或中等职业院校和高等专科院校各专业SQLServer2014的教材，也可以作为SQLServer2014的培训教材及自学参考书。单元1体验数据库应用与试用SQLServer20141教学导航1操作准备1知识导读3操作实战71．1数据库应用体验7【任务1-1】体验数据库应用与初识数据库71．2试用SQLServer201416【任务1-2】初识SQLServer2014ManagementStudio（SSMS）16【任务1-3】查看系统数据库及系统表20【任务1-4】查看SQLServer2014的登录名和服务器角色21【任务1-5】启动与停止SQLServer2014的服务23单元习题25单元2创建与操作SQLServer数据库26教学导航26操作准备26知识导读26操作实战282．1创建SQLServer数据库28【任务2-1】创建数据库282．2操作SQLServer数据库31【任务2-2】操纵数据库31【任务2-3】备份与还原数据库38【任务2-4】分离和附加数据库47【任务2-5】数据库的联机与脱机49单元习题51单元3创建与维护数据表52教学导航52操作准备52知识导读53操作实战593．1数据表中数据的导入与导出59【任务3-1】导入与导出数据593．2查看与修改数据表71【任务3-2】查看与修改数据表记录71【任务3-3】查看与修改数据表结构743．3创建数据表78【任务3-4】创建数据表783．4维护数据表90【任务3-5】维护数据库中数据完整性90【任务3-6】维护数据表101单元习题102单元4检索与操作数据表数据103教学导航103操作准备103知识导读104操作实战1064．1创建与使用查询106【任务4-1】查询时选择与设置列106【任务4-2】查询时选择行112【任务4-3】查询时的排序操作117【任务4-4】查询时的分组与汇总操作118【任务4-5】创建连接查询119【任务4-6】创建多表联合查询125【任务4-7】创建嵌套查询126【任务4-8】创建相关子查询1284．2创建与使用视图129【任务4-9】创建视图129【任务4-10】使用视图1324．3创建与使用索引133【任务4-11】创建聚集索引134【任务4-1

"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 AIRMAIL, EUB, EMS, TNT 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.