Call Now+234 803 304 5484, +234 906 000 2299

Send Message[email protected]

Start Date: 26 May, 2025

End Date: 30 May, 2025

WiFiFree WiFi available

$3,000

Event Details

Database Design, Tools & Techniques with MariaDB covers fundamental skills necessary to maintain and manage a MariaDB server open source databases and related applications in a production environment. It covers foundation of MariaDB, system architecture, creating and managing databases, fundamental SQL, operations and maintenance of PostgreSQL database systems, using basic tools, and backup/restore.

CONTENT

Installing MariaDB

  • Install MariaDB
  • Identify installed Files and Directories
  • Understand Initial Configuration
  • Start and Stop MariaDB

Configuring MariaDB

  • Understand Server Options, Variables, and the Command Line
  • Define Option Files
  • Use System Variables

User Management

  • Identify MariaDB Privilege System
  • Create and Modify User Accounts
  • Configure Passwords and Account Expiration
  • Understand Authentication Plug-Ins
  • Grant Permissions
  • Reset a Forgotten Root Password

Maintaining a Stable System

  • Define Stability
  • Use Capacity Planning
  • Troubleshoot
  • Identify the Causes of Server Slowdowns
  • Describe InnoDB Recovery

Backup Strategies

  • Understand Backups
  • Create a Backup Strategy
  • Use MariaDB Backup Tools
  • Define Raw Backup Methods
  • Explain Techniques that Use the Binary Log

MariaDB Architecture

  • Understand How MariaDB Processes Requests
  • Explain How MariaDB Stores Data

 

FOR WHOM:

CIOs, IT Development Managers, Heads of Department, System Administrators/Engineers, IT Professionals and others who want to sharpen their knowledge in IT world.

 

TRAINING METHODOLOGY

The training methodology combines lectures, discussions, group exercises and illustrations. Participants will gain both theoretical and practical knowledge of the topics. The emphasis is on the practical application of the topics and as a result participant will go back to the workplace with both the ability and the confidence to apply the techniques learned to their duties.

 

This course is available in the following locations:
Nigeria - $3000
Ghana    - $6500
Rwanda - $7500
UK - $8500
USA - $8500

Venue

SunLodge Hotel, Off Achimota - Circle Road behind the Shell Filling Station at No. 76, 4th Road (Saxel Estates) Tesano – Accra, Ghana.

Other Dates

Start Date End Date
17 Nov, 2025 21 Nov, 2025
Start Date End Date
26 May, 2025 30 May, 2025