EncartaLabs

MemSQL

( Duration: 2 Days )

MemSQL is a high-performance, in-memory database that combines the horizontal scalability of distributed systems with the familiarity of SQL. This MemSQL training course provides skills to use MemSQL tools to build effective data warehouses and real-time in-memory database applications. You will gain deep insights to Associated MemSQL technicalities like those of designing a Cluster during installation, analyzing Plancache during schema designing, concepts related query optimization, troubleshooting etc.

By attending MemSQL workshop, delegates will learn:

  • About the MemSQL real-time, in-memory distributed architecture
  • How to install MemSQL aggregator and leaf nodes
  • About the Schema design and query optimization techniques
  • Involved steps in operating MemSQL with MemSQL Ops
  • Best practices involved for deploying and monitoring MemSQL high availability clusters
  • Understanding of the steps necessary to perform troubleshooting, diagnosing, and tuning operations

  • Prior experience of working on Linux, relational database systems, and SQL platforms.

The MemSQL class is ideal for:

  • Application Developers, Database Developers, Operation Engineers, and Database Administrators.

COURSE AGENDA

1

MemSQL Architecture Change Management

  • Architecture
  • Rowstore
  • Columnstore
  • Shard Keys
  • Distributed Joins
  • Reference Tables
2

Installation and Upgrade

  • Designing a Cluster
  • Manual installation
  • Expanding a Cluster
  • Upgrade
  • Securing MemSQL
3

Schema Design and Optimization

  • Transactions
  • Geospatial data
  • Index types
  • Analyze, Explain, and Plancache
  • Schema and query optimization
4

MemSQL Architecture

  • Installing MemSQL Ops
  • MemSQL commands
  • Tips and tricks
5

MemSQL Ops

  • High Availability cluster
  • Logging, monitoring and diagnosis
  • Cluster replication
  • Backup and restore
  • Failover and recovery
  • Offline upgrading with MemSQL Ops
6

Troubleshooting MemSQL

  • Failure scenarios
  • MemSQL Support

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 4,000 Modules on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting http://encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top