• views: 63
• date: 2 February 2023
• posted by: voska89

Architecture, Performance, and Workload Optimization
What you'll learn
Create database schemas that are efficient and highly optimized in SingleStoreDB Cloud using universal storage tables, rowstores and reference tables.
Optimize queries and schemas using shard keys, sort keys, and indexes.
Use visual explain and profile to diagnose and optimize queries in SingleStoreDB Cloud.
Describe the architecture of a SingleStoreDB Cloud workspace.
Describe how SingleStore universal storage tables work, know when to use them, and create them in a SingleStoreDB Cloud Workspace.
Descibe how SingleStore rowstore and refrence tables work, know when to use them, and create them in a SingleStoreDB Cloud workspace.
Requirements
Learners should have a working knowledge of ANSI SQL.
Description
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
Who this course is for
Database Administrators, Applications Developers, Data Engineers, Data Scientists, and Data Analysts.
Homepage

https://www.udemy.com/course/sql-optimization-with-singlestore/

   
   
   

Forex Trading

Crypto Trading. 20 USD Bonus after KYC

We need your support!
Make a donation to help us stay online
        
Bitcoin (BTC)
bc1q08g9d22cxkawsjlf8etuek2pc9n2a3hs4cdrld
	
Bitcoin Cash (BCH)
qqvwexzhvgauxq2apgc4j0ewvcak6hh6lsnzmvtkem

Ethereum (ETH)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

Litecoin (LTC)
ltc1qt6g2trfv9tjs4qj68sqc4uf0ukvc9jpnsyt59u

USDT (ERC20)
0xb55513D2c91A6e3c497621644ec99e206CDaf239

USDT (TRC20)
TYdPNrz7v1P9riWBWZ317oBgJueheGjATm

0 1 2 3 4 5

| Print version |

	Information
		Users of GUESTS are not allowed to comment this publication.