Pricing options

Comprehensive preparation for designing and building scalable MemSQL solutions

Level Up

This course 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. This self-paced, online course includes video lessons, multimedia interactions, hands-on labs, and ready-to-use AWS environments.
Level Up

Hands-On Learning

Through video lessons, multimedia 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, this course 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

Curriculum

Course Modules

  • 1
    Module: Course Details and Downloads
    • Course Overview
    • Before we begin...
    • Software Requirements
    • Verify SSH access to EC2
    • Student Downloads
    • Virtual Training - Session 1
    • Virtual Training - Session 2
    • Virtual Training - Session 3
  • 2
    Module: MemSQL Essentials for Developers
    • LAB: Create the mycompany database
    • Appendix: A Deeper Look into MemSQL's Columnstore implementation
  • 3
    Module: Schema Design
    • Appendix: DDL & DML for Geospatial
    • ​LAB: Geospatial
    • SOLUTION: Geospatial
    • LAB: Use a reference table to query JSON with variant length arrays.
    • SOLUTION: Use a reference table to query JSON with variant array lengths
    • LAB: Identify a Sharding Strategy
  • 4
    Module: Query Optimization
    • LAB: Explain, Analyze, and Profile
    • SOLUTION: Explain, Analyze, Profile example
  • 5
    Module: Performance Benchmarking and Tuning
    • LAB: Database Workload Generator
    • LAB: MemSQL Top
  • 6
    Module: MemSQL Procedural SQL (MPSQL)
    • LAB: Stored Procedure
  • 7
    Module: Real-time Data Ingest
    • LAB: Apache Kafka Pipeline
    • LAB: AWS S3 Pipeline
    • SOLUTION: AWS S3 Pipeline
    • Appendix: Python Script
  • 8
    Module: Building Real-Time Applications
    • LAB: Predictive Analytics MNIST
  • 9
    Module: Certification
    • Requirements for Certification
    • MemSQL 6 Developer Certification Exam

How Self-Paced Learning Powers Your Success

Our self-paced, online courses are for developers who require just-in-time training that aligns with on-the-job performance and professional certification.

  • The duration of an online course is 4 weeks.

  • The time commitment is about 4 hours per week.

  • With each new week, you receive new instructor videos and demonstrations, student labs, and quizzes in your digital course player.

  • During the week, at your own pace, you watch the videos, complete labs, and pass any quizzes.

  • Online discussion forums allow you to ask questions about student labs, video lessons, and quiz questions. Our MemSQL experts and other students regularly answer.

  • At the end of 4 weeks, you take your final course exam.

  • To achieve MemSQL 6.5 Developer certification, complete the course and pass your exam.

Excel At Your Pace

Accelerate your on-the-job performance

  • Online Learning

    At your own speed, watch videos of instructor presentations, demonstrations, and solutions. Engage with multimedia interactions and knowledge checks.

  • AWS EC2 Environments

    For the duration of the course, each student receives four EC2 instances to design and deploy a MemSQL cluster.

  • Hands-on Labs

    In your deployed MemSQL Cluster, work-on student labs and solve specific use case challenges.

Online Learning Community

Join a community of learners and MemSQL experts

  • On Your Clock

    Engage and learn at a pace that works best for you and on your schedule. Go back and review modules and labs at anytime.

  • Motivation

    Self-checks, quizzes, and community challenges keep you motivated to succeed.

  • Discussion

    Answers to your questions from MemSQL instructors and fellow learners.

FAQs

Answers to common questions

  • How does MemSQL create self-paced, online courses?

    We employ the ADDIE model to design and develop our education content. We Analyze needs, Design the learning, Develop the curriculum, Implement the online 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 online courses and education content.

  • What do I need to participate in the online course?

    We run all our trainings as BYOL, Bring Your Own Laptop. Our self-paced, online courses require for you to be able to SSH into an Amazon EC2 instance using a provided pem 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, you access education content and curriculum materials from a web-based, digital course player.

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

    After enrollment, you can access your course for one year. Most students complete our self-paced courses within four weeks.

  • Do I have longer than four weeks to complete the course?

    Yes, you have up to one year after enrollment to complete the course and take the certification exam. The course is about 16 hours long. Typically, most students complete the course by the end of four weeks. At the end of four weeks, students no longer have access to their MemSQL cluster and their student license expires. However, students who need more than four weeks often use the MemSQL Docker Quickstart image or MemSQL Developer Edition to complete their labs.

  • Can I complete a self-paced course in less than four weeks?

    Yes, you may complete self-paced training in less than four weeks. Simply sign up for a one week course, two week course, or three week course. For the one week course, new topics are released to your course player each day. For the two week course, new topics are released every two days to your course player. For the three week course, new topics are released every two to three days to your course.

  • Is the certification exam separate or part of the course?

    We bundle the certification exam with the course. The exam can only be taken with the course. You can learn more about certification here.

  • If I need assistance with a student lab, how do I get help?

    Once enrolled, you'll be able to access your course player. In the course player, there is a discussion forum. This is a great place to ask a question and get an answer. For more individualized help, our MemSQL experts offer office hours.

  • Do the self-paced, online courses align with the latest version of MemSQL?

    Yes, MemSQL self-paced, online courses align with the most recent major and minor version of MemSQL. Because of the varying speed and cadence of maintenance releases, we are unable to update education content to support maintenance releases completely. In other words, our self-paced courses align with the most recent major and minor version of the general availability release of MemSQL.

  • Does MemSQL offer a discount for bundling MemSQL 6 Administrator and MemSQL 6 Developer self-paced, online courses?

    Yes, we offer a significant discount with our MemSQL 6 Quick Start Self-Paced Training bundle. This bundle includes both MemSQL 6 Administrator and MemSQL 6 Developer.