SQL Optimization with SingleStore

SQL Optimization with SingleStore, available at $64.99, has an average rating of 3.75, with 30 lectures, 12 quizzes, based on 150 reviews, and has 968 subscribers.

You will learn about 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. This course is ideal for individuals who are Database Administrators, Applications Developers, Data Engineers, Data Scientists, and Data Analysts. It is particularly useful for Database Administrators, Applications Developers, Data Engineers, Data Scientists, and Data Analysts.

Enroll now: SQL Optimization with SingleStore

Summary

Title: SQL Optimization with SingleStore

Price: $64.99

Average Rating: 3.75

Number of Lectures: 30

Number of Quizzes: 12

Number of Published Lectures: 29

Number of Published Quizzes: 11

Number of Curriculum Items: 51

Number of Published Curriculum Objects: 49

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will 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 Should Attend

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

Target Audiences

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

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 storagesupported 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

Course Curriculum

Chapter 1: Introduction

Lecture 1: Video: Welcome

Chapter 2: SingleStoreDB Workspaces Architecture

Lecture 1: Video: SingleStoreDB Workspaces Architecture (with demo)

Chapter 3: SingleStoreDB Partitions

Lecture 1: Video: Partitions Overview

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

Lecture 3: Create Partitions (Demo)

Lecture 4: Video: Flexible Parallelism (with demo)

Lecture 5: Video: Attaching and Detaching Databases (with demo)

Lecture 6: Video: Workspace Expansion and Repartitioning (with demo)

Chapter 4: Sharding and Shard Keys

Lecture 1: Video: Sharding and Shard Keys

Lecture 2: Video: Sharding and Shard Keys (demo)

Chapter 5: Universal Storage Tables

Lecture 1: Video: SingleStore Table Types and Universal Storage Tables Introduction

Lecture 2: Video: Universal Storage

Lecture 3: Video: SingleStore Columnstore Technology

Lecture 4: Video: Creating and Configuring Universal Storage Tables

Lecture 5: Video: Unlimited Storage

Lecture 6: Video: Universal Storage (with demo)

Chapter 6: Rowstores and Reference Tables

Lecture 1: Video: Rowstores and Reference Tables Overview

Lecture 2: Video: Rowstore (with demo)

Lecture 3: Video: Reference Table (with demo)

Chapter 7: Architecture Capstone Lab

Lecture 1: Review of Architecture Concepts from Sections 2 through 6

Chapter 8: Indexes

Lecture 1: Video: Skiplist, Hash, and Full Text Indexes

Lecture 2: Video: Indexing JSON and Spatial Data

Chapter 9: Query Tuning

Lecture 1: Video: Performance Optimization and Query Tuning Introduction

Lecture 2: Video: Query Optimization

Lecture 3: Video: Statistics Collection

Lecture 4: Video: Explain and Profile

Chapter 10: Understanding Query Operations

Lecture 1: Video: Understanding Query Operations Introduction

Lecture 2: Video: Query Plan Operations

Lecture 3: Video: Using Visual Explain

Instructors

Singlestore Education
SingleStore Instructor

Rating Distribution

1 stars: 2 votes

2 stars: 5 votes

3 stars: 13 votes

4 stars: 65 votes

5 stars: 65 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!