Home / Online MariaDB DBA Training

Online MariaDB DBA Training

Many Startup companies across the world hiring Mariadb DBA’s.This is a open database with good features.DBA CENTRE will provide very good training on Open Sources databases.Students will get hands-on exposure to MariaDB Installation, Configuration and Administration.
we will provide One to One.

Online MariaDB DBA Training

Online MariaDB DBA training
EMAIL:- [email protected] [ or ] [email protected]
CALL US ( OR ) TEXT ME {Mariadb DBA} to +91-96404 72496

Session 1: THE SERVER, CLIENTS AND TOOLS

  • Introduction
  • The versions of MariaDB and MySQL
  • An Overview of MariaDB Architecture
  • MySQL Server
  • MySQL Tools
  • MySQL Admin
  • Exercises: Using Client Programs

Session 2: MYSQL WORKBENCH

  • Installation
  • Connecting
  • Screens
  • Exercises: Using MySQL Workbench

Session 3: OBTAINING METADATA

  • The mysqlshow Client Program
  • The SHOW and DESCRIBE Commands
  • The Information_Schema
  • Show Command and Information_Schema Differences
  • Exercises: Obtaining Information about MySQL

Session 4: MARIADB SERVER INSTALLATION AND CONFIGURATION

  • MySQL Distributions
  • Installing on Windows
  • Installing on Linux and UNIX
  • Starting and Stopping on Windows
  • Starting and Stopping on UNIX/Linux
  • Status Files
  • Upgrading the Server
  • Time Zone Tables
  • Exercises: Installing, stopping and starting

Session 5: CONFIGURING THE SERVER

  • MySQL Server Options and Variables
  • MySQL Status Variables
  • Configuring MariaDB Audit Plugin
  • Exercises: Configuring the Server

Session 6: SQL MODES, LOG FILES AND BINARY LOGGING

  • MySQL Error Messages
  • The SHOW Errors Statement
  • The SHOW Warnings Statement
  • SQL Modes
  • Note Messages
  • The PERROR Utility
  • The General Log
  • The Error Log
  • The Slow Query Log
  • The Binary Logs
  • Exercises: Interpreting Errors and Configuring the Logs

Session 7: MYSQL ARCHITECTURE

  • Client/Server Overview
  • Communication Protocols
  • The SQL Parser and Storage Engine Tiers
  • How MySQL Uses Disk Space
  • How MySQL Uses Memory
  • Exercises: Examining the Architecture

Session 8: TRANSACTIONS AND LOCKING

  • Locking Concepts
  • Explicit Table Locking
  • Advisory Locking
  • Exercises: Locking

Session 9: THE INNODB ENGINE

  • Introduction
  • Features of Innodb
  • Transactions
  • Referential Integrity
  • Physical Characteristics of Innodb Tables
  • System Tablespace Configuration
  • Log File and Buffer Configuration
  • Innodb Status
  • Exercises Using the InnoDB Engine

Session 10: OTHER STORAGE ENGINES

  • MyISAM Engine
  • Merge Engine
  • Archive Engine
  • Memory Engine
  • Blackhole Engine
  • CSV Engine
  • The Spider Engine
  • The ColumnStore Engine
  • The MyRocks Engine
  • Mixing Storage Engines
  • Exercises: Storage Engine Performance

Session 11: TABLE MAINTENANCE

  • Table Maintenance Operations
  • Check Table
  • Repair Table
  • Analyze Table
  • Optimize Table
  • MariaDB Check
  • MyISAM Table Maintenance and Repair Utilities
  • Exercises: Maintaining Tables

Session 12: BACKUP AND RECOVERY

  • Designing a Backup and Recovery Strategy
  • The Advantages and Disadvantages of Different Methods
  • Binary Backups of MYISAM Tables
  • Binary Backups of Innodb Tables
  • Recovery
  • Import and Export Operations
  • Exporting and Importing using SQL
  • Exporting from the Command Line using mysqldump
  • Importing from the Command Line using mysqlimport
  • Additional Backup Tools
  • Exercises: Backing Up and Recovery

Session 13: USER MANAGEMENT

  • Introduction
  • User Accounts
  • Creating Users
  • Renaming Users
  • Changing Passwords
  • Dropping Users
  • Granting Privileges
  • The User Table
  • Connection Validation
  • Exercises: Creating, Managing and Dropping Users

Session 14: PRIVILEGES

  • Introduction
  • Types of Privileges
  • Revoking Privileges
  • Resource Limits
  • The MySQL Database
  • The Show Grants Command
  • Exercises: Granting and Revoking Privileges

Session 15: SECURITY AND UPGRADING

  • Signs of Poor Security
  • Security Risks
  • Users, Operating System, File System and Network Security
  • Using SSL With MySQL
  • Remote Connecting to the MySQL Server Using SSH
  • Exercises: Securing the Server

Session 16: TUNING QUERIES

  • Tuning Overview
  • Identifying Candidates for Query Analysis
  • Using Explain to Analyze Queries
  • Meaning of Explain Output
  • Explain Extended
  • Exercises: Explaining and Tuning Queries

Session 17: TUNING AND INDEXES

  • Indexes for Performance
  • Creating and Dropping Indexes
  • Obtaining Index Metadata
  • Indexing Principles
  • Indexing and Joins
  • Fulltext Indexes
  • MyISAM Index Caching
  • Exercises: Creating and Using Indexes

Session 18: TUNING AND TABLES

  • General Table Optimizations
  • Myisam Specific Optimizations
  • Innodb Specific Optimizations
  • Other Engine Specific Optimizations
  • Exercises: Tuning Tables

Session 19: TUNING THE SERVER

  • Status Variables
  • Server Variables
  • Performance Schema Overview
  • The Query Cache
  • Exercises: Tuning the Server

Session 20: THE EVENT SCHEDULER

  • Event scheduler concepts
  • Event scheduler configuration
  • Creating, altering and dropping events
  • Event scheduler monitoring
  • Events and privileges
  • Exercises: Using the event scheduler

Session 21: PARTITIONED TABLES

  • Partitioned tables concepts
  • Obtaining Partitioned Table Metadata
  • Types of Partitioning
  • Subpartitioning
  • Maintenance of partitioned tables
  • Exercises: Using partitioned tables

Online Mariadb DBA Training & Remote Mariadb DBA Support in Cities: UK,San Francisco,Chicago,Dallas,Washington,New York, New Jercy,Boston,Orlando,Germany,Nepal,Tirupati,Bangalore,Chennai,Hyderabad,Vijayawada,Chennai,Cochin,Delhi,Pune,Kolkata,London.

For HR Trainings and Placments :- Click Me

GET OUR LATEST CONTENT IN YOUR INBOX

SUBSCRIBE 
Your information will never be shared
close-link
Enquiry
Submit
close-link
Sign-up for exclusive content. Be the first to hear about DBA Centre Blogs.
Subscribe