{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Sheet1","index":0,"n_rows":64,"n_cols":5,"rows_kept":64,"merged":[[0,0,0,3],[1,0,1,1],[1,2,1,3],[2,2,2,3],[5,0,10,0],[5,4,10,4],[11,0,11,4],[12,0,18,0],[19,0,19,4],[20,0,29,0],[30,0,30,4],[31,0,37,0],[38,0,38,4],[39,0,51,0],[52,0,52,4],[53,0,63,0]],"flags":["formulas_cached_only"]}
["MOOC课程设计表"]
["课程名称：SQL Server数据库",null,"课程负责人：秦晓安"]
["一级结构","二级结构","视频内容"]
["（模块）","（小节）","内容","时长","作业"]
["欢迎模块",null,"介绍课程内容，学习目标，授课教师个人履历，测验及作业，课程考核等内容","8’"]
["模块1 数据库\n(发布时间：2016-9-20 10:00)","1.1 SQL Server数据库安装与使用","视频1.1_1 SQL Server数据库的安装","9'30\""]
[null,null,"视频1.1_2 SQL Server数据库的使用","8'"]
[]
[null,"1.2 数据库操作","视频1.2_1 SQL Server数据库组成","9’"]
[null,null,"视频1.2_2 创建数据库","7'30\""]
[null,null,"视频1.2_3 配置管理数据库","8'"]
[]
["模块2 表\n(发布时间：2016-9-27 10:00)","2.1 表的操作","视频2.1_1 表的组成","8'"]
[null,null,"视频2.2_2 创建表","11'"]
[null,null,"视频2.2_3 表的后期管理","9'"]
[]
[null,"2.2 表中数据的操作","视频2.1_1 表中数据添加","8'"]
[null,null,"视频2.2_2 表中数据的修改","11'"]
[null,null,"视频2.2_3 表中数据的删除","9'"]
[]
["模块3 查询\n(发布时间：2016-9-27 10:00)","3.1 单表查询","视频3.1_1 对查询结果进行选择（字段、函数）","8'"]
[null,null,"视频3.1_2 对查询条件进行设置","11'"]
[null,null,"视频3.1_3 对查询结果进行排序","9'"]
[null,null,"视频3.1_4 对查询结果进行分组","12'"]
[]
[null,"3.2 多表查询","视频3.2_1  嵌套查询","8'"]
[null,null,"视频3.2_2  连接查询","11'"]
[]
[null,"3.3 视图","视频3.3_1  创建视图","9'"]
[null,null,"视频3.3_2  视图配置管理（加密）","10'"]
[]
["模块4 数据完整性\n(发布时间：2016-9-27 10:00)","4.1 约束","视频4.1_1 主键","8'"]
[null,null,"视频4.1_2 外键","11'"]
[null,null,"视频4.1_3 check约束","9'"]
[null,null,"视频4.1_4 默认与唯一性约束","8'"]
[]
[null,"4.2 规则与默认","视频4.2_1 规则对象","7'30"]
[null,null,"视频4.2_2 默认对象","7'"]
[]
["模块5 数据库编程\n(发布时间：2016-9-27 10:00)","5.1 SQL Server编程基础","视频5.1_1 变量定义与使用","11'"]
[null,null,"视频5.1_2 三大基本结构","8'30"]
[]
[null,"5.2 自定义函数*","视频5.2_1 创建自定义函数","11'"]
[null,null,"视频5.2_2 自定义函数使用","10'"]
[]
[null,"5.3 存储过程","视频5.2_1 创建简单的存储过程","11'"]
[null,null,"视频5.2_2 创建带有参数的存储过程","9'"]
[null,null,"视频5.2_3 存储过程的配置与管理","8'"]
[]
[null,"5.4 触发器","视频5.3_1 系统表inserted与delete","11'"]
[null,null,"视频5.3_2 创建触发器*","9'"]
[null,null,"视频5.3_3 触发器的配置与管理","5'30"]
[]
["模块6 数据库安全管理\n(发布时间：2016-9-27 10:00)","6.1 账户管理","视频6.1_1 创建登录名","6'30"]
[null,null,"视频6.1_2 创建用户","11'"]
[null,null,"视频6.1_3 创建角色","9'"]
[null,null,"视频6.1_4 分配权限","8'"]
[]
[null,"6.2 数据的导入与导出","视频6.2_1 SQL数据库之间的导入与导出","8'"]
[null,null,"视频6.2_2 SQL数据库与Access之间的导入与导出","11'"]
[null,null,"视频6.2_3 SQL数据库与Excel之间的导入与导出","7'"]
[]
[null,"6.3 数据库备份与恢复","视频6.3_1 数据库备份","11'"]
[null,null,"视频6.3_2 数据库恢复","10'"]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}