Database Design, Tools & Techniques with MariaDB
Details
Installing MariaDB
- Install MariaDB
- Identify installed Files and Directories
- Understand Initial Configuration
- Start and Stop MariaDB
Outline
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
Speaker/s
Special Offer
Schedules
Tue, Fri | 09:00 AM — 04:00 PM |
No. of Days: | 4 |
Alpha Partners is a reputable firm of Training and Management Consultants with many years of corporate training experience in Finance, Accounting, Auditing, Banking, Management, Information Technology, Oil and Gas Sector, Security, Engineering, Public Relations, Secretarial Studies, Leadership, Marketing and other fields of human endeavour.
We are one of the leading players in the profession. Our firm, a multi-disciplinary one with highly talented, experienced and dedicated partners and staff who have experiences in different facets of working life was established in 1996 and has branches in Lagos, Enugu and Awka.
We offer a wide range of professional services, which covers audits, accounting, finance, taxation, ICT, security, engineering, insurance, human resources management, secretarial and consultancy services in all ramifications.
Our numerous clients attest to the high quality services we offer which contribute in no small measure in ensuring sound and efficient management of their resources.