LinuxCBT mDB5x Edition

English | mp4 | H264 1358x766 | 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