Database Design, Tools & Techniques with MySQL

  • Start Date

    25 Apr, 2023

  • End Date

    28 Apr, 2023

  • Price

    ₦285,000

  • WiFi

    Free wifi

Event Details

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

CONTENT

Installing MySQL

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

Configuring MySQL

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

User Management

  • Identify MySQL 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 MySQL Backup Tools
  • Define Raw Backup Methods
  • Explain Techniques that Use the Binary Log

MySQL Architecture

  • Understand How MySQL Processes Requests
  • Explain How MySQL 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.

 

DATE:

1ST BATCH:               25th - 28th Apr, 2023

2ND BATCH:             24th- 27th Oct, 2023

Other Dates

Start Date End Date
24 Oct, 2023 27 Oct, 2023
Start Date End Date
21 Jun, 2022 24 Jun, 2022
Start Date End Date
25 Apr, 2023 28 Apr, 2023
  • Venue

    Alpha Partners Professional Training Conference Centre. 200, Muritala Mohammed Way (3rd Floor), Yaba Lagos.

Share this course