|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/basicsqlwithsqlserver2016/
课程评论:没有评论
**课程名称:SQL Server 2017 Express 基础** **课程概述:** 本课程专为SQL Server初学者设计,旨在帮助您掌握SQL Server 2017 Express的基础知识。课程内容涵盖了SQL Server的各项实用功能,通过大量视频讲解和实际操作帮助您深入理解。 **核心亮点:** * **更新至SQL Server 2017:** 课程内容已进行大幅更新,替换了大部分视频,以反映SQL Server 2017的新特性。 * **丰富的视频内容:** 包含大量视频,平均时长约10分钟,提供详细的讲解。部分视频集成了问题,增强互动性。 * **实用的数据库示例:** 使用AdventureWorks2016CTP3和AdventureWorks2017数据库进行演示,方便学习者实践。 * **深入讲解关键概念:** 例如,索引(Indexes)等核心概念会在多个视频中穿插讲解,确保全面掌握。 * **不依赖PPT和花哨图表:** 教学风格注重内容本身,通过Zoom等方式突出重点。 * **重点关注执行计划:** 课程会多次深入讲解执行计划(Execution Plans),帮助理解查询性能。 * **明确的适用人群:** 本课程适合SQL Server初学者。不适合有中级或高级SQL经验的学习者。 * **不包含内容:** 课程不涵盖 JOIN、数据库规范化(Normalization)和存储过程(Stored Procedures)。 * **学习建议:** 建议按顺序完整观看所有视频,以最大限度地获取课程价值。 **重要提示:** 在购买前,请务必仔细查阅课程大纲,确保课程内容符合您的学习需求。课程内容的更新和改进仍在进行中。学习者需要具备下载课程资源的技能。
Most Important: Friends, please be sure to look through the course curriculum with meticulous care before buying to be sure this course will work for you. Thank you. This course is being updated to bring it up to date with SQL Server 2017. As of 3/27/2018, 40 videos have been replaced. Replacement of all videos will happen over a month or so.Reviews from before 3/6/2017 are from the older version of this course. The new course features questions built right into the videos. The new course features audio done with a studio microphone. If you are at the intermediate or advanced level in SQL, do not join this course. My explanation can be very detailed at times, so be sure you enjoy that. Some of the videos cover programming, and some cover using a variety of resources without programming.I use AdventureWorks2016CTP3, but you can also use AdventureWorks2017. Both are saved under the lesson 2 resources. There is no practical difference between the two for the purposes of this course. You must already know how to download lesson resources. I do not show how to do that. Various topics are discussed through the videos. For example, there is not just one video on indexes because indexes are too big a topic. I discuss indexes through the videos where they play a role. The same applies to other concepts. Be sure to look under the lesson resources for additional information and the code.My explanations, in some of the videos, but not all, can be very detailed, so be sure you enjoy that before enrolling.If you are looking for powerpoints, fancy graphics or a talking head, please do not enroll. I don't use those. I do in different places use zooming to emphasize points. The videos are an average in 10 minutes in length, so please be aware of that. All the code is created in the Microsoft SQL Server Management Studio. I talk about execution plans quite a lot over multiple videos.This course does not cover joins, normalization or stored procedures.Friends, to get the most from this course, please watch it all, from beginning to end. There is a lot of information here:) Thank you,Tom and Adiv