Thank you for sending your enquiry! One of our team member will contact you shortly.
Thank you for sending your booking! One of our team member will contact you shortly.
Course Outline
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
Requirements
- Experience with Linux, relational database systems, and SQL platforms
- Experience with Scala, Java, or Python programming
Testimonials
It gives me an insight on Redis, and also guide me to the right path if I want to know more about Redis
Ameer Fiqri Barahim - Sarawak Information Systems Sdn Bhd
Redis for High Availability and Performance Training Course Course
The broad coverage of the subjects
- Roche
Big Data Storage Solution - NoSQL Course
Related Courses
Amazon Redshift
21 hours
Pivotal Greenplum for Developers
21 hours
Greenplum Database
14 hours
Big Data Storage Solution - NoSQL
14 hours
HBase for Developers
21 hours
Aerospike for Developers
14 hours
Scylla Database
21 hours
OrientDB for Developers
14 hours