The best preparation for
managing and operating
MemSQL production clusters

Education for Administrators

Our administrator training provides students with a comprehensive understanding of the steps necessary to install, design, operate, maintain, and monitor a high availability cluster with MemSQL and MemSQL Ops, our built-in management tool. Our administrator training includes instructor demonstrations, hands-on labs, and ready-to-use AWS environments.
Education for Administrators

Hands-on Learning

Through presentations, demonstrations, interactions, and hands-on labs, students will master MemSQL key concepts, terminology, and topics such as:
  • Fundamental concepts for the distributed architecture of MemSQL
  • Installing aggregators and leaves including advanced installation scenarios
  • Operating MemSQL with MemSQL Ops
  • Securing MemSQL and MemSQL Ops
  • Managing offline and online upgrades for MemSQL Ops and MemSQL
  • Backup strategy for disaster recovery
  • Operating MemSQL for high availability and durability
Hands-on Learning

Audience and Prerequisites

Designed to serve the learning goals of database administrators and operation engineers, MemSQL 6.5 Administrator Training requires previous experience with Linux, relational database systems, and SQL.
Audience and Prerequisites

Professional Certification

MemSQL certification provides employers, partners, and customers with tangible evidence of your skills and expertise. Certification validates your expertise and helps establish your leadership credentials. Participants of this training achieve certification with course completion and by passing a certification exam.

MemSQL issues digital certificates that are verifiable. MemSQL Certified Administrators easily add their digital certificate to their LinkedIn profiles.
Professional Certification

Curriculum

Course modules

  • 1
    Module: Course Details and Downloads
    • Software Requirements
    • Verify SSH access to AWS EC2
    • Student AWS EC2 Instances
    • Student Downloads
  • 2
    Module: MemSQL Fundamentals for Administrators
    • Architecture Concepts
    • Rowstore and Columnstore -- Rowstore
    • Rowstore and Columnstore -- Columnstore
    • Data Distribution
    • Distributed Joins
    • Reference Tables
    • Designing a Cluster
    • Expanding a Cluster
  • 3
    Module: Installing MemSQL
    • Manual Installation
    • Installing MemSQL Ops
    • Advanced Installation Scenarios
    • LAB: Installing MemSQL Manually
    • LAB: Installing MemSQL Manually without MemSQL Ops (no SSH)
    • LAB: MemSQL Installation with MemSQL Ops
    • LAB: MemSQL Installation with MemSQL Ops with the CLI no SSH
  • 4
    Module: MemSQL Ops
    • MemSQL Ops WebUI
    • MemSQL Ops Command Line Interface (CLI)
    • Common Shell Scripts with MemSQL Ops
    • LAB: Multi-node SQL bash shell script
  • 5
    Module: Securing MemSQL and MemSQL Ops
    • Securing MemSQL and MemSQL Ops
    • MemSQL Client to Custer and Node to Node Security
    • Role Based Access Control (RBAC)
    • Row Level Security
    • LAB: Cluster Security
    • LAB: Securing MemSQL Ops and all MemSQL nodes
  • 6
    Module: Managing Upgrades
    • Upgrade MemSQL Ops
    • MemSQL Offline and Online Upgrade
    • LAB: Offline Manual Upgrade
    • VIDEO: Online Upgrade
  • 7
    Module: Operating MemSQL
    • Transaction Models
    • High Availability
    • Cluster Replication
    • Backup and Restore
    • Failover and Recovery
    • Logging, Monitoring, and Troubleshooting
    • LAB: Snapshot
    • LAB: Kill a Leaf
    • LAB: Manually promote and copy partitions
    • Appendix: Explain, Analyze, Profile
    • Appendix: MemSQL kill scenarios
  • 8
    Module: Certification
    • Requirements for Certification
    • MemSQL Administrator Certification Exam
    • ORDER BY ASC - Survey

Learn Your Way

Available options for MemSQL Administrator training

  • MemSQL 6.5 Administrator
    Onsite

    We visit your onsite location to deliver MemSQL training to your team.
    Learn more

  • MemSQL 6.5 Administrator
    Virtual

    Join us for a virtual instructor-led training that suits your timezone.
    Learn more

  • MemSQL 6.5 Administrator
    Self-Paced

    With the support of a learning community, learn at your own speed.
    Learn more

MemSQL Administrator

How our offerings compare


ONSITE
VIRTUAL
SELF-PACED
AWS EC2 instances



Certification exam



Course player



Curriculum downloads



Hands-on labs



In-person assistance



Instructor-led



Live discussions



Online discussion forum



Quizzes



Recorded sessions



Videos tutorials



FAQs

Answers to common questions

  • How are MemSQL courses created?

    We design our courses to align with professional certification and on-the-job success. We employ the ADDIE model to design and develop our education content. We Analyze needs, Design the learning, Develop the curriculum, Implement the onsite training course, and Evaluate the performance. We also employ an agile methodology for curriculum and courseware development. Based on student feedback and success, we regularly improve our education content.

  • How does MemSQL qualify instructors?

    Only MemSQL Certified Instructors deliver MemSQL training. MemSQL Certified Instructors are MemSQL experts that have already achieved MemSQL certification. MemSQL Certified Instructors are experienced enterprise software trainers.

  • Does MemSQL Administrator training include the certification exam for the course?

    Yes, the certification exam is included with the Administrator course. We bundle the certification exam with the course. The exam can only be taken with the course.

  • What do I need to participate in MemSQL Administrator training?

    We run all our trainings as BYOL, Bring Your Own Laptop. You need to be able to SSH into an Amazon EC2 instance using a provided PE or ppk key and public IP. MemSQL supplies the pem and ppk keys, student license, and Amazon EC2 hosts that you use for student labs. Using either Chrome or Firefox, students access education content and curriculum materials from a web-based, digital course player.

  • How do I access course materials?

    As an enrolled student in a training course, you will have access to course materials using the course player. The course player includes downloads of presentation materials, ebooks, white papers, and code examples.

  • For how long do I have access to the course player?

    After enrollment, you can access your course for up to one year.

  • Does MemSQL offer a discount for bundling MemSQL Administrator and MemSQL Developer courses?

    Yes, we offer a significant discount of 50% off the second course. Inquire about our MemSQL Quick Start Training Bundle.