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.
Hands-On Learning
Through video lessons, multimedia interactions, and hands-on labs, students will master MemSQL key concepts, terminology, and topics such as:
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.
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.
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.
We suggest moving this party over to a full size window.
You'll enjoy it way more.