LinuxCBT mDB5x Edition-0daytown

LinuxCBT mDB5x Edition

English | mp4 | H264 1358×766 | AAC 2 ch | 7 hrs 57 min | 1.23 GB

Course Objective

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