|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-optimization-with-singlestore/
课程评论：没有评论
课程名称：使用SingleStore进行SQL优化 课程概述：本课程将带您了解SingleStoreDB架构以及如何充分发挥SingleStoreDB Cloud工作区和数据库的性能。课程包括讲座和演示以介绍概念，还有实践实验和知识检查以巩固学习。主要内容包括：SingleStore架构——了解SingleStore架构的功能；SingleStore支持的不同存储类型；以及架构设计策略，如分片及分片键的使用、索引等。查询优化，特别是在像SingleStore这样的分布式系统中的优化。基准测试工具用于监控查询性能，发现改进机会。实验为实践操作形式，需访问免费的SingleStoreDB Cloud试用版。课程的第一个实验包括如何创建账户的说明，如果您没有账户，如何启动工作区。 完成本课程后，您将能够： - 理解SingleStoreDB架构的关键概念 - 知道何时使用分片和索引的最佳实践 - 熟悉收集和分析查询性能信息的工具 - 查看性能统计信息，了解优化查询的方向 - 采用查询优化的方法提升性能 - 理解基准测试的好处 先决条件：选择参加本课程的学生应具备SQL技能（将用于实验）以及对关系数据库的理解。
In this course, you'll learn about SingleStoreDB architecture and how to get the best performance from your SingleStoreDB Cloud workspaces and databases. The course includes lectures and demonstrations to introduce concepts, and hands-on labs and knowledge checks to reinforce learning.Topics include:SingleStore architecture - how SingleStore's architecture functions; the different types of storage supported in SingleStore; and schema design strategies, such as the use of sharding and shard keys, indexes, and more.Query optimization, specifically on optimizations in distributed systems like SingleStore.Benchmarking tools to monitor the performance of our queries and discover opportunities for improvements.Labs are hands-on, and require access to a free SingleStoreDB Cloud trial. The first lab of the course includes instructions on how to set up an account if you don't have one, and how to launch a workspace.By the end of this course, you will:Understand the key concepts of SingleStoreDB architectureKnow how and when to use sharding and indexing best practicesBe familiar with the tools you can use to gather and analyze information about query performanceReview performance statistics to understand where to optimize queriesEmploy methods of query optimization to improve performanceUnderstand the benefits of benchmarkingPrerequisites: Students who choose to enroll in this course should have:SQL skills, which will be used in the labsUnderstanding of relational databases
