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

Curriculum

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