SQL Optimization with SingleStore

Focused View

Singlestore Education

2:37:42

68 View

1. Introduction

1. Video Welcome.mp4

02:38

2. SingleStoreDB Workspaces Architecture

1. Video SingleStoreDB Workspaces Architecture (with demo).mp4

07:39

2. Lab Create a SingleStore DB Cloud Workspace.html

3. Knowledge Check SingleStoreDB Workspaces.html

3. SingleStoreDB Partitions

1. Video Partitions Overview.mp4

00:40

2. Video Create Partitions and Flexible Parallelism in SingleStoreDB Cloud (demo).mp4

06:08

3. Create Partitions (Demo).mp4

03:09

4. Video Flexible Parallelism (with demo).mp4

01:52

5. Lab Creating Partitions and Exploring Parallelism Assignment.html

6. Knowledge Check Creating Partitions and Flexible Parallelism.html

7. Video Attaching and Detaching Databases (with demo).mp4

05:42

8. Video Workspace Expansion and Repartitioning (with demo).mp4

05:17

9. Lab Workspace Expansion and Repartitioning a Database.html

10. Knowledge Check Workspace Expansion and Repartitioning a Database.html

4. Sharding and Shard Keys

1. Video Sharding and Shard Keys.mp4

09:41

2. Video Sharding and Shard Keys (demo).mp4

08:40

3. Lab Sharding and Shard Keys.html

4. Knowledge Check Sharding and Shard Keys.html

5. Universal Storage Tables

1. Video SingleStore Table Types and Universal Storage Tables Introduction.mp4

00:44

2. Video Universal Storage.mp4

06:10

3. Video SingleStore Columnstore Technology.mp4

05:12

4. Video Creating and Configuring Universal Storage Tables.mp4

06:39

5. Video Unlimited Storage.mp4

02:43

6. Video Universal Storage (with demo).mp4

05:57

7. Knowledge Check Universal Storage.html

6. Rowstores and Reference Tables

1. Video Rowstores and Reference Tables Overview.mp4

05:06

2. Video Rowstore (with demo).mp4

08:49

3. Video Reference Table (with demo).mp4

02:05

4. Knowledge Check Rowstores and Reference Tables.html

7. Architecture Capstone Lab

1. Review of Architecture Concepts from Sections 2 through 6.html

2. Capstone Lab Create Database Tables and Review Data Distribution and Skew.html

8. Indexes

1. Video Skiplist, Hash, and Full Text Indexes.mp4

03:37

2. Lab Skiplist, Hash, and Fulltext Indexes.html

3. Video Indexing JSON and Spatial Data.mp4

03:00

4. Lab JSON and Spatial Indexes.html

5. Knowledge Check Indexes.html

9. Query Tuning

1. Video Performance Optimization and Query Tuning Introduction.mp4

00:39

2. Video Query Optimization.mp4

03:59

3. Knowledge Check Query Optimization.html

4. Video Statistics Collection.mp4

05:51

5. Lab Utilizing Table Statistics.html

6. Knowledge Check Statistics Collection.html

7. Video Explain and Profile.mp4

12:33

8. Lab Using EXPLAIN and PROFILE.html

9. Knowledge Check Explain and Profile.html

10. Understanding Query Operations

1. Video Understanding Query Operations Introduction.mp4

02:33

2. Query Execution Video (with demo).mp4

09:03

3. Video Query Plan Operations.mp4

09:03

4. Knowledge Check Query Plan Operations.html

5. Video Using Visual Explain.mp4

12:33

Description

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.

Who is this for?

Database Administrators, Applications Developers, Data Engineers, Data Scientists, and Data Analysts.

More details

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 architecture
Know how and when to use sharding and indexing best practices
Be familiar with the tools you can use to gather and analyze information about query performance
Review performance statistics to understand where to optimize queries
Employ methods of query optimization to improve performance
Understand the benefits of benchmarking
Prerequisites: Students who choose to enroll in this course should have:
SQL skills, which will be used in the labs
Understanding of relational databases
Who this course is for:
Database Administrators, Applications Developers, Data Engineers, Data Scientists, and Data Analysts.

User Reviews

Rating

average 0

Total votes0

Focused display

SQL

Singlestore Education

Instructor's Courses

SingleStore courses are developed and delivered by experienced instructors who have a deep knowledge of how to configure and use SingleStoreDB. Our instructors work with SingleStore's engineering team that builds the product and their field engineering team that helps customers implement and use it. They provide students with the latest information about new features, best practices, and real-world scenarios. Our instructors are highly motivated to provide the practical skills and knowledge needed to launch, test, and maintain your SingleStoreDB workspaces and databases.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.