MemSQL Training Chennai

MemSQL Training

MemSQL is a high-performance, in-memory database that combines the horizontal scalability of distributed systems with the familiarity of SQL.

MemSQL the software

• Distributed and Parallel
• Shared-Nothing, Lock-Free
• Data in memory or SSD
• SQL all the way down

MemSQL Training Chennai

 

Course Outline

Module 1: MemSQL Architecture Overview

In the first module, describes MemSQL and its main database characteristics, including technical principles, architecture, design and implementation.

Module 2: Durability, Backups, Replication, and High Availability

What happens when an in-memory database reboots? How is data replicated? In module 2, walks through what happens when MemSQL is deployed on machines, and how MemSQL demonstrates the four essential qualities of any leading database: Atomicity, Consistency, Isolation and Durability.

Module 3: MemSQL Geospatial

MemSQL supports common datatypes like strings, dates, numbers. MemSQL 4 also supports geospatial data types. In module 3, explains how geospatial data is stored in MemSQL, relational functionality, and spatial indexing for fast queries.

Module 4: Columnstore

In Module 4, explains the structure of the MemSQL columnstore, which compresses and processes data on disk. The MemSQL columnstore is ideal for storing data that exceeds your memory capacity. Infinite disk storage on MemSQL is provided for free.

Module 5: Moving Data

In Module 5, describes ways to move data in and out of a MemSQL cluster. He covers Hadoop/HDFS, Amazon S3, MySQL, flat files, and ODBC data sources.

Module 6: Schema Design and Capacity Planning

In Module 6, dives into the MemSQL in-memory rowstore, explaining data types, indexes, sparnesses and JSON, online ALTER TABLEs, and sharding strategies. He concludes with advice for planning a cluster based on various data workloads.

 

 

MemSQL Training Chennai

Contact us

Mail: info@bigdatatraining.in
Call: +91 9789968765 / 044 – 42645495

Weekdays / Fast Track / Weekends / Corporate Training modes available

MemSQL Training  Also available across India in Bangalore, Pune, Hyderabad, Mumbai, Kolkata, Ahmedabad, Delhi, Gurgon, Noida, Kochin, Tirvandram, Goa, Vizag, Mysore,Coimbatore, Madurai, Trichy, Guwahati

On-Demand Fast track Apache Spark Training globally available also at Singapore, Dubai, Malaysia, London, San Jose, Beijing, Shenzhen, Shanghai, Ho Chi Minh City, Boston, Wuhan, San Francisco, Chongqing.