Withdrawal method: Baidu.com
Total [48] sections
Availability of courseware: Yes

You will gain

sql语句的使用

数据库开发能力

数据库管理能力

对数据库基本优化

population (esp. of a group of people)

数据库感兴趣的初学者、数据库开发人员、DBA
Courses

本课程从最基础的数据库创建开始，为数据库小白打下良好的基础，以讲师日常工作中使用的案例，代码为基础，以案例演示为主，让学习者更好的了解，更主观的看到代码的效果。学习完本课程你将不只是能使用简单的sql语句，还能进行数据库的开发，和日常的数据库管理，直至数据库的优化也能有一定的理解。

Course Catalog

数据库的创建和删除 14:50
数据类型 09:06
表的创建、修改、删除 12:23
表记录的增、删、改 07:59
表的查询select上节 08:35
表的查询select下节多表关联 08:49
where条件的使用 09:36
group by分组 04:14
视图 06:27
函数 09:59
聚合函数 03:53
触发器 07:42
视图触发器 05:59
存储过程 08:05
约束 12:54
索引 13:04
游标的使用和改写 08:27
CASE的使用 08:23
生成序号或排名 04:13
时间字段相关操作 08:35
动态SQL 08:23
系统表 08:49
系统变量 05:28
系统过程 06:50
系统检测DBCC 06:28
数据库的备份 10:30
数据库的还原 05:34
数据库的附加 06:48
数据库多文件组的还原 08:50
数据库的7天循环备份和异地备份 08:36
使用工具实现本地、异地备份 13:17
作业的创建 09:59
日志收缩清除 04:49
误操作救命绝招用日志还原数据 05:09
链接服务器的创建 06:10
链接服务器的使用 07:55
维护计划 09:41
统计信息 07:53
执行计划 14:29
优化案例，利用包含索引 07:54
事件探查器profiler的使用 12:55
锁、事务、阻塞、死锁 11:36
权限管理 07:58
质疑的修复SQL2000 11:02
质疑的修复SQL2008 07:05
数据库分区技术 12:21
动态管理视图DMV 07:53
辅助工具使用 10:33

Resource Download

The download price for this resource is19.9Gold coins, please firstlog in

Resource Disclaimer (Purchase is deemed to be agreement with this statement):
1. Any operation on the website platform is considered to have read and agreed to the registration agreement and disclaimer at the bottom of the website, this site resources have been ultra-low price, and does not provide technical support
2. Some network users share the net disk address may be invalid, such as the occurrence of failure, please send an e-mail to customer service code711cn#qq.com (# replaced by @) will be made up to send
3. This site provides all downloadable resources (software, etc.) site to ensure that no negative changes; but this site can not guarantee the accuracy, security and integrity of the resources, the user downloads at their own discretion, we communicate to learn for the purpose of not all the source code is not 100% error-free or no bugs; you need to have a certain foundation to be able to read and understand the code, be able to modify the debugging yourself! code and solve the error. At the same time, users of this site must understand that the Source Code Convenience Store does not own any rights to the software provided for download, the copyright belongs to the legal owner of the resource.
4. All resources on this site only for learning and research purposes, please must be deleted within 24 hours of the downloaded resources, do not use for commercial purposes, otherwise the legal disputes arising from the site and the publisher of the collateral liability site and will not be borne!
5. Due to the reproducible nature of the resources, once purchased are non-refundable, the recharge balance is also non-refundable