課程大綱： 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
加入高級會員獲得助教答疑
