Perfect preparation for building
high-performance, operational data warehouses and real-time,
in-memory database applications

Instructor-led onsite training

Our onsite 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. This onsite training includes live demonstrations, hands-on labs, and ready-to-use AWS environments.
Instructor-led onsite training

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 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
    • Software Requirements
    • 6.7 Lab Verify SSH Access to EC2
    • Student AWS EC2 Instances
    • Student Downloads
  • 2
    Module: MemSQL Essentials for Developers
    • Architecture Concepts
    • 6.7 LAB Install MemSQL with MemSQL Tools
    • Rowstore and Columnstore
    • Data Distribution
    • Distributed Joins
    • Reference Tables
    • 6.7 LAB Create the db_mycompany Database
    • Application Cluster Topologies
    • Appendix: Tuning columnstore tables
    • Appendix: Understanding Operations on Encoded Data for Columnstore tables
    • Quiz
  • 3
    Module: Schema Design
    • Geospatial Data
    • 6.7 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
    • Analyze, Explain, and Profile
    • Schema Optimization for Query Performance
    • LAB: Explain, Analyze, and Profile
    • SOLUTION: Explain, Analyze, Profile example
    • LAB: MemSQL Studio
    • Using Query Hints
    • Quiz
  • 5
    Module: Performance Benchmarking and Tuning
    • Experimental Metrics
    • Using dbbench for Performance Testing
    • 6.7 LAB Database Workload Generator
    • Management Views
    • Workload Profiling
    • 6.7 LAB Distributed Performance Insight with MemSQL Top
  • 6
    Module: MemSQL Procedural SQL (MPSQL)
    • Table-Valued Functions (TVF)
    • User-Defined Functions (UDF)
    • User-Defined Aggregate Functions (UDAF)
    • Stored Procedures (SP)
    • 6.7 LAB MemSQL Procedural Langauge
  • 7
    Module: Real-time Data Ingest
    • MemSQL Connector for Apache Spark
    • MemSQL Pipelines with Apache Kafka and AWS S3
    • 6.7 LAB Ingest Streaming Data with MemSQL Pipelines
    • 6.7 LAB Scale Factor 10 with S3 Pipelines
    • HDFS Pipelines
    • Continuous Loading with S3 Pipelines
    • 6.7 LAB Continuous Loading with S3 Pipelines
    • Pipelines INTO Stored Procedures
    • 6.7 LAB Pipeline into a Stored Procedure
  • 8
    Module: Full-Text Index and Search
    • Full-Text Index
    • Full-Text Search
    • 6.7 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
    • ORDER BY ASC - Survey

Enroll Today!

  • $2,995.00

    Regular price

    Buy

How We Deliver MemSQL 6.7 Developer Onsite

Onsite training is for teams of developers who require a rigorous, hand-ons, instructor-led learning experience that aligns with both professional certification and real-world job performance.

  • Our onsite developer training course runs for two full days, typically from 9AM to 5PM.

  • The time commitment is about 8 hours per day, including lunch and breaks.

  • Throughout each day, your instructor introduces new topics using live demonstrations. Topics align with specific learning objectives.

  • In your digital course player, for each new topic, your instructor releases presentations, student labs, white papers, and ebooks.

  • During your training, you complete hands-on labs, solve challenges, and review your new knowledge with quizzes.

  • With instructor-led training, you ask questions about student labs, live demonstrations, and quiz questions. Our instructors are MemSQL experts that answer your questions.

  • At the end of the 2 days, you take your final course exam.

  • To achieve certification, you complete the course and pass the exam.

Knowledge Is Power

Accelerate success for the whole team

  • Live Demonstrations

    Our onsite training includes live, instructor-led demonstrations that align with specific learning objectives.

  • 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

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

Learning Journey

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

  • Instructor-led

    With instructor-led training, you see live demonstrations and receive live help with hands-on labs.

  • Team Motivation

    Group-checks, quizzes, and use-case team challenges with prizes keep you and your team motivated to learn.

  • Interactive Discussions

    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 onsite training courses?

    We design our onsite 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 many people can attend onsite training?

    Typically, the maximum number of students is 12 for onsite training. That said, if you have more than 12 students, we will happily work with you to make sure everyone gets trained.

  • Can both onsite and remote team members participate in onsite training?

    Our onsite trainings are packed with live demonstrations, hands-on exercises, interactive discussions, and review questions. Experience tells us that combining both onsite and virtual students is on one hand extremely distracting for onsite students and on the other hand disengaging for virtual students. For our instructors, there are also technical challenges associated with combining both virtual and onsite delivery of our training. For these reasons, we are unable to combine onsite and virtual students in one training event. To receive the best learning experience, we recommend that remote team members enroll in virtual training or a self-paced course.

  • How does MemSQL qualify your instructors for onsite training?

    Only MemSQL Certified Instructors deliver MemSQL training. MemSQL Certified Instructors are MemSQL experts that have already achieved MemSQL certification.

  • Does onsite training include the certification exam for the course?

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

  • What do I need to participate in onsite 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 get access to the course materials for onsite training?

    As an enrolled student in an onsite 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 onsite trainings?

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