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.
In your deployed MemSQL Cluster, work-on student labs and solve specific use case challenges.
- 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
MemSQL issues digital certificates that are verifiable. MemSQL Certified Developers easily add their digital certificate to their LinkedIn profiles.
- 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
- LAB: Create the mycompany database
- Appendix: A Deeper Look into MemSQL's Columnstore implementation
- 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
- LAB: Explain, Analyze, and Profile
- SOLUTION: Explain, Analyze, Profile example
- LAB: Database Workload Generator
- LAB: MemSQL Top
- LAB: Stored Procedure
- LAB: Apache Kafka Pipeline
- LAB: AWS S3 Pipeline
- SOLUTION: AWS S3 Pipeline
- Appendix: Python Script
- LAB: Predictive Analytics MNIST
- Requirements for Certification
- MemSQL 6 Developer Certification Exam
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.
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.