1、培训过程中，如有部分内容理解不透或消化不好，可免费在以后培训班中重听；
        2、培训结束后,授课老师留给学员联系方式,保障培训效果,免费提供课后技术支持。
        3、培训合格学员可享受免费推荐就业机会。

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