» » » LinuxCBT mDB5x Edition

Information of news
12-09-2015, 09:25

LinuxCBT mDB5x Edition

Category: Tutorials / Other

LinuxCBT mDB5x Edition

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

- 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

- Find use-cases for Views
- Implement as desired
- Compare required queries


LinuxCBT mDB5x Edition

LinuxCBT mDB5x Edition

LinuxCBT mDB5x Edition



Site BBcode/HTML Code:
Dear visitor, you went to the site as unregistered user.
We recommend you Sign up or Login to website under your name.
Would you like to leave your comment? Please Login to your account to leave comments. Don't have an account? You can create a free account now.

Tag Cloud

archive of news

free html hit counter