Categories: Linux administration, Databases and SQL
Installation, configuration and maintenance of a MySQL server in Linux environment.
Duration
1 day
Agenda
- MySQL installation
- Server configuration
- environment variables, mysqld command line parameters, connection parameters
- Storage engines and their uses
- engine-specific tools, maintaining database consistence
- Users and databases management
- Internationalization
- Backups
- phpMyAdmin
- Replication
- principles
- configuration and operation
- permissions and copies
- Troubleshooting
Audience and prerequisites
We recommend that the participants are familiar with Linux administration.
Certificates
Course participants receive completion certificates signed by ALX.
See also:
- Oracle Database SQL
- Oracle Database PL/SQL
- Oracle database administration
- Data Analysis
- Linux administrator
- Oracle Database Programmer
- Advanced Linux administrator
- LPI 101. An introduction to Linux administration
- LPI 102. Linux administration and networking
- Building a modern CI / CD process using the Jenkins server
- Selected Linux network services
- Selected Linux server-side technologies
- LPI 201. Linux architecture and low-level configuration
- File sharing and directory services
- LPI 202. Selected network services and network security
- LPIC-2 exam prep course
- LPI 300: LDAP, Samba, Integration with MS Windows and Mixed Environments
- LPI 303: Cryptography, Access Control, Services and Network Security
- LPI 304: Linux Virtualization and High Availability
- E-mail server - Exim, anti-spam solutions
- E-mail server - Postfix
- Bash shell programming
- Advanced shell programming, Bash, AWK
- Linux backups
- Advanced network traffic and content filtering
- VPNs in theory and practice
- Bandwidth and Traffic Management (QoS) on Linux
- Server and network monitoring, SNMP, Nagios, Munin
- Apache HTTP server on Linux
- Bind domain name server on Linux
- LDAP directory services on Linux. Integrating authorization systems
- Samba server on Linux
- Advanced Samba configuration (PDC, LDAP, replication)
- Linux virtualization
- Wireless networks and their security
- Digital signature and encryption with OpenSSL and GnuPG
- High availability: Linux Virtual Server and supporting technologies (HA1)
- NFS: Network File System on Linux
- Safe Internet in a computer lab
- Security components in Linux
- Linux - application and kernel debugging
- Linux - exploiting applications and operating system. Low level attacks.
- Linux - application security testing, searching for possible exploits. High-level attacks
- Access: Databases and SQL for Analysts
- Databases for programmers
- MS SQL Server for programmers
- Oracle RDBMS for programmers
- MySQL for programmers
- MS Access (advanced)
- Access Programming using VBA
