NitroFlare LinuxCBT mDB5x Edition

Discussion in 'E-Books & Tutorials' started by kocogi, Sep 11, 2015.

  1. kocogi

    kocogi Active Member

    Joined:
    May 29, 2012
    Messages:
    17,043
    Likes Received:
    12
    Trophy Points:
    38
    [​IMG]
    LinuxCBT mDB5x Edition
    English | mp4 | H264 1358x766 | AAC 2 ch | 7 hrs 57 min | 1.23 GB
    eLearning


    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[​IMG]
    Buy Premium From My Links To Get Resumable Support,Max Speed & Support Me
    Code:
    Download ( NitroFlare )
    http://nitroflare.com/view/C898EAE7095D07F/fbm97.LinuxCBT.mDB5x.Edition.part1.rar
    http://nitroflare.com/view/914AA33B4C6A0C5/fbm97.LinuxCBT.mDB5x.Edition.part2.rar
    http://nitroflare.com/view/428E05F02102864/fbm97.LinuxCBT.mDB5x.Edition.part3.rar
    
    
    
    
    
    
    
    
    
     

Share This Page