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. 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 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 Developer 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 can be verified. Students can 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
    • 6.5 LAB: Verify SSH Access to EC2
    • Student Downloads
  • 2
    Module: MemSQL Essentials for Developers
    • MemSQL Overview and Use Cases
    • 6.5 LAB Install MemSQL with MemSQL Ops
    • Rowstore and Columnstore
    • Data Distribution
    • Distributed Joins
    • Reference Tables
    • 6.5 LAB Create the db_mycompany Database
    • Appendix: A Deeper Look into MemSQL's Columnstore implementation
    • Appendix: Tuning columnstore tables
    • Appendix: Understanding Operations on Encoded Data for Columnstore tables
    • Quiz
  • 3
    Module: Schema Design
    • Geospatial Data
    • Appendix: DDL & DML for Geospatial
    • 6.5 LAB Geospatial Data
    • Index Types
    • Sparsity and Normalized Forms
    • JSON and Computed Columns
    • LAB: Use a reference table to query JSON with variant length arrays.
    • SOLUTION: Use a reference table to query JSON with variant array lengths
    • Shard Key Strategies
    • LAB: Identify a Sharding Strategy
  • 4
    Module: Query Optimization
    • Explain, Analyze, and Profile
    • Schema Optimization for Query Performance
    • LAB: Explain, Analyze, and Profile
    • SOLUTION: Explain, Analyze, Profile example
    • LAB: Install MemSQL Studio
    • Using Query Hints
    • Resource Governance with Resource Pools
    • Quiz
  • 5
    Module: Performance Benchmarking and Tuning
    • Experimental Metrics
    • Appendix: Experimental Metrics
    • Using dbbench for Performance Testing
    • LAB: Database Workload Generator
    • Management Views and MemSQL Top
    • LAB: MemSQL Top
  • 6
    Module: MemSQL Procedural SQL (MPSQL)
    • Extensibility Overview
    • Table-Value Functions (TVF)
    • User-Defined Functions (UDF)
    • User-Defined Aggregate Functions (UDAF)
    • Stored Procedures
    • 6.5 LAB MemSQL Procedural Langauge
  • 7
    Module: Real-time Data Ingest
    • Data Ingest Overview
    • MemSQL Connector for Apache Spark
    • MemSQL Pipelines with Apache Kafka
    • Debugging Pipelines and AWS S3 Pipeline
    • 6.5 LAB Ingest Streaming Data with MemSQL Pipelines
    • LAB: AWS S3 Pipeline
    • SOLUTION: AWS S3 Pipeline
    • 6.5 LAB Continuous Loading with S3 Pipelines
    • Pipelines INTO Stored Procedures
    • 6.5 LAB Pipeline into a Stored Procedure
  • 8
    Module: Full-Text Index and Search
    • Full-Text Index and Search
    • 6.5 LAB Full-Text Index and Search
  • 9
    Module: Building Real-Time Applications
    • Business Intelligence Dashboards
    • MemSQL Pipelines for Machine Learning
    • LAB: Predictive Analytics MNIST
  • 10
    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.

  • Watch instructor videos and demonstrations, participate in student labs, and take quizzes in your digital course player.

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

  • After you have completed all of the modules, you take your final course exam.

  • To achieve certification, complete the course and pass the 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

An interactive, live learning experience that focuses on real-world, performance-based results

  • 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

    Onsite training fosters interactive discussions. Get answers to your on-the-topic questions from your MemSQL instructor.

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.

  • 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.

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

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