Course curriculum

  • 1
    Module: Course Details and Downloads
    • Course Overview
    • Before we begin...
    • Software Requirements
    • 6.7 LAB Verify SSH Access to EC2
    • Student Downloads
  • 2
    Module: MemSQL Fundamentals for Administrators
    • MemSQL Overview and Use Cases
    • 6.7 LAB Configure your AWS Host Instances
    • Rowstore and Columnstore
    • Data Distribution
    • 6.7 LAB Install the MemSQL tarball Manually
    • Distributed Joins
    • Reference Tables
    • 6.7 LAB Create the db_mycompany Database
    • Designing a Cluster
    • Expanding a Cluster
    • Appendix: A Deeper Look into MemSQL's Columnstore implementation
    • Quiz
  • 3
    Module: Installing MemSQL
    • Installing MemSQL Ops
    • 6.7 LAB Install MemSQL with MemSQL Ops
    • 6.7 LAB Install MemSQL with the MemSQL Ops CLI
    • Quiz
  • 4
    Module: MemSQL Ops
    • MemSQL Ops Web UI and CLI
    • Common Shell Scripts with MemSQL Ops
    • 6.7 LAB Multi-Node SQL with a bash shell script and the MemSQL Ops CLI
    • Quiz
  • 5
    Module: Securing MemSQL and MemSQL Ops
    • Securing MemSQL and MemSQL Ops
    • 6.7 LAB Secure the MemSQL Ops Web UI
    • MemSQL Client-to-Cluster and Node-to-Node Security
    • Row Level Security
    • Synchronizing Permissions
    • 6.7 LAB Securing MemSQL
    • 6.7 LAB Secure the root user on all nodes with MemSQL Ops
    • Quiz
    • Appendix: Setting the root user password
  • 6
    Module: Managing Upgrades
    • Upgrading MemSQL and MemSQL Ops
    • 6.7 LAB Upgrade MemSQL Ops
    • 6.7 LAB Upgrade MemSQL with MemSQL Ops
  • 7
    Module: MemSQL Studio
    • Using MemSQL Studio
    • 6.7 LAB: Install MemSQL Studio
  • 8
    Module: Operating MemSQL
    • Transaction Models
    • High Availability
    • 6.7 LAB Snapshot a Database
    • Resource Governance
    • Backup and Restore
    • Backup History
    • MV_EVENTS
    • AWS S3 Backup and Restore
    • Failover and Recovery
    • 6.7 LAB Kill a paired Leaf node
    • 6.7 LAB Manually Promote a Slave Partition to Master
    • Logging
    • Monitoring Database Partition Health
    • General Monitoring and Troubleshooting
    • Appendix: Explain, Analyze, Profile
    • Appendix: MemSQL kill scenarios
    • Quiz
  • 9
    Module: Certification
    • Requirements for Certification
    • MemSQL Administrator Certification Exam