SQL Optimization with SingleStore

سرفصل های دوره

Architecture, Performance, and Workload Optimization

1. Introduction

1. Video Welcome

2. SingleStoreDB Workspaces Architecture

1. Video SingleStoreDB Workspaces Architecture (with demo)

2. Lab Create a SingleStore DB Cloud Workspace.html

3. Knowledge Check SingleStoreDB Workspaces.html

3. SingleStoreDB Partitions

1. Video Partitions Overview

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

3. Create Partitions (Demo)

4. Video Flexible Parallelism (with demo)

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)

8. Video Workspace Expansion and Repartitioning (with demo)

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

2. Video Sharding and Shard Keys (demo)

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

2. Video Universal Storage

3. Video SingleStore Columnstore Technology

4. Video Creating and Configuring Universal Storage Tables

5. Video Unlimited Storage

6. Video Universal Storage (with demo)

7. Knowledge Check Universal Storage.html

6. Rowstores and Reference Tables

1. Video Rowstores and Reference Tables Overview

2. Video Rowstore (with demo)

3. Video Reference Table (with demo)

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

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

3. Video Indexing JSON and Spatial Data

4. Lab JSON and Spatial Indexes.html

5. Knowledge Check Indexes.html

9. Query Tuning

1. Video Performance Optimization and Query Tuning Introduction

2. Video Query Optimization

3. Knowledge Check Query Optimization.html

4. Video Statistics Collection

5. Lab Utilizing Table Statistics.html

6. Knowledge Check Statistics Collection.html

7. Video Explain and Profile

8. Lab Using EXPLAIN and PROFILE.html

9. Knowledge Check Explain and Profile.html

10. Understanding Query Operations

1. Video Understanding Query Operations Introduction

2. Query Execution Video (with demo)

3. Video Query Plan Operations

4. Knowledge Check Query Plan Operations.html

5. Video Using Visual Explain

189,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training