The best preparation for
designing and building
scalable MemSQL data warehouses and databases

Education for Developers

Our developer training provides students with a comprehensive understanding of the steps necessary to optimize schemas, improve queries, benchmark performance, and design real-time data applications with MemSQL and MemSQL Ops, our built-in management tool. Developer training includes instructor demonstrations, hands-on labs, and ready-to-use AWS environments.
Education for Developers

Hands-On Learning

Through demonstrations, interactions, and hands-on labs, students will master MemSQL key concepts, terminology, and topics such as:
  • MemSQL real-time, in-memory distributed architecture
  • Schema design
  • Query optimization
  • MemSQL Procedural SQL (MPSQL)
  • Performance Benchmarking and Tuning
  • Real-time data ingest with pipelines
  • Full-Text Indexes and Search
  • Building real-time applications
Hands-On Learning

Audience and Prerequisites

Designed to serve the learning goals of application developers and database developers, MemSQL Developer Training requires previous experience with Linux, programming in Scala, Java, or Python, 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 Developers easily add their digital certificate to their LinkedIn profiles.
Learn more
Professional Certification


Course Modules

  • 1
    Module: Course Details and Downloads
    • Software Requirements
    • Verify SSH access to EC2
    • Student AWS EC2 Instances
    • Student Downloads
  • 2
    Module: MemSQL Essentials for Developers
    • Architecture Concepts
    • LAB: MemSQL Installation with MemSQL Ops
    • Rowstore and Columnstore
    • Data Distribution
    • Distributed Joins
    • Reference Tables
    • LAB: Create the mycompany database
    • Application Cluster Topologies
    • Appendix: A Deeper Look into MemSQL's Columnstore implementation
    • Appendix: Tuning columnstore tables
    • QUIZ | Module 02
  • 3
    Module: Schema Design
    • Geospatial Data
    • Appendix: DDL & DML for Geospatial
    • ​LAB: Geospatial
    • SOLUTION: Geospatial
    • Index Types
    • Sparsity and Normalized Forms
    • JSON and Computed Columns
    • LAB: Use a reference table to query JSON with variant length arrays.
    • Shard Key Strategies
    • LAB: Identify a Sharding Strategy
  • 4
    Module: Query Optimization
    • Analyze, Explain, and Profile
    • Schema Optimization for Query Performance
    • LAB: Explain, Analyze, and Profile
    • Using Query Hints
    • Experimental: Explain Plain Viewer
    • QUIZ | Module 04
  • 5
    Module: MemSQL Procedural SQL (MPSQL)
    • Table-Valued Functions (TVF)
    • User-Defined Functions (UDF)
    • User-Defined Aggregate Functions (UDAF)
    • Stored Procedures (SP)
    • LAB: Stored Procedure
  • 6
    Module: Performance Benchmarking and Tuning
    • Experimental Metrics
    • Appendix: Experimental Metrics
    • Using dbbench for Performance Testing
    • LAB: Database Workload Generator
    • Management Views
    • Workload Profiling
    • LAB: MemSQL Top
  • 7
    Module: Real-time Data Ingest
    • MemSQL Connector for Apache Spark
    • MemSQL Pipelines with Apache Kafka and AWS S3
    • LAB: Apache Kafka Pipeline
    • LAB: AWS S3 Pipeline
    • Appendix: Python Script
  • 8
    Module: Building Real-Time Applications
    • Business Intelligence Dashboards
    • MemSQL Pipelines for Machine Learning
    • LAB: Predictive Analytics MNIST
  • 9
    Module: Certification
    • Requirements for Certification
    • MemSQL 6 Developer Certification Exam
    • ORDER BY ASC - Survey

Learn Your Way

Available options for MemSQL Developer training

  • MemSQL 6.5 Developer

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

  • MemSQL 6.5 Developer

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

  • MemSQL 6.5 Developer

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

MemSQL Developer

How our offerings compare

AWS EC2 instances

Certification exam

Course player

Curriculum downloads

Hands-on labs

In-person assistance


Live discussions

Online discussion forum


Recorded sessions

Videos tutorials


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 Developer training include the certification exam for the course?

    Yes, the certification exam is included with the developer 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 Developer 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.