|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-server-replication-in-the-real-world/
课程评论：没有评论
**Coursera 课程总结：SQL Server 复制在实际应用中的实践** 本课程“SQL Server 复制在实际应用中的实践”旨在教授学员如何正确配置 SQL Server 特有的三种复制拓扑。复制是一种将数据从源数据库自动分发到至少一个目标数据库的技术。 **课程核心内容：** * **三种复制拓扑：** * **快照复制 (Snapshot Replication)：** 初始复制整个数据集。 * **事务复制 (Transactional Replication)：** 复制数据更改的事务。 * **合并复制 (Merge Replication)：** 允许源和目标数据库之间进行双向数据同步。 * **复制的实际应用：** * **报告 (Reporting)：** 将数据分发到用于报告的数据库。 * **数据仓库 (Data Warehousing)：** 支持数据仓库的构建和维护。 * **off-loading nightly batch processing tasks：** 将夜间批量处理任务分载到其他服务器。 * **重要概念：** * 复制用于**持续的数据传输**，而非简单的数据复制。 * 虽然复制可用于高可用性解决方案，但**不被推荐**。 * 复制使用“出版物” (Magazine Publishing) 的术语，可以将文章或整个数据库进行复制。 * **课程目标：** * 学员将学习所有必要的**术语、架构**以及**实用的技巧和窍门**，以确保复制功能稳定运行。 **学员评价亮点：** * 讲师声音清晰，语速适中，不会仓促带过。 * 每一步操作都展示清楚，节省了学员重复观看的时间。 本课程非常适合希望深入理解和实践 SQL Server 复制技术的相关人员。
Review from similar course: "The trainer has a nice clear voice and the most important is that he does not rush through the subject, which is the problem with many instructors. By speaking slowly and displaying every step, it saves us time by not having to replay every section over and over, thanks for this." - Andres Welcome to SQL Server Replication in the Real World. In this course, you'll learn how to correctly configure the three replication topologies specific to SQL Server. Replication is a way of distributing data automatically from a source database to one or more destination databases. In this course, we are going to cover three core topologies. They are, Snapshot Replication, Transactional Replication and Merge Replication. It has also been used to for high availability solution but that's not recommend. Replication is for continuous data transfer and is not used for simply copying data. The two most common real world applications for replication are reporting and data warehousing. I've also seen it used for off-loading nightly batch processing tasks. Replication uses a Magazine Publishing vocabulary. Anything from an article to an entire database can be replicated. In the course, we are going to cover all the nomenclature, architecture and real world tips and tricks you'll need to keep replication functioning without issue. Thanks for your interest in SQL Server Replication in the Real World. We will see you in the course!!!
