Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Physical/logical architecture MySQL
- Server files and startup scripts
- Server configuration MySQL
- My.cnf
- Basic parameters
- Server log files
- Querylog
- Slow query log
- Errorlog
Management
- User accounts
- Permissions and security in MySQL
- Backup and Restore - Mysqldump vs. Percona Backup
- Database maintenance
Schema optimization
- InnoDB: specific presentation - advantages and disadvantages, what is it really different from MyISAM - when to use what?
- How to choose primary keys (when spatial, when b-tree, etc.)?
- Fulltext search on the InnoDB engine (<5.6 only MyISAM possible, above 5.6 MyISAM+InnoDB)
MySQL Query Cache
- Why, for what queries, what value, is it worth making it large?
Performance testing, determining performance problems
- What to test – depending on the results we want to obtain
- Solving performance problems (slow queries, waits, performance tools, etc.)
Data sharding (horizontally and vertically)
- Differences, costs, limitations
Schema optimization
Indexing
- Indexes on very large tables
- Primary keys (when complex, in what fields)
Data types
- Tips in selecting data types, correct use of field types (int/float, time, geolocation) - benefits, limitations
- Is a primary key other than int acceptable and equally efficient?
- Should every table have a primary key?
- Transactions - when to use and when not - advantages and disadvantages.
Optimization of the operating system and hardware utilization
- The most important parameters in my.cnf
Optimization at the application level
- Optimization tools
- Scripts that analyze settings and display suggestions
Database replication
- Replications, clusters - how to achieve high availability?
- Replication Configuration (ROW/PAGE, troubleshooting, rebuilding, monitoring/diagnosing the replication process
MySQL Proxy vs. HAProxy
- Principle of operation, reliability(?), advantages, disadvantages
MySQL Cluster
- Principle of operation
- Configuration
- Efficiency
- Security
Cache
- Cache MySQL, temporary tables
- Is it worth moving relationships to databases or is it better to keep them in the code?
- Subqueries & joins - should they be used, how should they be optimized?
Explain as an aid for query testing
- Using indexes to build queries
- Query profiling - what tools and how to do it effectively?
- Visual design tools - is it worth using or simplifying structures?
Good practices and naming conventions - keys, columns, indexes, tables
Building optimal table structures
- Triggers: good practices when it comes to maintaining logic in procedures and triggers - how to manage, how to test, when it is worth using?
- Design patterns and anti-patterns
Is it worth switching to MariaDB?
Management tools
- MySQL Workbench
- Navicat
- Heidi SQL
14 Hours
Delivery Options
Private Group Training
Our identity is rooted in delivering exactly what our clients need.
- Pre-course call with your trainer
- Customisation of the learning experience to achieve your goals -
- Bespoke outlines
- Practical hands-on exercises containing data / scenarios recognisable to the learners
- Training scheduled on a date of your choice
- Delivered online, onsite/classroom or hybrid by experts sharing real world experience
Private Group Prices RRP from €4560 online delivery, based on a group of 2 delegates, €1440 per additional delegate (excludes any certification / exam costs). We recommend a maximum group size of 12 for most learning events.
Contact us for an exact quote and to hear our latest promotions
Public Training
Please see our public courses
Testimonials (5)
The quality of training and wealth of experience !
Edvin - Verizon Connect
Course - MySQL Developer
Was carefully tailored to our needs, very responsive to live questions and situations, gave us lots of practice repeating what we were learning.
Colin - Drax
Course - MySQL Administration
Trainer was accommodative. And actually quite encouraging for me to take up the course.
Grace Goh - DBS Bank Ltd
Course - Python in Data Science
The course built lesson to lesson, and the pacing was a big deal for me.
Bradford Moore - Regis College
Course - SQL in MySQL
exercise: setting up HAProxy for load balancing Galera cluster lecture: certification based replication
