LinuxCBT.com

Syllabus

Focus: MariaDB 5x Administration

Duration: 8-Hours

  • MariaDB - DBMS

    • MariaDB Installation
      • Introduction to MariaDB5x
      • Explore topology | target systems
      • Install MariaDB on targets
      • Highlight important directories | files
      • Contrast with MySQL
      • Identify key MariaDB clients
    •  
    • Terminal Monitor Shell Client
      • Explore Terminal Monitor interface
      • Explore defaults
      • Escape to and use SHELL as needed
      • Secure installation
    •  
    • MariaDB Client
      • Identify primary client
      • Use client to connect to MariaDB targets
      • Execute SQL queries as needed
      • Interact interactively | non-interactively
    •  
    • Secure Client
      • Implement secure connectivity with SSH
      • Ensure client | server communications are secure
      • Contrast connection options
      • Perform queries as needed
      • Confirm equal functionality
      • Enable TLS security
      • Force TLS | SSL connectivity
      • Contrast both secure methods
    •  
    • GUI Management | PHPMyAdmin
      • Obtain and install latest PHPMyAdmin Web Management Tool
      • Secure connection with TLS
      • Test connectivity using multiple users
      • Explore the rich PHPMyAdmin Interface
      • Import data via GUI interface
    •  
    • Data Dump
      • Explain available options
      • Connect and dump data to flat files
      • Import | Export dumped data
      • Dump DBs | Tables selectively
      • Encrypt dumped data
    •  
    • Data Import
      • Format data for import
      • Perform SHELL-based imports
      • Compare imported structures
      • Debug malformations
      • Tie imports to specific tables
      • Evaluate performance
    •  
    • Miscellaneous Queries
      • Identify system stats
      • Identify available users
      • Enumerate processes
      • Find various LOG data
      • JOIN as needed
    •  
    • Indexes
      • Discuss performance enhancements
      • Discuss current limitations
      • Implement indexes on key columns
      • Evaluate performance improvements
      • Import large sets
      • Compare post-index performance
      • Use Aria storage engine for Full-Text Index support
    •  
    • VIEWS
      • Find use-cases for Views
      • Implement as desired
      • Compare required queries
    •  

LinuxCBT mDB5x Edition

  •  
DEMO