         MemSQL培訓

Introduction

Overview of MemSQL

Understanding the MemSQL Architecture

Quick Start with MemSQL Using MemSQL Ops

Understanding Essential MemSQL Concepts

Overview of MemSQL Commands
Working with Rowstore and Columnstore
Implementing Data Distribution
Using Shard Keys
Implementing Distributed Joins
Using Reference Tables
Understanding Application Cluster Topologies
Installing and Upgrading MemSQL

Designing a Cluster
Doing Manual Installation
Expanding a Cluster
Implementing an Upgrade
Securing MemSQL
Working with Schema Design and Query Optimization

Working with Transactions
Working with Geospatial Data
Understanding Index Types
Using Sparsity and Normalized Forms
Hands-on: Using a Reference Table to Query JSON with Variant Array Lengths
Working with Shard Key Strategies
Identifying a Sharding Strategy
Understanding Analyze, Explain, and Profile
Implementing Schema Optimization for Query Performance
Using Query Hints
Diving Deep into Administering MemSQL Operations

Using the MemSQL Ops Command Line Interface
Administering a Cluster
Understanding Administrator Key Concepts
Backing Up and Restoring Data
Scaling Cluster Size
Dealing with Cluster Failures
Managing High Availability
Monitoring MemSQL
Working with the Trace Log
Using Durability and Recovery
Running Diagnostics
Working with MemSQL Procedural SQL (MPSQL)

Using Table-Valued Functions
Using User-Defined Functions
Using User-Defined Aggregate Functions
Using Stored Procedures
Implementing Performance Benchmarking and Fine-Tuning

Using Experimental Metrics
Performance Testing with dbbench
Hands-on: Working with a Database Workload Generator
Using Management Views
Implementing Workload Profiling
Hands-on: MemSQL Top
Working with MemSQL Pipelines and Real-Time Data Ingestion

Using the MemSQL Connector for Apache Spark
Using MemSQL Pipelines with Apache Kafka and AWS S3
Creating Real-Time Applications

Working with Business Intelligence Dashboards
Using MemSQL Pipelines for Machine Learning
Implementing a Real-Time Dashboard
Implementing Predictive Analytics
Troubleshooting MemSQL

Summary and Conclusion